 |
| Windows-7 Task Scheduler |
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="csvInsertArtist"
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">
<description>Inserts artist names from CSV file into Artist custom object.</description>
<property name="name" value="csvInsertArtist"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile" value="c:\dataloader\csvInsertArtist.log"/>
<entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
<entry key="sfdc.username" value="<i>Your Salesforce ID</i>"/>
<entry key="sfdc.password" value="<i>Your encrypted Salesforce password</>"/>
<entry key="sfdc.timeoutSecs" value="540"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Artist__c"/>
<entry key="process.operation" value="insert"/>
<entry key="process.mappingFile" value="c:\dataloader\artistmap.sdl"/>
<entry key="process.outputError" value="c:\dataloader\errorInsertArtist.csv"/>
<entry key="process.outputSuccess" value="c:\dataloader\successInsertArtist.csv"/>
<entry key="dataAccess.name" value="c:\dataloader\Artists_1_100.csv" />
<entry key="dataAccess.type" value="csvRead" />
<entry key="process.initialLastRunDate" value="2007-06-06T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>
 | |
| C:\Program Files (x86) C:\Program Files (x86)\salesforce.com\Data Loader\bin process ../conf csvInsertArtist |
Name
|
Latest Version
|
Apex Data loader
|
29.0
|
Force.com API
|
29.0
|
Force.com IDE
|
29.0.0 (compatible with Eclipse 4.2 and 4.3)
|
Salesforce.com
|
Winter' 2014
|
Field
|
Description
|
Batch size
|
* In a single insert, update, upsert,
or delete operation, records moving to or from Salesforce are processed in
increments of this
size.
*The maximum value is 200. We recommend
a value between 50 and 100.
*The maximum value is 10,000 if the Use
Bulk API option is selected.
|
Insert null values
|
*Select this option to insert blank
mapped values as null values
during data operations.
* Note that when you are updating
records, this option instructs Data Loader to overwrite any existing data in
mapped fields.
*This option is not available if the Use
Bulk API option is selected.
*Empty field values are ignored when
you update records using the Bulk API.
* To set a field value to null
when the Use
Bulk API option is selected, use a field value of
#N/A.
|
Assignment rule
|
*Specify the ID of the assignment rule
to use for inserts, updates, and upserts.
* This option applies to inserts,
updates and upserts on cases and leads.
* It also applies to updates on accounts
if your organization has territory assignment rules on accounts.
*The assignment rule overrides Owner
values in your CSV file.
|
Server host
|
*Enter the URL of the Salesforce server
with which you want to communicate.
* For example, if you are loading data
into a sandbox, change the URL to
https://test.salesforce.com.
|
Timeout
|
Specify how many seconds Data Loader
waits to receive a response back from the server before returning an error
for the request.
|
Query request size
|
*In a single export or query operation,
records are returned from Salesforce in increments of this size.
*The maximum value is 2,000 records.
Larger values may improve
performance but use more memory on the
client.
|
Allow field truncation
|
*Select this option to truncate data in
the following types of fields when loading that data into Salesforce: Email, Multi-select
Picklist, Phone, Picklist, Text, and Text(Encrypted).
*This option is not available if the Use
Bulk API option is selected. In that case, the
load operation fails for the row if a value is specified that is too large
for the field.
|
Use Bulk API
|
*Select this option to use the Bulk API
to insert, update, upsert, delete, and hard delete records.
*The Bulk API is optimized to load or
delete a large number of records asynchronously.
*It’s faster than the default
SOAP-based API due to parallel
processing and fewer network round-trips.
Caution:
*When you select the Hard Delete operation,
the deleted records are not stored in the Recycle Bin.
*Instead, they become immediately eligible
for deletion.
*The permission for this operation, “Bulk
API Hard Delete,” is disabled by
default and must be enabled by an
administrator.
*A Salesforce user license is required
for hard delete.
|
Enable serial mode for Bulk API
|
*Select this option to use serial
instead of parallel processing for Bulk API. *Processing in parallel can
cause database contention. When this is severe, the load may fail.
* Using serial mode guarantees that
batches are processed one at a time.
* Note that using this option may
significantly increase the processing time for a load.
*This option is only available if the Use
Bulk API option is selected.
|
Upload Bulk API Batch as Zip File
|
*Select this option to use Bulk API to
upload zip files containing binary attachments, such as Attachment records or
Salesforce CRM Content.
*This option is only available if the Use
Bulk API option is selected.
|