Checking Variable Data
You can check whether the variable field and the variable data are properly set.
|
Important
|
|
Make sure to check the variable data and variable fields before performing variable printing.
|
Checking the Variable Data
Using the Functions of Variable Editor to Check the Data
1.
Click [Check Variable Data] from the [Tools] menu.
The [Check Variable Data] dialog box is displayed.
2.
Click [Start].
The variable data check starts.
If there is a problem, one of the following messages will be displayed. Confirm the source of the problem and then fix it as necessary.
The database is not connected or there is no database set.
|
Remedy
|
Set the database in the correct location so that connection is possible.
Connect to the database.
|
The field extends beyond the boundaries of the page.
|
Remedy
|
Move the field so that it is entirely inside the page.
|
This field does not exist in the database specified as the connection destination.
|
Remedy
|
Change the database connection destination.
Change the field.
|
No database field is set in the image field.
|
Remedy
|
Configure the image fields correctly.
|
Cannot display all of the text in the field.
|
Remedy
|
Adjust the size of the text field so that all of the text is displayed.
|
The image file does not exist.
|
Remedy
|
Set [Folder Path] in the properties of the image field again.
Move the image file.
|
You do not have permission to access this image file.
|
Remedy
|
Set the folder and image file access permissions correctly.
|
The image file format is either incorrect or not supported.
|
Remedy
|
Change the image file to a format that can be inserted into the image field (*.bmp/ *.tiff/*.tif/*.jpg/*.jpeg/*.png/*.gif) and correct the database.
|
The record value or the field settings are incorrect.
|
Remedy
|
Confirm the information in the database and field and set them correctly.
|
There is an empty record in the database field.
|
Remedy
|
Confirm the records that do not display data in the [Database Connection/Settings] dialog box and correct the database.
|
The path to the folder where the image file is saved is incorrect.
|
Remedy
|
Set [Folder Path] in the properties of the image field again.
Move the folder that contains the image file.
|
The path to the folder where the image file is saved is not specified.
|
Remedy
|
Set [Folder Path] in the properties of the image field.
|
|
Note
|
|
When the following message is displayed, variable printing is unavailable. Make sure to resolve the problem.
The database is not connected or there is no database set.
For more information on the database settings, see the following.
For information on the variable field settings, see the following.
|
3.
Click [Close].
If you click [Close], the [Check Variable Data] dialog box is closed.
Performing Manual Checks
Since the display of Excel and the Variable Editor differs in some cases, currency symbols may not be displayed, and the values of some records may not be displayed or displayed incorrectly.
The total record number displayed in Variable Editor and the database record number are different.
If a record in the database is hidden, but not deleted, the hidden records are considered as records in Variable Editor.
Remedy
Open the database, and check that no records have been hidden.
Currency symbols are not displayed.
When the type (display format) of a record is set to the currency type, the currency symbol is not displayed in Variable Editor.
Remedy
Change the database and display the data again.
If you change the type (display format) of records for which the currency symbol is not displayed to the text type and enter the value manually, the currency symbol can also be displayed in Variable Editor.
Use the functions of Variable Editor.
Currency symbols manually entered in text fields are displayed in Variable Editor.
Some record values are not displayed or are displayed incorrectly.
When records of multiple types (display formats) or records whose content and type do not match are in the same field, some record values are not displayed or are displayed incorrectly.
Remedy
If you change the type (display format) of fields with a problem to the text type and enter the value manually, they are displayed correctly.
Checking a Variable Field Database
The data displayed in the [Database Connection/Settings] dialog box is used for the record values. Check whether the values are correct.
To display the [Database Connection/Settings] dialog box, select the [Database] menu > [Database Connection/Settings].