Copy link to clipboard
Copied
Hi!
I need to revise some old sales tax returns for a client and wanted to see if I could do it with either Adobe Acrobat or InDesign.
The tax returns are interactive and look like this - http://tax.illinois.gov/TaxForms/Sales/ST-1-X.pdf
I want to use an Excel file with my data and map it to the forms for each month that needs to be revised.
I have 4 years of tax returns (48 months) and three different entities so this would create 144 individual sheets.
Can anyone recommend the best way to do this?
Thank you!
Copy link to clipboard
Copied
Importing data into a form requires that the data name in the data file exactly matches the field name in the PDF. For Excel data that means that the first entry in each column is the data(field) name.
Here's an article on the topic: https://www.pdfscripting.com/public/ExcelAndAcrobat.cfm
Use the Acrobat JavaScript Reference early and often
Copy link to clipboard
Copied
It can be done with Acrobat. The first thing you'd need to do is to save the file so that it can be inspected/edited with Acrobat. You can do this by opening it in Acrobat and selecting: File > Save a Copy
Then open this new file and go into form editing mode so you can discover what the various field names are. You will want to create a spreadsheet whose first row contains these identical field names (in any order you want), and the subsequent rows should contain the corresponding data for the 144 returns. Once your spreadsheet is correctly created, you need to export it as a tab-delimited text file. It is this data file that Acrobat will be able to read and import data from.
To import the data in Acrobat, open the blank form, go into form editing mode, and in the right-hand panel and select: More > Import Data
and select your tab-delimited data file. You will then be prompted to select a row that corresponds to the record you want to import.
It's possible to use JavaScript to automate the manual process of importing data I just described. If you plan on doing this type of thing more in the future, it might be worth pursuing, but it won't take too long to manually do 144 records. I suspect most of the time spent on this job will be in preparing the spreadsheet.
Copy link to clipboard
Copied
Thanks George!
I'll try the manual first so I can see how it goes. Then I'd love to know more about automating it with Java. Is it easy to get the code or find someone to do that?
Dave
Copy link to clipboard
Copied
Hi George,
I've been able to export but importing hasn't been working. Will I have to import one at a time? Is there any chance I can use Mail Merge (with Word)?
Thank you!
Copy link to clipboard
Copied
Importing data into a form requires that the data name in the data file exactly matches the field name in the PDF. For Excel data that means that the first entry in each column is the data(field) name.
Here's an article on the topic: https://www.pdfscripting.com/public/ExcelAndAcrobat.cfm
Use the Acrobat JavaScript Reference early and often
Copy link to clipboard
Copied
The link doesn't work for me, but assuming this is a normal Acrobat PDF form (not one created using LiveCycle Designer, for example), then it should be possible, yes. This kind of operation is called a Mail Merge. Some versions of the Acrobat PDFMaker plugin for Office allow you to do it, and it's also possible using a script, like this (paid-for) tool I've developed: Custom-made Adobe Scripts: Acrobat -- Mail Merge and Email PDF Files