Page 1 of 1

Filename PDF same as record CSV

Posted: Mon Oct 23, 2017 4:29 pm
by dennismeyer
Hi all,

For one of our customers we have a flow to create entrance passes.
The income database (csv) have a structure like below:

Name - Employeenumber
1. Dennis - 123
2. Pieter - 567
etc...

We use HP Smartstream configurator to make the PDF, and the export is somewhing like: Indesignfilname_record1 etc...
The customer want to have this Filename: Dennis 123.pdf

Is it possible with scripting or anything else.

Re: Filename PDF same as record CSV

Posted: Mon Oct 23, 2017 7:37 pm
by sander
If your output contains name_RecordNumber.pdf or something I would lookup the RecordNumber in the csv and rename accordingly.

Re: Filename PDF same as record CSV

Posted: Tue Oct 24, 2017 4:15 pm
by NEOSA
Hi,

May be using CSV2XML from the AppStore ?

Do you pass all the job at the same time ?

As explained by sander, may be also using a Rename tool, with a regEx to search a certain pattern, and rename with regEx also ?

Search for :

Code: Select all

([A-Za-z0-9]*)_([A-Za-z0-9]*)_([A-Za-z0-9]*)_(.*)
Replace by :

Code: Select all

\2_\3_\1
(this is an example)

Re: Filename PDF same as record CSV

Posted: Thu Jan 18, 2018 3:40 pm
by Kermy812
I have used "A Better Finder Renamer". It's great - it has a lot of remanning tools that you'll be amazed at. You'll have to use the function called "Rename from List from list". You'll make a list with the current name in 1 column, then put what you want it to be in the column 2, save as a text tab delimited file. Import the text file into ABFR, then drag n drop the pdfs to rename.
http://www.publicspace.net/ABetterFinderRename/

Re: Filename PDF same as record CSV

Posted: Tue Aug 07, 2018 5:20 am
by james121
I wish I saw this information sooner