+ Start a Discussion
ChadMeyerChadMeyer 

Insert/Upsert to Custom Object and set Owner with an External ID

I am looking for a way to import records to a custom object "Expense" and set the Owner by referencing an external ID on User.

 

So far, the only thing I have found that can do this is the custom object import wizard, and that isn't going to work because we need to do this daily and you can't save a map or set constants.

 

I appears that this can't be done with Data Loader (SF), Jitterbit Dataloader, or even DemandTools.

 

Here is a screenshot that shows how this works with the import wizard: http://www.screencast.com/t/apHyBg1W

 

Any suggestions on a tool that can do the same? If I can't find anything, I think I'll have to build a trigger to update the owners after insertion.

Wizno @ ConfigeroWizno @ Configero

Our dataloader does that, and allows you to save mappings. You can also preview & bulk edit the data before it is inserted. Additionaly, you can choose which field it should match on for the external ID. 

 

http://www.configero.com/products/data-loader-salesforce

https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009wRkqEAE