Skip to main content
Participant
September 17, 2019
Question

PDF Merge Data Files into Spreadsheet Crashing

  • September 17, 2019
  • 1 reply
  • 2005 views

An employee is attempting to export the data of a form they created into Excel (csv) using the Prepare FormMerge Data into Spreasheet... option where you can select multiple forms to export the data. I have tested this on my computer and it seems that I can only get 252 documents to export and honestly on the 253rd file it crashes and the csv is 0kb. The said employee has much more difficulty getting less or more than 100 facing the same issue.

 

Is there a limitation to how many forms you can export to CSV? Could this be a form issue or is this a limitation to Acrobat? As well, if anyone has faced this issue before, do you have any recomendations to other tools that could be use to achieve this?

    This topic has been closed for replies.

    1 reply

    ls_rbls
    Community Expert
    Community Expert
    September 17, 2019

    Hi,

     

    Maybe you meant clicking on "Edit" ---> selecting "Form Options" ---> then selecting "Merge Data Files into Spreadsheets" ?

     

    This "Merge Data Files into Spreadsheets" menu option is not accessed through the "Prepare Form" tool add-on and it is independent from it.

     

    As far as exporting to a CSV file using the method above, when you click on that option the dialogue box that will pop has a tip with a light bulb icon that says: "Data Files you add should be from the same form". So what I did first I tried to push to the limits my crappo computer and merged about 100 PDF  files in a single document (which took about roughly 2 minutes to optimize and verify signatures on documents etc.), Then used the "Merge Data Files into Spreadsheets" and it created  CSV file out of a 2900 pages long single PDF document with no crashes.

     

    I also recreated your scenario adding  up to 324 pdf files using the method you are describing in your post and adding the files from different folders and directories in my compputer; then  merged for an export.

     

    It ran in under 1 minute and 10 seconds without crashing.

     

    I also had Acrobat DC with 4 documents opened through 4 different tabs, one of them a heavily edited Georeferenced map PDF file, two different browser opened at the same time, one of them with up to 14 different browsing windows opened simultaneously in the same broswer, Task Manager to monitor these processes, and a heavy download of a program running in the background that is performing an online installation in my computer (for about  an hour now , and is still has a long way to go as I type here).

     

    NOTE: My system is a crappo eMachines El1352 series (with EoL support from the vendor) , it used to have Win7 64bit and I forced an upgrade to Windows 10 on top of Windows 7 (not a clean install) with the following hardware specs: two different generic 4GB RAM sticks (taken from old unused computers) which  adds up to 8GB of unganged RAM, with an AMD Sempron 145 processor (2.8GHz) with very old SATA hard drives and a disconnected DVD-ROM.

     

    So my recommendation would be, did you try to upgrade your Acrobat to the latest version first?

     

    Can you confirm if before you perform the merging that the files that you are adding are saved locally in a directory of the hard drive of that computer and not in a shared or TEMP folder,  and that such files are not being opened simultaneously by different users ,( if shared on a network , for example) as you try to do the merge?

     

    Participant
    September 17, 2019
    Thanks for your reply, quite extensive troubleshooting however I don't seem to get the same results as you. Are you working with PDF forms that are filled in?
    Participant
    September 17, 2019

    Sorry, thought SHIFT+Enter would give me a new line. I have updated my Adobe Acrobat 2017 to the latest it could give me (17.011.30148) but still Adobe crashes and produces a 0kb csv file. The process I am doing is to open a form and go to Prepare Form, then on the right under "More" with a wrench and hammer, there is an option to Merge Data Files into Spreadsheet. The files did reside on a network location however for obvious testing thinking that was the issue I have moved them to my desktop.

    What version of Adobe do you have?