Oracle® Social CRM Applications Administration Guide > Administering Oracle Sales Prospector > Troubleshooting Oracle Sales Prospector >

Troubleshooting the CSV File Import


This topic provides guidelines for resolving the CSV file import problems. To resolve the problem, look for it in the list of symptoms or error messages in Table 4.

Table 4. Resolving CSV File Import Problems
Symptom or Error Message
Diagnostic Steps or Cause
Solution

Missing a required field

Identify the required field that is missing from the CSV file. Refer to File Mapping for Records for details on the required fields.

Specify a value for the required field column in the CSV file.

Undefined data type

Check the first line of the CSV file for a typographical error.

Make sure that all the header columns in the CSV file match those in the CSV files specified in File Mapping for Records.

Invalid field length

Check the data length in the CSV file.

Make sure that the data length does not exceed the limit specified for the field. The limits are described in File Mapping for Records.

Unsupported encoding type

Check the CSV file for any character that is not included in the ISO-8859-1 character set.

Remove or replace data that is not included in the ISO-8859-1 character set. UTF-8 is supported.

Invalid numeric value

The expected data type is a numeric value.

Replace the erroneous data with a numeric value.

Invalid date value

The expected data type is a date value.

Make sure that the erroneous date value is in the following format: YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

Invalid header

The first line of the CSV file does not match a predefined record type.

Make sure that the first line of the CSV file matches one of the record types specified in File Mapping for Records.

Invalid double quote

Data containing double quotation characters must be surrounded by double quotation characters.

You must enclose the entire string value that contains a double quotation character within double quotation characters, and represent the double quotation character using two double quotation characters. For example, 5" SCREW, must be specified as: "5"" SCREW"

Oracle® Social CRM Applications Administration Guide Copyright © 2009, Oracle. All rights reserved.