#Data merge excel indesign cs4 update#

The advantage with merging on a master page is that the data stays linked. If merging on a regular page, the static items need only be on the master page. If merging on a master page, the static items need to be on a master page ABOVE and the variable items need to be on a master BASED ON the static master. So, when doing a data merge with multiple records, the variable data has to be treated separately to the static data (items which will be on every page like a background or, in this example, the smiley face). This is somewhat hard to explain so i'll demonstrate in pictures using a simple mergeīut, if a graphic is placed on the same page (whether it's the master page or not, it doesn't matter) that is where things can go awry 'Indesign takes what it considers a 'record' from anything on the page, that is from the top left to the bottom right of the page, any objects indesign can grab it considers a record.' I suspect what is happening is what I outlined in the second paragraph of my earlier post: It just means that the resulting indesign file won't have a link back to the text file. If this isn't an issue, the data can be placed on not just one page but many pages within an indesign document.

#Data merge excel indesign cs4 update#

This is handy if changes are likely or easier to update via the text file used for the records. Import CSV documents (.csv) (UTF-8, UTF16-BE, UTF16-LE, UTF32-BE, UTF32-LE) (UTF 16 only) Export to dynamically named Indesign, PDF, interactive PDF, JPEG, PNG documents. Merging on a master page is only necessary if the text data is to remained linked in the links palette after the merge. Import Excel documents (.xlsx) Import linebreaks from Excel documents and keep them during the data merge. if there is a background, it needs to be on a separate master page, and the variable data has to be on a master page which is BASED ON the master with the background on it. Indesign takes what it considers a 'record' from anything on the page, that is from the top left to the bottom right of the page, any objects indesign can grab it considers a record. The multiple record part is done in the 'create merged document' dialog and the rows/columns are set there. One set of data containing one record's worth of information needs to be created. If i connect the document to the following set of containers Indesign only reads the data of the first row of the cell which results in a document which only contains the same data.ĭata Merge doesn't allow 'next records' in this fashion. But Indesign doenst copy the data in the following row of the cell in the following sets of containters. Indesign reads the data and places it correctly. I went data merge and connected the TXT document to the first set of containers. I copied the three containers on the page which resulted in the a master page with 40 containers for each article. On the master page i made a layout with the folling containers. It only reads the first row of cells in the document. I got the following problem with an automated data merge document.