CardExchange Producer can automatically display the correct image for each database record. This is done by linking the image filename to the record's primary key, allowing the image to change automatically when you select a different record.
Before You Begin
Make sure the following requirements are met:
- Your database is already connected to the card template.
- Each image filename matches the corresponding record's primary key.
- All images use the same file format, such as
.png or .jpg. - Your images are stored in an accessible folder.
Example: If the primary key in your database is 202201, the corresponding image should be named 202201.png if you are using PNG files.
Step 1: Open the Image Properties
- Open CardExchange Producer.
- Select the card template you want to edit.
- Click Card Designer.
- Double-click the image placeholder to open the Properties window.
Step 2: Change the Image Type
- In the Properties window, locate the Fixed image dropdown list.
- Change the selection to Variable image.
This allows the image to change according to the selected database record.
Step 3: Select the Database Column
- Select the database column that will be used to identify each image.
- Choose the column containing the primary key.
For example, select the ID column if it uniquely identifies each record and matches the image filenames
- Click the browse button to select the folder containing your images.
- Choose the folder where the images are stored.
- Select the appropriate File extension based on the format of your images.
For example, select .png if all your images are saved as PNG files.
Best practice: Keep your database file and image files in separate folders to make them easier to manage.
Step 5: Save the Card Template
Save your card template to preserve the changes, then close the Properties window.
Step 6: Test the Automatic Image Insertion
- Return to the main CardExchange Producer window.
- Open the Records view.
- Select different records one at a time.
- Check the card preview to confirm that the displayed image changes according to each record.
If the correct image appears for each record, the automatic image insertion is working as expected.
Troubleshooting Tips
If the image does not appear or the wrong image is displayed, check the following:
- The image filename matches the primary key exactly.
- All images use the same file format.
- The selected image folder is correct.
- The selected database column contains the correct primary key values.