Topics about getting data into BarTender objects


How to view records in label design

Question  How can I see my records on the label design Answer  You can view records and navigate through them in label design by turning on the live database connection. Click on the Cylinder icon on the bottom left of the design window above the Template tab. This should enable the view of recor...

Can the Database Connection be changed on multiple documents at once?

Question Is there a way to change the database connection in multiple documents at the same time. Answer No, each database connection is saved to the document so each document has to have its own database connection modified. One way to prevent this problem in the future is to use Named Database ...

Can BarTender connect to Google Docs

Question Can BarTender connect to Google Sheets? Answer BarTender cannot make a direct connection to Google Docs. However, you can export data from Google Docs to a supported format for BarTender. You can then connect BarTender to the support file. Export Google Docs to a file Create, view, or s...

How to manually remove Named database connections

Symptom  User has created named database connections that are no longer needed and would like to remove them from BarTender Environment  BarTender 2016+ Fix/Answer  Currently there is no way to remove the named database connection from within BarTender and you will have to remove the connections ...

Can BarTender connect to an Azure SQL database?

Question Can BarTender connect to an Azure SQL database? Answer The answer on how to achieve this would depend on whether the connection needs to be done directly from BarTender or if a third party is connected to the Azure SQL database, and therefore BarTender needs to be integrated instead with...

Connect to a DBF database file

Question  Can BarTender be used to source data from a DBF database file? Answer  BarTender can certainly connect to this type of database, but you'll need to use a General OLE DB provider and manually configure its connection. This is what you need to do: When creating the new database connectio...

Sort how the database fields are displayed

Question  Is it possible to sort how the database fields are displayed in "record picker"? Answer YES.   BarTender v2016 You can easily do it by dragging and dropping the pertinent column on the desired place: This can be done in all record selection dialog boxes, such as the "Rec...

Introduction to selecting records

Overview There are a number of ways to filter data from a database for the purpose of specifying which records to print at print-time. Understanding how each method of filtering works will help you decide the best method to use for your printing requirements. Determining factors may include the d...

Using a static filter (Video - 2:47)

  Applies to: BarTender 2016   This video/article uses the following downloads: Sample.xlsx Overview A static filter, also known as a basic filter, is configured in Database Connection Setup, and  will always filter using the same criteria for the condition.   Dynamic filters use criteria...

Using a dynamic filter (Video - 5:36)

  Applies to: BarTender 2016   This video/article uses the following downloads: Sample.xlsx Overview When you need the ability to provide filter criteria at print-time, you can use the Database Connection Setup dialog to create a query prompt that appears each time the document is printe...

Using multiple databases or tables (Video - 4:06)

  Applies to: BarTender 2016 This video/article uses the following downloads: Database1.xlsxTable B.txt Overview Joins are basic functions of databases that enable you to merge the contents of two different tables and/or databases into a single view based on a common field or fields betwe...

Connecting BarTender to a QuickBooks database

Overview Intuit’s QuickBooks application is a very popular accounting and business management program that contains its own proprietary database.  There are two ways to connect BarTender to Quickbooks.   Connecting to QuickBooks directly via ODBC For more information about using the ODBC driver p...