How To Execute This Idea Is It Even Possible?

Legacy Poster

• March 27, 2012 08:29

Hi
How can i put multiple columns and rows from excel into one Label. Two columns, multiple rows as in 10 and more.

Example.
1 ID S/N
2 |123 | 18 |
3 |124 | 19 |
4 |125 | 20 |
5 |126 | 21 |
6 |127 | 22 |

And after printing it and scanning it into excel get same row/column/data positioning?

Using bartender professional, label type data-matrix 2d.

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • March 28, 2012 02:47
  That's a hard challenge...
  
  BarTender's database connection only allows single record.
  
  I would try with BarTender 9.4/10 s Rich text(Markup text) control's HTML and create datasource (HTML) by VB Script, with its own database connection.
  
  [url="http://seagullscientific.invisionzone.com/index.php?/topic/73-designing-labels-with-1many-relationships/page__p__133__hl__%2B+%2Btable__fromsearch__1#entry133"]Designing Labels With 1:many Relationships [/url]
  
  To create barcode to store whole table - What if you enter Tab separated text to Datamatrix?
  
  such as
  [code]
  Value = ""
  Value = Value & "ID" & vbTab & "S/N" & vbCrLf
  Value = Value & "123" & vbTab & "18" & vbCrLf
  Value = Value & "124" & vbTab & "19" & vbCrLf
  Value = Value & "125" & vbTab & "20" & vbCrLf
  [/code]

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 19, 2016 22:52

  Hi All

   

  I have a similar request.

  I have a customer which requires to print 1 x QR code form a excel file which has multiple columns and multiple rows.

  My concern is not the columns but with the rows.

   

  How do i create a QR code form a column with multiple row of data.

  Basically what they want to do is to the have multiple items with unique serial number which they want to pack into boxes and by scanning the outside QR code which was generated from all the seral numbers in a column they will know which items with serial numbers is in the box.

   

  Have they include this feature in version 16

   

  Please assist if possible.

   

  Thanks

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 20, 2016 02:28

  Unfortunately, no - BarTender's connection to Excel (or any database) is record based so there's no way to combine records.

  I would connect those excel records using Excel macro or formula to create a single record to contain all necessary data.

  0

Please sign in to leave a comment.