With NiceLabel you can connect to any database, assuming you have the drivers for that database. In NiceLabel you can browse to the 'file-based databases' - these are the file formats you mention. If you have any other 'server-based database' you can use ODBC/OLE DB drivers to get records from them.
I understand you currently work with text files as 'databases' for your label data. It is fairly simple to add the support for the variable picture to each product.
Do the following:
- Add one additional field into your text database. Use it for the name of the image stored on your hard drive.
For example, you might already have your text file set up as:
- Code: Select all
Flower 1;Green flower;10
Flower 2;Smelly flower;5
Add additional field that will contain the full path and filename of the image you want to use with that flower.
- Code: Select all
Flower 1;Green flower;10;c:\MyData\Images\flower1.jpg
Flower 2;Pretty flower;5;c:\MyData\Images\rose.bmp
- When you link that text file onto your label, you will see additional database variable Image.
- Now the trick is to link the variable Image with the Picture object on the label. Click the small arrow button next to the Picture icon in the Toolbox, then select Use Existing Variable, then select the variable Image.
The image specified in the text file will print as the picture on the label.
- If you link the variable Image to the Text object, you will see the name of the picture as text, which is not what you need.
- The format of the image (.BMP, .JPG, etc.) is not important, as long as you use any of the numerous graphical formats that NiceLabel supports.
Traditionally you will store the path and filename into your product database. NiceLabel then simply locates the image in that folder and uses it on the label.
However, NiceLabel software also supports the images embedded into the databases. Some databases have support for binary fields (BLOB fields). You can store the entire image into such fields.
The benefit is huge. There is no need to store the product data in the database and leave the image somewhere in the file system. You need to maintain your data on two locations. You can simply put everything in the database. Of course, not all databases have support for such fields and the database size will grow because of the embedded images.
See the following topics in the help file:
- Use Variable Images
- Use Variable Images from Blob Fields