create an automation for printing label for every new data entry from excel to bartender.
create an automation for printing label for every new data entry from excel to bartender. The process would be like this 1. I scan an QR code with values into the excel. 2. Bartender automatically detect the new data entry and print the label. Is this possible or there are any way to do it. The reason why i am using the excel it is because of the QR code value has multiple value and I need excel to convert the value to my SKU standard and let the bartender print. Currently we do this by batches but we need to do it in real time for each scan the printer will print out the label i need.
-
You will need to create a Database Integration to achieve this. One difficulty you may encounter is the locked file issue that you get with Excel as only one person can access the file at a time and the ODBC driver used to create the link would be considered to be a "person" for this and so when a user scan a new code into the spreadsheet they would need to close and save it for the New Record Integration to work.
An alternative would be to create a macro in Excel that say outputs the data into a CSV when it is scanned into the spreadsheet with Integration Builder setup as a File Integration looking for the CSV and then triggering and printing the label.
0 -
Hi Farman,
Creating automation within Excel was something I tried a while back, but it didn't work as smoothly as I needed it to.
If your primary goal in Excel is to break down the QR code string to get the SKU standard required, why not use BarTender's built-in Transforms tab to handle the breakdown process?
If you provide an example of how the QR code string needs to be parsed, there might be an easier way to achieve this directly within BarTender. This could streamline your workflow, allowing you to print labels immediately after scanning the QR code, without relying on an intermediary like Excel.
0
Iniciar sesión para dejar un comentario.
Comentarios
2 comentarios