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.
WO2015Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
I published an article here at EE that does what you're asking for:
How To Split-Rename-Move a Batch of PDF Files Based on Contents of the Files

But it may need to be modified for your particular situation. Also, you mentioned an Excel Add-On, so if values you need are in Excel spreadsheets, I've also published an article here at EE about that:
How To Rename-Move a Batch of PDF Files Based on the Contents of Corresponding Excel Files

Since your programming skills are very limited when it comes to something like this, I'd be happy to customize it for you, and the cost would likely be very reasonable (probably less than what you pay your vendor annually, based on your comment that you pay the vendor "a lot throughout the year"). The way EE handles situations like this is for you to click the Hire Me button in my profile if you're interested. Regards, Joe

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sarabandeCommented:
We upload many, say 100 accounts a day, the results are in a single .pdf file.
what is the target when uploading an account? how is it possible to get a result of an upload? normally results were downloaded, right? why isn't it possible to get a pdf file after each single upload? or is that not practicable?

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
WO2015Author Commented:
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.)
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Joe Winograd, Fellow&MVEDeveloperCommented:
> 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
WO2015Author Commented:
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?
Joe Winograd, Fellow&MVEDeveloperCommented:
> 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
WO2015Author Commented:
Thank you Joe, let me have a meeting later this week or early next week and we may be in touch!
Joe Winograd, Fellow&MVEDeveloperCommented:
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
sarabandeCommented:
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
WO2015Author Commented:
Thank you Sara!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.