These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

combined pdf with text box data source from excel

Forum Index > JavaScript > combined pdf with text box data source from excel
2011-11-11 15:45:31
sgtsparky
Registered: Nov 11 2011
Posts: 3
Answered

Hi All.
I'm confused on where to start.
I have multiple pdf's, some as single pages and some with multiple pages, that I need to add a Header/Watermark too from an Excel spreadsheet.
My thought was to combine all to a single pdf then apply a textbox with data source but that is proving to be difficult.
So...here's the example;
 
abc123.pdf (1 page)
xyz432.pdf (18pages)
 
excel spreadsheet;
Name Matrix
abc123 321-123-654.02.05-897
 
I copy the Matrix number from excel then paste it into the Header on each pdf but must repeat this function thousands of times!
 
If anyone has any ideas on how I would approach this, please respond ASAP! I'm dying here!
 
Thanks

My Product Information:
Acrobat Pro 10.0.2, Windows
Top
2011-11-11 15:55:43
#1
try67
Expert
Registered: Oct 30 2008
Posts: 2398
This can be achieved with a script, combined with a batch process.
The script would read in the data from the Excel file, and the batch process would use that data to apply the correct header to each file that it processes.
Creating such a tool would require quite a bit of scripting knowledge, though.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2011-11-11 16:10:28
#2
sgtsparky
Registered: Nov 11 2011
Posts: 3
try67,
Thank you for the prompt reply - you've helped out alot in the past!
Would you say that this is the ONLY way to achieve my intended result?
Does the script compare the name of the pdf file to the spreadhsheet (for accuracy)?
Do the pdf's need to be all in one folder? or is there a search directory function? etc.?

Top
2011-11-13 16:23:35
#3
try67
Expert
Registered: Oct 30 2008
Posts: 2398
Accepted Answer
-Yes, I would say that's the only way to achieve this in Acrobat.
-The script can be customized to do whatever comparison is necessary to find a match, including comparing the file name to one of the columns in the data file.
-The files don't have to all be in the same folder. If you run a batch process using the "Selected Folder" option, all sub-folders are also scanned.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2011-11-13 15:46:23
#4
sgtsparky
Registered: Nov 11 2011
Posts: 3
try67,

I do not know how to thank you enough for your patience and skills! You are worth every penny. I will be contacting you very soon for more great scripts.

You did an absolutely fantastic job for me. Your script works perfectly and very fast.
Thank you very much.
Top