Oracle® Social CRM Applications Administration Guide > File Mapping for Records >

CSV File Mapping for Customer Records


Table 6 describes the CSV file mapping for customer records. The sample file is CUSTOMERS.csv.

Table 6. Data Types for Customer Records
Column
Data Type
Maximum Length
Required
Description

CUSTOMER_ID

String

30 characters

Yes

Customer identifier.

CUSTOMER_NAME

String

200 characters

Yes

Customer name.

NOTE:  CUSTOMER_NAME is a unique key. 1

CUSTOMER_LOCATION

String

300 characters

No

Customer location.

OWNER_EMAIL

String

100 characters

Yes

Email address of the customer account owner.

OWNER_NAME

String

200 characters

Yes

Name of the customer account owner, which is used to identify the owner.

VARCHAR_1

String

200 characters

No

Industry.

VARCHAR_2

String

200 characters

No

Headquarters Country.

VARCHAR_3

String

200 characters

No

Public or Private.

VARCHAR_4

String

200 characters

No

Exporter or importer.

VARCHAR_5

String

200 characters

No

Custom string field 5. 1

VARCHAR_6

String

200 characters

No

Custom string field 6. 1

VARCHAR_7

String

200 characters

No

Custom string field 7. 1

VARCHAR_8

String

200 characters

No

Custom string field 8. 1

VARCHAR_9

String

200 characters

No

Custom string field 9. 1

VARCHAR_10

String

200 characters

No

Custom string field 10. 1

NUMERIC_1

Number

10 digits, no decimal places

No

Annual revenue in thousands. For example, use 1000 for $1,000,000 annual revenue.

NUMERIC_2

Number

10 digits, no decimal places

No

Number of employees.

NUMERIC_3

Number

10 digits, no decimal places

No

Number of locations.

NUMERIC_4

Number

10 digits, no decimal places

No

Custom numeric field 4. 1

NUMERIC_5

Number

10 digits, no decimal places

No

Custom numeric field 5. 1

NUMERIC_6

Number

10 digits, no decimal places

No

Custom numeric field 6. 1

NUMERIC_7

Number

10 digits, no decimal places

No

Custom numeric field 7. 1

NUMERIC_8

Number

10 digits, no decimal places

No

Custom numeric field 8. 1

NUMERIC_9

Number

10 digits, no decimal places

No

Custom numeric field 9. 1

NUMERIC_10

Number

10 digits, no decimal places

No

Custom numeric field 10. 1

DATE_1

Date

Not applicable

No

Custom date field 1 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_2

Date

Not applicable

No

Custom date field 2 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_3

Date

Not applicable

No

Custom date field 3 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_4

Date

Not applicable

No

Custom date field 4 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_5

Date

Not applicable

No

Custom date field 5 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_6

Date

Not applicable

No

Custom date field 6 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_7

Date

Not applicable

No

Custom date field 7 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_8

Date

Not applicable

No

Custom date field 8 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_9

Date

Not applicable

No

Custom date field 9 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

DATE_10

Date

Not applicable

No

Custom date field 10 (for future use). All custom date fields must be formatted as YYYY-MM-DD. To set the default date format correctly on your computer, see Changing the Date Format on Your Computer.

1Oracle Data Mining uses the custom data fields (except for DATE_1 through DATE_10) when it generates the prediction model. You can use these custom fields (except for DATE_1 through DATE_10) to include other attributes in addition to the attributes that are visible in the user interface.

Example of a Customer Records File

The following is an example of a customer records file:

CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_LOCATION,OWNER_EMAIL,OWNER_NAME,
VARCHAR_1,VARCHAR_2,VARCHAR_3,VARCHAR_4,VARCHAR_5,VARCHAR_6,VARCHAR_7,VARCHAR_8,
VARCHAR_9,VARCHAR_10,
NUMERIC_1,NUMERIC_2,NUMERIC_3,NUMERIC_4,NUMERIC_5,NUMERIC_6,NUMERIC_7,NUMERIC_8,
NUMERIC_9,NUMERIC_10,
DATE_1,DATE_2,DATE_3,DATE_4,DATE_5,DATE_6,DATE_7,DATE_8,DATE_9,DATE_10

CUST-01,CUSTOMER 1 NAME,,brenda.moore@company.com,Brenda Moore,Manufacturing,Canada,Public,Both,,,,,,,4521,135,3,,,,,,,,,,,,,,,,,

CUST-02,CUSTOMER 2 NAME,USA,donna.parker@company.com,Donna Parker,Financial Services,USA,Public,Importer,,,,,,,12129,929,6,,,,,,,,,,,,,,,,,

NOTE:  For the CUST-01 record, annual revenue is $4,521,000, the number of employees is 135, and the number of customer locations is 3. For the CUST-02 record, annual revenue is $12,129,000, the number of employees is 929, and the number of customer locations is 6.

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