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

XML TO DATABASE

Forum Index > Forms: LiveCycle Designer > XML TO DATABASE
2009-09-25 11:44:00
oksana77
Registered: Apr 24 2009
Posts: 89

When I send a survey form and receive it back as xml... is there a way to combine all survey answers in one database table? When I try to import my xml to db, I get too many tables and too many columns with wierd names that it is very hard to follow. What is wrong with the survey?

Would it be more efficient to save survey data directly to database from pdf? Many people are using xml. Is there a better way?

My Product Information:
LiveCycle Designer, Windows
Top
2009-09-30 07:32:28
#1
stonesrock
Registered: Feb 27 2007
Posts: 54
How did you design your XML schema for your PDF form?

How are you pulling in the XML into your database?
Top
2009-09-30 15:14:37
#2
oksana77
Registered: Apr 24 2009
Posts: 89
I am using LiveCycle designer to design the form and than I export the filled form data to xml. I open access database and import the xml there.
Top
2009-10-09 11:48:02
#3
stonesrock
Registered: Feb 27 2007
Posts: 54
So you are using the basic XML import functionality of Access? I know I tried that, it is a pain because of the shema's differing. What I've done is use VBA to "push and pull" data to interact with form. The VBA code pushes out the XML schema, I build the form, then once the XML is generated from form, use VBA code to pull in data.
Top