Salesforce Anytime

  Hi, When I was working on inserting some records using Salesforce Workbench tool online, I received below error. Error: "Workbench almost exhausted all its memory after only processing 0 rows of data. When performing a large data load, it is recommended to use a zipped request for processing with the Bulk API. To do so, rename your CSV file to 'request.txt', zip it, and try uploading again to Workbench." Surprisingly the file I was using was not big enough that it would need to be split in to multiple files. It seems that this is another issue Workbench tool has discovered since last few weeks. Please find workaround solution to above error below. Solution: 1. Login to https://www. packmagix .com using your Salesforce credentials. 2. Click on  Data Insert  menu item in the  Home  tab for Data Insert operation. For other operations select other menu item as required. 3. Select a Salesforce Object you want to import . e.g. Account. 4. Default Mode of import is...

Hi, Did you ever get a question how to build an SOQL query for an Object dynamically by selecting the fields on screen and export the results to a CSV file ? If yes, there are few ways you can export your data without any hassle. You can use Salesforce Workbench online tool or Salesforce Inspector chrome plugin for this purpose. However, if you want a more flexible and dynamic way for selective object fields with additional filters then you can use below solution for this. Solution 1. Login to https://www.packmagix.com using your Salesforce credentials. 2. Click on 'Data Export' menu item in the Home tab. 3. Select the Object Name. e.g. Account for running SOQL query. 4. Select and 'Add to Fields' the fields you want in your data export report. 5. Edit the SOQL Fields list if any changes needed. Add any reference object fields manually e.g. Parent.Name / Lookup__r.CustomField__c. 6. Update LIMIT (default 200) if needed. 6. Add any WHERE , GROUP BY clauses if applicable....