+ Start a Discussion
TwEEkTwEEk 

CLI Data Migration Tool Error

I am trying to migrate the user accounts from one sandbox, to the next.

 

There are several custom feilds in the  user object, one of which has external ID turned on.

 

I can extract the users just fine. Except when I am upserting them, no record gets inserted:

 

ERROR com.salesforce.dataloader.client.PartnerClient - Errors were found on item ## 

ERROR com.salesforce.dataloader.client.PartnerClient - Error message:OC_User_ID__c not specified

 

This occurs for EVERY record, and non are inserted. Details about this custom field

 

Field Label: OC User ID

Field Name: OC_User_ID

Required: False

Unique: False

External ID: True

Default Value: [blank]

Length: 20

 

 

 

 As for the config file, The relevent stuff here:

 

<entry key="sfdc.entity" value="User"/>

<entry key="sfdc.externalIdField" value="OC_User_ID__c"/>

<entry key="process.operation" value="upsert"/>

<entry key="process.outputError" value="c:\dataloader\errorUpsertUsers.csv"/>

<entry key="process.outputSuccess" value="c:\dataloader\successUpsertUsers.csv"/>

<entry key="dataAccess.name" value="c:\dataloader\ExtractUsers.csv" />

<entry key="process.initialLastRunDate" value="2007-06-06T00:00:00.000-0800"/>

 

Inside ExtractUsers, the data is all there, The records all have an OC_User_ID__c entry.

 

Can somebody shed some light on this? Thanks

 

 

Message Edited by TwEEk on 12-20-2009 09:19 PM
TwEEkTwEEk

Bump.

 

 

TwEEkTwEEk

I managed to progress, how ever I am now getting the following error for EVERY user record.

 

com.salesforce.dataloader.client.PartnerClient - errors were found on item # (every item)

com.salesforce.dataloader.client.PartnerClient - Error message: Required fields are missing: [Username, LastName, email, Alias, CommunityNickname, ...]

 

BUT THESE FIELDS ARE IN THE CSV FILE!!! About ready to ram my fist through my monitor!~!!