• Puneet Mehra 14
  • NEWBIE
  • 20 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 1
    Replies
I am trying to update a set of records that were given to me with an Excel spreadsheet

1. The Name field on there is an Autonumber
2. I have no other unique fields I can use as an External ID

Here's what I've tried so far:
1. DataLoader doesn't allow me to do an upsert by matching on autonumber fields
2. I've tried using the Data Import Wizard on Salesforce to make an upload but that application always has a problem reading my csv file, so I am never able to proceed to field mappings

This leaves me in a tricky situation, having to tap into our mySQL database to first get record IDs and then do a data upload.

Is there a better way?