How to export from Developer Console in Salesforce?

1. Login into Salesforce.

2. Goto Developer ConsoleStep.

3. Execute the query in Query Editor.

4. Select all (Ctrl+A).

5. Paste in Excel Sheet.

6. Cut the required rows and paste it in a new excel file.

Cheers!!!

Conditional Highlighting in Reports in Salesforce

Conditional Highlighting in Reports in Salesforce is used to highlight field values on summary or matrix reports based on ranges and colors you specify. To enable conditional highlighting, your report must contain at least one summary field or custom summary formula.

1. Create a Summary or Matrix Report and select Conditional Highlighting under Show.


2. Set the values for colors.


Output:


Limitations/Considerations:

A. Only 3 conditions maximum per report.
B. Conditional Highlighting only applies to summary rows.
C. Available for numerical analysis only.
D. First condition is <; second condition <; third condition >=
E. Conditional Highlighting is available only in Matrix and Summary Reports. 

How to install two different versions of Informatica clients on the same machine?

To install two different versions of Informatica clients on the same machine, kindly use two different directories.

First install the 1st version in D: and later install the second in any drive other than D:.

Cheers!!!

How to find the number of days for a month using Apex in Salesforce?

Sample Code:

Integer numberDays = Date.daysInMonth(2014, 2);

system.debug('No of days in this month is ' + numberDays);

Output:


Cheers!!!

How to open Informatica Admin Console?


Cheers!!!

How to install Informatica 8.6 server?

Things to be done before installation:
Create DB users:

At least two database user accounts are required to host INFORMATICA repository :

POW_REP for the repository Database
POW_DOM fro the domain Configuration Database

For Oracle, you must perform the following instruction :

1. Create the below user.

CREATE USER POW_REP IDENTIFIED BY POW_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

2. Grant access to the user.

GRANT CONNECT, resource, CREATE VIEW TO POW_REP;

3. Create the below user.

CREATE USER POW_DOM IDENTIFIED BY POW_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

4. Grant access to the user.

GRANT CONNECT, resource, CREATE VIEW TO POW_DOM;

Set the Environment Variables:

Kindly mention the path where you are going to install the server in the environment variables.

INFA_JAVA_OPTS - C:\Informatica\PowerCenter8.6.0\java\bin


PATH - C:\Informatica\PowerCenter8.6.0\server\bin



Steps:

1. Select the language.


2. Click "Next".


3. Click "Next".


4. Select license and click "Next".


5. Click "Next".


6. Click "Next".


7. Select location for installation and click "Next".


8. Click "Next".


9. Click "Install".


10. Select "Create New Domain" and click "Next".


11. Select the database type, enter your computer name in Database URL, Database user id and password, Service name and click "Next".

Datebase URL: Computer FullName:1521


12. Choose your domain, username and password and click "Next".


13. Click "Done".


How to check the status of Oracle Database?

1. Go to command prompt.

2. Enter "lsnrtcl".

3. Enter "status".

Cheers!!!

How to start executing SQL commands in SQL command line?

1. Open your command prompt and use "sqlplus" command.


2. Enter your username and password and start using the SQL command line.


Cheers!!!

Net start OracleServiceXE system error

Net start OracleServiceXE system error is due to your profile.

Kindly do the following to fix it


Cheers!!!

What is the default username for Oracle Database Express Edition?

The default username for Oracle Database Express Edition is "system".

Cheers!!!

How to create database using SQL?

Syntax:

CREATE DATABASE db_name

Example:

CREATE DATABASE MyDevDB

Cheers!!!

Currency format in Visualforce page

Sample Code:

Visualforce page:

<apex:page extensions="Sample" standardController="Employee__c">
<apex:pageBlock >
    <apex:pageBlockSection columns="1">
        <apex:outputText value="${0, number, ###,###,###,##0.00}">
            <apex:param value="{!a}" />
        </apex:outputText>
        <apex:outputText value="${0, number, ###,###,###,##0.00}">
            <apex:param value="{!b}" />
        </apex:outputText>
        <apex:outputText value="${0, number, ###,###,###,##0.00}">
            <apex:param value="{!c}" />
        </apex:outputText>
    </apex:pageBlockSection>
</apex:pageBlock>

</apex:page>

Apex Class:

public class Sample {
    public Decimal a {get;set;}
    public Decimal b {get;set;}
    public Decimal c {get;set;}
    
    public Sample(ApexPages.StandardController controller) {
        a = 1800.00;
        b = 200;
        c = 34567.09;
    }

}

Output:




Sample Code:

Visualforce page:

<apex:page controller="Sample">
<apex:outputLabel value="The value is : "/>
<apex:outputText value="{0, number, currency}">
    <apex:param value="{!inte}"/>
</apex:outputText>
</apex:page>


Apex Controller:

public class Sample { 
    public Decimal inte {get;set;}
    public Sample() {
        inte = 098.23;
    }         
}


Output:


Getting started with Informatica Powercenter

What is Informatica Powercenter?
PowerCenter Enterprise forms the foundation for all your data and enterprise integration initiatives—including data governance, data migration, and enterprise data warehousing—setting the standard for high-performance enterprise data integration and quality software. It scales to support large volumes of disparate data sources and meets demands for security and performance.

http://www.informatica.com/us/products/data-integration/enterprise/powercenter

Client Applications:
Informatica client applications are desktop tools used to create transformations, manage metadata, execute ETL processes and monitor them.

Designer - Tool for creating ETL mappings.
Workflow Manager - Tool to create and start workflows (sequences of mappings)
Workflow Monitor - Tool to monitor the workflows
Repository Manager - Tool to manage source/targets connections, folders, objects, users, etc.
Administrator console - Tool to perform domain and repository service tasks (configure services, nodes, perform backups, etc.)

Cheers!!!

Decimal to Currency format using apex in Salesforce

Sample Code:

Decimal a = 14862.00;
system.debug('Currency is ' + (a.format().contains('.')?a.format():(a.format()+'.00')));

a = 14862.05;
system.debug('Currency is ' + (a.format().contains('.')?a.format():(a.format()+'.00')));

Output:


Cheers!!!

How to create multiple fields in Salesforce using ANT tool?

1. Extract the object using the following package.xml

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
    <types>
        <members>Employee__c</members>
        <name>CustomObject</name>
    </types>
    <version>30.0</version>
</Package>

2. Create multiple fields like below in the Employee__c.object


3. Deploy the modified Employee__c.object.

Output:


Cheers!!!

How to get the list of users who have given Grant Login Access in Salesforce?

1. Create a report with Users report type.


2. Filter the report as below


Cheers!!!

SetupEntityAccess

SetupEntityAccess represents the enabled setup entity access settings (such as for Apex classes) for the parent PermissionSet. To grant users access to an entity, associate the appropriate SetupEntityAccess record with a PermissionSet that’s assigned to a user. This object is available in API version 25.0 and later.

Sample SOQL:
SELECT Id, ParentId, Parent.Name, SetupEntityId FROM SetupEntityAccess

Cheers!!!

Product2, PriceBook2 and PriceBookEntry

Product2
A product that your organization sells.

Pricebook2
A price book that contains the list of products (Product2 records) that your organization sells.

1. Each organization has one standard price book that defines the standard or generic list price for each product or service that it sells.

2. An organization can have multiple custom price books that can be used for specialized purposes, such as a discount price book, price books for different channels or markets, price books for select accounts or opportunities, and so on.

3. For some organizations, the standard price book might be the only price needed, but if you need to set up further price books, you can reference the standard price book when setting up list prices in custom price books.

PricebookEntry
A product entry (an association between a Pricebook2 and Product2) in a price book.
It represents a price for a given currency.

Cheers!!!

How to make calls to mobiles free of cost from internet?

Check the below link

http://www.google.com/googlevoice/about.html

Within US and Canada, its absolutely free. To other other countries its very cheaper.

Cheers!!!

How to get parent id from the URL in Salesforce?

Sample Code:

Id parentId = ApexPages.currentPage().getParameters().get('retURL').substring(0,15);

Cheers!!!

How to add subgroup in Salesforce?


Accessing Data with Standard List Controllers in Salesforce

Sample Code:

<apex:page standardController="Account" recordSetVar="accounts" tabstyle="account" sidebar="false">
<apex:pageBlock >
<apex:pageBlockTable value="{!accounts}" var="a">
<apex:column value="{!a.Name}"/>
apex:column value="{!a.WebSite}"/>
apex:column value="{!a.AccountNumber}"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:page>

Cheers!!!

Getting Started With Salesforce

How to move reports from one organization to other usin ANT tool in Salesforce?

Sample package.xml:

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
        <members>Report Name</members>
        <name>Report</name>
    </types>
    <version>30.0</version>
</Package>


Cheers!!!

Opening for Freshers in Accel Frontline

Engineer-Technical Support

Experience
:     0 – 3 yrs.
Location
:     Chennai
No. of Positions
:     2
Education
:     Any Graduate

Job Description

•          Handling customer queries on basic hardware and networking issues

Desired Candidate Profile

•          Good communication skill in English/Tamil/Hindi
•          Basic understanding of hardware and networking issues
•          Any certification in hardware and networking will be an added advantage


Applying Procedure : Email your CVs to barada.kanta@accelfrontline.in keeping hrd@accelfrontline.in in CC

Cheers!!!

Opening for Freshers in HCL

Designation
Trainee
Location
Chennai
Job Family
Support (Support)
Job Description (Posting).
To attend to and provide solutions for the issues raised by users in their applications in a timely manner and according to agreed standards and procedures.
Experience
Fresher
Qualification
BCA
No. of Positions
5
Skill (Primary)
Technical Skills-Programming/Scripting Languages-Oracle PL/SQL
Removal Date
20-Sep-2014

Reference :


Cheers!!!

How to avoid Salesforce Governor Limits in Test class in Salesforce?

Test.startTest() and Test.stopTest() are very useful when your test class hits Salesforce Governor Limits.

The code inside Test.startTest() and Test.stopTest() have new set of Salesforce Governor Limits. As a good practice, make sure initializing the variables, fetching records, creating and updating records are coded before Test.startTest() and Test.stopTest() and calling the controllers for code coverage is done inside Test.startTest() and Test.stopTest(). The code before Test.startTest() and after Test.stopTest() have new set of Salesforce Governor Limits and code between Test.startTest() and Test.stopTest() have new set of Salesforce Governor Limits.

Sample Test Class:

private class TestClass {
        static testMethod void test() {
                /*
                        Declare the variables, Fetch the required records, Create and update sample records
                */

                /*
                        Test.startTest();
                        /*
                        Call the controller for code coverage
                        */
                        Test.stopTest();
                */
        }
}

Cheers!!!

What is the purpose of Test.startTest() and Test.stopTest() in Salesforce?

Test.startTest() and Test.stopTest() are very useful when your test class hits Salesforce Governor Limits.

The code inside Test.startTest() and Test.stopTest() have new set of Salesforce Governor Limits. As a good practice, make sure initializing the variables, fetching records, creating and updating records are coded before Test.startTest() and Test.stopTest() and calling the controllers for code coverage is done inside Test.startTest() and Test.stopTest(). The code before Test.startTest() and after Test.stopTest() have new set of Salesforce Governor Limits and code between Test.startTest() and Test.stopTest() have new set of Salesforce Governor Limits.

Sample Test Class:

private class TestClass {
        static testMethod void test() {
                /*
                        Declare the variables, Fetch the required records, Create and update sample records
                */
                /*
                        Test.startTest();
                        /*
                        Call the controller for code coverage
                        */
                        Test.stopTest();
                */
        }
}

Cheers!!!

Creating Activity on insertion of record using trigger in Salesforce

Add the Activity related lists:



Sample Trigger:

trigger EmployeeActivityTrigger on Employee__c (after insert) {
    List<Task> listTask = new List<Task>();
    for(Employee__c emp : trigger.new) {
        Task tk = new Task();
        tk.WhatId = emp.Id;
        tk.Description = 'Conact the employee';
        tk.Subject = 'Employee Created on ' + Date.today();
        listTask.add(tk);
    }
    insert listTask;
}

Output:



How to right align in apex:pageBlockTable?

Sample Code:

Visualforce page:

<apex:page controller="Sample">
    <style type = "text/css">
        .colHeadr {text-align:center;}     
    </style>
    <apex:pageBlock >
        <apex:pageBlockSection >
            <apex:pageBlockTable value="{!listEmp}" var="e" border="1">
                <apex:column dir="RTL" value="{!e.Name}"/>
                <apex:column dir="RTL" value="{!e.Age__c}"/>
            </apex:pageBlockTable>
        </apex:pageBlockSection>
    </apex:pageBlock>
</apex:page>

Apex Class:

public class Sample {
    public List<Employee__c> listEmp {get;set;}
    public Sample() {
        listEmp = new List<Employee__c>();
        listEmp = [SELECT Name, Age__c FROM Employee__c];
    }
}

Note: This dir attribute is not applicable for header.

If the above code is not working, try the below code

<apex:page controller="Sample">
    <style type = "text/css">  
        .rightAlign {text-align:right;} 
    </style>
    <apex:pageBlock >
        <apex:pageBlockSection >
            <apex:pageBlockTable value="{!listEmp}" var="e" border="1">
                <apex:column dir="RTL" value="{!e.Name}"/>
                <apex:column dir="RTL" value="{!e.Age__c}" styleClass="rightAlign"/>
            </apex:pageBlockTable>
        </apex:pageBlockSection>
    </apex:pageBlock>
</apex:page>


Cheers!!!

How to align column header to center in Visualforce page?

Sample Code:

Visualforce page:

<apex:page controller="Sample">
    <style type = "text/css">
        .colHeadr {text-align:center;}     
    </style>
<apex:form >
    <apex:pageBlock >
        <apex:pageBlockSection >
            <apex:pageBlockTable value="{!listEmp}" var="e">
                <apex:column value="{!e.Name}" headerClass="colHeadr"/>
                <apex:column value="{!e.Age__c}" headerClass="colHeadr"/>
            </apex:pageBlockTable>
        </apex:pageBlockSection>
    </apex:pageBlock>
</apex:form>
</apex:page>

Apex Class:

public class Sample {
    public List<Employee__c> listEmp {get;set;}
    public Sample() {
        listEmp = new List<Employee__c>();
        listEmp = [SELECT Name, Age__c FROM Employee__c];
    }
}

Output:



Cheers!!!

Step by Step Approval Process in Salesforce

Sample Approval Process:


For first approval:


For second approval:


Output:


How to navigate to next page on click of a button in Salesforce?

Visualforce page1:

<apex:page controller="Sample">
<apex:form >
    <apex:pageBlock >
        <apex:pageBlockButtons >            
            <apex:commandButton value="Next Page" onclick="show();"/>
        </apex:pageBlockButtons>
    </apex:pageBlock>
</apex:form>
</apex:page>

Apex class:

public class Sample {
    public Sample() {
    
    }
    
    public PageReference next() {
        return Page.Sample1;
    }
}

Visualforce page2:

<apex:page >
This is the second page.
</apex:page>

Output:




How to switch from one tab to another using button in Visualforce page?

Sample Code:

Visualforce page:


<apex:page controller="Sample">
<apex:form >
    <apex:tabPanel id="theTabPanel" value="{!tabOpt}">
        <apex:tab label="One" name="One" id="One"><apex:commandButton value="Go to Two" action="{!switch}"/></apex:tab>
        <apex:tab label="Two" name="Two" id="Two">content for tab two</apex:tab>
    </apex:tabPanel>
</apex:form>    
</apex:page>

Apex Controller:

public class Sample
{
    public String tabOpt {get;set;}
    public String amount {get;set;}
    public Boolean curencyBool {get;set;}
    
    public sample()
    {            
    }      
    
    public void switch()
    {
        tabOpt = 'Two';
    } 
}

Cheers!!!