6Sample Files
Sample Files
This appendix provides sample files that you can use as a basis for creating your own files. It includes the following topics:
Sample Map File
The following sample map file is for account objects:
"Oracle CRM On Demand Field","Import File Field" "ZText_33","Owner_Full_Name" "Indexed Boolean 0","IndexedBoolean0" "Public Company","PublicCompany" "Account Industry - Translation","Industry" "ZText_32","Row_Id" "Annual Revenues","Annual Revenues" "Account Status","Status" "Indexed Number 0","IndexedNumbr0" "ZPhone_0","Custom_Phone_0" "Indexed Long Text 0","IndexedLongText0" "ZText_30","Primary_Contact" "ZText_0","Custom_Text_Long_0" "Bill To City","Bill City" "Main Phone Number","Main Phone #" "ZNum_20","Custom_Percent_0" "ZNum_0","Custom_Number_0" "ZDate_25","Custom_Date_0" "Currency Code","Account Currency" "ZText_1","Modified_by_Email_Address" "Bill To Country","Bill Country" "ZDate_0","Custom_DateTime_0" "ZText_31","Indexed_Short_Text_1" "Ship To Postal Code","Ship PostalCode" "ZCur_0","Custom_Currency_0" "External System Id","Unique External ID" "Indexed Currency 0","IndexedCurrency0" "ZMSPick_0","Custom_MultiSelect_Picklist_0" "Indexed Pick 0","IndexedPick0" "Ship To Street Address 2","Ship StreetAddress2" "Type","Account Type" "Ship To Country","Ship Country" "Bill To Street Address","Bill StreetAddress" "Number of Employees","Number of Employees" "Home Page","Web Site" "Ship To Street Address","Ship StreetAddress" "Bill To Postal Code","Bill PostalCode" "Source Code","Custom_Integer_0" "Number of Physicians","NumberOfPhysicians" "Main Fax Number","Main Fax #" "ZText_34","Custom_Text_Short_0" "Bill To Street Address 2","Bill treetAddress2" "Priority","Priority" "Location","Location" "ZPick_0","Custom_Picklist_0" "Description","Description" "Region","Region" "Name","Account Name" "ZBool_0","Custom_Checkbox_0" "Ship To City","Ship City"
Sample Data File
The following sample comma-separated value (CSV) data file is for account objects:
Account Name,Location,Main Phone #,Main Fax #,Web Site,Account Currency,Account Type,Priority,Industry,Public Company,Region,Annual Revenues,Number of Employees,Primary_Contact,Description,Billing Address,Shipping Address,Indexed Short Text 1,Indexed Long Text,Indexed Picklist 1,Custom Checkbox 0,Custom Currency 0,Custom Date 0,Custom Date/Time 0,Custom Integer 0,Custom Multi-Select Picklist 0,Custom Number 0,Custom Percent 0,Custom Phone 0,Custom Picklist 0,Custom Text (Long) 0,Custom Text (Short) 0,# Physicians,Indexed Checkbox,Indexed Currency,Indexed Number,Modified by Email Address,Owner_Full_Name,Row Id,Status Accnt_1000001,Toronto,416-123-4567,905-123-4567,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1234,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000001,Active Accnt_1000002,Toronto,416-123-4568,905-123-4568,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1235,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000002,Active Accnt_1000003,Toronto,416-123-4569,905-123-4569,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1236,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000003,Active Accnt_1000004,Toronto,416-123-4570,905-123-4570,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1237,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000004,Active Accnt_1000005,Toronto,416-123-4571,905-123-4571,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1238,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000005,Active Accnt_1000006,Toronto,416-123-4572,905-123-4572,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1239,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000006,Active Accnt_1000007,Toronto,416-123-4573,905-123-4573,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1240,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000007,Active Accnt_1000008,Toronto,416-123-4574,905-123-4574,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1241,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000008,Active Accnt_1000009,Toronto,416-123-4575,905-123-4575,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1242,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000009,Active Accnt_1000010,Toronto,416-123-4576,905-123-4576,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1243,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000010,Active Accnt_1000011,Toronto,416-123-4577,905-123-4577,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1244,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000011,Active Accnt_1000012,Toronto,416-123-4578,905-123-4578,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1245,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000012,Active Accnt_1000013,Toronto,416-123-4579,905-123-4579,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1246,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000013,Active Accnt_1000014,Toronto,416-123-4580,905-123-4580,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1247,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000014,Active Accnt_1000015,Toronto,416-123-4581,905-123-4581,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1248,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000015,Active Accnt_1000016,Toronto,416-123-4582,905-123-4582,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1249,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000016,Active Accnt_1000017,Toronto,416-123-4583,905-123-4583,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1250,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000017,Active Accnt_1000018,Toronto,416-123-4584,905-123-4584,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1251,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000018,Active Accnt_1000019,Toronto,416-123-4585,905-123-4585,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1252,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000019,Active Accnt_1000020,Toronto,416-123-4586,905-123-4586,http:// crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description ,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1253,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000020,Active
Sample Log File
The following sample log file was created with the clientloglevel parameter set to detailed:
[2010-04-24 07:51:54,393] DEBUG - [main] BulkOpsClient.main(): Execution begin.
[2010-04-24 07:51:54,393] DEBUG - [main] BulkOpsClient.main(): List of all
configurations loaded: {numofthreads=1, impstatchkinterval=30, maxloginattempts=1,
manifestfiledir=.\Manifest\, sessionkeepchkinterval=300, routingurl=https://
sso.crmondemand.com, hosturl=http://sdchs20n263.us.oracle.com, testmode=debug,
maxthreadfailure=1, logintimeoutms=180000, csvblocksize=1000, maxsoapsize=10240}
[2010-04-24 07:51:54,393] DEBUG - [main] BulkOpsClient.main(): List of all options
loaded: {password=*********, clientloglevel=detailed, waitforcompletion=False,
datetimeformat=usa, importloglevel=errors, datafilepath=.\\data\\account1.csv,
operation=insert, help=False, mapfilepath=.\\data\\account1.map,
clientlogfiledir=., recordtype=account, duplicatecheckoption=externalid,
username=oracle/oracle, csvdelimiter=,}
[2010-04-24 07:51:54,393] INFO - [main] Attempting to log in...
[2010-04-24 07:51:55,081] INFO - [main] Successfully logged in as: wchung/eric
[2010-04-24 07:51:55,081] DEBUG - [main] BulkOpsClient.doImport(): Execution begin.
[2010-04-24 07:51:55,081] INFO - [main] Validating Oracle Data Loader On Demand
Import request...
[2010-04-24 07:51:55,081] DEBUG - [main] FieldMappingManager.parseMappings():
Execution begin.
[2010-04-24 07:51:55,097] DEBUG - [main] FieldMappingManager.parseMappings():
Execution complete.
[2010-04-24 07:51:55,331] DEBUG - [Thread-1] ODWSSessionKeeperThread.Run():
Submitting BulkOpImportGetRequestDetail WS call
[2010-04-24 07:51:55,331] INFO - [main] A SOAP request was sent to the server to
create the import request.
[2010-04-24 07:51:55,862] DEBUG - [Thread-1]
SOAPImpRequestManager.sendImportGetRequestDetail(): SOAP request sent successfully
and a response was received
[2010-04-24 07:51:55,862] DEBUG - [Thread-1] ODWSSessionKeeperThread.Run():
BulkOpImportGetRequestDetail WS call finished
[2010-04-24 07:51:55,862] DEBUG - [Thread-1] ODWSSessionKeeperThread.Run(): SOAP
response status code=OK
[2010-04-24 07:51:55,862] DEBUG - [Thread-1] ODWSSessionKeeperThread.Run(): Going
to sleep for 300 seconds.
[2010-04-24 07:51:55,862] DEBUG - [main]
SOAPImpRequestManager.handleSoapFaultException(): Handling SoapFaultException.
[2010-04-24 07:51:55,862] DEBUG - [main] There was an error sending the SOAP request
to web service: SBL-ODU-01005
[2010-04-24 07:51:55,862] DEBUG - [main] BulkOpsClient.sendValidationRequest():
Experienced SOAP Request Rate Limit error while sending the validation request. Will
try to send again in 1 sec.
[2010-04-24 07:51:56,862] INFO - [main] A SOAP request was sent to the server to
create the import request.
[2010-04-24 07:52:01,268] INFO - [main] A response to the SOAP request sent to
create the import request on the server has been received.
[2010-04-24 07:52:01,268] DEBUG - [main]
SOAPImpRequestManager.sendImportCreateRequest(): SOAP request sent successfully and
a response was received
[2010-04-24 07:52:01,268] INFO - [main] Oracle Data Loader On Demand Import
validation PASSED.
[2010-04-24 07:52:01,268] DEBUG - [main] BulkOpsClient.sendValidationRequest():
Execution complete.
[2010-04-24 07:52:01,268] DEBUG - [main] BulkOpsClient.submitImportRequest():
Execution begin.
[2010-04-24 07:52:01,268] DEBUG - [main] BulkOpsClient.submitImportRequest():
Sending CSV Data Segments.
[2010-04-24 07:52:01,268] DEBUG - [main] CSVDataSender.CSVDataSender():
CSVDataSender will use 1 threads.
[2010-04-24 07:52:01,268] INFO - [main] Submitting Oracle Data Loader On Demand
Import request with the following Request Id: 1QA2-Q5NU1...
[2010-04-24 07:52:01,268] DEBUG - [main] CSVDataSender.sendCSVData(): Creating
thread 0
[2010-04-24 07:52:01,284] INFO - [main] Import Request Submission Status: Started
[2010-04-24 07:52:01,284] DEBUG - [main] CSVDataSender.sendCSVData(): Starting
thread 0
[2010-04-24 07:52:01,284] DEBUG - [main] CSVDataSender.sendCSVData(): There are
pending requests. Going to sleep.
[2010-04-24 07:52:01,284] DEBUG - [Thread-3] CSVDataSenderThread.run(): Thread 0
submitting CSV Data Segment: 1 of 1
[2010-04-24 07:52:02,487] INFO - [Thread-3] A response to the import data SOAP
request sent to the server has been received.
[2010-04-24 07:52:02,487] DEBUG - [Thread-3]
SOAPImpRequestManager.sendImportDataRequest(): SOAP request sent successfully and a
response was received
[2010-04-24 07:52:02,487] INFO - [Thread-3] A SOAP request containing import data
was sent to the server: 1 of 1
[2010-04-24 07:52:02,487] DEBUG - [Thread-3] CSVDataSenderThread.run(): There is no
more pending request to be picked up by Thread 0.
[2010-04-24 07:52:02,487] DEBUG - [Thread-3] CSVDataSenderThread.run(): Thread 0
terminating now.
[2010-04-24 07:52:06,284] INFO - [main] Import Request Submission Status: 100.00%
[2010-04-24 07:52:07,284] INFO - [main] Oracle Data Loader On Demand Import
submission completed succesfully.
[2010-04-24 07:52:07,284] DEBUG - [main] BulkOpsClient.submitImportRequest():
Execution complete.
[2010-04-24 07:52:07,300] DEBUG - [main] BulkOpsClient.doImport(): Execution
complete.
[2010-04-24 07:52:07,300] INFO - [main] Attempting to log out...
[2010-04-24 07:52:09,487] INFO - [main] oracle/oracle is now logged out.
[2010-04-24 07:52:09,487] DEBUG - [Thread-1] ODWSSessionKeeperThread.Run():
Interrupted.
[2010-04-24 07:52:09,487] DEBUG - [main] BulkOpsClient.main(): Execution complete.