![]() Our example catalog uses a simple style: a large image at the top, a text frame with the price, and then a list of all of the other fields.Ĥ. These numbers reference the page number on which each field is mapped.Ĭontinue to add all of your fields and customize the layout to meet your needs. Numbers will also appear next to each field in the Data Merge panel. Image fields are inserted by creating a box with the Rectangle Frame tool (R), selecting that box and then clicking on the selected image field in the Data Merge panel.įields that are successfully mapped will appear surrounded by > symbols. Text fields are inserted by creating a Text Frame, selecting that frame and then clicking on the selected text field in the Data Merge panel. Each of your data source records will follow this mapping during the subsequent automatic pagination process. Mapping the fields Now it’s time to map each field within your desired layout. InDesign has identified two field types in our catalog example: text (ģ. The Data Merge panel will now fill with all of the fields from your source file: Preserve Spaces in Data Source – Check this box if you want to keep all extra spaces within your fields. Platform – Choose ‘PC’ if you’re working on a PC. ![]() Encoding – Choose whether the file uses ‘ASCII’ or ‘Unicode’ encoding. Choose ‘Tab’ if you saved your data source as a. txt file and check the ‘Show Import Options’ box (shown below).Ĭlick ‘OK’ and take a look at the new dialog box that appears:Ĭhange the options in this box to match your situation: Delimiter – Choose ‘Comma’ if you saved your data source as a. Setting up the Data Merge panel Open the Data Merge panel via Window > Utilities > Data Merge > Select Data Source. Now close your spreadsheet and open InDesign.Ģ. xls/.xlsx or alternatives! Perform the export in Excel by using File > Save as. The populated table should next be exported as either a comma-delimited file (.csv) or a tabdelimited file (.txt). On a Windows system – C:\Users\User Name\My Documents\Image.psd On a Mac system – Macintosh HD:Users:User Name:MyDocuments:Image.psd Take care to make all image paths match your file system, e.g. When all of the fields have been defined, the next step is to populate the table with your records. The apostrophe will force the cell’s entire content to be considered as text. ![]() The symbol is a special character in Excel, so add an apostrophe before the symbol if you’re presented with an error (e.g. Image fields should be defined with an symbol prefix (e.g. Be sure to write the field names correctly, add a field for every column and never duplicate a field name. Open up a blank spreadsheet and use the first row to define your fields. Your email address Sign upĬontact us if your project introduces more challenging requirements.įully automated solutions for beautiful documents. Sign up to our newsletter to download the working document template. Plan your project and make use of the latest technologies by reading our up-to-date guide (May 2015): Database Publishing and Variable Data Printing: A Better Approach. product information from Excel files and pricing information from your ERP export. We can also combine multiple data sources, e.g. At Pagination we offer solutions to overcome conversion issues and accurately convert even the most complex spreadsheets. csv/.txt conversion, but the process can often be complex and prone to errors. Note: The Data Merge tool only works with spreadsheets in. The project source files are available to the right. This tutorial uses InDesign’s Data Merge tool to create a catalog. Data Merge InDesign Tutorial: create a simple catalogĭata Merge InDesign Tutorial: Creating a Catalog JUNE 10, 2015
0 Comments
Leave a Reply. |