3 Replies Latest reply on Oct 5, 2011 5:06 AM by Peter Spier

    InDesign Data Merge Question....

    pwhite2315 Level 1

      I have a calendar created using the data merge feature within InDesign.  The only question I have thus far is on each day of the week, we currently have a text frame linking to a .txt file that our customers add events to.  How do I link the specific .txt files to the frame?  I cant use the image function in my excel file as it does not reconize it as that.  Is there another way to script/put this in my source file to link and place the text in the .txt files (individual txt files for each day of the year).??  Any help would be appreciated.  Thanks!

        • 1. Re: InDesign Data Merge Question....
          Peter Spier Most Valuable Participant (Moderator)

          I don't think I really undertand the structure of the data file you have. My sense, though is that this may not really be a data merge project.

           

          At its heart, Data Merge is is very primitive. It's great for mailing labels, but can get defeated by more complex projects. For the merge to work, all of the data must be structured the same for each record in terms of the number of fields, and the text you want to include needs to be in the fields (as far as I know, you cannot use a pointer to an external text file in a field the same way that you can use a pointer to an image). You have a choice when setting up the merge template, though, of putting the plceholders on the document page or on the master page.

           

          If you put the placeholders on the master page, the data can be updated AFTER the merge, at least in theory (doesn't seem to work well with images), but it doesn't really sound to me like that's what you need, but it is a possibility if you have a basic documenet and the clients add text later.

           

          In any case, if you are letting the client add text, you need to add that text directly into your data file, either in Excel and re-export the entire data set, or set up some sort of find/change routine to replace tags in the text file with the text supplied by the client.

          • 2. Re: InDesign Data Merge Question....
            Michael Gianino Level 4

            Peter Spier wrote:

            If you put the placeholders on the master page, the data can be updated AFTER the merge…

            I'm not sure what you mean by that. If you mean that you can edit the data source and update it in the ID file, that can be done if the placeholder is on the document page or the master page. I tried it both ways, and couldn't get the merged document to update on it's own. I had to do the merge on the ID file that contained the placeholder again to get an updated merge. Did I misunderstand you?

            • 3. Re: InDesign Data Merge Question....
              Peter Spier Most Valuable Participant (Moderator)

              It's been a while since I've seen or tried to do it, but yes, after the merge, there is an option to update data source which should update the merged data if the fields are on the master page. It is not something I use in my own work, but it came up about a year ago when a user posted that his images disappeared when he updated, and I was able, if I remember right, to reproduce the problem here, too.  I think this is covered inthe Help files...