• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Merging Data into a PDF form

New Here ,
Jul 25, 2018 Jul 25, 2018

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!

TOPICS
PDF forms

Views

12.0K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
1 ACCEPTED SOLUTION
Community Expert ,
Aug 01, 2018 Aug 01, 2018

Copy link to clipboard

Copied

LATEST

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

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

View solution in original post

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jul 25, 2018 Jul 25, 2018

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 25, 2018 Jul 25, 2018

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 30, 2018 Jul 30, 2018

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!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 01, 2018 Aug 01, 2018

Copy link to clipboard

Copied

LATEST

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

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 25, 2018 Jul 25, 2018

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines