Copy link to clipboard
Copied
Is there a way to increment a data merge file on each new page?
I have a 50 row text file with multiple fields i am trying to put on 50 pages (each row on each page), each page has existing unique artwork on it.
so i basically want to have data merge export use the existing 50 pages of the indesign doc.
I have put my fields on master A, but as predicted i t makes 50 records for each page in the indesign doc.
oh the data merge needs to be dynamic, i cant just create an ID doc with fields completed.
oh and the artwork cant be pulled from the data merge either.
any ideas?
thanks
Copy link to clipboard
Copied
I cannot see the layout nor the data you are using from here...so the comment is in general.
You may be able to use one of the in-line data merge scripts. I cannot remember if one ships with ID or not. But you can find a few on the Internet. If the data doesn't need styling on two or more fields, you can likely just cop the data from your spreadsheet to a text file, set the paragraph style to do a frame break (or otherwise size it to force a break if the data in each row is roughly the same amount of data/characters).
Mike
Copy link to clipboard
Copied
some sideways thinking there, i could use a table i guess, at least the entries would be delimited to an extent
i will have a look for inline data merge.
thanks for the suggestion
Copy link to clipboard
Copied
To be clear, you have an existing 50 page document with artwork already on it.
You then want to apply a data merge so that each page has unique data on it ON TOP OF what's already there.
To do this, you would need a database that had at least 50 fields across (one for each page, assuming there's only one item going on each page) and each field would need to be put on each individual page, not a master page.
But that will only be one row and create one record, so if you wanted 10 rows to create 10 books, you would end up with a database that is 50 fields across and 10 records deep (not including the header)
Have I understood this correctly?
Otherwise, Mike's suggestion is one I'd use. Go to ozalto.com (Downloads | Ozalto ) and get the inlinemerge script.
If you want to do this as a table, use the CSV2merge script, though I've found the one from ozalto doesn't work here, but the one from scriptopedia does: https://www.scriptopedia.org/en/js-indesign/126-csvtotable-en.html
Find more inspiration, events, and resources on the new Adobe Community
Explore Now