Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

Help: How to merge excel data onto PDF form

Avatar

Level 2

What steps do i need to take in order to merge excel data into my form. I'm currently looking into pulling the following fields from excell and merge them into my form:

Employee name

Employee ID#

Position Title

Supervisor

I been browsing around LiveCycle Designer and haven't stumble upon this feature yet.

Thank you for your time and really looking for some help out there.

Edit:   I want to create 600 records containing the information above out of my one form. That way i don't have to sit here and do i form for each employee one at the time.

2 Replies

Avatar

Level 10

I think that you should try and get the Excel data into XML format and to match the schema of your form. Try Stefan Cameron's blog: http://forms.stefcameron.com/.

Niall

Avatar

Level 2

Good afternoon Mr. Niall,

Well i already created the XML file so that is ready to go, just been trying to figure out how execute a merge and create 600 records one for each employee.

I was looking into exporting the PDF file into word and that way i could execute this merge much more easily but i don't think i have the capabilities to do so.