Skip to main content
Deutsch Español Français 日本語 简体中文 繁體中文

Search

Articles in this section

See more

How to Print Multiple Records Per Template Using a BarTender Table Object Linked to a Database

Otto Roberson

BarTender Content Team

  • Updated

Overview

Table objects to help you organize the placement of objects within a template while designing your label. They also offer the possibility for the table to be connected to a database directly. This article will provide instructions on how to leverage this functionality to populate a single label with data from multiple records in a database. 

Applicable to 

BarTender 2019 and above

Information

The grid of a table object resizes automatically at print time based on the size of the objects contained in its cells. In addition, when you create a table object that is connected to a database, the number of rows and columns adjusts automatically to the number of records to be displayed when the document is printed.

If you would like to download the sample files used in this example, you can find the download links at the bottom of this article. 

Create a Sample Database File

The sample database that will be used in this example to connect it to the table object of the template is a comma-delimited CSV file. It contains ten records of data, and its structure consists of the following columns: Title, FirstName, LastName, CompanyName, Phone, AddressLine1, City, StateProvince, CountryRegion and PostalCode. 

Title,FirstName,LastName,CompanyName,Phone,AddressLine1,City,StateProvince,CountryRegion,PostalCode
Ms.,Virginia,Miller,All Cycle Shop,918-555-0127,8713 Yosemite Ct.,Bothell,Washington,United States,98011
Mr.,John,Beaver,Center Cycle Shop,521-555-0195,1318 Lasalle Street,Bothell,Washington,United States,98011
Mr.,Paulo,Lisboa,Elite Bikes,380-555-0116,9178 Jumping St.,Dallas,Texas,United States,75201

Create the BarTender Document

Prepare the label and create the Table Object for our Database by associating the database connection to the CSV file.

  1. Open TestLabel.btw.
  2. Create a Table Object by clicking on the Table icon in the Toolbar (or alternately from the Create menu, select Table), and then select Create Table from Database.

CreateTablefromDB.png

  1. Complete the Database Connection wizard to connect to your database (TESTDB.csv). For more information about the types of databases that you can connect to, refer to Supported Database Types.
  2. Use the Database Setup Dialog to configure additional properties to define the record set that you want from the database(for example, via an SQL query: Using the Table Object with Advanced SQL Queries), and then click OK to close the dialog.

mceclip8.png

  1. Configure the Table Object properties by double-clicking it, or right-clicking and selecting Properties.

TableObjectProperties.png

  1. In this example, we have configured our first Row as Page Header, which will show the associated database field names.

Row1HeaderRow.png

  1. Configure the Row and Column properties depending on your needs. It's possible to insert, delete, duplicate, move a row or a column up or down, set height and alignment, as well as other options.
  2. You can also configure the Borders and Shading options as per your needs. Find further information about each of the settings in the BarTender Help System, also available online. 
  3. Optionally add other objects to the label as per your needs.
  4. Save the label.
  5. When you Preview or Print the label, you will see that the database records are printed in a table format within a single label.

PrintPreview.png

Adding Table Data Field Data Sources to the Table

After you select the source that you want for the table data, the Table Data Fields data source type is added to the Data Sources pane of the Toolbox. Expand the Table Data Fields node in the Data Sources pane to view the available data sources that are related to the source that you selected for your table data.

Add a Table Data Field data source to the table by dragging it from the Toolbox. This method creates a text object.

mceclip6.png

Additional Resources

Table Objects in BarTender 2019 and Later
BarTender Help System Table and Grid Objects

Related articles