ASAP Variable Image Database? ...help!

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderator: NiceLabel Support Team

ASAP Variable Image Database? ...help!

Postby sumbula » Wed Mar 05, 2008 1:23 am

Hi I have recently purchased the NiceLabel Pro 5 Software and have had great sucess with being able to import and use Databases with text (.TXT) But I have a dire need of the variable image option too. I have heard that it works and the tutorial mentioned it, but sadly never wen't in depth on it. I cannot stress the importance of being able to do this feature too. I work in the nursery business. Every Piece of stock that we print a sign for needs to have a unique image for it. Such as a sign showing a particular type of flower that gets posted infront of that grouping of flowers. Right now the only option is to manually pick a picture to paste onto the sign and pick one single item from the database to display it's information from. This is however very time consuming and being able to 'batch' it out all at once and let it print the database and pictures associated with each piece of stock is what I am needing to accomplish.

I am working with
-(Software) NiceLabel Pro 5
-(OS) Windows Vista
-(Printer) Lexmark C780

thank you in advance!
sumbula
Newcomer
 
Posts: 4
Joined: Wed Mar 05, 2008 1:08 am

Postby Rsas » Fri Mar 07, 2008 10:33 am

Hello!

I suggest you to take a look to NiceLabel sample label:
"C:\Program Files\EuroPlus\NiceLabel 5\Samples\Labels\ID_CARD.lbl"

This label is using a sample database containing inforamtion about images:
"C:\Program Files\EuroPlus\NiceLabel 5\Samples\Database\Identity.mdb"

To learn how to connect database and place a graphics on the label please see the tutorial avaialbe on our web site:

http://www.nicelabel.com/Learning-center/Tutorials

"NiceLabel Pro Part4: Using Databases and Spreadsheets"

Check settings used on that label and try to make a new label by yourself.

In case that you need additional help I ssuggest communicating with your NiceLabel reseller.
Regards,

Sasa
Pre-sales Specialist
Rsas
NiceLabel
NiceLabel
 
Posts: 303
Joined: Tue Oct 24, 2006 3:20 pm
Location: Kranj, Slovenia

Postby sumbula » Fri Mar 07, 2008 6:00 pm

Yes, that video does help with using an acessing a database that has been previously configured and addresses how to apply it to the label. That does help me but only partially.
What type of pictures can I use for an image database? JPEG I am seriously hoping. And how do you take pictures and make a database out of them? (.mdb) I clearly understand how to take .txt files to make a database, but NiceLabelPro 5 allows only .mdb, .accdb, .txt, .csv, .xlx and .xlsx. I am not completly familiar with these formats, so if you could tell me which one I need to make a database from and how to convert the pictures to one of the above forms it would be greatly appreciated.
Thank you In Advance!
sumbula
Newcomer
 
Posts: 4
Joined: Wed Mar 05, 2008 1:08 am

Postby Saso » Sun Mar 09, 2008 8:10 pm

Hi sumbula,

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:
  1. 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
    Product Name;Description;Price
    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
    Product Name;Description;Price;Image
    Flower 1;Green flower;10;c:\MyData\Images\flower1.jpg
    Flower 2;Pretty flower;5;c:\MyData\Images\rose.bmp
  2. When you link that text file onto your label, you will see additional database variable Image.
  3. 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.
  4. 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.
  5. 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
Saso Fleiser
Senior Technical Product Specialist
User avatar
Saso
NiceLabel
NiceLabel
 
Posts: 2292
Joined: Mon Sep 04, 2006 8:09 am

Postby sumbula » Mon Mar 10, 2008 3:17 am

Hey, Saso

Thank you for the assistance...I have done everything you ask in Microsoft Access to make this work as you describe, but I have still reached an issue.

example: Product Name; Description; Price; Picture Path

Flower 1;Sun loving plant; $1.00; C:\Users\Nick Shatlaw\Documents\My Labels\Graphics\PDF-JPEG\Sedum ''Matrona''.jpg



This is giving me the error "Invalid Value for object! Production aborted" when i try to do a print preview. I even went to "Tools>Options>Folders>Pictures" to make sure it was foung to the correct folder that all of my pictures are located in...C:\Users\Nick Shatlaw\Documents\My Labels\Graphics\PDF-JPEG...this all looks correct to me. Let me know if something is wrong.


MDB path:

C:\Users\Nick Shatlaw\Documents\My Labels\Graphics\PDF-JPEG\Sedum ''Matrona''.jpg

NiceLabel Pictures Path:

C:\Users\Nick Shatlaw\Documents\My Labels\Graphics\PDF-JPEG


Please help me. Long nights ahead otherwise.
sumbula
Newcomer
 
Posts: 4
Joined: Wed Mar 05, 2008 1:08 am

Postby Saso » Tue Mar 25, 2008 9:33 am

NiceLabel does not find the specified image on the disk.
Are you sure you have provided the correct image filename?

The name 'Sedum "Matrona".jpg' seems suspicios. You cannot have a double-quite character in the name of the file.

Make sure you include the correct image filename in the Access database. It will work then.

Also, if you will move the images to some other file location any time in the future, you will have problems during label printing again, because the images are not in the same folder as specified in the Access database anymore. It makes more sense not to hardcode the path to the images in the database.

Read the following FAQ on NiceLabel Web site, how we suggest you set up your folders in order for the files always to be found, no matter in which folder they currently reside:
- http://www.nicelabel.com/Support/FAQ/General#g8
Saso Fleiser
Senior Technical Product Specialist
User avatar
Saso
NiceLabel
NiceLabel
 
Posts: 2292
Joined: Mon Sep 04, 2006 8:09 am


Return to Label Design & Printing

Who is online

Users browsing this forum: No registered users and 3 guests