5 Replies Latest reply on Jan 7, 2015 10:16 AM by Mreillydesign

    Creating a cookbook using DataMerge

    Mreillydesign Level 1

      I created an Excel spreadsheet housing everything necessary for the cookbook. Titles are in the first row for each column. The Ingredients and Directions areas are multiple lines of information, so I kept the text in one cell and just put in line breaks in the info to constitute as the next step in the directions, or next ingredient in the list. When perform the Merge in InDesign, not all the info comes through as it should. None of the steps in the directions come through and the Ingredients only come through with the first word. Does DataMerge not support linebreaks? If so, is there a work around?

       

      I am using CC and Excel 2013

       

      Thank you.

        • 1. Re: Creating a cookbook using DataMerge
          SJRiegel Adobe Community Professional & MVP

          You can't use line breaks, as far as I have found. They will break the process.

           

          The only workaround would be to (within excel) use some symbol that is not used elsewhere to represent the line breaks, and then do a global find-and-change after the data merge is done.

          • 2. Re: Creating a cookbook using DataMerge
            Peter Spier Most Valuable Participant (Moderator)

            Mreillydesign wrote:

             

            I created an Excel spreadsheet housing everything necessary for the cookbook. Titles are in the first row for each column.

            I hope you meant the first column for each row...

             

            A data merge record corresponds to a row in the spreadsheet, with the first record containing the field names. In addition to line breaks wreaking havoc, if your data file is set up incorrectly you won't get what you expect.

            • 3. Re: Creating a cookbook using DataMerge
              Chad Chelius Adobe Community Professional

              It sounds like you'd be better off creating a separate cell for each step/ingredient and inserting the hard return in InDesign. This way, InDesign will insert the return and you just pull the data from each step/ingredient. I'm thinking you could have columns for step1, step2, step3 and ingredient1, ingredient2, ingredient3 making sure that you have enough columns for the max recipe size.

              • 4. Re: Creating a cookbook using DataMerge
                Mreillydesign Level 1

                Thanks Chad, I was able to easily convert the Excel document so that each step / ingredient were in their own cell labeled "ingredient 1" and so on. Then I used find/replace in excel to select the empty value cells and put in NULL (since there were multiple recipes, and not the same amount of inredients / steps) so that there wouldn't be an issue when importing into InDesign using DataMerge. Then I went into InDesign and used Find / Replace NULL with a blank field.

                 

                Thanks for the help!

                • 5. Re: Creating a cookbook using DataMerge
                  Mreillydesign Level 1

                  I set up the data fields correct, it was the line breaks that was messing things up. By putting each piece of data in it's own cell, I was able to complete the project with little problems.