If you are a Salesforce Administrator in a large company, you inevitably get to do a lot of data loading. But existing tools like dataloader.io…
Disclaimer: I am the founder of an alternative called SmartUpload, that can help you overcome these pitfalls. In this article, I will point to solutions within SmartUpload that are built to overcome these common data loading issues. And there is also a free version of SmartUpload.
In this article, I will discuss pitfalls that can occur when using free tools commonly used for data loading into Salesforce:
These three tools all are free to use (to some extent) and have their own pros and cons, but since they all work in a similar fashion they are all prone to the same issues. So let’s dive in …
All existing Salesforce dataloading tools work based on CSV files. These are plain text files, where data is stored on lines separated by commas. But the CSV only contains values, it doesn’t have metadata about the values.
Why is this important? Let’s illustrate with an example. Consider the following Excel sheet:
There was a problem reporting this post.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.