Spinny Wheel and 9991 pages after merger - InDesign

[lorib105]

Data Merger created 9991 pages as a result from a .csv file that had 94 pages of data. Now When I force quit it won't open because the file is too large and teh spinny wheel is running and won't open

[Mike Witherell]

Hi Lori,

The page limit in an InDesign document is 9,999 pages. Once you climb to that number, the document will fail.

How many individual record rows are in your 94-page CSV? You may have to split that into 2 halves. Or you may have to get involved in a more robust merging software addon.

[Robert at ID-Tasker]

@lorib105

What do you mean by "94 pages of data"? 

[Peter Spier]

Are you doing a single record per page, or multiple records per page merge?

My instinct is that you are doing multiple and that your template is built incorrectly, or that you used the preview function, which is buggy, before the merge.

[Laubender]

Hi @lorib105 ,

I would cut the data to pieces of a maximum of 1000 entries each.

That should be an amount where InDesign can handle the task per merge ( depending of available memory and processor speed ) . What will also help: restart InDesign after every merging process to free up memory.

Regards,
Uwe Laubender
( Adobe Community Expert )

[Dave Creamer of IDEAS]

Break your .csv file into reasonable "chunks". Process them separately.

While the limit is 9,999 pages as Mike mentioned, I would never build a single document with that many pages.

Depending on what you are trying to accomplish, have you ever discussed variable-data printing with a commercial printer? It might be more efficient depending on your project.

[Abhishek Rao]

Hi @lorib105,  

I hope the experts' suggestions helped! Were you able to split the CSV into smaller chunks and try merging again? Also, could you share your InDesign version and OS details? Let me know if the issue persists. Looking forward to your update!  

^

Abhishek