Local Database

[Shane_Ziebarth]

I have created a form in LiveCycle ES. I would like for my employees to answer the questions and then email me (via button I have on the form). All of this works correctly and the email arrives as a .xml file. I now need to inport this into a spreedsheet. I have done this with Achrobat Pro however it just imports the name of the .xm. file as the first line in the spreadsheet. I need all of the fields in the form represented. Can anyone assist or point me in the direction I need to research how to accomplish this?

What I am wanting to do is after 6 months to a year of collecting the data and then importing it to the spreadsheet I want to organize it to create profiles of common domoniators.

I would appreciate any guidence.

[Former Community Member · Accepted solution]

You want to Distribute the form to your employees.

When the form is distributed, it will create two files; Distribute and Response.

When you get your form back via email, it will ask if you want to save it in the Response file, which is actually a pdf portfolio.  Say Yes.  The Response file is like a respitory for all returned pdf.  In this Response file you can export (all data fields) one or all pdfs into Excel very easily.