Skip navigation
anna-rees
Currently Being Moderated

Is it possible to datamerge more than one image per page?

Jan 8, 2013 3:14 PM

Tags: #data #merge

I am building a product catalogue using datamerge.  Is it possible to data merge more than one image per page? (ie I have a logo, product image and dimensioned drawing to go with each product page)

What would the coding be for the Data Field Name?

 

Would it be

 

@Logo

@Product Image

@Dimension Drawing

Add image fields in the data source file

 

By adding image fields to the data source file, you can allow a different image to appear on each merged record. For example, when you merge documents that include information from various companies, you may want to include an image of each company’s logo as part of the merge.

  1. Open the data source file.
  2. At the beginning of the data field name, type an “at” symbol (@) to insert text or paths that refer to image files.The @ symbol is required only in the first line; subsequent lines should include the image paths. Paths, which are case-sensitive, must follow the naming conventions of the operating system in which they’re stored.
    If you get an error message when you type the @ symbol at the beginning of the field, type an apostrophe (') before the @ symbol (such as '@Photos) to validate the function. Some applications, such as Microsoft Excel, reserve the @ symbol for functions.

     

 

(Windows) Example of image references in data source file

Bill Tucker

36

C:\Photos\BillTucker.jpg

Dat Nguyen

53

C:\MyDocuments\dat.gif

Maria Ruiz

26

C:\Photos\Ruiz.psd

 

(Mac OS) Example of image references in data source file

Bill Tucker

36

Mac HD:Photos:BillTucker.jpg

Dat Nguyen

53

Desktop:Family:dat.gif

Maria Ruiz

26

Mac HD:Photos:Ruiz.psd

You can use InDesign to view the path of an image on your operating system. Insert an image in an InDesign document, and then use the Links panel to view the image’s location. With the image selected, choose Copy Info > Copy Full Path from the Links panel menu. You may need to edit the path after you paste it in your data source. This technique is especially useful for images on a server.

 

 
Replies
  • Currently Being Moderated
    Jan 8, 2013 4:48 PM   in reply to anna-rees

    anna-rees wrote:

    I am building a product catalogue using datamerge.  Is it possible to data merge more than one image per page? (ie I have a logo, product image and dimensioned drawing to go with each product page)

    What would the coding be for the Data Field Name?

     

    Would it be

    @Logo

    @Product Image

    @Dimension Drawing

     

    Yes, pretty much exactly as you describe. You would then just add those fields to the boxes in your page. I tend to add an apostrophe before the @ symbol in Excel so it doesn't think it's a function - as per text you quoted above.

    If you get an error message when you type the @ symbol at the beginning of the field, type an apostrophe (') before the @ symbol (such as '@Photos) to validate the function. Some applications, such as Microsoft Excel, reserve the @ symbol for functions.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points