function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
bigmatebigmate 

Update Row Failed: Owner ID: id value of incorrect type

I have an issue with the Excel Connector.  I am trying to import some new leads in to Salesforce and it is failing with the above mentioned error on the Owner ID field.  I am putting the full username into the field.  ie. Alain Obrien in this example.  This is the same format I used when importing contacts and accounts etc and I had no issues.
 
The bizaar bit is if I use the wizard to extract leads into Excel, it shows the owner ID as I have described above.  If I change nothing, and try and use the update option, it fails with the same error.  So its failing to update with the data it has just extracted.
 
Any assistance would be most appreciated.
 
Thanks
 
 
Chris
kevinedelmannkevinedelmann
Sometimes that will happen, not sure why, but it does.  The best fix is to enter the Users actual Salesforce ID into the field instead of their name.  That typically fixes the error.
dbrunsdbruns
What is the easiest way to find teh Owner ID? Pull an export?
kevinedelmannkevinedelmann
For mass amounts of people yes that would be the easiest way.  For one offs though you can just go to that persons record and see their id in the address bar.