Capture page count in multiple PDF files

Post Reply
beastridge
Newbie
Posts: 6
Joined: Sun May 27, 2012 7:11 pm

Capture page count in multiple PDF files

Post by beastridge »

Looking for a way to capture the file name and page count in many, over 10,000, PDF files and write to a text or csv file. The files are nested in 100's of folders and sub folders. Currently we have a csr writing this data into a spreadsheet but that is very time consuming. This is done, more or less, for data collection to determine job costs. Each file has a copy count of two, so the quantity of each is static. I am trying to get approval to purchase the database module but until then I wanted to see if there was another way to do this in Switch. We do have the scripting module but I am not knowledgeable enough with scripting to do this at this time. :? Thank you for your time!
bleuprocess
Newbie
Posts: 2
Joined: Wed Nov 23, 2011 10:43 am
Contact:

Re: Capture page count in multiple PDF files

Post by bleuprocess »

Hi beastridge :)

I developed a script/module, which allows to do exactly what you are looking for (amongst a lot of other things - basically, you can log anything in a txt/csv file - it is completely configurable and this will suit many more use cases than only this one).
The cost of this script is much cheaper than the database module (and everything logged here would be possible to be imported to a database the day you would like to upgrade to the database module).
If you are interested in, just PM me and I'll explain more about it.

Best,
Christian
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Re: Capture page count in multiple PDF files

Post by gabrielp »

You can also do some database stuff with this script: https://github.com/open-automation/switch-sql-query
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
Dave23
Member
Posts: 41
Joined: Thu Oct 12, 2017 4:42 pm

Re: Capture page count in multiple PDF files

Post by Dave23 »

Hi,

I was wondering gabrielp do you by any chance have a flow that has this script working? i'm quite new to switch and I can't seem to get it to work.

Cheers
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Re: Capture page count in multiple PDF files

Post by gabrielp »

I don't have any off hand. The trickiest part of using this script is configuring an ODBC connection. If you have specific questions, you may find some help here: https://gitter.im/open-automation/Lobby
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
Dave23
Member
Posts: 41
Joined: Thu Oct 12, 2017 4:42 pm

Re: Capture page count in multiple PDF files

Post by Dave23 »

Alright gabrielp, apologies I have tried looking on the link you provided but couldn't find much on that script. I have created ODBC connections which work great with the database module that I have. I just thought maybe this script will make creating a csv file quicker if in fact it actually does this?

What I am currently doing is using sed via execute command I am writing one row at a time to a csv file from sql. I wanted to make this process quicker by writing multiple lines, i thought maybe this script could help with this? Although i cannot seem to execute it properly. In the sql query I have put in multiple select statements, query type: Direct and result type: multiple result value.

Cheers
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Re: Capture page count in multiple PDF files

Post by gabrielp »

You can use this script to pull out multiple rows as an XML dataset. Then you can look for a script/app or build one which converts XML to CSV.
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
Post Reply