Csv Label Files And Sorting S’abonner
Our current warehouse-level retail control system exports a label file for each of our member stores in a standard CSV format. The export is generated as it goes through the UPC listing. Our existing label printing software that we are looking to replace has an option to sort the items imported form the CSV file into whatever order we need. I am testing the latest Enterprise Automation Trial (version 10.01 SR3) of Bartender on my local PC (Windows 7) to see if it will meet our needs. So far I am able to replicate our label formats and print the different forms and templates. The one issue I am currently having is figuring out how to achieve the final sorting. We normally sort the printed label output in numerical order by two of the fields inside the CSV (category and then warehouse item code). I cannot get this to work in Bartender. Any ideas?
6 commentaires

Legacy Poster
There is a "Sort" tab inside the database connection setup screen within BarTender. Does this have the functionality you're looking for?
Well, you're right. I don't have a sort tab either when I import a .csv or .txt. When I import a .xls, it is there. I wonder why this is Seagull?
Steven,
You can try to create an ODBC User DSN using the "Microsoft Access Text Driver" in ODBC Administrator, and then connect to this source from BarTender's database connection setup dialog. Do this by selecting "ODBC Data Source" and then your User DSN. Once connecting to the data source, you will see a "Sort" tab.
For your issue of naming the .txt file, the Commander utility actually has the ability to "Use Trigger File A Data File" or something like that. This means your .txt file could be any name and Commander will know to use that as the data when it triggers a print job.
Vous devez vous connecter pour laisser un commentaire.