0

I want to update a number of Cases using a CSV file that contains two fields: case number (NOT technical id, but the automatically generated human readable id/name) and a textual complaint.

Data loader is not able to handle this and I found a suggestion to use Workbench instead. So I uploaded the file and set the proper fields. This is right before you start the actual upsert:

enter image description here

But when I click "Confirm Upsert", all records are rejected: "CaseNumber Not Specified, MISSING_ARGUMENT"

If I preview the CSV file, CaseNumber is filled with the data that I expect to see there.

What am I missing here?

3
  • is the number in your screenshot matching up with what you actually have for data in the excel (318 records)? Aug 9, 2021 at 14:54
  • @KrisGoncalves Yes. Aug 9, 2021 at 15:01
  • By the way, I've submitted the PR, and I have a working demo available on my heroku if you want to try it and make sure it works correctly.
    – sfdcfox
    Aug 10, 2021 at 0:31

1 Answer 1

2

You're trying to map by an autonumber field, which is read-only, so the mapping logic doesn't support what you're trying to do. This would work if you were working with a mappable field, such as custom External Id on cases, or a required name field (e.g. Account Name). However, it would be possible to patch workbench to support this, as it is open source, but you'd have to run your own local copy or submit a PR (Pull Request).


Edit: I have fixed the problem in my cloned copy, which you can try out here. This clone may or may not be maintained or enhanced in the future, but I'll leave it up for as long as I can. There may be some delay on startup, as it is a Free Tier Heroku App. I have submitted a PR to have this put into the main app. Stay tuned.

2
  • Thank you very much for your time and effort! In the meantime, I have solved my problem by using dataloader.io. It was not immediately apparent how to get it done with that product, but after consulting it's documentation, I got my data imported. Sorry for my impatience, but you know how it is. Thanks again! Aug 10, 2021 at 6:18
  • 1
    @SanderdeJong No worries. You have a business to run. Still, I was able to make at least a minor contribution for anyone who might need this in the future.
    – sfdcfox
    Aug 10, 2021 at 14:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .