Using xlsx or csv file to pick up files

Post Reply
LasseThid
Advanced member
Posts: 354
Joined: Tue Mar 03, 2015 2:30 pm
Location: Molndal, Sweden

Using xlsx or csv file to pick up files

Post by LasseThid »

We have a costumer who has a number of posters in a folder on our server.
Every week they send us an xlsx and a csv file containing names of files and the number of copies they want of those files.
At the moment I have to copy every file listed in the xlsx/csv file, rename them with a numerical prefix and add the amount at the end of the file name and then copy them to the input folder for the printer. This should be an ideal job to automate, but how can I read the rows of text from the xlsx/csv file and have them pick up the correct file while keeping track of which position in the list they have?
Can I convert the xlsx/csv to xml-files and then create an xml file for each entry containing the poisition, file name and amount and then use that to inject the file from the archive and rename the files using the meta data from the xml?

Any ideas or suggestions are gratefully accepted.

Thanks
Enfocus Switch, Enfocus PitStop Server, Enfocus PDF Review, HP SmartStream& Kodak Prinergy with RBA
Offset 72x102, Offset Large Format, Digital Large Format and Digital print.
jan_suhr
Advanced member
Posts: 629
Joined: Fri Nov 04, 2011 1:12 pm
Location: Nyköping, Sweden

Re: Using xlsx or csv file to pick up files

Post by jan_suhr »

Hi Lars,


Take a look at my app Excel to XML. it will do the job for you
Jan Suhr
Color Consult AB
Sweden
=============
Check out my apps
LasseThid
Advanced member
Posts: 354
Joined: Tue Mar 03, 2015 2:30 pm
Location: Molndal, Sweden

Re: Using xlsx or csv file to pick up files

Post by LasseThid »

Sweet! Will do for sure...

Thanks Jan!
Enfocus Switch, Enfocus PitStop Server, Enfocus PDF Review, HP SmartStream& Kodak Prinergy with RBA
Offset 72x102, Offset Large Format, Digital Large Format and Digital print.
Mark Casey
Member
Posts: 23
Joined: Thu Sep 26, 2019 1:47 pm
Location: Leeds, UK

Re: Using xlsx or csv file to pick up files

Post by Mark Casey »

HI LasseThid

Did this do the job? I'm looking for something similar

Thanks
Mark
NEOSA
Member
Posts: 47
Joined: Thu Mar 10, 2016 6:31 pm

Re: Using xlsx or csv file to pick up files

Post by NEOSA »

Mark Casey wrote: Tue May 28, 2024 2:21 pm HI LasseThid

Did this do the job? I'm looking for something similar

Thanks
Mark
You can go there with your eyes closed, Jan is very efficient and responsive in supporting his applications 8-)

I did some similar workflows (with an alternate App, available at the AppStore) : incoming CSV, transformation to XML, Spit XML, sort XML, repurposing sorted XML's, merging those XML, creating a new CSV responsible for driving imposition software.
rhd_ole
Member
Posts: 112
Joined: Mon Jan 24, 2022 5:36 pm

Re: Using xlsx or csv file to pick up files

Post by rhd_ole »

I do this daily using the app List Magic: https://www.enfocus.com/en/appstore/product/list-magic

I'm converting the xlsx to CSV, then use List Magic.

It takes the CSV and outputs each row as it's own text file including the headers. All column headers become privatedata to you can grab the info very easy since everything is already stored. From there all I do is use one of the various inject apps to grab the art from it's location based on the name of the file from that txt file using the privatedata and then off it goes. We also use other columns as needed for qty, print type, sides, etc depending on what is in the excel.

Works flawlessly.

Hope that helps.
Color Science & Workflow Automation
LasseThid
Advanced member
Posts: 354
Joined: Tue Mar 03, 2015 2:30 pm
Location: Molndal, Sweden

Re: Using xlsx or csv file to pick up files

Post by LasseThid »

Mark Casey wrote: Tue May 28, 2024 2:21 pm HI LasseThid

Did this do the job? I'm looking for something similar

Thanks
Mark
Sorry for the late reply.
I don't work as much with Switch any more since most of the flows we need are done and working as they are supposed to (as long as the operators doesn't get creative and change the way they are supposed to name the files for instance... :lol: )

Yes, the Excel to XML app was the solution to the flow I was trying to build and it works perfectly.
Enfocus Switch, Enfocus PitStop Server, Enfocus PDF Review, HP SmartStream& Kodak Prinergy with RBA
Offset 72x102, Offset Large Format, Digital Large Format and Digital print.
Post Reply