WO2015
asked on
Splitting PDF's and renaming
Hello,
We are currently using a vendor for a daily project which cost us money, a lot throughout the year. The reason we use a vendor is because we are unsure how to do this our self or if there is a software out there that would complete our task. Here is the process:
We upload many, say 100 accounts a day, the results are in a single .pdf file. The issue is 1. All 100 or more results are combined into 1 PDF file. We need them separated (which is what our vendor does). 2. The separation the vendor does also lets us using a naming convention that have the file number in each so we can easily find the specific pdf's down the road. They have an Add-On within Excel that does all of this.
Our skills as far as programming are very limited when it comes to something like this. Are there any programs or maybe a easy way to program our self the split of the pdf's but also the naming convention with the specific file number in each?
Thank you.
We are currently using a vendor for a daily project which cost us money, a lot throughout the year. The reason we use a vendor is because we are unsure how to do this our self or if there is a software out there that would complete our task. Here is the process:
We upload many, say 100 accounts a day, the results are in a single .pdf file. The issue is 1. All 100 or more results are combined into 1 PDF file. We need them separated (which is what our vendor does). 2. The separation the vendor does also lets us using a naming convention that have the file number in each so we can easily find the specific pdf's down the road. They have an Add-On within Excel that does all of this.
Our skills as far as programming are very limited when it comes to something like this. Are there any programs or maybe a easy way to program our self the split of the pdf's but also the naming convention with the specific file number in each?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Its a website the department of defense website. We have to go there to see if someone is in the military. (https://www.dmdc.osd.mil/appj/scra/multiple_record.xhtml). We wish it were possible to get them separated and named already.
With the acrobat is it possible to select a naming convention based off something that is in the actual PDF, like the file name? This is a must for us in order to find files down the road.
I am going to read more about Joe's solution, I was hoping there was something a little easier though. My employees may not understand all the steps, the software we use is so simple and easy (I guess that's what we are paying for.)
With the acrobat is it possible to select a naming convention based off something that is in the actual PDF, like the file name? This is a must for us in order to find files down the road.
I am going to read more about Joe's solution, I was hoping there was something a little easier though. My employees may not understand all the steps, the software we use is so simple and easy (I guess that's what we are paying for.)
> I was hoping there was something a little easier though. My employees may not understand all the steps, the software we use is so simple and easy (I guess that's what we are paying for.)
My solution will be very simple and easy for your users. They will not have to understand any steps. They will simply browse to the single PDF file that has all of the accounts in it. My program will separate that PDF into one PDF for each account and will automatically apply whatever naming convention you want, such as putting the account number in each file name. The cost of this program is likely to be less than what you pay your vendor annually and may be even be in the price range of Acrobat XI Pro. Regards, Joe
My solution will be very simple and easy for your users. They will not have to understand any steps. They will simply browse to the single PDF file that has all of the accounts in it. My program will separate that PDF into one PDF for each account and will automatically apply whatever naming convention you want, such as putting the account number in each file name. The cost of this program is likely to be less than what you pay your vendor annually and may be even be in the price range of Acrobat XI Pro. Regards, Joe
ASKER
Joe,
Does the naming convention pull from the actual PDF file? How would I get a hold of you if my business partners are in fact interested in testing this and seeing about a price?
Does the naming convention pull from the actual PDF file? How would I get a hold of you if my business partners are in fact interested in testing this and seeing about a price?
> Does the naming convention pull from the actual PDF file?
Yes!
> How would I get a hold of you
EE doesn't allow putting email addresses in posts, so go to my profile and click the Hire Me button. It doesn't really mean that you're hiring me (yet) — it simply sends an email to me and at that point we can start communicating privately (perfectly legal at EE). Also, I will send you a message via the new EE Messaging System. If you haven't used it yet, it's very nice — it will at least get us started communicating and then we can continue via email. Regards, Joe
Yes!
> How would I get a hold of you
EE doesn't allow putting email addresses in posts, so go to my profile and click the Hire Me button. It doesn't really mean that you're hiring me (yet) — it simply sends an email to me and at that point we can start communicating privately (perfectly legal at EE). Also, I will send you a message via the new EE Messaging System. If you haven't used it yet, it's very nice — it will at least get us started communicating and then we can continue via email. Regards, Joe
ASKER
Thank you Joe, let me have a meeting later this week or early next week and we may be in touch!
You're welcome — and thanks to you for the follow-up. I look forward to hearing from you next week. I'll send you a message now via the EE Messaging System. Regards, Joe
With the acrobat is it possible to select a naming convention based off something that is in the actual PDF, like the file name? This is a must for us in order to find files down the road.just to answer your question: yes, the acrobat pro allows to access all contents of a pdf. i know solutions which added images to an existing pdf or a watermark. it is not so much different from the solution offered by Joe, beside that the automation covers the full functionality of acrobat pro (and more as you actually have a programming language to add your own customization). you also may do the split manually. i found the following link where they discussed a custom split similar to your requirements: https://acrobatusers.com/tutorials/how-to-break-a-pdf-into-parts. as far as i understood the method it is to add headers and footers to separate the parts into pages. then you can split the pages into multiple files with automatic renumbering.
however it looks as if you would need some programming experience to get it fully working. so, you will go fine with Joe and i wish you both much luck and success.
Sara
ASKER
Thank you Sara!
my questions were targetting at whether it could be possible to already get the infos separated and then easily would store them as wanted into a file or database.
an even simpler solution would be if you could get the results as a text file in list format or as csv file. both formats easily could evaluated line by line.
if the pdf file is a must, you could use automation with acrobat pro to do a split. there are a lot of sample programs coming with acrobat such that it is not really difficult to adapt one of them for your purposes. acrobat pro is not cheap but as you would need only one license it might be a bargain nevertheless. non-adobe pdf suites are much cheaper but i don't know one whcih supports automation. however, those programs would give a cheap and quick way to do the split interactively and renaming the output files to your needs can be made with a simple script if the pdf suite couldn't be configured to your wishes directly while doing the split.
Sara