Filename PDF same as record CSV

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

Filename PDF same as record CSV

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

Re: Filename PDF same as record CSV

Postby 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 10k, HP Indigo 7600's (full options), Highcon Euclid III, Zünd S3
- HP Production Pro 6.0.1, HP Production Center 2.5.1 beta, Apogee 10, Enfocus Switch 17u1 & PitStop Server 17.

Chat: open-automation @ gitter

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

Re: Filename PDF same as record CSV

Postby 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

Postby 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/


Return to “PDF Creation”



Who is online

Users browsing this forum: No registered users and 1 guest