I have a number of bartender label templates that create PDFs from CSV data files.

These PDFs are sent via email to warehouses around the country - they used for shipping multiple products to multiple customers.

All of this works flawlessly via combination of Bartender integration tasks and a few PowerShell scripts.  Except for one thing.

To make everyone's life a little easier, I use the option add the contents of certain database fields within those CSV files to the PDF file name.

99.99% of the time this works.  The CSV files are mapped via database connections to make sure the right things are printed on the right parts of the label. 

One of those things is the order number, which I also use as part of the file name (it's a cool feature of the PDF printing process).  The only time this doesn't work is if the CSV file only has one line.

When I check the fields via the database connection everything is there.  But when I try to print the PDF I get the error message "The file name contains unknown database field names or data sources.  You must manually remove these from the file name or else cancel the print job".

If I edit the CSV file and copy/paste the 1 line of data so there are now 2 duplicate lines of data, the label prints the PDF using the contents of the database field in the file name without any issue.

1 line of data in the CSV file - cannot use the contents of database fields in the filename.

2 or more lines of data - it works.

It isn't the data, because if it was duplicating it as additional lines would not work.

The problem is while it seems like a small thing - not being able to add additional information to a file name - doing so makes the lives of the people working with the labels so much easier.