Quick technical tweaks in salesforce

File Migration Exporting a file is a tough task. File export with its binary data is not supported in most of the available tools in the market. (eg: Dataloader, Dataloader.io, workbench). However, we have the Skyvia web app, which does a really great job in file export and import.    We should pay attention to the following objects: ContentVersion(CV), ContentDocument (CD), ContentDocumentLink (CDL). I will use abbreviations for the above 3 objects further in this blog. A combination of these 3 is used for storing files in Salesforce. We will ideally export only two of them — ContentVersion and ContentDocumentLink.   ContentVersion : stores binary data of a file. A file can have multiple versions, but a user only sees LatestContentVersion by default. ContentDocument : there is always only 1 ContentDocument for a file. ContentDocument always contains LatestContentVersion id. ContentDocumentLink : connects a record to the file with the help of ContentDocumentId and Linked EntityId (pa

If you have come across requirement, where you have to do clean-up of groups and you have no idea where to start. You can prepare a list of Groups and check the count of Total, Inactive, Active users in those groups and reach some conclusion. I have prepared an apex code script, which does the same job and the final output is CSV file text which you can copy and paste in CSV file and get the final result. output String :: GroupId total inactive 00G2v000004FWzCEAW 1 1 00G90000001mENyEAM 2 1 00G90000001mEO3EAM 1 1 Final Outcome will be like this  GroupId   total   inactive   Active(do csv formula)  00G2v000004FWzCEAW  1  1  0  00G2v000004FWzCEAM  2  1  1  00G90000001mEO3EAM  1  1  0

Below script will be useful when we have to find out Active/Inactive/Total users across sf org and No of roles are so many, so doing thing manually won't work. I have prepared below apex script which can be execute in developer console or workbench execute anonymous window. I hope this will be useful for you. Output will be like this when copied in csv file .  RoleId   total   inactive    00E900000016i8gEAA  1  null  00E900000016i8oEA   1  1

Salesforce Connections are used to share data/records between 2  salesforce org of yours or with Partner. Terminology we need to understand more about salesforce connection and how it works. Source Org = Org which is used to share records and its data. Target Org =  Org which receive shared record. Connection User = A user under this operation of sharing and receiving are performed is known as "Connection User" with Profile "Partner Network". Settings and Configuration  In Setup :  go to Salesforce to Salesforce, and enable it first to use. Click on All Tabs at the navigation bar and look for Connections tab Click on  New Button to create a new Connection. Fill Contact (mandatory), Account, Connection Owner. Based on Contact Email Id, a Connection Invite email is sent to that mail id and that person/Partner User has to click on a link received in email and that link direct to login to sf org for login to their own org which will serve