We have large statement files with up to 10,000 bookmarked accounts. we can split them using Acrobat X Pro but we need a corresponding CSV file to use as an index file to process the pdfs into a data base. How do we create the CSV file?
creating a CSV file when splitting a PDF
2011-09-29 08:56:50
My Product Information:
Acrobat, Windows
Acrobat, Windows
2011-09-29 09:41:10
#2
Thanks for the response. We are using the Split tool. We were told by a sales rep that X Pro would create a CSV. But not that we would need to write a script to do it. Are there canned scripts available that we could modify to pull out the fields we need? I watched your getting started tutorial and on the trial version of X pro we have I don't have an Advanced tab. Are you aware of any other products that will do what we need without writing scripts? Thanks again.
2011-09-29 10:10:09
#3
Do you mean a CSV file of the bookmarks structure? If so, then you can use this script (the text version), created by me: http://try67.blogspot.com/2008/11/acrobat-export-bookmarks-to-pdf-txt.php
If you need the output to have a specific format, I can adjust it for you.
If you need the output to have a specific format, I can adjust it for you.
2011-09-29 10:49:02
#4
What we really need is an XML file in a specific format (which includes the bookmarks as index values) to load the split PDF files into a database. We have a program that will read a CSV file and build the XML file. We need Acrobat to build the CSV. The CSV file needs to contain the bookmark values and the name of each split file.
The following would be an example of the CSV record from the bookmark IXO^999999999^_^06/24/2011^test account.
"FileName","VAR_APP","VAR_ACCT","VAR_RMACCOUNT","VAR_END_DATE","VAR_NAME_PRI"
"IXO_9999999999_000000.pdf","IXO","9999999999","_","06/24/2011","test account"
The following would be an example of the CSV record from the bookmark IXO^999999999^_^06/24/2011^test account.
"FileName","VAR_APP","VAR_ACCT","VAR_RMACCOUNT","VAR_END_DATE","VAR_NAME_PRI"
"IXO_9999999999_000000.pdf","IXO","9999999999","_","06/24/2011","test account"
2011-09-29 10:54:09
#5
Yeah, that's possible. Send me an email (the address is in my signature) and we could discuss it further.
The only way to create a custom CSV file is to write a script. If you're already using a script to do the splitting then this is just addition. But if you are not using a script you'll need to write one to analyze the doc and produce the CSV you need.
The general method is to create a string variable to hold the raw CSV Text data as the document is being analyzed, then at the end of the analysis process write the string into an attachment on the file.
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script