Databases
Connect your database to your label design to avoid manually typing your content and minimize user errors.
Note
You can connect your label only to one table in one database.
You can connect to:
Databases stored in Control Center
Documents :Microsoft Access
Microsoft Excel
External Microsoft SQL Database
Connecting to Access or Excel database
To connect your label to a database stored in
Click the
Data icon to open theData Sources menu.Expand the
Add database drop-down menu, then clickFrom Documents .Navigate to the location where your database is stored, click your database, then click
Select .Your label connects to the database, and the database
Properties window opens on the left side of your label design. You can change the name of your database connection (which doesn't affect the actual database file name inDocuments ), add your description, and select the table.You can define or change table fields properties. Click on the field to open the field properties window.
In the
Data section, you can limit the length of the database value and set theProvisional value .Provisional value is a value you use when you design your label. For example, you want to define the maximum size of your Text object on the final print. You use the longest expected value (string) as aProvisional value to make sure your printed text is not out of your label.Now, you can connect your text objects, barcodes, and pictures to your database fields.
Place the label object on the design surface.
Click the object to open the object properties.
In the
Source section, select your database field.
Your label object now presents the prompt variable value.
To delete the database connection, first delete all label objects that are connected to your database. Then right-click your database and select
Connecting to Microsoft SQL database
Note
Since you are connecting to your SQL database from cloud-based Web Designer, your database must also be accessible from other computers, even if installed locally.
Click the
Data icon to open theData Sources menu.Expand the
Add database drop-down menu, then clickFrom Microsoft SQL Server .Add New Database Connection window opens. Insert your SQL Server and database details, then clickSelect .You can also enter the connection string if you click
Show connection string :Your label connects to the database, and the database
Properties window opens on the left side of your label design. You can change the name of your database connection, add your description, and select the table.You can define or change table field properties. Click on the field to open the field properties window.
In the
Data section, you can set theProvisional value .Provisional value is a value you use when you design your label. For example, you would like to define the maximum size of your Text object on the final print. You use the longest expected value (string) as aProvisional value to make sure your printed text is not out of your label.Now, you can connect your text objects, barcodes, and pictures to your database fields.
Place the label object on the design surface.
Click the object to open the object properties.
In the
Source section, select your database field.
Your label object now presents the prompt variable value.
To delete the database connection, first delete all label objects connected to your database. Then right-click your database and select
To use database values with your label objects:
Place the label object on the design surface.
Click the object to open the object properties.
In the
Source section, select your database field.
Your label object now presents the database field value.