linking a set to a data source
Labeljoy enables you to use an external data source to create label sets. Linking a set to a data source means that you will be able to connect the elements it contains to specific fields of the data source. For example, it will be possible to add a Text element that, once connected to a field, will display dynamic information, different for each label in the set.
Labeljoy connects to a data source, reads the data it needs, stores it in its own memory (eventually the job file) and then disconnects from the data source. This working mode is known as Disconnected data source.
All changes made to the original data source will not be visible in Labeljoy until the data source is updated.
Linking to extremely large data sources will result in high memory consumption and very large files.
Labeljoy enables you to connect to the following data sources:
- Access 97, 2000, XP, 2003, 2007, 2010, 2013, 2016
- Excel 3.0, 4.0, 5.0, 7.0, 97, 2000, XP, 2003, 2007, 2010, 2013, 2016
- dBase III, IV, 5.0
- Lotus 1-2-3 WK1, WK3, WK4
- Delimited text file (txt, csv)
- Microsoft Outlook Address book
- Outlook Express or Windows Address Book (WAB)
- SendBlaster database
- MySql database
- Oracle database
- SQL Server database
- Text data in the Windows Clipboard
- Custom data connection
Select the type of data source you wish to connect to from the top combo box. Depending on the item selected, a list of controls and fields will be displayed to enable you to define the needed connection parameters.
Once the data source type is defined you can flag the Update data when this file is loaded or printed checkbox if you want Labeljoy to re-load the data every time the current file is loaded and before it's printed or exported.
When all the required parameters have been defined, click Ok or Apply and the data load procedure will start. In this phase, a progress bar will be shown to indicate the operation status. Depending on the size of the selected table or worksheet, this phase can take anything between a few seconds to several minutes.
Once the set is connected to a data source, the label number will be updated to match the current record number in the data source. It will also be possible to connect label elements to fields belonging to the data source.