Database Connection Configuration for Text Files

Connection name defines the name for the connected database file. By default, it displays the filename of the connected file. Insert a new name to make it easy to be found in the Desktop DesignerDynamic Data Explorer.

Description is a field that allows adding additional information and suggestions for the connected database.

Connection identifies the currently connected database file. To replace the currently connected file, click the Connection Setup button. New Database Connection Properties window reappears – repeat step 1 to connect to an alternative database file.

Fields Tab

Available Fields frame lists available fields of the connected database file. Select the field(s) from the list.

Selected fields displays the fields (columns) to be further used as the data source.

Fields can be added to or removed from the Selected fields using Add > and < Remove buttons. To use the entire range of available table fields (columns), use Add all >> and << Remove All buttons.

Define Fields opens the Using Text File Structure Wizard. This wizard defines the text file database fields.

Refresh Fields rereads the connected database file and displays the refreshed available fields.

Data Retrieving Tab

Data selection at print time initialization group defines database print time record selection and printing options.

• Show record selection at print time initialization enables you to manually select the database records before printing. The content of selected records is displayed in label objects and printed. When enabled, this option adds a selection column to the database table. This column allows individual selection of the records to be printed.

• Default print defines how many database records should be printed by default.

  • All records prints out the entire range of selected records.

  • First record only prints out the first record in a table.

  • Last record only prints out the last record in a table.

Number of copies per record sets print quantities for individual database records.

• Copies per record defines how many labels should be printed per single record. The value can be set manually or dynamically using a data source.

• Number of copies can be changed at print time option allows you to set the number of printed label copies for a single database record. When enabled, this option adds a column to the database table. This column allows individual setting for print quantity for your selected record.

Advanced options allow you to set how multiple records can be displayed.

• Collect records displays the content of multiple records in a single object.

  • Delimiter defines how the records are separated when displayed in an object. Set New line(CR/LF) or select a special character from the list.

• Limit number of collected records enables the maximum number of displayed records in a single object.

  • Records sets the maximum number of records to be displayed in an object.

  • Span multiple labels enables the records to be displayed in an object over multiple labels.

• Use the same record for entire print job prints out the selected record only.

Data Tab

Data tab provides a preview of the connected database file. It enables field filtering and record search.