BulkOpImportCreateRequest
Creates a bulk import request.
Usage
Use the BulkOpImportCreateRequest method to create a bulk import request.
The arguments taken by the method correspond to elements in the WSDL file, as described in the table in the Arguments section.
The xsdLocal1:ImportOptions argument specifies the import options, which are similar to the options available in the Import Wizard in the Oracle CRM On Demand application:
CSVDelimiter. The type of CSV delimiter used in the file: comma (,) or semi-colon (;).
DateTimeFormat. The date and time format used in the CSV file: usa, can, eur, uk, other.
DuplicateCheckOption. Whether the Row Id (rowid) or external ID (externalid) are used for duplicate checking.
ErrorLogLevel. The level of error logging:
all. All messages
errors. Error messages only.
errorswarnings. Error messages and warning messages only.
Typical customer import data is contained in a CSV file with the following format:
ColumnName1, ColumnName2, ...
Data1, Data2, ...
Data1, Data2, ...
...
The xsdLocal1:ListOfFieldMappings element specifies the mapping of CSV column names to field names in Oracle CRM On Demand. For example:
<ns1:ListOfFieldMappings>
<ns1:FieldMapping>
<ns1:CSVColumnName>
Web Site
</ns1:CSVColumnName>
<ns1:FieldName>
Home Page
</ns1:FieldName>
</ns1:FieldMapping>
</ns1:ListOfFieldMappings>
CSVColumnHeaders specifies the list of CSV column names, for example:
<ns0:CSVColumnHeaders>
"Account Name","External Unique Id","Web Site","Account Location"
</ns0:CSVColumnHeaders>
The mappings are validated and if everything is correct, the import request is created.
Arguments
The following table describes the arguments taken by the BulkOpImportCreateRequest method.
Name | Description | Required | Default | I/O |
---|---|---|---|---|
DataFileName |
The name of the data file to be imported, for example, account1.csv |
Yes |
Not applicable |
Input |
RecordType |
The record type to be imported. |
Yes |
Not applicable |
Input |
xsdLocal1:ImportOptions |
The list of import options. |
No |
Not applicable |
Input |
xsdLocal1:ListOfFieldMappings |
The mapping of CSV file column names and their corresponding fields. |
Yes |
Not applicable |
Input |
CSVColumnHeaders |
The list of column names from the CSV file. |
Yes |
Not applicable |
Input |
EnableImportAudit |
Enables or disables auditing of record creation/update during import requests. This setting takes effect only if the user has the privilege Manage Record Auditing for Imports, otherwise it is ignored. Accepted values are true or false. |
No |
true |
Input |
EnableMailNotification |
Enables or disables email notifications for import requests. Accepted values are true or false. |
No |
true |
Input |
ImportBlankInMSP |
Enables or disables the importing of blank values in multi-select picklist fields. Accepted values are true or false. |
No |
false |
Input |
SendUserLogFile |
Whether the user log file is attached to the email notification for import requests. If email notification is disabled, SendUserLogFile is ignored. Accepted values are true or false. |
No |
false |
Input |
CSVRowCount |
The number of data records in the data file to be imported. |
Yes |
Not applicable |
Input |
Operation |
The operation for the current request, such as insert, update. |
Yes |
Not applicable |
Input |
ClientVersion |
The current Data Loader client version number. |
No |
Not applicable |
Input |
RequestId |
The ID of the request created. |
Not applicable |
Not applicable |
Output |
Status |
The status of this Web service request. |
Not applicable |
Not applicable |
Output |
ErrorMessage |
Any error message from this Web service request, or a message indicating success. |
Not applicable |
Not applicable |
Output |
Return Value of the Call
The request ID, status, and any error message are returned.