Event ID 20503 Occurs When You Import a CSV Catalog (277184)

SYMPTOMS

When you attempt to import a CSV file by using the Catalogs Module in Bizdesk, you may receive the following event in the Event Viewer:

Event ID: 20503
Source: Commerce Server 2000
Description: Invalid property is used in the product. <Column Names and Product Description>. Possible causes can be: For a string property, the property value exceeds the property length, for an enumerated property the enumerated value does not exist, for a date property the date does not fall within the specified date range.

NOTE: <Column Names and Product Description> are the column names from the CSV file that are being imported, and the specific product information that is broken into the comma separated fields.

CAUSE

This event can occur when you try to import a CSV file that contains numeric fields such as image_height or image_width. These fields may be in a CSV file that has been exported by using the CSV Export function in the Catalog Module in Bizdesk.

WORKAROUND

Do not import a CSV file that contains numeric fields. If the CSV file is the only representation of a catalog that you can obtain, you may need to convert the file into XML, and use the Import XML function.

MORE INFORMATION

The Import CSV function is designed to only import text fields. However, the Export CSV function exports all catalog information, including numeric fields. CSV Export and Import are not designed to function as a means of exporting a catalog and importing that catalog back to Commerce Server 2000. To achieve this, you must use XML Export and Import.

For more information about CSV Import, see the "Importing a CSV Catalog" topic in the Microsoft Commerce Server documentation.