LABEL SOFTWARE - STRUCTURING DATA
LP5 DATABASE MANAGER
Edit databases and tables with the LP5 database manager. Fill the tables with your article data, for example, or access existing databases (e.g. from an ERP system) via ODBC drivers.
You can print directly from the LP5 database manager.
Data records can be filtered with conditions. Control fields can be defined which provide the respective specifications for the automatic label printing for each data record (e.g. name of the layout, name of the printer, number of labels, layout directory, print job information field).
KEEP AN OVERVIEW OF YOUR DATA STRUCTURES
When the database manager of the LP5 label software is started, the database / table selection window opens immediately. In this the user can select a database and its table directly. The user can also activate the item 'Open automatically on next start' in the window. This causes the corresponding database or table to be loaded the next time the database manager is started without the 'Open database' window appearing.
​
After loading the database / table, it is displayed in a table in the database manager.
Screenshot of the database manager of the LP5 label software
Editing of data sets
Screenshot - marked line in the LP5 database manager
The user can click and select a data record with the mouse. The selected data set will be colored.
The user can simply open any table and work with it immediately, i.e. select and print data record without having to make any further settings. Editing / deleting / adding data records is also usually activated immediately if the database manager finds a key column in the table.
​
Otherwise the user has to manually select the key column. All settings for a table are saved for each table in the LP5DBManager.ini and are immediately available the next time the respective table is opened.
Screenshot of the function "Table views"
The so-called "views" for a database are also stored in the INI.
​
A "table view" is a compilation of fields from one or more tables in this database. For example, if you have two tables, "Addresses" and "Contact names", you can create a view that contains fields from both tables.
The user can select the entire table or just a part of it in the database manager via 'Filter data record' and set any sorting order (by clicking on the column header, e.g. all print heads with a price less than 1000 euros, sorted by name).
Screenshot of the "Filter data records" function