Salesforce Data migration/Data Consolidation Tricks & Tips


1) Change System TimeZone to UTC.

Rightclick on date and time and click on Adjust date/time.in Time Zone select UTC Coordinated Universel time.
Adjust date/time for salesforce data migration
Adjust date/time for salesforce data migration
Adjust date/time for salesforce data migration
Adjust date/time for salesforce data migration



2) Update your dataloader time zone as GMT.

Salesforce dataloader time Zone
Salesforce dataloader time Zone 

3) Change time zone in salesforce user org to GMT+00:00 Greenwhich mean time GMT

4) While Exporting Data use UTF-8 to avoid special characters.

5) Always Use CSV file format to export and load the data.

6) While loading data keep short date system (yyyy-dd-mm)format in excel.

7) Save files with version names ex : samplefile_v1.csv

8) Turnoff Email Deliverabilities while loading data.

9) Check Field mapping in dataloader and save mapping file (slds) for feature use.

10) Check some records/data manually after load.

11) Store previous record id in any external unique field.

12 ) Learn vlookup in Microsoft excel, i will useful for Mapping parent records in excel before loading.

13) Export data from setup -> Data Management in salesforce.

Comments

  1. Indie Test DeveloperOctober 23, 2019 at 3:05 AM

    thanks for sharing wonderful article on Tech Stuffs

    ReplyDelete
  2. Alfred AvinaOctober 28, 2019 at 11:31 PM

    Archiving the data from one to different platforms has been a difficult task for me until I found one of the best data migration development services. I really feel thankful to your company for offering me excellent data migration solutions along with the stepwise guidance.

    ReplyDelete

Post a Comment

Popular posts from this blog

Community/Experience Cloud Interview Questions

  Community Cloud /Experience Cloud: 1) What is community cloud/Experience Cloud ? Community cloud is a platform to connect with customers, partners, and employees.customers can view records (case,order), share documents, images etc.We can directly communicate with Agents to resolve problems. Community cloud renamed as Experience Cloud in Spring 21. From now community Builder,community workspace called as Experience Builder and Experience workspace. 2) May i know Spring 21 major updates about terminology in community/Experience cloud? Below are the major updates given by salesforce in Community cloud. Community cloud changed to Experience Cloud Community changed to Site or Experience Cloud site Lightning community changed to Experience Builder Site Lightning community template changed to Experience Builder template Lightning community theme changed to Experience Builder theme Lightning community page changed to Experience Builder page Salesforce Tabs + Visualforce community chang
Read more

Script to delete multiple records using Apex salesforce

Delete multiple records from salesforce anonymous block using some script.find the below script just paste the script in the anonymous vlock and select the code and click on Execute Highlighted. Before that if any conditions need to check add it in SOQL Query or if condition then it will filter the records and delete the records. If there are more records we have to run this script multiple times .if we try to delete all the records at a time we might get the DML and limit exceptions.so adding limit in SOQL query and executing. Example :  Object : ABC__c Fields : field1__c, field2__c list<ABC__c> abclist = new list<ABC__c>(); List<ABC__c > alltldroles = [SELECT id,name,field1__c,field2__c                              FROM ABC__c LIMIT 1000]; if(alltldroles.size()>0){     for(ABC__c tldroleslist : alltldroles) {          if(tldroleslist.field1__c != null && tldroleslist.field2__c!=null )  {           abclist.add(tldroleslist);       }
Read more

Change Owner / Update record using Lightning Custom Button Salesforce

Image
This post is related to changes the Owner or update the record from detail page in lightning. Actually we have standard button to change the owner of the record but when we click on the lighting button it will populate the popup and ask for user to change. But here the requirement is change the logged in user direcly when we click on the button. So here we created Custom lightning component with custom Quick action to complete this task. Standard Change Owner in Lightning In classic saleforce we used custom javascript buttons to execute the functionalites but lighting not support the javascript so here we created custom component with Quick action and added in the pagelayout so we can see it in lighting.and add the button in "Salesforce Mobile and Lightning Experience Actions" section. Add caption Lightning Button Pagelayout Change owner Lightning Button  <!--change owner lighting Component --> Component Name : changeowner.cmp <aura
Read more