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

Data Export - please help!

neth
Registered: Mar 17 2010
Posts: 25

Hi all,

I am just designing a form in Livecycle and am almost pulling my hair out trying to figure out how it works! When I export the data to excel the column headings do not come up as the questions i have in my form and they are not in my prefered order. Is there a way to fix this please? The headings come out like this - form1[0].TextField1[0].

Please help!!

Thanks,

Ken

My Product Information:
LiveCycle Designer, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Those are the default names in the data hierarchy. The name of the data is the name of the field. There are two things you can do. First, name your fields appropiately. Second, map your data. The data mode in a LiveCycle form defaults to the form hierarchy. But you can create an XML file that organizes the data the way you want, then attach this to your form, so you don't get those ugly hiearchy names.

But really you need some LiveCycle training. Have you see the tutorials at the official LiveCycle site?
http://help.adobe.com/en_US/livecycle/9.0/designerHelp/index.htm?content=000001.php

You'll also find tutorials and videos on this site.

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
Ken,

I think your issue may be related to a bug in LiveCycle Designer 8.2 where a processing instruction ex. <?templateDesigner StyleID aped3?> gets copied repeatedly into your document. Try updating to Acrobat 9.1 or later to correct the issue. For more details check out the following blog entry:
http://blogs.adobe.com/livecycle/2009/03/post.php

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

neth
Registered: Mar 17 2010
Posts: 25
Thanks for the useful help. Mapping the data sounds like it would solve my problem. Could you explain how to create an xml file that organises my data please? Is this easy to do, I have never used xml?!

Thanks again,

Ken
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
In a LiveCycle form the data organization is "mapped" by adding the XML as a Data Connection. This is done from the menu in the "Data View" window. The specifics of XML grammar go way beyond what I could explain in a forum post. But it's not too difficult. XML is very much like HTML. It's very popular and you'll find loads of info by searching on the web. To see a sample XML layout for your data simply export data from your form as XML.

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script