Filename PDF same as record CSV

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

Filename PDF same as record CSV

Post by dennismeyer » Mon Oct 23, 2017 4:29 pm

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: 257
Joined: Wed Oct 01, 2014 8:58 am
Location: The Netherlands

Re: Filename PDF same as record CSV

Post by sander » Mon Oct 23, 2017 7:37 pm

If your output contains name_RecordNumber.pdf or something I would lookup the RecordNumber in the csv and rename accordingly.
Part of my playground:
- HP Indigo 12.000 | HP Indigo 10.000 | HP Indigo 7600's | HP Production Center
- Scodix Ultra 2 Pro | Highcon Euclid III | CP Bourg booklet maker (inline w/ 7600)

NEOSA
Member
Posts: 27
Joined: Thu Mar 10, 2016 6:31 pm

Re: Filename PDF same as record CSV

Post by NEOSA » Tue Oct 24, 2017 4:15 pm

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 » Thu Jan 18, 2018 3:40 pm

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 » Tue Aug 07, 2018 5:20 am

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