I have many forms that were filled by users with the data still live (not locked). Using Adobe Acrobat 8, there was no problem to use these interactive pdf forms to merge the data directly into an Excel 2007 spreadsheet. All the data would write onto the spreadsheet. I could even use a combination of xml and pdf files from the same form.
However, since I upgraded to Acrobat 10 X pro, it no longer works. I have first to export each single pdf file to xml. This takes an enormous amount of time that I do not have. The only thing that downloads is the name of the file. None of the live data print to the spreadsheet.
1. Why is this feature no longer working in 10 pro? 2. Is there another way to make this work as with Acrobat 8 or 9? 3. If not possible, is it possible to have both Acrobat version 9 and version 10 on the same computer? (I was told by our IT people that it is not possible).
With no files open in Acrobat, open the Tools Pane, Forms Panel, and click "More form options". From the dropdown choose "Manage form data" -> "Merge data files into spreadsheet". You can them pick a whole series of PDFs or FDFs containing filled form entries, and export them as a single XML or CSV file which will open in Excel.
Sorry! did not work. Got the exact same result as before, with the empty form opened. Just got the titles of
the files in the first column and nothing for the subsequent columns.
It only works if I convert each individual file into xml first, which is too much work because I have hundreds of these files.
This is a serious problem. The Merge datafiles to spreadsheet functionallity does not work in the same way as it did.
I have 300-odd forms from which I extract data, the largest of which has 955 fields. Acrobat X grenerates a csv with 350-odd fields, Acrobat 9 produces one with all 955 fields. Until this issue is resolved I will have to revert to Acrobat 9. This is a serious bug or loss of functionallity that needs to be addressed.
I cannot see how the Action Wizard could be used to batch the export of data to xml - a batch export would probably work as Acrobat X seems to treat xmls differently although I have not had to to fully investigate.