Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Data Merge > increment on new page

Explorer ,
May 25, 2019 May 25, 2019

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

493
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Valorous Hero ,
May 25, 2019 May 25, 2019

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
May 25, 2019 May 25, 2019

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 26, 2019 May 26, 2019
LATEST

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

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines