![]() Anyway, my solution was to create a fresh header, save a new Mac. So, the file could have picked up some wonky coding in the open-n-saves prior to me. Which, btw/, had been touched by a couple of staff members as they did their part to massage the data before it hit my Mac (oh, yes, I'm on a MacBook Pro). And, bingo! The import to InDesign worked! So, there must have been some wonky coding in the Header row that was created in the original SalesForce file. Then, I manually typed in new headers for each column in the spreadsheet. I realise that it will be possible to have the javascripted, but was kind of hoping to avoid this with the newest InDesgn. So, I first copy-n-pasted all the data below the header row to a fresh, new Excel file leaving the header row blank. We are specifically looking for a way to output single PDFs (500 page Data Merged InDesign Document saves as 500 PDF files for example) and each PDF being named using a column from the attached Excel file. After much trial and error (and reading the comments here), I deduced that it had to have something to do with the Header row in the orginal Excel file. I could not get my data file's Headers to show up in the data merge window in InDesign for a file generated out of PatronManager (which is sits on the SalesForce platform). ![]() The only other option is to manually enter the spreadsheet data certificate by certificate, but I really don't have time for it this month! Please help!! I use a PC normally, but brought my MacBook in today to see if I could get it to work.I have copied JUST the content in these spreadsheets (not the whole spreadsheet, not the blank rows or columns beyond the content), and pasted JUST the values into a blank spreadsheet, and saved that as.I have saved & re-saved the spreadsheets in.These updated files don't support the Data Merge either, which makes me think this is a spreadsheet issue. ![]() I have re-created and re-packaged the certificate templates with a simple copy/paste of the Master & page content in CC2018 to avoid the missing plugin issue.Confirm the file exists and that you have the rights to open it and select open data source again" I receive an error saying "the data source can not be opened.The Data Merge screen maintains the 1-2-3 step instructions like I didn't do anything. I select the file and nothing happens.When I go to Data Merge and select the file, one of two things will happen:.This template had a "missing plugin" I was unable to find locally or anywhere on Google: 37xmltw.indesignplugin.I had an indd file with certificate template.(i.e., "Select Data Source." doesn't recognize the spreadsheet). The spreadsheet simply won't connect with InDesign's Data Merge.In my previous job I'd performed dozens of data merges - and I've never run into a problem like this.įirst of all, according to every help forum and Adobe InDesign guide I've found on the Internet, and three other CC users, I'm doing everything right. Problem is, the certificate templates I'm inheriting and the spreadsheets I was provided aren't working with indd's Data Merge feature. My team is at at its absolute all-hands-on-deck busiest time of the year and another team needs me to jump in and help them create 80 certificates ASAP. Please tell me that someone can help me figure this out as soon as possible.I'm dying here. ![]() I've tried everything I've seen on the forums, apart from uninstalling and reinstalling. I have watched the tutorial videos, read the entire help section regarding data merge, and have correctly created my data source file. I read that it may be because the files need to be on the right hand sheet of the master, however, when I move my info to the right sheet, I get the following message. I also deleted my "cache"/settings" by doing "ctrl, alt, shift" when reopening the program. I made sure that the placeholder "allows overwrite from the master". I deleted my "page 2" to avoid that conflict. I made sure that my document does not have facing pages. See image below.Īfter watching tutorials, reading, etc. When I select "Create Merged Document" the "select multiple records per page" is greyed out, however, there is plenty of room on the page for the 8 records I want it to show. I am inserting this info on the left sheet of the master file. All images, original file, and data source file are in the same folder. I am attempting to do a data merge from the Master Page.Īs you can see in the image, I have inserted my fields from the data source file. I am attempting to create a catalog with the data merge option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |