Start with Form Prompt before label select 追蹤

0
Avatar
arron connor

Hi,

We currently have multiple labels set up, we pick the correct label, press print and then fill in the part number prompt which pulls the other data, description, QR, barcode etc.  This requires that you know the right label to begin with.

I am trying to change this so a form prompt pops up and asks for the part number.  This would then pick the correct label from the database, which would be linked to the appropriate printer.

How do I start with this?  Not even sure if designer is the right thing to use or should I be using process builder?

6 意見

0
Avatar
Pete Thane
評論操作 永久連結

As you correctly say for BarTender you need to tell it what label to load and then perform the database look up to pull the correct data from to populate and print the label. 

To adjust this order then some other software would normally but needed , but if you have the Automation (or Enterprise) version then you could create a "label" that does not print but that at print time performs the database lookup and then outputs the data, including the label format name to a text file via the use of the Actions option in the Data Entry form options. Depending on your database you may need to output all the data required for the label including the label format name to use or else just the label format name and the database query/lookup value. With some databases (such as Excel) only one "person" can access a database at a time and BarTender would class as a person and so the actual print operation could be blocked in these instances which is why I mentioned outputting all the required data.

If all the data is output you would need to rejig your labels to use a text file as the database. 

You would then need to run an Integration (created via Integration Builder) that triggers when the text file is detected. The name of the label format to use can be configured as to be read from one  of the data fields contained in the trigger file and it can also include the database lookup value too or else all the other data required for your label. 

0
Avatar
Pete Thane
評論操作 永久連結

Sorry meant to add this image of the Actions screen as mentioned above

0
Avatar
arron connor
評論操作 永久連結

Hi Pete,

 

Thanks for the reply.  Yes using automation edition.

Its pretty powerful software, can't believe there's not an option baked in to deal with multiple networked printers

0
Avatar
Pete Thane
評論操作 永久連結

Yes it is very powerful but it is label printing software and so you have to tell it what label to open. It is the same as opening a Word document, for example, if you dont know the name of it you have to open Word itself  first and then search for the document you want. 

For your scenario normally some other software would be involved (could be from an ERP system for example) that can pick out the required label name and then send the instructions to BarTender what label to use etc. but the above shows one way how it could be achieved without a third party program.

There is another alternative, if you labels are the same size, and that would be to have multiple templates (or layers) contained within the same label and use conditional printing. For example, the image below shows a label with 3 templates with different layouts:

In the Page Setup you can configure the label templates to print only in certain circumstances via the use of conditional printing. For this example I have named the field on Template1 "ColourChoice" and have linked this to a Red/Blue Radio button on the Data Entry Form but with conditional printing the control item/data can come from a database. In the image below I have set Template 1 to not print at all, template 2 to only print when ColourChoice equals Red and am part way through setting Template 3 to equals Blue. The second image is a Print Preview of the result of a Red choice

Maybe this method would suit your application better. 

0
Avatar
arron connor
評論操作 永久連結

Sadly all different label sizes and formats.

The aim is to idiot proof it, so if a person knows the part number they can print the correct label with no knowledge of all the sizes.  I may well have a look at ERP integration.  I just know any ERP development ends up coming with a big cost

thanks for your efforts on this

0
Avatar
Pete Thane
評論操作 永久連結

No problem.

Depending on your setup and labels you could maybe reduce the choice if a certain size of label is customer specific for example by adding additional filter in to your database query for example but would still need to have at least one label design per size. which doesn't match your initial requirements. 

登入寫評論。