Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Aggregating exported XML data

Avatar

Level 2

I am familiar with the process for saving each XML schema received as a separate file and then using the Tools pane within Adobe Reader to merge these into a CSV file for use in Microsoft Excel. My organization is looking to create program enrolment/withdrawal forms and to send them to a generic email address for processing by a member of the administrative/clerical staff.

Give that ours is a very large organization, there could potentially be countless program enrolment/withdrawal requests coming in each month. Saving the data from each form submission manually, then selecting the XML files to merge seems a time-consuming process. Can someone tell me whether there is a simpler way to aggregate what could potentially be hundreds of XML schema? Automatic aggregation would certainly lift the burden we would otherwise be placing on our admin staff.

Thanks.

1 Reply

Avatar

Level 10

Not sure if this will help but if you are dumping csv into Excel then you could concatenate the data in the form into a single field with comma separated values and maybe copy/paste that into Excel.

You have to write the code to do this copying all the pertinent data into the field and adding commas.

field.rawValue = field1.rawValue + ", " + field2.rawValue + ", " //etc.

I think there are ways to hook into Excel using a schema but I've not done it.

http://forums.adobe.com/thread/795951

http://forums.adobe.com/thread/725817