Ye Meri Life Hai - Chirag Mehta

Be Good & Do Good!

Page 3 of 133

Alvida … Phir milenge … Good Bye Tata Consultancy Services …

Dear TCS’ers …

Today, 5+ Years of my journey in TCS comes to an end. I would like to personally let you know that today I am leaving my position at Tata Consultancy Services Ltd. I have enjoyed working here and I sincerely appreciate having had the chance to work with you.

Thank you for the support and encouragement you have provided me during my time at TCS. I will miss our interactions and projects we had worked on together.

I would appreciate your continued advice as I start the next phase of my career.

Please keep in touch. Again, thanks so much for your support and keep smiling.

Sometimes it gets very very hard to leave things aside and walk away, as those things have already made a big foot print in your soul.

Best regards,
Chirag

How do I mass-move reports from one folder into another new folder

Problem Statement: We are currently cleaning up our report folders. In order to do so we want to move all unused reports into a ‘quarantene map’ before deleting them. How can we move a large number of reports all at once into one folder? i.e.,

Approach1
In the Eclipse IDE

  • Create a new project
  • Include ‘reports’ or more specifically the report folders you are concerned with
  • Let Eclipse refresh the project with the reports metadata
  • In Eclipse, navigate to the reports folder you just download and then select the Report Folder you want the reports you want to move from, right click and select Properties
  • Take Note of the Location. This is the path where the metadata files are located
  • Open a windows explorer window and navigate to that path
  • Highlight all the Reports you want to move and right click Cut
  • Still in the Window explorer navigate back to the list of report folder and expand the one you want to move the reports to and right click and Paste
  • Now back in the IDE highlight the folder titled Reports and right click and Refresh and then right click again and Force.com>Save to Server
  • BOOM! Now you have moved your reports.

 

Approach2

  • Another alternative would be to edit each report folder on the Report page and move unused reports to the Unfiled Public Reports folder.  You can then move all the reports in your Unfiled Public Reports folder to a new “quarantine” folder.  Yeah I know, still a lot of manual effort.

 

Approach3


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 Force.com IDE

A year back Salesforce began supporting source code analysis on Force.com through http://security.force.com/sourcescanner. But there wasn’t any integration with the Force.com IDE.

Checkmarx, the company Salesforce partnered with to provide Force.com 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 Force.com 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 http://www.apexscanner.com.

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 Database.com Dreamforce’10 new baby …

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

Check this
Database.com
Database.com

Read more @ http://www.database.com/

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 Facebook.com? 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 FB.com 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 “yourprofileid@fb.com” (i.e., chiragmehta84@fb.com), the email doesn’t bounce back
  • mail.facebook.com – 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 @ https://register.facebook.com/help/?topic=download

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.

Salesforce.com launches new HELP Site with Winter’11

Salesforce.com 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 Salesforce.com 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 Salesforce.com 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.

« Older posts Newer posts »