Export PDF form data to single file

This Forum is for the use of End Users requiring help and assistance for Tracker Software's PDF-Tools.

Moderators: TrackerSupp-Daniel, Tracker Support, Chris - Tracker Supp, Vasyl-Tracker Dev Team, Sean - Tracker, Tracker Supp-Stefan

Post Reply
petepuma01
User
Posts: 42
Joined: Wed Mar 02, 2016 12:56 am

Export PDF form data to single file

Post by petepuma01 » Wed Apr 22, 2020 12:19 am

We are exporting data from multiple PDF forms to CSV file using PDF Tools using the built in "Export Form Data". If we have X number of PDF forms, we get X number of CSV files. We would prefer to get a single CSV file (or XLSX, etc). Is there a way to get a single file with all the form data? Or do you have a process that will combine multiple CSV/XLSX files into one?

User avatar
TrackerSupp-Daniel
Site Admin
Posts: 4730
Joined: Wed Jan 03, 2018 6:52 pm

Re: Export PDF form data to single file

Post by TrackerSupp-Daniel » Wed Apr 22, 2020 12:26 am

Hi, petepuma01

Currently we do not offer any method to export multiple documents into a single file, but that is in the pipeline now that we offer the ability to import form data with multiple variants being used.
I cannot promise a timeline, but it is on the way.

Kind regards,
Daniel McIntyre
Support Technician
Tracker Software Products (Canada) LTD

Support: <Support@tracker-software.com>
Sales: +1 (250) 324-1621
Fax: +1 (250) 324-1623

millsy
User
Posts: 1
Joined: Wed Jun 03, 2020 2:04 pm

Re: Export PDF form data to single file

Post by millsy » Wed Jun 03, 2020 2:16 pm

Hi petepuma01,

I found a workaround, using Excel's Power Query, to get all the form information into one spreadsheet, as long as the forms are all the same format.

Once you have all your separate csv files from PDF Tools , move them into a separate folder.

In Excel, open a blank spreadsheet, go to Data – Get Data – From File – From Folder

Pick the new csv folder. It opens a window, click on Transform Data and it opens a new Power Query Editor Window, it should show a list of all the different csv files.

On the first column you should see two down arrows in the header. Click on this, one row will appear, hit ok and all the info from the csv files should appear. You can either clean you date up here or later. Click on "close and load" on the top left and all the info should appear on a spreadsheet.

User avatar
Tracker Supp-Stefan
Site Admin
Posts: 14755
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Export PDF form data to single file

Post by Tracker Supp-Stefan » Wed Jun 03, 2020 2:34 pm

Hello millsy,

Welcome to our forums, and many thanks for sharing your solution! I am sure it will be useful to others as well!

Kind regards,
Stefan

labrat
User
Posts: 1
Joined: Tue Jul 20, 2021 3:22 am

Re: Export PDF form data to single file

Post by labrat » Tue Jul 20, 2021 3:59 am

I was dismayed when I saw the directory containing 150 .csv files, but I found a simple solution to combine the .csv's using Windows PowerShell. Put all of the .csv files into their own directory and open a PowerShell session in that directory. (This can be done by opening File Explorer to that directory and typing "powershell" in the address bar.) Paste the following into the command line:

Get-ChildItem -Filter *.csv | Select-Object -ExpandProperty FullName | Import-Csv | Export-Csv .\combinedcsvs.csv -NoTypeInformation -Append

This creates an additional file named "combinedcsvs.csv" containing all of the .csv files in that directory with the header from only the first file at the top. The only issue I saw is that all of the fields, including numerics, are in quotes, but Excel or OpenOffice can ignore the quotes on import.

I hope this helps folks.

User avatar
Tracker Supp-Stefan
Site Admin
Posts: 14755
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Export PDF form data to single file

Post by Tracker Supp-Stefan » Wed Jul 21, 2021 10:36 am

:)

Post Reply