Friday, 22 February 2019

How to "Export Multiple Objects" in single xls sheet in Salesforce in few clicks?

IDEA:  For any Salesforce Admin or developer, there is a requirement to mass export multiple objects (Custom or Standard Object) in xls. It would be tedious job to copy and click each object one by one using Salesforce Standard process.  

These type of work requests would take more effort and time, so one of the best option to overcome this situation is by using the this appexchange tool called Salesforce Bulk Object Field Creator (BOFC)



Benefits of using BOFC Application for Export Objects?
  1. Multiple Objects can be extracted in single click in single xls sheet
  2. Supports both Standard and Custom Objects
  3. Object Details, Standard and Custom Field details are extracted for multiple objects
  4. Easy, Simple, Clickable process to export objects.

Few Simple Steps to Export Multiple Objects in salesforce


1. Open the BOFC Home > Click "Bulk Export Fields" or "Export Object & Fields for Multiple Objects"



2. It will open below screen for BOFC "Export Objects" screen



3. User can choose different actions on below image has many features (each number has its description as below):
  1. Select single or multiple objects from the drop down. For ex:  Selected Objects: Asset, Case, Campaign, Case Test
  2. Select what needs to exported (for eg: standard fields, custom fields, etc)
  3. Select "Field Permissions" option to export field permission for all the standard or custom fields
  4. If Field Permission is selected, then it is mandatory to choose Profiles using "Select Profile(s) option.
  5. System Fields are the salesforce controlled fields which cannot be exported using normal way. This is a unique feature available in this tool.
  6. Click "Click to Initiate Export" button to export xls file for all the selected objects with all the selected details. It will exports single xls (with multiple tabs, one tab for each object) for all the selected objects in Salesforce           
4. On clicking the export buttons, it will display a small section on the page. This section show the status of your export for multiple objects. Wait for couple of seconds, until status is changed to "Completed"
  1. Status: Shows if process got completed or not
  2. Total Object Selected: Shows no of object selected to export
  3. Objects Processed: Shows no of object which are processed
  4. Failure: Shows no of objects which got error out
5. Once status is "Completed", your file is ready for export. This below image has some number highlighted in [].
  1. Download Complete Object Details: On clicking this link, it will download a xls file for all the selected objects. Each object is represented as a separate tab in xls. Each Tab will have complete detail of Object, Standard Fields, Custom Fields.
  2. Download only Custom Fields: On clicking this link, it will download a xls file for all the selected objects. Each object is represented as a separate tab in xls. Each Tab will have only Custom Fields. This is used when user needs to take export and insert same fields in some other orgs.

For more details, refer official webpage of this application



No comments:

Post a Comment