Ye Meri Life Hai - Chirag Mehta

Be Good & Do Good!

Page 3 of 133

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 @

Facebook Email or FEmail or FMail or Future Email ….?

Are we going to hear something spectacular or something really new n future Email service from There are lot of speculations on inet about Facebook about to announce it’s email service tomorrow (15 Nov, 2010). Let’s wait and watch.

However there are few interesting facts

  • Facebook has acquired the domain name. The whois record for the domain name just updated to show Facebook’s name and nameservers for the domain name.
  • Try and send email to “” (i.e.,, the email doesn’t bounce back
  • – prompts you with username and password to login to facebook email – Is it employee email account login or is it future login portal for the public

So there’s something really coming up this Monday, FEmail or FMail or Future Email ….

Facebook latest feature : “Download Your Information”

Just came across a new latest feature from Facebook, “Download Your Information.” Feature was launched almost a month back, I just came across it today.

This tool lets you download a copy of your information, including your photos and videos, posts on your wall, all of your messages, your friend list and other content you have shared on your profile. Within this zip file you will have access to your data in a simple, browseable manner.

Learn More about downloading a copy of your information @

We don’t do anything ourselves, is it?

Today, came across nice little story about Turtles.  The story is small, yet it speaks out a message which is really part of everyone’s life.  Are we doing anything for ourselves? Are we ?

Some of us waste our time waiting for people to live up to our expectations. We are so concerned about what others are doing that we don’t do anything ourselves.

A turtle family decided to go on a picnic. The turtles, being naturally low about things, took seven years to prepare for their outing. Finally the turtle family left home looking for a suitable place. During the second year of their journey they found a place ideal for them at last!

For about six months they cleaned the area, unpacked the picnic basket, and completed the arrangements. Then they discovered they had forgotten the salt. A picnic without salt would be a disaster, they all agreed. After a lengthy discussion, the youngest turtle was chosen to retrieve the salt from home. Although he was the fastest of the slow moving turtles, the little turtle whined, cried, and wobbled in his shell. He agreed to go on one condition: that no one would eat until he returned. The family consented and the little turtle left.

Three years passed and the little turtle had not returned. Five years…six years… then on the seventh year of his absence, the oldest turtle could no longer contain his hunger. He announced that he was going to eat and begun to unwrap a sandwich.

At that point the little turtle suddenly popped out from behind a tree shouting, ‘See! I knew you wouldn’t wait. Now I am not going to go get the salt.’

Some of us waste our time waiting for people to live up to our expectations. We are so concerned about what others are doing that we don’t do anything ourselves. 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.

Orkut Virus Warning: Bom Sabado!

I got Bom Sabado Orkut Scraps in my gmail account from almost 3 friends in my network.

I wasn’t able to find any official information regarding this. But there is a serious scrap that is spreading verry fast to all orkut users.

Before opening orkut, I searched about this on google and found couple of warning messages

When I opened orkut and tried to visit those friends profile, I suddenly noticed in my updates that I have joined few Porno related community and have sent that scrap too all my friends in my network. I tried to visit that community and unjoined from that, but orkut was so slooow. After that I saw I again joined that community. This is too bad and a scam for sure. So my request is that please do not open your Orkut account any sooner or you will be a victim.

All those communities were in Portuguese language, so it may be originated from there or Brazil, where Orkut is most popular.Change your password soon.

In the mean time, remember these :

1. DONOT visit any profile on Orkut till this script is blocked ( More preciously DONOT use Orkut till this is blocked, as you can get affected by Flash scraps posted on your SB too! )

2. Clear your cookies and cache right away and change your password and security question :

3. Let your friends know about this script and make them aware of the situation. ( It’s just an effort to minimize the damage ).

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 @

« Older posts Newer posts »