• gdk
  • NEWBIE
  • 25 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 2
    Likes Received
  • 0
    Likes Given
  • 15
    Questions
  • 9
    Replies
Hello all,
I want to integrate Magento(e-Commerce) Orders with Salesforce for this i have a public endpoint url, but i need to authenticate the magento system in salesforce, i have created user in magento & i have username, api key how to authenticate in salesforce and how to get orders in salesforce programatically step by step process,
please any one help.


Thanks,
  • July 03, 2018
  • Like
  • 0
Hi All,

User-added image

I need to uplaod more than 100 contacts and Accounts like the above CSV file format,
here 2 accounts and 13 contacts iam uploading and also duplicate not allowed for Contacts as well as Account
this is working fine when iam uploading 30 records,
But i am getting following error while uploading more than 30 records

System.LimitException: Too many SOQL queries: 101

below the code i used:
-------------------------------
public PageReference UploadAction() {
          Count=0;
    contactInsert.clear();
    dcontact.clear();
 
 
  if(csvFile!=null)
        {
           nameFile=csvFile.toString();          
               //Read the CSV Rows using split method
            filelines = nameFile.split('\n');        
         }
    for (Integer i=1;i<filelines.size();i++)
            {
                String[] inputvalues = new String[]{};
                  inputvalues = filelines[i].split(',');   
                 Contact cnt= new Contact();
                 Account Ac=new Account();
                  List<Account> al= new List<Account>();
                 cnt.FirstName= inputvalues[0];
                 cnt.LastName= inputvalues[1];
                 if(String.isNotBlank(inputvalues[2]))
                 {
                 Ac.Name=inputvalues[2];
                al=[Select id,Name from Account Where name=:Ac.Name];                 
                 if(al.size()==0)
                 {
                 insert Ac;
                 }                 
                 List<Account> Acl= new List<Account>();
                 Acl=[Select id, name from Account Where name=:Ac.Name];
                 cnt.AccountId=Acl[0].id;     
                 
                }
                
                cnt.Email= inputvalues[3];
                
                cnt.Phone= inputvalues[4];    
                List<contact> cl= new List<contact>();
                cl=[select id, email from contact where email=:inputvalues[3] and account.name=:inputvalues[2]];
               
                if(cl.size()==0)
                {
                count++;
                 contactInsert.add(cnt);
        
                 }
                 else{
              
                 cnt.AccountName__C=  inputvalues[2];
          
       
                 dcontact.add(cnt);
                 
                 
       
                 }
            }    
            
            if(count!=0)
            {
            System.Debug('-------------count value----'+ Count);
    insert contactInsert;
    count=0;
    
    }else{
 
    }
     
        return null;
    }


Thanks...!
  • April 29, 2015
  • Like
  • 0
Hi All, 
           How to Restrict Home Tab for My Users and All Tabs (+) , Please Reply 


Thanks in Advance
  

 
  • October 28, 2014
  • Like
  • 0
Hi All ,
            I have a Requirement to Download the Visualforce Page as PDF When click on CommandButton


Here I have 2 - Visualforce Pages i have placed a Command Button in One of the Visualforce page when i click on this button the other visualforce page will Download as a PDF without pageredirection


Plese give me a Solution and Thanks in advance...
  • September 09, 2014
  • Like
  • 0
Hi All,
   
          How can we import social contacts like Facebook, Twitter, Gmail, LinkedIn ... Into Salesforce





Thanks in Advance !!
  • July 10, 2014
  • Like
  • 0
Iam getting the following error while sending the mail, how can i overcome this

Error: Invalid Data.
Review all error messages below to correct your data.
You have exceeded your daily limit for emails.
  • June 02, 2014
  • Like
  • 0
Hi
     How to lock all Opportuniies Fields immediately upon close (either closed won or closed lost) for all users
      except the opportunity owner and the administrator



Thanks in Advance.
  • May 26, 2014
  • Like
  • 0
Hi,
     I have a requirement, I need to create custom Link with the name " View Hierarchy " , when i click this link in an Account's deatial layout
    which will display Parent Account  |_
                                                                      Child Account |_
                                                                                                    Opportunties


Thanks in advance.
  • May 26, 2014
  • Like
  • 1
Hi Friends,
                     How to Create Visualforce emai template for different language People to send


Thanks in advance
  • May 17, 2014
  • Like
  • 0
  • April 15, 2014
  • Like
  • 1
hi,
iam define a lookup relation between two objects A__c(parent) and B__c(child), and displayed list of records of B in visulaforce page by using EnhancedList, and i placed a lookup field of B object under EnhancedList and i palced a button with value to Update.

i want to when i select a value from lookup field  and click on update button , the master field of EnhancedList will be get updated

pls help 
  • January 30, 2014
  • Like
  • 0

Hi,

 

Error: EnterMarks Compile Error: Constructor not defined: [System.SelectOption].<Constructor>(Decimal, Decimal) at line 11 column 16

 

public List<selectOption> lstR = new List<selectOption>();
    public List<selectOption> getNumber() {
        lstR.add(new selectOption('---None---','---None---'));
    for(Student_Information__c objR:[select Roll_Number__c from Student_Information__c ]){
      lstR.add(new selectOption(objR.Roll_Number__c,objR.Roll_Number__c));
      }
        return lstR;
    }

 

Please help.

  • October 04, 2013
  • Like
  • 0

hi,

 I created 2 custom objects with lookuprelation,

i placed a picklist on vfpage and i placed related field values in that picklist,

i want to display table when i select a value from picklist , plese help 

  • September 25, 2013
  • Like
  • 0

Hi,

  I created one Picklist on vf-page and I added all Field names of an object into that picklist, when I select one field name from that Picklist i want to dispaly " Field Name, Field Label, Field Type, and Field Length " in PageBlockTable format with in the page itself.

  • October 18, 2012
  • Like
  • 0
Hi,
     I have a requirement, I need to create custom Link with the name " View Hierarchy " , when i click this link in an Account's deatial layout
    which will display Parent Account  |_
                                                                      Child Account |_
                                                                                                    Opportunties


Thanks in advance.
  • May 26, 2014
  • Like
  • 1
  • April 15, 2014
  • Like
  • 1
Hi All,

User-added image

I need to uplaod more than 100 contacts and Accounts like the above CSV file format,
here 2 accounts and 13 contacts iam uploading and also duplicate not allowed for Contacts as well as Account
this is working fine when iam uploading 30 records,
But i am getting following error while uploading more than 30 records

System.LimitException: Too many SOQL queries: 101

below the code i used:
-------------------------------
public PageReference UploadAction() {
          Count=0;
    contactInsert.clear();
    dcontact.clear();
 
 
  if(csvFile!=null)
        {
           nameFile=csvFile.toString();          
               //Read the CSV Rows using split method
            filelines = nameFile.split('\n');        
         }
    for (Integer i=1;i<filelines.size();i++)
            {
                String[] inputvalues = new String[]{};
                  inputvalues = filelines[i].split(',');   
                 Contact cnt= new Contact();
                 Account Ac=new Account();
                  List<Account> al= new List<Account>();
                 cnt.FirstName= inputvalues[0];
                 cnt.LastName= inputvalues[1];
                 if(String.isNotBlank(inputvalues[2]))
                 {
                 Ac.Name=inputvalues[2];
                al=[Select id,Name from Account Where name=:Ac.Name];                 
                 if(al.size()==0)
                 {
                 insert Ac;
                 }                 
                 List<Account> Acl= new List<Account>();
                 Acl=[Select id, name from Account Where name=:Ac.Name];
                 cnt.AccountId=Acl[0].id;     
                 
                }
                
                cnt.Email= inputvalues[3];
                
                cnt.Phone= inputvalues[4];    
                List<contact> cl= new List<contact>();
                cl=[select id, email from contact where email=:inputvalues[3] and account.name=:inputvalues[2]];
               
                if(cl.size()==0)
                {
                count++;
                 contactInsert.add(cnt);
        
                 }
                 else{
              
                 cnt.AccountName__C=  inputvalues[2];
          
       
                 dcontact.add(cnt);
                 
                 
       
                 }
            }    
            
            if(count!=0)
            {
            System.Debug('-------------count value----'+ Count);
    insert contactInsert;
    count=0;
    
    }else{
 
    }
     
        return null;
    }


Thanks...!
  • April 29, 2015
  • Like
  • 0
Hi All, 
           How to Restrict Home Tab for My Users and All Tabs (+) , Please Reply 


Thanks in Advance
  

 
  • October 28, 2014
  • Like
  • 0
Hi All,
   
          How can we import social contacts like Facebook, Twitter, Gmail, LinkedIn ... Into Salesforce





Thanks in Advance !!
  • July 10, 2014
  • Like
  • 0
Iam getting the following error while sending the mail, how can i overcome this

Error: Invalid Data.
Review all error messages below to correct your data.
You have exceeded your daily limit for emails.
  • June 02, 2014
  • Like
  • 0
Hi
     How to lock all Opportuniies Fields immediately upon close (either closed won or closed lost) for all users
      except the opportunity owner and the administrator



Thanks in Advance.
  • May 26, 2014
  • Like
  • 0
  • April 15, 2014
  • Like
  • 1

Hi,

 

Error: EnterMarks Compile Error: Constructor not defined: [System.SelectOption].<Constructor>(Decimal, Decimal) at line 11 column 16

 

public List<selectOption> lstR = new List<selectOption>();
    public List<selectOption> getNumber() {
        lstR.add(new selectOption('---None---','---None---'));
    for(Student_Information__c objR:[select Roll_Number__c from Student_Information__c ]){
      lstR.add(new selectOption(objR.Roll_Number__c,objR.Roll_Number__c));
      }
        return lstR;
    }

 

Please help.

  • October 04, 2013
  • Like
  • 0