Form Maker - Batch item list limits to 403 lines only

JuliaMJ

I have a combo box in which I need to upload a list of about 2,500 items. The batch function works well, but it only uploads the first 403 lines from my Excel file, the rest are skipped.

Is there a workaround for this limitation?

Ariel

JuliaMJ Can you upload the list here (zip a .txt file of the list and upload) so that I can test with it?
I'm not aware of a specific limit. Are you sure all items were pasted into FormMaker's edit box?

Ariel

JuliaMJ I've written a script that makes it possible to load an unlimited number of choices.
All the details, and the download link, here: https://www.id-extras.com/combo-superload/

HTH!
Ariel

JuliaMJ

Just tested it out again and made sure everything was pasted, and I still have the issue. See attached zip. Maybe it's a character limit?

Ariel

JuliaMJ Could be a character limit I suppose. Thanks for the file, I'm testing with it now.

Ariel

JuliaMJ (You can delete the file from the forum now if you like.)
Are you using column A or column B?
(Oh, and I won't question the wisdom of having a combo box that has 2500 items in it, but it's definitely the biggest I've ever seen :-)!)

Ariel

It seems that there is a 30,000 character limit for pasting into the edit box. This would be a general ScriptUI (InDesign) limitation. Your Column A has more than 173,000 characters in it!
I'm trying to think of a workaround...

JuliaMJ

Yeah, that's what I thought, just wondering if there's a bypass or a way to run the batch multiple times without deleting the first batch. I can enter new items manually after. To answer your question, I'm using both columns. First one is item line, et second column is for the export value.

I couldn't find a way to delete the zip file. I tried to hide it, but it's still showing.

Ariel

Hi JuliaMJ,
I've got a solution ready, I'll upload it in a few hours.

JuliaMJ

THANK YOU! Works like a charm!!