Ye Meri Life Hai - Chirag Mehta

Be Good & Do Good!

Tag: Salesforce (page 2 of 11)

Field datatype mapping between Oracle/SQL Server and Salesforce

Over the time I have started developing a tool that pulls salesforce metadata information and creates oracle/sql server “create table” scripts. Isn’t that really awesome!!

The most useful part of the tool is field data type mapping i.e, what data type of salesforce maps to what data type of oracle/sql server. Below is the list of mapping that I used while generating create table scripts – enjoy!!

salesforce data type sql server data type oracle data type
boolean bit varchar2(1)
date smalldatetime date
datetime Datetime date
currency decimal(precision,scale) number(precision,scale)
double decimal(precision,scale) number(precision,scale)
int Int number(10)
picklist nvarchar(255) varchar2(255)
id nvarchar(18) varchar2(18)
reference nvarchar(18) varchar2(18)
textarea nvarchar(max) varchar2(4000)
email nvarchar(255) varchar2(255)
phone nvarchar(255) varchar2(255)
url nvarchar(255) varchar2(255)
textarea nvarchar(max) varchar2(4000)
multipicklist nvarchar(max) varchar2(4000)
anyType nvarchar(max) varchar2(4000)
percent decimal(5,2) number(5,2)
combobox nvarchar(max) varchar2(4000)
base64 nvarchar(max) varchar2(4000)
time nvarchar(255) varchar2(255)
string nvarchar(length) varchar2(length)


Apex Visualforce Code Scanning directly in IDE

A year back Salesforce began supporting source code analysis on through But there wasn’t any integration with the IDE.

Checkmarx, the company Salesforce partnered with to provide source scanning, has stepped up and made an offering available to all of us. For 90 days, for the first 1000 developers, they’ll give away a free version of an Eclipse plugin that can scan all code (under 100k LoC). The great thing about this is that you get actionable results, directly in your IDE, without having to cross reference line numbers in a report like you have to do today. I hope this is a great resource for all of us!

Download a copy at

Salesforce Ideas Coming in Spring ’11 Release

Check out which Ideas are Coming in the Spring ’11 Release!

Spring'11 Logo

Favorite : My Favorites

Is Dreamforce’10 new baby …

Came acrorss a site, is that a new baby to be delivered in Today’s Dremaforce’10 conference?

Check this

Read more @ launches new HELP Site with Winter’11 launches new HELP Site with Winter’11. The new Help site brings together a rich set of resources to help you find the answers to your questions quickly and easily.

With the new Help site, you can:

  • Find Answers Fast: Use advanced search find the information you need quickly
  • Customize Help: Personalize the Help site to meet your specific needs by adding gadgets and customizing the layout
  • Chat: Chat with Support experts in real-time
  • Work with Cases: Open and review cases faster than ever
  • Leverage New Administrator Views: Administrators gain insight with enhanced reporting on cases and organization information

The new Help site replaces the current Help & Training site. The Winter ’11 Help release is English-only, but future versions of the Help site will include content in all supported languages.
Note: Chat support will be rolled out in phases and may not be available to all customers when they first begin to use Help.

Create Salesforce lightboxes – Modal Dialogs

Lightbox components are a standard part of the Salesforce UI, but they’re not easily available (until now!) for your own code.

Salesforce lightboxes have the following properties:

  • They “grey out” the rest of the page behind the component, making the page unclickable until the lightbox is dismissed
  • They can be dragged around the screen by dragging on the title bar
  • They can contain any content you like, including a Visualforce page (use an iframe inside the lightbox)

Get Salesforce Lighbox component @

VMforce : Cloud Computing for Java Developers : Recorded Webinar

The recorded webinar “VMforce : Cloud Computing for Java Developers” provides an introduction to Cloud Computing, overview of the platform, and a sneak peak of VMforce.

The webinar was recorded, and it is available for viewing @

For additional information, tutorials and tips, visit following site and blog:

What network IP addresses do I need to whitelist? has an IP address block allocated directly to by the American Registry for Internet Numbers (ARIN).

To provide continuity of service if you utilize email or IP address security filters, white list or otherwise add’s IP address space to your list of trusted addresses

The IP address spaces are as follows: East Coast Data Center (set one) East Coast Data Center (set two) West Coast Data Center (set one) West Coast Data Center (set two) Singapore Data Center

To clarify, the “0/25” that you see in the ranges refers to an abbreviated form of Classless Inter-domain routing notation. In essence this notation is a network number followed by a “/” and a number , the latter number indicates the number of 1’s (starting a the left most bit i.e MSB – most significant bit) in the subnet mask i.e the number of bits relevant to a network portion of the IP address. So “/25” means 25 bits constitute the subnet mask of, and really 25 bits reserved for network address which is identified by performing bitwise “AND” to the full network number.

For example means 2 possible networks in the form of and each having possible 126 hosts i.e total 252 hosts or IP addresses per specified range.

Salesforce – Hide standard buttons display (Working version)

There are many a times where we want to remove few standard buttons from page layout, but there is no such option to remove such restricted buttons. Few such buttons are …

  • “New Note” or “Attach File” button on Google Docs, Notes, & Attachments Related list
  • “Save & Send Invitation” button on New Event page
  • Following is a solution which will hide “Save & Send Invitation” button on New Event page

    STEP1: JAVASCRIPT Code. Create a JS file with below code

    function hideBtns()
    document.getElementsByName(“sendEmail”)[0].style.display = ‘none’;
    document.getElementsByName(“sendEmail”)[1].style.display = ‘none’;
    if (window.addEventListener) {
    window.addEventListener(“load”, hideBtns, false);
    else if (window.attachEvent) {
    window.attachEvent(“onload”, hideBtns);

    STEP2: Upload the JS file as a DOCUMENT

    STEP3: Create a Home Page Component of type (HTML Area)

    <script src=”/servlet/servlet.FileDownload?file=01530000001OcDl”></script>

    Here 01530000001OcDl is ID of document created in STEP2

    STEP4: Add above created Home page component in your home page layout.

    That’s it you are all set, now open New Event and add invitees, automatically the “Save & Send Invitation” button will disappear.

    Please note : If you have some functionality which you want to work across all pages or on every form then navigate to Setup then go to Customize->User Interface, check “Show Custom Sidebar Components on All Pages” under the Sidebar section.

    Differences between the Import Wizard and the Apex Data Loader

    Salesforce CRM provides two tools for data migration—the Import Wizard and the Apex Data Loader.

    The Import Wizard

    is designed for less-technical users and smaller, simple imports of up to 50,000 records. It takes you through the process step by step and displays error messages to alert you to potential record duplications (“dupes”). For more information, go to Help & Training | Importing Data | Using the Import Wizards.

    Use the Apex Data Loader

    for complex imports of any size. It’s for technical users only. You’ll need access to the API to use this tool, which is included with Enterprise and Unlimited Edition. If you have another edition, you can purchase the API separately by contacting your account executive. The Data Loader doesn’t display error messages to alert you to potential problems. However, this tool includes several features that help make large data imports easier, such as being able to save your mappings. For more information, go to Help & Training | Data Loader.

    The table below summarizes the difference between the two tools. The instructions in the remaining steps refer to the Import Wizard.

    Older posts Newer posts