6 Replies Latest reply on May 22, 2013 5:56 AM by SteveE91

    Data Merge not picking up all data fields

    SteveE91 Level 1

      Hi,

       

      I have been working on a document that is full of client-specific information, that usually takes a few days to sift through and make amends.

       

      The document, when finished, includes tables that vary in row count depending upon the selections that a client has made as well as including text that depends on the clients choice.

      I have been using a script called CSV2Tables to prepopulate tables in an InDesign document.

       

      Beginning with a simple table, I set up a 2 x 2 table, insert row headers and leave a blank row to insert my data tags e.g.

       

       

      Header 1Header 2
      <<holder1>><<holder2>>

       

       

      I select the data source, run the script and it populates a table with multiple rows.

       

      My problem is, the CSV file that I am using to populate the rows also includes data tags, so that I can run a full Mail Merge (using another CSV source) so that the table ends up with prepopulated rows, full of text.

       

      Once I have run the CSV2Tables script (inserting external data) and created a table, it will look something like this:

       

      Header 1Header 2
      Row title 1Sample text dependant upon <<ClientName>> choices
      Row title 2How many choices has <<ClientName>> made: <<ChoiceNo>>
      Row title 3The client would like <<HolidayDays>> days holiday this year
      Row title 4

       

      All of the data tags that are being inserted have already been chosen and set in the second CSV file so that they all match.

       

      Now though, when I select the second data source and run the Mail Merge, it seems that these data tags have been imported as regular text and InDesign doesn't pick up that they are data tags.. even though all of them are available to select as Fields.

       

       

      Basically, I'm looking for a way of making sure InDesign recognises that the <<datatags>> that are being inserted into each table after the CSV2Tables script is run, are infact data tags and not just plain text. So the table above should end up like this:

       

      Header 1Header 2
      Row title 1Sample text dependant upon InDesign Inc. choices
      Row title 2How many choices has InDesign Inc. made: 44
      Row title 3The client would like 28 days holiday this year
      Row title 4

       

      Let me know if further explanation is needed. Thanks,