{"id":273,"date":"2014-04-18T16:37:05","date_gmt":"2014-04-18T11:07:05","guid":{"rendered":"https:\/\/www.dhruvsoft.com\/blog\/?p=273"},"modified":"2024-07-26T09:46:51","modified_gmt":"2024-07-26T09:46:51","slug":"twelve-salesforce-com-data-upload-tips","status":"publish","type":"post","link":"https:\/\/www.dhruvsoft.com\/blog\/twelve-salesforce-com-data-upload-tips\/","title":{"rendered":"12 Salesforce.com Data Upload Tips"},"content":{"rendered":"

Salesforce.com Data upload is a regular task for some of the Salesforce.com administrators or end users. The quality of data in CRM determines the health of your CRM implementation. Considering this – the data upload – not only in Salesforce.com, but in any CRM has to be a well planned task.<\/p>\n

<\/p>\n

In this post we have identified some of the key tips that you must consider before doing the data upload in Salesforce.com CRM. Here is what you must consider before uploading any data into salesforce.com CRM using data loader:<\/p>\n

Twelve Salesforce.com Data Upload Tips<\/h4>\n

\"12<\/a><\/p>\n

1. Avoid duplicates in source sheet:<\/h4>\n

Make sure that the sheet doesn’t contain any duplicates records.<\/p>\n

2. Ensure data in required columns:<\/h4>\n

Any required fields that are made required at the field level should be uploaded otherwise it will not allow you upload the record.<\/p>\n

3. Verify and deactivate workflows if required:<\/h4>\n

Make sure that all the email alerts in the salesforce are inactive while uploading the data. We have seen reports of unwanted emails getting triggered on data upload from many Salesforce.com administrators.<\/p>\n

4. Upload a sample first to test:<\/h4>\n

Don\u00e2\u20ac™t upload complete data at a time first upload a sample 5 records and verify, if it is ok upload the remaining data.<\/p>\n

5. Time zone in data loader:<\/h4>\n

Make sure that the time Zone is set in the data loader – if not the data fields may load incorrectly.<\/p>\n

6. What if process is interrupted?:<\/h4>\n

When the upload process is interrupted in the middle due to server problem or something else you need not separate the sheet and upload the remaining records, simply use the same sheet and set the \u00e2\u20ac\u0153start at row \u00e2\u20ac\u009d value in dataloader.<\/p>\n

7. Validate picklist fields:<\/h4>\n

While uploading any picklist values make sure that the values in the sheet exactly match with the values in the salesforce
\nEx: Salesforce picklist value: Prospect
\nSheet value: Prospects<\/p>\n

If upload is through Dataloader it will not show any error it simply saves the value in the record but that value is not available in the picklist values of the field.<\/p>\n

If upload is through \u00e2\u20ac\u0153Import Wizard\u00e2\u20ac\u009d it will not allow you save the value.<\/p>\n

8. Validate date Fields:<\/h4>\n

Make sure that date format in the sheet match with date format of salesforce
\nEx: Salesforce date format : mm\/dd\/yyyy
\nSheet format : dd\/mm\/yyyy
\nThis will upload the records with wrong dates. To avoid this check the \u00e2\u20ac\u0153Use European date format\u00e2\u20ac\u009d checkbox in dataloader settings<\/p>\n

9. Validate owner:<\/h4>\n

Data Sheet should contain the Owner – if not it will take the current user uploading as owner of the records.<\/p>\n

10. Record identified for upload batches:<\/h4>\n

We recommend to maintain a \u00e2\u20ac\u0153batch reference number\u00e2\u20ac\u009d for every upload so that if anything goes wrong in the upload then you can delete them by using the batch reference number. Batch reference number can be a custom field on the object you are uploading.<\/p>\n

11. Use Salesforce.com IDs:<\/h4>\n

Always use the id instead of name for any lookup values in \u00e2\u20ac\u0153Import Wizard\u00e2\u20ac\u009d so that the mismatch of the records can be avoided.<\/p>\n

12. Avoid entering security token by adding IP address:<\/h4>\n

No need to give the security token to login in to dataloader just add the IP in the IP Ranges under network access.<\/p>\n

These tips will help Salesforce.com administrators when uploading data in Salesforce.com CRM.<\/p>\n","protected":false},"excerpt":{"rendered":"

Salesforce.com Data upload is a regular task for some of the Salesforce.com administrators or end users. The quality of data in CRM determines the health of your CRM implementation. Considering this – the data upload – not only in Salesforce.com, but in any CRM has to be a well planned task.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[113,115,114],"class_list":["post-273","post","type-post","status-publish","format-standard","hentry","category-salesforce-tip-of-the-day","tag-data-upload-tips","tag-data-upload-tips-in-slaesforce","tag-salesforce-crm-tips","entry"],"_links":{"self":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=273"}],"version-history":[{"count":0,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/273\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}