Installation Url: https://login.salesforce.com/packaging/installPackage.apexp?p0=04t30000001EoJh
Ye Meri Life Hai – Chirag Mehta
Category Archives: Salesforce
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
- A appexchange product, DashPort, allows you to mass move and delete reports and dashboards. You can check out AppExchange listing for more details: http://sites.force.com/appexchange/listingDetail?listingId=a0N300000019lulEAA
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) |
| 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!
- Criteria Based Sharing (includes by Record Type)
- Google Chrome Web Browser makes Salesforce Faster – Make Google Chrome available
- “Like” button is needed in Chatter
- Notification Icon for Tweets / Chatter
- Allow for in-line editing of fields on visualforce pages
- Allow more than three “Run as logged-in user” Dashboards
- Report Builder: Type to search filter fields
- salesforce for outlook – save email attachments to salesforce
- Salesforce for Outlook – selective association of emails to records
- Rebrand Trialforce Welcome Message
- Sort Order of Quote Line Items
- Set the dashboard Running User as “current user” (dynamic) Enable this for EE
- RSS Feed for trust.salesforce.com
- Add delete button for inbound change sets
- SF Knowledge Articles: where is the number?
- Import / Export in the Translation Workbench
- New Dashboard Editor: Please support Google Chrome!
- Enable open web technologies like Google Chrome Frame in IE
- Making the Public Knowledge Base Shell Available in Different Languages
- Salesforce for Outlook: support for delegated authentication (SSO)
- Make Report Builder available to the Prof. Edition Standard User profile
- Warning Message in Outlook when password will expire
- Highlight the Edit Custom Filters button in the new report builder
- Allow Override of Labels of Managed Custom Objects
: 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
Read more @ http://www.database.com/
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.
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 @ http://sites.force.com/appexchange/listingDetail?listingId=a0N30000001g3u0EAA#
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 Force.com platform, and a sneak peak of VMforce.
The webinar was recorded, and it is available for viewing @
:: http://wiki.developerforce.com/index.php/VMforce_Webinar_Series
For additional information, tutorials and tips, visit following site and blog:
:: http://developer.force.com/
:: http://blog.sforce.com/
What salesforce.com network IP addresses do I need to whitelist?
Salesforce.com has an IP address block allocated directly to salesforce.com 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 salesforce.com’s IP address space to your list of trusted addresses
The IP address spaces are as follows:
204.14.232.0/25 East Coast Data Center (set one)
204.14.233.0/25 East Coast Data Center (set two)
204.14.234.0/25 West Coast Data Center (set one)
204.14.235.0/25 West Coast Data Center (set two)
202.129.242.0/25 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 255.255.255.128, and really 25 bits reserved for network address which is identified by performing bitwise “AND” to the full network number.
For example 204.14.232.0/25 means 2 possible networks in the form of 204.14.232.0 and 204.14.232.128 each having possible 126 hosts i.e total 252 hosts or IP addresses per specified range.
