Filename PDF same as record CSV

Post Reply
dennismeyer
Newbie
Posts: 2
Joined: Mon Oct 23, 2017 4:25 pm

Filename PDF same as record CSV

Post 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.
sander
Advanced member
Posts: 274
Joined: Wed Oct 01, 2014 8:58 am
Location: The Netherlands

Re: Filename PDF same as record CSV

Post by sander »

If your output contains name_RecordNumber.pdf or something I would lookup the RecordNumber in the csv and rename accordingly.
NEOSA
Member
Posts: 39
Joined: Thu Mar 10, 2016 6:31 pm

Re: Filename PDF same as record CSV

Post 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)
Kermy812
Newbie
Posts: 5
Joined: Wed Jan 17, 2018 4:45 pm

Re: Filename PDF same as record CSV

Post 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/
james121
Newbie
Posts: 1
Joined: Tue Aug 07, 2018 3:47 am

Re: Filename PDF same as record CSV

Post by james121 »

I wish I saw this information sooner
Hello guys, I'm James from JSON formatter online team. Our projects are: roll the ball and slope game . Hope your help, thank you!
Post Reply