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

Form generated XML file, fills multiple rows when imported to Excel

Forum Index > Forms: LiveCycle Designer > Form generated XML file, fills multiple rows when imported to Excel
2010-12-09 19:20:21
Yokie Kuma
Registered: Dec 9 2010
Posts: 4

I have created an interactive form where a person can inspect goods and fill out good/bad criteria. They fill in the form and a xml file is generated.
 
I want to import these xml files (1 per inspection, about 10 per day) into an excel file so I can manage the data.
 
However, the xml file, when imported to Excel, takes 20-30 rows (each row has 1 piece of data from the form).
 
How can I get the data so all the fields from the form fill in only 1 row? So then each filled out form would be 1 row of data?
  
Thanks,
Yokie

My Product Information:
LiveCycle Designer, Windows
Top
2010-12-27 16:54:56
#1
Bamboolian
Registered: Jul 27 2010
Posts: 48
Hi,

The point will be how to design the XML.

Probably, your XML should look something like;
<FORM><INSPECTIONS><INSPECTION><GOODS>MAT1</GOODS><QUALITY>FINE</QUALITY></INSPECTION><INSPECTION><GOODS>MAT2</GOODS><QUALITY>OK</QUALITY></INSPECTION><INSPECTION><GOODS>MAT3</GOODS><QUALITY>BAD</QUALITY></INSPECTION></INSPECTIONS></FORM>
If you simply import this XML to excel, you should get result like,
GOODS | QUALITY
-----------------
MAT1 | FINE
MAT2 | OK
MAT3 | BAD


If your form have fixed nubmer of rows (lets say 3 for example) and you want all the data to be outputted in 1 row, then you should design the XML like;

<FORM><GOODS1>MAT1</GOODS1><QUALITY1>FINE</QUALITY1><GOODS2>MAT2</GOODS2><QUALITY2>OK</QUALITY2><GOODS3>MAT3</GOODS3><QUALITY3>BAD</QUALITY3></FORM>
this should give you something like,
GOODS1 | QUALITY1 | GOODS2 | QUALITY2 | GOODS3 | QUALITY3
------------------------------------------------------------
MAT1 | FINE | MAT2 | OK | MAT3 | BAD


And ofcource, if you don't want to change your form, then you can do the work using your excel macro.
But I guess it will be out of this forum's scope.

Top
2011-01-11 00:27:16
#2
Yokie Kuma
Registered: Dec 9 2010
Posts: 4
Thank you for the suggestion.

I've decided to use MSAccess to load the xml data and generate reports .... excel did not quite do what I needed.

Cheers!
Top