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.

Problem merging XML files into a spreadsheet (CSV file) - no data

Avatar

Former Community Member
Hey all,



I have just upgraded to Acrobat Professional 8 and created a survey with Designer. I have sent it out to some people and got two XML files back. The files themselves contain the answers, I see the data there. I have re-named the files and saved them in a folder on my desktop.



I then open Acrobat Pro 8, go to forms > manage form data > merge data files into spread sheet, "add" the two XML files from that folder, then click "export" and save as "report.csv", which is the default setting. It comes up with a window saying "Done!" and I click on "View File now". This opens Excel, which is what I want.



THE PROBLEM IS that there is no data and I only see the two FILE NAMES in column A row 2 and 3. The file names are in full with ".xml" at the end. The data within the XML files (that I want) does not appear in this CSV spreadsheet that I just created.



One further comment: I did not have this problem with Acrobat Pro 7, the data sets came out and I easily edited them, created graphs etc.



Can you please provide some advice as to how I can solve this?



Best regards,

Dima Ivanov
16 Replies

Avatar

Former Community Member
Hello Dima,

I am trying to do the same thing and are getting the same results as you. There is a Free XML Toolbox you can install into excel to help import data - but you must have Enterprise version of excel.

Also keen to find the answer

Cheers

gazzzz

Avatar

Former Community Member
It appears that no one ever posted an answer to this question. However, I am having the exact same problem today. It's definitely Acrobat 8 related, because I can export the .xml files into spreadsheet using Acrobat 7. Any ideas?

Avatar

Former Community Member
Same probleme here. It simply doesn't work anymore in 8. Gazz how do I use this excel toolbox?

Avatar

Former Community Member
Having the same problem as well in Acrobat 9. The functionality to merge worked for me once on one file and then stopped working.



I wish someone could help with this issue. I have numerous FDF files that to merge to together in a CSV.

Avatar

Level 7
If you're trying to do it in Acrobat, this is a different problem. I

recommend the Acrobat forum. Be sure to describe in detail what you

are trying to do.



Aandi Inston

Avatar

Former Community Member
I have the same issue.



I need an answer URGENTLY?

Avatar

Level 7
Let's be sure, especially as this is urgent. Are you sure you are

using the LiveCycle Form Manager product? If not, posting in the wrong

forum won't speed anything up...



Aandi Inston

Avatar

Former Community Member
Yes.



Create the form in Livecycle



Send it out through Acrobat exactly as first post Dima Ivanov



Thanks

Avatar

Former Community Member
Yes, it's still broken, but I did discover a workaround. When Merging Data Files into a Spreadsheet in Acrobat, save the output file as XML rather than CSV. That creates a long XML document that contains all of the original files in a serial format.



Now, open Microsoft Excel. From the toolbar, select Data > XML > Import. Import the report.XML file. Click OK to allow Excel to create a schema, and OK to list data in existing worksheet.



That's it. This solution has consistently worked for me and others I've shared it with. Meanwhile, I do think Adobe owes it to us to fix the thing after all this time.

Avatar

Former Community Member
Hi John,



Agreed Adobe owes us a fix?



I have tried this but find it difficult with multiple XML files. Do you have a solution for this?



Thanks

Avatar

Former Community Member
For what it's worth, I was able to populate Excel using the Merge Data Files into Spreadsheet feature as long as the form being referenced in the XML files is available on my PC. When I changed the file name of the form to something different prior to using the Merge Data feature all I got was a CSV file in Excel with the file names I was merging.



Hope this helps,

Johnny

Avatar

Former Community Member
I am having the same problem with Acrobat 8. It used to work, then eventually it would work every other time, now it won't work at all. I called their tech support and after holding for 5 minutes the phone rang and then hung up on me.



Good job Adobe.

Avatar

Former Community Member
I have found that if I save the output file in the same directory as the source files, the compilation works properly.



I will not be spending any of my own money on Adobe products, however, due to the state of their support.

Avatar

Former Community Member
Problem solved!.. Well not exactly.. its bit longer, but much matter than manual copy & paste.

..works for me..



We can first export it as a .xml database. (which is using Acrobat->Forms->Manage Form Data->Merge Data Files into Spreadsheet ->Add Files (add your multiple xmls)->export -> Export as ".xml ", in types, select .xml, This options would merge all the xmls into one xml database.



(Acrobat lost the ability to merge things into .csv file due to Window's .net framework updates.. but ability to export as .xml would always be stable)



Then, in excel



Data-> xml ->import->(select your file, the final xml data base)



then you'll have your list!



^_^

Avatar

Former Community Member
Tim's solution does not work for me. Acrobat 9 saves its form data in XFDF format (looks like XML to me). However, the Merge data feature has CSV conversion and no other--and the excel spreadsheets come up with no data, just the filenames in column 1.



Is there a workaround that Adobe might have? We counted heavily on this feature when we designed our surveys, and it was nifty until a few days ago. Now, its one more non-working "feature."

Avatar

Level 1

SOLUTION FOUND!!!!

Felt like a positive heading for a change Dima here, the originator of the post.

Well, I now have VISTA and Acrobat9 - bought CS4 a while ago. And alas - the SAME FREAKING PROBLEM as I had on XP and Acrobat 8.

Now, luckily I found my post. Read everyone's feedback, and have some great news:

1. If you read above, you'll find how to merge into an XML file, as opposed to merging into a CSV. I then imported this "merged" XML file into Excel 2007 as data, pressed all the "ok" buttons that came up and A MAGIC TABLE with all data nicely populated appeared! Task complete.

2. To test the other theory, I simply copied my original interactive PDF file that I mailed out to everyone INTO the folder with all the re-named XML replies. Then, when I was selecting the "data files to be merged" I just selected ALL of the files in the folder (Ctrl+A). May be it selected the PDF file as well, not sure. Anyway, I then saved the "report.csv" that was created into this folder also. This made for a messy folder. BUT - it WORKED!!!!!!

It seems the engine for collating the info is working, but Adobe forget to give you some instructions to place original PDF file into the folder with all the XML replies.

Adobe - this could be a simple message when you go to select the XML replies. Good luck with fixing this bug!

Hope this helps others,

Cheers

A happy Dima Ivanov