You need to sign in to do that
Don't have an account?
Jamie Gossen
Correcting an error on an Insert of data with data Loader
I did an insert of usage to product subscriptions and the invoice date was wrong. I need to correct the invoice date on all the usages that created. I tried to do an upsert using the same info in which I inserted with and only changed the invoice date but it created a duplicate record. I was able to delete those records but I still can't figure out how to change the invoice date. I can't even delete the records. I need an ID but the ID number i pull is missing 3 letters at the end so it isn't working. Can someone walk me through what i need to do?
Copy the success file from the original load to a new file name, correct the date in the new copy of the success file, and then use that file to do an update not an upsert.