Salesforce Blog

Search This Blog

XML to CSV using VBS file

on November 05, 2022

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

This work is to extract every object and fields like Id, Date or DateTime from Salesforce WSDL API XML file

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Create queue in sfdc apex test class for case object

Usually we need to create all type of data while writing test class. Like custom settings, custom object records, queue. Queue will be associated with the group. So to create a queue we need to create group. Following is the code snippet which runs to create the queue. APEXTEST:

Data Chunking in salesforce for large volume data extracts

Basically Chunking can be done in two ways: Auto-number Chunking PK chunking Auto-number Chunking Using a date range to group data into sets can be easy and clean, but the total number of records that could fall within a given range might go above the Force.com query optimizer’s selectivity threshold. When this happens, the underlying query must do a full object scan, often leading to timeouts. (Refer to the Database Query & Search Optimization Cheat Sheet to see what the selectivity thresholds are.) If you are certain that filtering by the date range alone will always be selective, you can use this field to chunk your data. Otherwise, using a unique ID is more reliable, and can be easily implemented by following these steps. Create or use an existing auto-number field. Alternatively, you can use any number fields that can make up a unique value, as long as they are sequential. Note : If you are adding a new auto-number field, make sure to enable the “Generate Auto

Make html form to not open a new window every time form gets submitted

Recently I got this scenario and researched a lot to find the hack/solution. Solution - If you can put a window names and refer same every time, then browser will make sure to open new tab if not opened already, otherwise it will just refresh the window. Example snippet: demo here <form id="myForm" action="<URL>" method="POST" target="_blank" onsubmit="target_popup(this)"> First name: <input type="text" name="fname"/><br/> Last name: <input type="text" name="lname"/><br/> <button type="submit" id="btnTest"> Submit</button> </form> <script> var target_popup = function(form) { window.open('',//URL should be blank so that it will take form attributes. 'UniqueWindowName', //window name 'width=400,he

Powered by Blogger

Written by @JPradeepkumar

XML to CSV using VBS file

Comments

Post a Comment