CSV Lookup allows a CSV (comma separated values) file to be used as a simple database to help simplify Switch flows. Instead of having to install and configure a database server, design tables, populate with data and write SQL queries, you can simply use a spreadsheet exported to CSV format.
CSV Lookup supports up to 3 "compare" values and up to 4 "lookup" values. Compare values specify which columns in the CSV should be used to locate a matching row. Once a match has been found, CSV Lookup retrieves the values in the "lookup" columns and stores them in the job's private data. These values can be easily retrieved by other elements in your flow using Switch variables.
Solved a HUGE problem for us!
Example: We had a print quantity run list for PDF documents supplied by client that was variable (dates). Page 1 of the PDF required 10 copies at press, page 2 50 copies, page 3 113 copies, etc...
We were able to link our customer supplied run list (Excel) to our switch flow using "CSV Lookup" and generate one PDF will all quantities included, resulting in a PDF of 17,000 pages.
The "CSV Lookup" app saved us 4 hours on the first job, and has completely automated the process.
Thank You Dwight for an incredible app.
Bennett Graphics (Atlanta, GA)