Bartender Write-to Excel Follow

-1
Avatar
Elizabeth Broadwell

Hi, 

I've got a barcode with serial number label setup.  The serial numbers are pulled from an Excel database, and that connection works fine.  

I need to be able to write into the database record for a specific serial number the date that it was used/printed.  I need this to prevent duplicate serial numbers from being used in the future.  

I've been playing with form-level actions but can't find a good way to make this work.  I'm very new to bartender.  

7 comments

0
Avatar
Eduards Gzibovskis
Comment actions Permalink

What version of BarTender are you using?

0
Avatar
Elizabeth Broadwell
Comment actions Permalink

I'm on the free version right now but we're about to buy enterprise.  

0
Avatar
Eduards Gzibovskis
Comment actions Permalink

At this point I understand you have; 1 excel file (extracting serial numbers), and another database where you'll write (serial numbers from Excel) to a separate database?

And the database you'll be writing to, cannot have serial number duplicates?

Also, does the serial number must come from Excel? In other words, does the serial number link to specific records and extract specific information onto your desired label?

0
Avatar
Elizabeth Broadwell
Comment actions Permalink

I have : 

  • 1 excel file 

This file has two columns: 

  • Serial number 
  • Used/not used

The file is created with the serial number column filled (no duplicates) and the used/not used column empty.  My label file extracts the serial number from the excel file, and if that serial number is printed, I need it to update the used/not used column.  

This way, no two devices go out with the same serial number on them.  

1
Avatar
Eduards Gzibovskis
Comment actions Permalink

Excel File:

Template:

Form:

Form-Level Action:

Form-Level Action:

Form-Level Action:

Form-Level Action:

Form-Level Action:

Form-Level Action:

0
Avatar
Elizabeth Broadwell
Comment actions Permalink

How are you adjusting the SQL command source?  The text in mine doesn't look like that.

 

S/N is the serial number I'm checking, MCH-10RMS is the column that contains my "yes" or "no" entries.  

0
Avatar
Eduards Gzibovskis
Comment actions Permalink

Click "Database Connection Setup" and edit it from there.

Please sign in to leave a comment.