Detail Page Link in Apex Class

Hi

below is the code where you get detail page link in Apex Class or trigger.

str= System.URL.getSalesforceBaseUrl().getHost();
str = str + '/'+ oldOpp.Id;
System.debug('---------System URL-----------------'+ str);

Creating Excel in Visualforce Page.

Create a visualforce page and add the content type attribute in the <apex:page>

<apex:page standardController="Opportunity" extensions="OpportunityReport_Extn" showHeader="true" sidebar="true" cache="true" contenttype="application/vnd.ms-excel#Opportunity_report.xls">
  <apex:pageBlock >
       <apex:pageblockTable value="{!generateReport}" var="oppty" id="tbl1">
           <apex:column value="{!oppty.Name}"/>
           <apex:column value="{!oppty.Id}"/>
           <apex:column value="{!oppty.StageName}"/>
           <apex:column value="{!oppty.Closedate}"/>
           <apex:column value="{!oppty.Type}" />
       </apex:pageblockTable>    
   </apex:pageBlock>
</apex:page>

In this page I have used controller, below is the code for that.

public class OpportunityReport_Extn {
    public List <Opportunity> getgenerateReport()
    {
       query = 'select Closedate,Name,Type,StageName,Id from Opportunity';    
        try
        {
            List<Opportunity> opplist = database.query(query);
            return opplist;          
        }
        catch (QueryException e)
        {
            ApexPages.addMessages(e);
            return Null;
        }      
   }
}

The above code will generate the Excel sheet.

Note: If your excel sheet contains some extra data, such us Months and month picklist, for that if you have used <apex:form> tag, remove that form tag in the visualforce page.

Create a Popup on Visualforce Page

VF Page :

Apex Controller:

OUTPUT:

How to update an AccountTeamMember Via DataLoader

If you want to update the Account Team Member in Salesforce Via Dataloader

we have to use Account Share Object.

Account Share object will have data of AccountTeamMemeber and Owner of the Account.

While Updating we have to skip the owner data and we have to update only the AccountTeamMember data.

Below is the screen shot for Account Team Member Present in the Account.

For this Account when we extract the AccountShare Object from Dataloader, it has 2 records.

In the RowCause field you can identify, whether it is Team or Owner. you cannot update the data for Owner. Team Data can be updated.

so using data loader you can update the Team Data, which will automatically update the Access of Account Team Member data.

Auth. Providers in salesforce.

Login salesforce using Gmail Account.

This is done by the Auth.Providers option in salesforce.

STEP 1:

Create a Google Id field in User Object. and paste the Google User Id into that field Manually.
Google User Id will be there in the below URL.

Create a Apex class which implements Auth.RegistrationHandler

STEP 2:

Create the consumer key and consumer secret from Google API

Goto https://developers.google.com click on API Console ->APIs & auth ->Registered App -> register App

After clicking on register, below screen will appear with client Id and Client Secret.

STEP 3:

Login in to salesforce.

Goto setup->Adminstrators->Security Controls->Auth. Providers.

Click on New.

Choose the providerType as Open Id Connect. below screen will appear.

Enter the client Id and Client Secret in Consumer Key and consumer Secret.
Choose the class, which you have created in step 1 in Registration Handler class.
Choose the User, who is going to execute the registration.

Click on save. After saving client configuration will get generated. From that copy the callback URL and paste it in Redirect URI in Google API Field.

STEP 4:

Enable the Identifier in domain.

Goto setup->Administer->Domain Management->Domains, if you have not created any domain just create the domain now.

Click on the domain name, under Login Page Branding click Edit and enable the Authenticate Service, which you have created in step3.

Click save.

STEP  5:

Logout from Salesforce.My domain name for login page is https://priyamohanraj-dev-ed.my.salesforce.com.below screen will appear when we type this url in browser.

                     

click on Google, it will redirect to below page.


After entering the password, it will redirect to salesforce home page.