You need to sign in to do that
Don't have an account?
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.
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