Query on BarTender integration & abilities.
I’m in the pharmaceutical print industry. We produce inserts/outserts/books etc. for the medical industry. Our operators currently print labels for our product on the work floor from a communal computer. This has to be accessed by 15-20 people. The MIS software we use has limitations when it comes to printing box labels. All the information is on the system but gaining access for 15-20 operators is not feasible. We currently print labels using third party software but our operators are required to input the information manually leading to human error along with being time consuming.
We are now looking to invest in new label printers to streamline the process. For this to happen we need to have a third party application that links to our MIS database. We want to end point enable the operator to input a unique job number and for the rest of the information that is linked to that job number to populate automatically onto the label. This will alleviate the amount of manual input each operator will need to do.
So our aims are:
- Operator enters a job number (They will have this number exp. 57582) into a form.
- They will enter the box quantity.
- All other information is populated through from the database.
I have downloaded BarTender trial and have linked the MIS database from which the information will pull. I want to know if it’s possible that the operator can just input the job number and that all of the other information (Product Code, Quantity, Delivery Address Etc.) can be populated from that.
I’ve already linked the database and seen that the correct information appears, but I’m a bit lost when it comes to creating a data entry form that will just require the operator to enter the box quantity and job number. I’d like the operator to have a window pop up where it asks for the job number and box quantity and that is all they can input as all other information that is linked to that job number will pull through.
I’d like to test the labels in the trial edition before making a commitment to the software & label printers (Zebra ZT410).
-
It sounds like you should create a BarTender document that connects to the MIS database where the information that you wish to print is located. Then in the database setup create a query prompt and build a filter that searches on the desired field, uses an operator like "=" for an exact match, then the name of the query prompt for the criteria value. Next create a data form for the document, place a text input form control down and link the control to the query prompt data source. If you want to show visual confirmation of the found record, either use the record picker form control, or place other text fields on the form that link to database fields and set their value to read only - thus making them informational only.
The below sections of the BarTender Support Center should also prove helpful:
https://support.seagullscientific.com/hc/en-us/sections/200754157-Working-with-Databases
https://support.seagullscientific.com/hc/en-us/sections/200767858-Data-Entry-Forms
請登入寫評論。
評論
1 條評論