.Net, SQL, Oracle,Sharepoint, Android, BB-CRM, Salesforce.com and MS Dyanamics CRM Tips and tricks: On demad Integration of Salesforce Org to another Salesforce Org

Salesforce

This topic is related to the On demad Integration of Salesforce with another Salesforce Org. The scenario is to make a custom VF page and this page we need to capture only those account which are made in last 24 hours in 1st Org and fetch all these account on the 2nd Org. So lets Start, we have 2 Salesforce Org for this activity. So I have made a 2 Orgs. I am naming this Org as Org 1 and Org 2. So we only need to work on Org 2. No need to work on Org 1.

Create a new custom VF page."AccountFromOrg" in Org 2. Please see the below picture

Picture A

In above picture A, if user click the top button “Get from SF Org” than it will go to the first Org i.e. Org 1 and fetches those accounts which are created in between last 24 hours and after fetching those account, it will make 2 panel, one panel contains those accounts which are the new account for Org 2 and right columns contains those accounts which contains those accounts which have already imported to Org 2 and now if user want to make any update on these right column account than he needs to only select those entries and then press the below “Import Record” than these accounts will update on Org 2. And similarly insert the left column account in Org 2.

So in VF Page, please see the below VF page code.

<apex:page controller="AccountFromOrg">

<apex:form >

<apex:pagemessages />

<apex:pageblock title="Upload Account(s)">

<apex:pageblocksection columns="4">

<apex:commandbutton value="Get from SF Org" action="{!fetch}" />

</apex:pageblocksection>

</apex:pageblock>

<tr>

<apex:pageblock title="New Record(s)" rendered="{!acclistVisible}">

<apex:pageblocktable value="{!lstUAcc}" var="lstA">

<apex:column >

<apex:facet name="header">

<apex:inputcheckbox onclick="selectAllCheckboxes(this,'uAcc')" />

</apex:facet>

<apex:inputcheckbox value="{!lstA.selected}" id="uAcc" />

</apex:column>

<apex:column value="{!lstA.account.name}" />

<apex:column value="{!lstA.account.BillingStreet}" />

<apex:column value="{!lstA.account.BillingPostalCode}" />

<apex:column value="{!lstA.account.BillingCity}" />

<apex:column value="{!lstA.account.BillingCountry}" />

<apex:column value="{!lstA.account.Site}" />

<apex:column value="{!lstA.account.phone}" />

<apex:column value="{!lstA.account.fax}" />

</apex:pageblocktable>

</apex:pageblock>

</td>

<apex:pageblock title="Duplicate Record(s)" rendered="{!dacclistVisible}">

<apex:pageblocktable value="{!lstDAcc}" var="lstD">

<apex:column >

<apex:facet name="header">

<apex:inputcheckbox onclick="selectAllCheckboxes(this,'dAcc')" />

</apex:facet>

<apex:inputcheckbox value="{!lstD.selected}" id="dAcc" />

</apex:column>

<apex:column value="{!lstD.account.name}" />

<apex:column value="{!lstD.account.BillingStreet}" />

<apex:column value="{!lstD.account.BillingPostalCode}" />

<apex:column value="{!lstD.account.BillingCity}" />

<apex:column value="{!lstD.account.BillingCountry}" />

<apex:column value="{!lstD.account.Site}" />

<apex:column value="{!lstD.account.phone}" />

<apex:column value="{!lstD.account.fax}" />

</apex:pageblocktable>

</apex:pageblock>

</td>

</tr>

<tr>

<apex:commandbutton value="Import Record(s)" action="{!importCSVFile}" rendered="{!dacclistVisible || acclistVisible}" />

</td>

</tr>

</table>

function selectAllCheckboxes(obj, receivedInputID) {

var inputCheckBox = document.getElementsByTagName("input");

for (var i = 0; i < inputCheckBox.length; i++) {

if (inputCheckBox[i].id.indexOf(receivedInputID) != -1) {

inputCheckBox[i].checked = obj.checked;

}

</script>

</apex:form>

</apex:page>

After this, if we see the controller of above apex page.

public class AccountFromOrg{

//Properties

public Blob csvFileBody {get;set;}

public string csvAsString {get;set;}

public String[] csvFileLines {get;set;}

public List<AccountWrapper> lstUAcc {get;set;}

public List<AccountWrapper> lstDAcc {get;set;}

public Map<String, Contact> mapUContact {get;set;}

public Map<String, Account> mapUAccount {get;set;}

public List<Account> lstAccount {get; set;}

public Boolean acclistVisible {get; set;}

public Boolean dacclistVisible {get; set;}

public Map<String, Account> mapAccount {get; set;}

//Login Domain May be test, prerellogin.pre

String LOGIN_DOMAIN = 'login';

public String pwd{get;set;}

public String userName{get;set;}

public String errMsg{get;set;}

public String displayError{get;set;}

public List<Account> acc{get;set;}

public Integer depositAmount{get;set;}

public string AccountId{get;set;}

public AccountFromOrg(){

csvFileLines = new String[]{};

lstUAcc = New List<AccountWrapper>();

lstDAcc = New List<AccountWrapper>();

lstAccount = new List<Account>([select Id, Name, Original_Company_Name__c, Account_Duplicate_Count__c from Account]);

acclistVisible = lstUAcc.size() > 0;

dacclistVisible = lstDAcc.size() > 0;

mapAccount = new Map<String, Account>();

string n;

for(Account a: lstAccount){

n = string.valueof(a.Original_Company_Name__c).replaceAll( '\\s+', '').toLowerCase();

mapAccount.put(n, a);

}

userName = 'maiz.ansari@outlook.com';

pwd = 'MaizOutllookTTvdM2qm3p9RTkX3gjHfQ8t6';

}

public void fetch()

{

errMsg = 'Some error occurred, please try again';

try

{

//-----------------------------------

// Login via SOAP/XML web service api

//-----------------------------------

HttpRequest request = new HttpRequest();

request.setEndpoint('https://' + LOGIN_DOMAIN + '.salesforce.com/services/Soap/u/22.0');

request.setMethod('POST');

request.setHeader('Content-Type', 'text/xml;charset=UTF-8');

request.setHeader('SOAPAction', '""');

//not escaping username and password because we're setting those variables above

//in other words, this line "trusts" the lines above

//if username and password were sourced elsewhere, they'd need to be escaped below

request.setBody('<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"><Header/><Body><login xmlns="urn:partner.soap.sforce.com"><username>' + userName+ '</username><password>' + pwd+ '</password></login></Body></Envelope>');

Dom.XmlNode resultElmt = (new Http()).send(request).getBodyDocument().getRootElement()

.getChildElement('Body', 'http://schemas.xmlsoap.org/soap/envelope/')

.getChildElement('loginResponse', 'urn:partner.soap.sforce.com')

.getChildElement('result', 'urn:partner.soap.sforce.com');

//-------------------------------

// Grab session id and server url

//--------------------------------

final String SERVER_URL = resultElmt.getChildElement('serverUrl', 'urn:partner.soap.sforce.com') .getText().split('/services')[0];

final String SESSION_ID = resultElmt.getChildElement('sessionId', 'urn:partner.soap.sforce.com') .getText();

//----------------------------------

// Load first 10 accounts via REST API

//---------------------------------

final PageReference theUrl = new PageReference(SERVER_URL + '/services/data/v22.0/query/');

datetime dt = System.now() - 1;

Date myDate = date.newinstance(dT.year(), dT.month(), dT.day());

string dtS = string.valueof(myDate).replace('00:00:00','T01:02:03Z');

string query = 'Select a.Phone, a.Name, a.CreatedBy.FirstName, a.CreatedById,a.Original_Company_Name__c,a.Account_Duplicate_Count__c From Account a where a.createddate >= ' + dtS + 'T01:02:03Z' ;

//order by a.createddate desc';

system.debug('query' + query);

theUrl.getParameters().put('q',query );

request = new HttpRequest();

request.setEndpoint(theUrl.getUrl());

request.setMethod('GET');

request.setHeader('Authorization', 'OAuth ' + SESSION_ID);

String body = (new Http()).send(request).getBody();

JSONParser parser = JSON.createParser(body);

do{

parser.nextToken();

}while(parser.hasCurrentToken() && !'records'.equals(parser.getCurrentName()));

parser.nextToken();

acc = (List<Account>) parser.readValueAs(List<Account>.class);

filterAccounts(acc);

}

catch(Exception e)

{

displayError = 'block';

}

public pageReference importCSVFile(){

try{

List<Account> tmpA = new List<Account>();

List<Account> tmpB = new List<Account>();

mapUAccount = new Map<String, Account>();

for(AccountWrapper aw: lstUAcc){

if(aw.selected){

tmpA.add(aw.account);

}

insert tmpA;

for(AccountWrapper aw: lstDAcc){

if(aw.selected){

tmpB.add(aw.account);

}

system.debug('tmpAdeel: ' + tmpA);

system.debug('tmpBdeel: ' + tmpB);

update tmpB;

}

catch (Exception e){

ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured.');

ApexPages.addMessage(errorMessage);

return null;

}

PageReference nextPage = new PageReference('/apex/AccountFromOrg');

nextPage.setRedirect(true);

return nextPage;

}

public void uploadCSVFile(){

try {

if(csvFileBody != null && csvFileBody.size() > 0){

csvAsString = csvFileBody.toString();

csvFileLines = csvAsString.split('\n');

system.debug('CVS File: '+ csvFileLines.size());

List<Account> lstTmp = new List<Account>();

//List<Contact> lstTmp1 = new List<Contact>();

mapUContact = new Map<String, Contact>();

for(Integer i=1;i<csvFileLines.size();i++){

Account a = new Account();

Contact c = new Contact();

string[] csvRecordData = csvFileLines[i].split(',');

string str = csvRecordData[1].replaceAll( '\\s+', '').toLowerCase();

a.Name = csvRecordData[1];

a.Original_Company_Name__c = csvRecordData[1];

a.Phone = csvRecordData[9];

a.Fax = csvRecordData[10];

a.BillingStreet = csvRecordData[4];

a.BillingPostalCode = csvRecordData[7];

a.BillingCity = csvRecordData[5];

a.BillingCountry = csvRecordData[8];

a.Site = csvRecordData[6];

lstTmp.add(a);

if(string.isNotBlank(csvRecordData[2]) && string.isNotBlank(csvRecordData[3])){

c.LastName = csvRecordData[2];

c.Title = csvRecordData[3];

mapUContact.put(str, c);

}

filterAccounts(lstTmp);

}

else{

ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.WARNING,'Please select valid file to upload.');

ApexPages.addMessage(errorMessage);

}

catch (Exception e){

ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured while reading CSV file.');

ApexPages.addMessage(errorMessage);

}

public class AccountWrapper{

public Account account {get; set;}

public Boolean selected {get; set;}

public AccountWrapper(Account a){

this.account = a;

this.selected = false;

}

public void filterAccounts(List<Account> accounts){

system.debug('Asif: ' + mapAccount);

for(Account a: accounts){

string str = string.valueof(a.Name).replaceAll( '\\s+', '').toLowerCase();

system.debug('key: ' + str);

if(mapAccount.containsKey(str)){

a.Id = mapAccount.get(str).Id ;

//double cnt = mapAccount.get(str).Account_Duplicate_Count__c != null ? double.valueof(mapAccount.get(str).Account_Duplicate_Count__c) : 0;

//a.Account_Duplicate_Count__c = double.valueof(cnt+1);

//system.debug('a.Account_Duplicate_Count__c: ' + a.Account_Duplicate_Count__c);

lstDAcc.add(new AccountWrapper(a));

}

else{

//a.Id = mapAccount.get(str).Id ;

lstUAcc.add(new AccountWrapper(a));

}

system.debug('lstDAccAdeel: ' + lstDAcc);

system.debug('lstUAccAdeel: ' + lstUAcc);

acclistVisible = lstUAcc.size() > 0;

dacclistVisible = lstDAcc.size() > 0;

}

In above code, if you see the yellow highlighted code, you would see that function which is making a call to Org 1 and pass the query which is in red highlighted area. So this way it only fetches only those account which are created in last 24 years. In above code, if you see the green highlighted code, this code is the User Name and password of Org 1, the security token should be append with password. In above light blue highlighted code, it is actually deciding which list is go for Insert or Update in Org 2. After selecting from right and left panel and presses the Import button than Accounts get passed into the Org 2 in smooth manner.

.Net, SQL, Oracle,Sharepoint, Android, BB-CRM, Salesforce.com and MS Dyanamics CRM Tips and tricks

Monday, 28 December 2015

On demad Integration of Salesforce Org to another Salesforce Org

No comments:

Post a Comment

Pages

Followers