Your working spreadsheet can remain in Google Spreadsheets or Excel if that's easier for your workflow, but to run the merge, you will need to export each sheet to a separate CSV. These formats do not support multiple sheets. Would it be better to just work in separate spreadsheets rather than using multiple sheets in one spreadsheetĪ data source file can be a comma-delimited file (.csv), a tab-delimited (.txt), or a semicolon-delimited file in which each piece of data is separated by a comma or a tab, respectively. I think there may also be a script or plug-in that might help with this - don't quote me) (For advanced users, you can also apply a GREP style to reduce the font size for particularly long texts. Your text box can be set to auto-center its contents, so that it can "adjust" to the absence of any Flavor Text. would it be better to just work in separate spreadsheets rather than using multiple sheets in one spreadsheet?Īs another comment has already mentioned, your Flavor Text should be a separate column in the spreadsheet, and in your Data Merge options, you set it to remove empty fields. I haven't even tried exporting or linking this, but for my sanity. This is a game that has cards with varying templates, as an example. My spreadsheet (on Google Sheets) has several sheets for the different kinds of cards (Allies, Animals, Objectives.) which will have their own layouts and different kinds of game information. Is there a way to make InDesign aware of whether or not an entry in my csv file has Flavor Text or not and adjust the main text box accordingly?Īt the moment, I'm still doing the initial design of my game and making a lot of changes and references across the different types of cards. There are a lot of cards that include additional text that adds theme or context to cards. For many cards, t hey only contain text that is applicable to the game. The name for this feature (to my knowledge) is borrowed from Magic: the Gathering. I've never used indesign before, and I have found a few applicable tutorials, but I have a few questions I haven't found answers to at a glance. There are also even more robust solutions that let you have live links between InDesign and a database such as Teacup Software’s DataLinker or Cacidi’s LiveMerge.I'm trying to use a spreadsheet to manage a card game I am designing. You can do that easily with a plug-in such as InData from Em Software. For example, you can’t build intelligence or rules into the process, such as “if this session is listed as being in the “Foible Room” put such-and-such icon next to it. However, Data Merge doesn’t do everything you might want. If you like what you see there, please consider becoming a subscriber to the magazine. Rufus Deuchler wrote it for InDesign Magazine, but it’s posted free for you at. Click the flyout menu on the right-hand side and choose select data source, and select the tab delimited text file you made earlier. I’m not going to give you a lesson on how to use datamerge here because someone else has done a great job of it already. Go to your window menu at the top and choose Automation> Data Merge. There are lots of options for doing database publishing, but one of the simplest (and certainly least expensive if you already own InDesign CS2) is Data Merge, which comes with the program (see Window > Automation > Data Merge). What you’re talking about is database publishing: Taking data from a database or spreadsheet and making it pretty in InDesign. We have an Excel database of all the information, but are just wondering if there is a faster way to do this kind of layout in either Indesign or Illustrator. I am working on a building signage project, and one of the challenge is to layout hundreds of room identification signs at the same size, but all the room numbers / room names and pictograms are different, and we need to keep them at precisely the same position.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |