Using xlsx or csv file to pick up files

[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

[jan_suhr]

Hi Lars,


Take a look at my app Excel to XML. it will do the job for you

[LasseThid]

Sweet! Will do for sure...

Thanks Jan!

[Mark Casey]

HI LasseThid

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

Thanks
Mark

[NEOSA]

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

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]

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.

[LasseThid]

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... )

Yes, the Excel to XML app was the solution to the flow I was trying to build and it works perfectly.