Filling Form Fields with External Data

[larryaffelt]

My manufacturing company would like to find a way to fill in fields in a PDF document with data from an SQL database. We can export data from the database into multiple formats such as CSV, tab separated values, Excel, etc. if we truly need to.
We manufacture products which are very similiar except for a few parts, and we have fillable forms which right now are printed and hand written or edited in the PDF and saved. For higher efficiency and accuracy we want the fields to be automatically filled or triggered by clicking a button on the form.

Does anyone have a solution for this?

TIA ... Larry Affelt

[Thom Parker]

You'll find information and a number of tools for handling form data here:

https://www.pdfscripting.com/public/Form-Data-Handling.cfm

If you are interested in custom development work, I can create a specialized tool for you. 

PM me through the forum.

[try67]

You can import data directly in Acrobat via Tools - Forms - More Form Options - Import Data.

It needs to have the right format, though. For example, it can be a tab-delimited text file with the names of the fields in the first row and their values in the second.

You can't import data directly from a database, though. It used to be possible but unfortunately Adobe removed this functionality a while ago.