Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

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