Pallet Labels
Im trying to print pallet labels that get's it's info from a excel database. I it to recognize the data to put multiple sku's on the label with the appropriate pallet number.
Product # Description Total Units on Pallet Pallet Number Total Number of Pallets Cartons on Pallet Units per Carton
77-24270_B Apple iPhone 5 960 1 3 40 24
77-25876_B Apple iPhone 4 960 1 3 40 24
77-16875_B Apple iPhone 3 960 2 3 40 24
I need the label to gather the information that the two top sku's are on one pallet and the other is on a pallet by its self.[attachment=355:SUPERIOR PALLET(NEW).btw]
Product # Description Total Units on Pallet Pallet Number Total Number of Pallets Cartons on Pallet Units per Carton
77-24270_B Apple iPhone 5 960 1 3 40 24
77-25876_B Apple iPhone 4 960 1 3 40 24
77-16875_B Apple iPhone 3 960 2 3 40 24
I need the label to gather the information that the two top sku's are on one pallet and the other is on a pallet by its self.[attachment=355:SUPERIOR PALLET(NEW).btw]
0
-
If I understand correctly you need to enter the information from several records in the same printed label? If that is the case I'm afraid that BarTender doesn't directly support it.
There is a concept in our world of “multiple records per page/label.” This is generally the world of forms/reports. So, an application like Crystal Reports is set up to do this kind of multiple records per page printing. BarTender was originally not set up for this world.
We may well add this functionality in the future, but it is difficult, because we would then get into some rather deep page dimension issues (variable length pages), how to graphically handle the header versus the body versus the footer, etc.
In the meantime, there are some workarounds you can follow:
1. You will need to create a label format which uses the entire page size as the size of the label. This way, you will be able to place multiple records per label and also place the page header and footer (if needed), but the printing will need to be controlled through the use of ActiveX Automation (ActiveX Automation is supported in the Automation Edition of BarTender).
Furthermore, since version 9 of BarTender, we now have a proper .NET SDK (Software Development Kit), which will allow you to control the BarTender programming class at a higher level.
With your ActiveX Automation application, you will be able to connect to your database, get the variable information, and then place the variable information on the label using the .SetNamedSubStringValue Method.
Please also take a look at the below White Paper documents on ActiveX Automation and our new .NET SDK:
http://www.seagullscientific.com/ftp/whitepapers/WhitePaper_BarTender's.NET_SDKs.pdf
http://www.seagullscientific.com/ftp/whitepapers/WhitePaper_BarTender'sActiveXAutomationInterface.pdf
2. We have a small ActiveX sample which is kind of similar as to what you're wishing to achieve. This sample will help you to indirectly support "Multiple Records per Label + headers and footers (if requested)" on your label / page. As I cannot add the link to download it, could you send us an email to our tech support departement asking for it?
You will need to modify this VB .NET sample for your own use (you will need to own an Automation Edition of BarTender for this).
3. Another workaround would be to use VBScript using ActiveX Data Objects (ADO) and Data Access Object (DAO) database techniques. I've attached a sample for you to examine "DAOMultipleRec75var.btw" (this feature is supported in the Professional Edition of BarTender).
This sample currently has 2-prompts:
The first prompts for the number of records to read and apply to a label object data source.
The second prompts for the total number of required records in the database of the table being used.
The database used is the Microsoft Access database example Northwind.mdb (which you can download from the Internet) which I have placed into the folder “C:\Seagull\”.
In summary, we really do not have an easy way to handle this yet, but it is also not totally impossible.0 -
Has this functionality been added to Bartender yet?
0 -
Hello Glenn,
I'm afraid such feature hasn't been added as of yet, we hope to improve such functionality in the future.
Best Regards.
0
Please sign in to leave a comment.
Comments
3 comments