Extracting Data From A Text File For Use On A Single Label

Legacy Poster

• August 13, 2014 03:19

Hi all

 

I thought this was going to be easy, but its not turning out that way :(

 

I have a bar tender "label" and a "text file" that I want to combine to make a label

 

See attachments

 

[attachment=1109:Document1.btw]

 

[attachment=1110:BHP.txt]

 

Any tips on the best way of doing this?

 

This was as close as i could get but this prints one field per label, not all fields on the same label :(

 

[attachment=1111:BarTender Automation - Document1.btw_2014-08-13_15-16-04.jpg]

 

Thanks

0

• 

  Fernando Ramos Miracle

  ★ BarTender Hero ★

  • August 13, 2014 15:23

  Hello,

   

  I'm afraid that the type of "report printing" you are trying to achieve is not something that BarTender directly supports; although there are certainly a number of alternatives:

   

  1. In v10.1 we've included the "Page Template" feature, which will allow you to set a number of labels per page and then set common objects to all of them. With this option you could "imitate" a report, although it would require a fixed a mount of records to be printed per page.

   

  This option can be activated from the "File>Page Setup..." dialgo, under the "Page" tab.

   

  2. Another option would be to configure a single label that covers the entire page, and enter the value of each label object through a .NET SDK application. The latter application would be the one actually reading from the database and specifying the value of each data source one by one.

   

  3. We have a small ActiveX sample which is kind of similar as to what you're wishing to achieve. This sample will help you to indirectly support "Multiple Records per Label + headers and footers (if requested)" on your label / page. You will need to modify this VB .NET sample for your own use (you will need to own an Automation Edition of BarTender for this)

  https://docs.google.com/open?id=0B99j0_sFF_x3MTAxODZhMTgtMThmZC00ZGQ3LWJjNDAtYWMzNGQ2N2JiNzZm

   

  The label format (.btw) and database file (.mdb) included in this .NET proyect can be saved to the "c:\Seagull" folder for testing.

   

  4. Another workaround would be to use VBScript using ActiveX Data Objects (ADO) and Data Access Object (DAO) database techniques. I've attached a sample for you to examine "DAOMultipleRec75var.btw" (this feature is supported in the Professional Edition of BarTender).

   

  This sample currently has 2-prompts:

   

  The first prompts for the number of records to read and apply to a label object data source.

  The second prompts for the total number of required records in the database of the table being used.

  The database used is the Microsoft Access database example Northwind.mdb (which you can download from the Internet) which I have placed into the folder “C:\Seagull\”.

   

  In summary, we really do not have an easy way to handle this yet, but it is also not totally impossible.

   

  Best regards.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • August 13, 2014 19:45

  Thanks

  0

Please sign in to leave a comment.