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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes