To import image directories in excel, go to the data tab at the top of the page and press the “Get Data” button. Additionally, do not have your datasource file saved to this directory yet, as it will also be imported which could misorder the images as well. Even if you have an alphabetized list of names, if just one photo associated with a name is missing, then all the names listed after will be paired with the wrong image. If you do intend on importing image data into excel, I would recommend doing it before adding any other information as images are always imported in alphabetical order. It is possible within Excel to import the file names and directories from a folder, which may be convenient if you’re working with lots of images. Obviously though, this will vary depending on where the files are saved. (C:\Users\\Documents\Images\john-smith.jpg). If your image files are stored in such a way that this isn’t possible, then you can put the full directory which would likely look something like That way, simply putting the file name and extension will find the correct file (john-smith.jpg). For the sake of simplicity, I’d recommend placing your datasource within the folder containing all your images. When you're serious about it, then consider using Adobe FrameMaker.InDesign searches file paths relative to the location of the datasource file, which in this case is our excel document. InDesign is not intended to deal with this kind of catalogue automation. Though it won't be very flexible when you want to vary your layout afterwards. So it will take quite some tinkering and tweaking to get it all up and running, but it all seems feasible to me. Or are you willing to dig into Object Styles ? And those color backgrounds and boxes can be achieved with Paragraph Shading and Borders. How to switch from products to headings and let headings span across the whole text box ? It's an available Paragraph setting, but then the base for the layout needs to be a multi-column text frame, carefully measured to have this image as an anchored element in the text flow. However, there are challenges in this approach. And items/rows/paragraphs can disappear by letting GREP delete (actually Find/Replace) the whole paragraph by searching for the indicator. Using textual indicators in your data like "do-show" or "no-show" and "heading" or "subhead", you can let GREP search for these indicators, and apply Cell and Paragraph Styles to those texts, including settings like "Start on next page". The only feature which can define very precise conditions (and act upon it) is GREP. InDesign doesn't offer any conditional formatting upon importing text or generating content with data merge. Phew ! It's a nice setup you're trying to buildĪnd it might just work with a two-step approach. I would really appreciate any feedback and help on this! Thank you so much! ! I also am not sure if this is better done (or even possible at all) with scripting. Are these things possible? I'm new to Data Merge so I don't know if this is within the capabilities of the platform. Third, I'd like to be able to skip over a product if I don't want to show it in the catalogue.īelow is how I would like the document to for those few lines that are outlined in the big red box:Īs you can see, rather than display a blank graphic, data merge would insert a page break where noted, place a graphic for the Heading and place a different graphic for a Subheading, and skip over the lines that I don't want to show. Second, I'd like to be able to insert headings and subheadings before the start of each category's set. Therefore, when I have a break of one cell, it chooses to display an empty graphic in the Multiple Records Merged Document.įirst, I'd like to know if there is an option to have a page break in the middle of a set of data. The way I understand Data Merge to work is that it goes down the CSV file one row at a time. I have a few questions about how I can display this data. I have an example CSV file / spreadsheet that carries all the information for each of the products: Hi! I'm currently working on a catalog of products and their information, which is split into specific categories.
0 Comments
Leave a Reply. |