This content has been marked as final. Show 2 replies
You can use a free tool from Informatica - https://app.informaticaondemand.com/saas/registerUser.do?edition=dls&offerCode=DLS-Website
You can do mass imports, exports, upserts, deletes, and can easily map fields.
1. You can change the texts of the LOV items in the DataLoader. When that corresponds with to a name in the uploaded data, it's defaulted to that value.
2. Not really... However you can define a Transformation that creates an invalid row (like empty'ing NOT NULL columns). So uploading that row will fail. And that is visible to the end user..