Skip to main content

Search

Search

Bartender Write-to Excel

Comments

7 comments

  • Avatar
    Eduards Gzibovskis

    What version of BarTender are you using?

    0
  • Avatar
    Elizabeth Broadwell

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

    0
  • Avatar
    Eduards Gzibovskis

    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

    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.  

    0
  • Avatar
    Eduards Gzibovskis

    Excel File:

    Template:

    Form:

    Form-Level Action:

    Form-Level Action:

    Form-Level Action:

    Form-Level Action:

    Form-Level Action:

    Form-Level Action:

    1
  • Avatar
    Elizabeth Broadwell

    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

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

    0

Please sign in to leave a comment.