linking a set to a data source
In-depth resources:
Video: Connect external data sources
Video: Load data from Excel
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.
Note:
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, 2019, 365
- Excel 3.0, 4.0, 5.0, 7.0, 97, 2000, XP, 2003, 2007, 2010, 2013, 2016, 2019, 365
- 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
- Google Sheets
- MySql database
- Oracle database
- SQL Server database
- Text data in the Windows Clipboard
- Custom data connection
Run un the link data source wizard that will guide you through the process.
Click the Data source button to close this windows and start the data connection wizard.
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.
