Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

Data Merge question

Return to Member Forum

  • Author
    Posts
    • #55511
      Chris Vogel
      Member

      I am trying to make a series of labels (not mailing labels, but labels for art that will be silkscreened in a museum installation), and I'm trying to use Data Merge. However, everything I've read, seen, and tried with Data Merge gives a new frame for each record. I'm trying to create a multipage linked story with all of the labels.

      It sounds as if what I'm trying to do should be fairly simple but maybe not. I know that I can do this with the ImData plug-in, but I'm trying to avoid buying a fairly expensive plug-in.

      Here's a link to what I want vs. what Data Merge is giving me: https://files.nga.gov/seos/1000/mpd/22042010c53374dca7d29498859f4b3a83e5afd7

      any thoughts or ideas would be appreciated. Thanks

      Chris

    • #55519

      the data merge function in indesign doesn't make “next record” merges like word does, but instead merges to fields within fixed text boxes, so one frame = one data merge result. when doing mailing labels in word, there is a field called “next record” which then calls in the next piece of information.

      the “next record” field is a vital field which indesign doesn't have and i'd like… but that doesn't answer your question. i can see three ways of doing what you want to do:

      1) do a mail merge in word and use the “catalog” feature and do the merge in word. format the word file appropriately using stylesheets, and once the merge is made, save the file and close it. THEN, place the file in indesign and then change the imported stylesheets into something which resembles more like what you want.

      2) use indesign's data merge but make sure that multiple record layout is selected in the first dialog box when creating merged document; and that when previewing the records, the records appear to be in one column (even though they are still in separate text frames). merge the document, and in the new document, select all the text frames in the page and then run the MergeTextframes_ID.jsx script which can be found at https://ajarproductions.com/blo…..-indesign/ .this will have to be done page by page and then rethreaded each page, but it's a workaround

      3) if the data in the datamerge is a csv, convert the csv to xml. if the csv is small (less than 100K) there is a converter online where the contents of the csv is copied into the converter. it is at https://www.creativyst.com/Prod/15/ . The next step is complicated and needs some knowledge of XML. my advice is to get hold of a book called “Designer's Guide to Adobe InDesign and XML” by James Maivald, and specifically read chapter seven and base your merge on this.

      i hope this helps

      colly

    • #55521
      Chris Vogel
      Member

      Thanks, Colly

      I should have said I was using a csv file. I'll try your suggestion no. 3; I'm not that familiar with XML, but I do have the book and I'll study chapter 7

      Chris

Viewing 2 reply threads
  • The forum ‘General InDesign Topics (CLOSED)’ is closed to new topics and replies.
Forum Ads