Hi Everyone,
I got a very strange issue while updating Customer Number Field from the Data Loader in salesforce. Actually I was uploading Contacts from the Data Loader and there is a custom field Customer Number on Contact. I have to add two leading zeros in the number and make it 10 digit number. e.g if If customer Number is 98765432 then I had to upload as 0098765432. So when I am filling this value in CSV Column, it automatically remove leading two zeros. So here is the workaround for this :
1. Right Click on the Column in which you want to add leading zeros and make it as Text:
2. Fill the value in the column whatever you want and save it in CSV format.
3. Now upload the CSV file. But always remember, never open the CSV file because if you open that file leading zero automatically will remove so try to upload without open that CSV file.
I got a very strange issue while updating Customer Number Field from the Data Loader in salesforce. Actually I was uploading Contacts from the Data Loader and there is a custom field Customer Number on Contact. I have to add two leading zeros in the number and make it 10 digit number. e.g if If customer Number is 98765432 then I had to upload as 0098765432. So when I am filling this value in CSV Column, it automatically remove leading two zeros. So here is the workaround for this :
1. Right Click on the Column in which you want to add leading zeros and make it as Text:
2. Fill the value in the column whatever you want and save it in CSV format.
3. Now upload the CSV file. But always remember, never open the CSV file because if you open that file leading zero automatically will remove so try to upload without open that CSV file.
No comments:
Post a Comment