Printing Multiple Labels - CSV
Okay, I must be missing really simple here.
I have a label file and an integration setup with all my mappings set (and confirmed through testing a sample label and validating the fields). I'm generating a CSV file that has multiple different items that need to get a label generated. For example, a file will get generated with 5 rows where each row is a different SKU with different data sets.
While testing with integration builder I only ever get 1 label from the first row in the CSV file. I never get any of the other labels within that file. My first thought is that my print step was not a child action of the for each database record step so it was picking up the first record and then not processing the rest. But, I moved the print step under the for each step as a child and I'm still just getting one of the 5 records.
Clearly I'm missing something here but I can't figure it out. I worked with the CSV integration video from Bartender but I'm not getting the results I was expecting.
It does sound like a setting somewhere that is causing this as not come across the same issue. Have you double-checked your label format is set to Queried Records "Al;l" on the File>Print screen in BarTender and not set to First Record Only
Odd thing is I deployed my integration so I could test code changes on the ERP side and it was working fine. But if it surfaces again I'll make sure I check that setting. This is my first go with Bartender as we've been using an ancient label platform called Optio which this will replace.
Thanks for the feedback!0
A bit of an add-on question here. I did notice that when the Bartender integration picks up a CSV file with multiple rows it prints each row as an individual print job. Ideally, I'd like to submit all the rows in an CSV as a single print job. That way I can print the job on the printer and have it cut the labels between each print job.
Now, I either have a print & present where it prints each row as an individual tag and it cuts between each tag or where it prints everything until it gets to the end of its print queue and then cuts.0
Not sure what printer you are using but I would always use one of Seagull's drivers where possible (I have seen some weird/inconsistent results when using some manufacturers own drivers especially when peripherals like cutters and internal rewinds etc are involved).
I would also always control the action of the cutter etc. from inside the driver and not via the front panel configuration of the printer.
For IB have you set up the cutter action in Media Handling section of the Print Properties page?0
After doing some more testing I did find out that the issue is how Bartender handles each row in a CSV file. Say I send a CSV file with 5 rows (5 different tags) my expectation (and the behavior of our previous label platform) was that it would create a single print job that had 5 pages; 1 page for each row. However, Bartender treats each row as an individual print job so I get 5 individual print jobs instead of 1 job with pages.
Which is why I was getting a cut between each label because the print & present setting saw each label as a separate job. Where as if I had 1 job with all the labels it would print everything and then cut the run.
It is important because our pickers pickup the labels off the printer and there are usually multiple labels and they can pickup the set for their order.
So, now I just need to figure out how to get Bartender to behave this way and so far that isn't immediately obvious to me.0
I did go back tot he label builder and ran the print job from there and it does generate a single print job with X number of pages inside that job.0