Need Help Populating A Dropdown List With Data From Excel

Legacy Poster

• November 10, 2014 18:18

Hi folks,

I'm new to Bartender software and after sucessfully creating a template for a label using data from a excel file, i'm hitting a wall
 

I cannot get a dropdown list to be filled with data from the excel file, it simply defaults to value 1 or value 2
 

I've tried to use the vbscript I found on this site, (after modification to get the file names and location etc. working) and when tested within the vb edit window, all appears fine

 

However when I click OK an error, #6693 insert the name of a column entry here already exists within the Item test column.

 

If I remove the first entry ion the column being checked, I get the following error, OnFillList(Line 6): : Type mismatch: 'Value'
 

If I change the first value to a random value, I recieve an error, #6693 insert the second name of a column entry here already exists within the Item test column.

It seems the vbscript doesn't like multiple entries of the same value in the column. my column of 900+ rows of data has multiple repeat entries of the same value.

e.g. row 1 column entry Andrew, row 2 column entry Andrew, etc. etc, row 10 column entry Bruce, row 11 column entry Andrew, etc.

So that leaves me with 2 questions;

1. is it possible to populate a drop down list with known values which will be in the column i'm checking to filter only the matching records when printing from the database?

2. is it possible to modify the vbscript to overcome this obstacle?

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • November 11, 2014 07:16

  Hi,

  Drop-down box display text cannot have duplicate value.

  However actual value can be duplicated.

  have serial number before the display texts, like...

   

  op=""

  op = op & "001 John" & vbTab & "John" & vbCr

  op = op & "002 John" & vbTab & "John" & vbCr

  op = op & "003 Carlottta" & vbTab & "Carlotta" & vbCr

   

  etc.

  Not sure it works fine with 900+ rows, though.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • November 11, 2014 09:23

  HI Shotaro, to clarify the number of selections in the drop down list will be around 20 in total. The dataset I'm working with is 900+ rows and in the particular column, there may be many similar values.

   

  I'll try and populate a drop down list manually and see if it correctly filters the dataset for printing and report back.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • November 12, 2014 10:28

  OK just to confirm the dropdown list doesn't work. I've had to use the sql query which is somewhat problematic as it involves an operator manually entering the selection criteria and I had hoped to remove the potential for human error as much as possible.

   

  It seems that this 'non-feature' needs to be addressed, fingers crossed it will be soon.

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • November 13, 2014 01:03

  Thanks for update - it looks you need to create front-end application to filter data for the user.

  Once the record set got perfect, I recommend that to feed Commander - that keep your app simple.

  0

Please sign in to leave a comment.