Expand my Community achievements bar.

Adobe Summit 2025: AEM Session Recordings Are Live! Missed a session or want to revisit your favorites? Watch the latest recordings now.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Merging data from a CSV file into a PDF Form

Avatar

Former Community Member
Hello all,



I have a 4-page PDF file. I need to print out this document for 4000 employees. However, I need to put the employee's name and address at the top of the document. I have a CSV file and an XML file with all of the names and addresses but I am having trouble merging this file into the PDF document.



Here is what I have tried so far:



1. I went into Adobe Designer 7.0 and I created a form using my document.



2. I then mapped my form fields to my XML file.



3. I went into Acrobat 3D and then went to Advanced-->Forms-->Import Data to Form.



I can get the first employee to appear on the document but how do I get Acrobat to cycle through all 4000 employees in the file and create all 4000 documents? Basically, I need this process to continue for each employee essentially creating 4000 4-page documents.



If Acrobat or LiveCycle cannot handle this, can anyone think of how this could be handled using a different product?



Thanks in advance!
2 Replies

Avatar

Former Community Member
create subform, add your fields in that subform, map your xml elements to the fields in the subform, and finally the min and max property of the subform.

Avatar

Former Community Member
MS-Word mail merge does that kind of thing. You can do a mail merge using data from a database if you want. No scripting required!