These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Help with exporting form data to excel!

Forum Index > Forms: LiveCycle Designer > Help with exporting form data to excel!
2010-03-22 13:54:39
neth
Registered: Mar 17 2010
Posts: 25

Hi there,

I have created an interactive form using Livecycle Designer that comes with Adobe 9 Pro. Forms will be download from a website, completed and emailed back to me. I'm having trouble trying to export the data to excel. Whilst it lets me export data to excel it does not appear in the logical order as it is on the form. I'm not sure how to fix this and/or if its possible to only have certain fields displayed in excel?

Is it also possible to automate the process so that data in completed forms that i save will update the inforamtion in excel?

Any help greatly appreciated, I'm new to forms.

Windows XP
Adobe Acrobat 9 Pro
Microsoft Excel 2003

Thanks,

Ken

My Product Information:
Acrobat Pro 9.3.1, Windows
Top
2010-03-27 12:24:44
#1
Roy Ing
Registered: Mar 27 2010
Posts: 3
Hi Ken. We offer a solution that enables you to import data automatically from PDF (Acrobat or Live Cycle) forms to Microsoft Excel (and also Access database). For more information, please visit http://www.EpiSuccess.com.

Have a nice day.
Top
2010-12-13 07:56:30
#2
Lhicks7
Registered: Dec 13 2010
Posts: 1
Hello,

I am also having the same problem. When I export my response data set to Excel (it is actually a csv that opens with Excel) the order of the columns is random. I read 1 other posting pertaining to this issue and it said to make sure the hierarchy was correct. After spending about 4 hours on the hierarchy order and testing it again it did the same thing. I am dealing with a 17 page form. Did you ever find a solution to this?

If anyone knows how to fix this I would greatly appreciate it!

Thanks,
Lisa
Top
2010-12-14 01:00:12
#3
DaveyB
Registered: Dec 10 2010
Posts: 70
Hi Lisa,

Have you considered exporting the data as eXtensible Markup Language (XML) instead of CSV? Excel can still import it, and will allow you to map the fields it pulls the data into. Take a look at Excel 2007 Help and How-to at microsoft.com for information on this feature.Essentially, a CSV is a spreadsheet, but in text format, and will display the data in the order in which it is found in the file, complete with the header row. XML uses a different data layout, and Excel can use the "headers" contained in the file to map the data to the correct field in an existing spreadsheet, even if the "headers" are not in the same order as the headings in the spreadsheet. The proviso on this, of course, is that the spreadsheet column headers and the XML data headers are the same, which shouldn't present a problem in this case.Hopefully that will give you the information you need to help you resolve your problem :)

DaveyB

LiveCycle Designer 8.0
"Genius is one percent inspiration, ninety-nine percent perspiration." ~~ Thomas Edison
"If at first you don't succeed, get a bigger hammer." ~~ Alan Lewis
"If the conventional doesn't work, try the unconventional" ~~ DaveyB

Top