Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
16

Questions
9

Replies

0 replies

Connecting To MySQL using Sales force

Hi All

I need to connect to MySQL with Sales force. Means Using Apex Class i need to connect ,

not with Web Services.

Any one knows please help me

Thanks

Anu...

Anumca
July 19, 2011
Like
0

3 replies

integrete magento with salesforce using API

Hi All

I need to integrate magento with salesforce using API. I dont know about web services. can u please help me how to write that webservice class and how to integrate to magento.

please help me

Thanks & Regards

Anu.

Anumca
July 13, 2011
Like
0

0 replies

Export the Contacts as Google Spread sheet

Hi All I need to display the contacts as google spread sheet. For this I wrote the page .

My page is

<apex:page standardController="contact">
<script type="text/javascript" src="/js/functions.js"></script>
<script src="/soap/ajax/10.0/connection.js"></script>
<script type="text/javascript">
if (!top) var top={};
top.retURL = "/003";
var g; 
function init() {
  sforce.debug.println = log;   
  sforce.debug.trace = false;

  g = new GoogleSpreadsheet();
  g.authSubLogin(top);  
    
  var query = 'Select FirstName, LastName, Phone From Contact Limit 5';
  var queryResult = sforce.connection.query(query, queryCallback );
}

function queryCallback(queryResult) {
  var cellFeedUrl = getCellFeedUrl();
  var contacts = queryResult.getArray('records');
  for (var i=0; i<contacts.length; i++) {
    g.updateCell(cellFeedUrl, i+1, 1, contacts[i].LastName + ", " + contacts[i].FirstName);
    g.updateCell(cellFeedUrl, i+1, 2, contacts[i].Phone);
  }

  // Return to the contacts page
  jumpback();       
}

function getCellFeedUrl() {
  var SPREADSHEET_TITLE = 'Salesforce.com Contacts';
  var WORKSHEET_REL = 'http://schemas.google.com/spreadsheets/2006#worksheetsfeed';
  var CELLSFEED_REL = 'http://schemas.google.com/spreadsheets/2006#cellsfeed';

  // Query to find the spreadheet called "Salesforce.com Contacts"  
  var spreadsheets = g.getFeed(g.feeds + '/spreadsheets/private/full'); 
  var entries = g.getEntryList(spreadsheets);
  for (var e in entries) {
    if (g.getTitle(entries[e]) == SPREADSHEET_TITLE) {
      var worksheetsFeedUrl = g.link(entries[e],WORKSHEET_REL);
      var worksheets = g.getFeed(worksheetsFeedUrl);
      var worksheetEntries = g.getEntryList(worksheets);
      return g.link(worksheetEntries[0], CELLSFEED_REL);
    }
  }
}

function log(string) {
  var doc = document.getElementById("log-output");
  doc.innerHTML += string + '<br>';
}

function jumpback() {
  retURL = top.retURL; // one more override 
  if ( window.opener && typeof(window.opener) == 'object' ) { // deal with popup
    setTimeout("window.close();",100); 
    window.opener.location.href = retURL;
  } else { // normal parent close
    window.parent.parent.location.href = retURL; 
  }
}
</script>
  <!--{!INCLUDE($SControl.gspreadsheet_snippet)}-->

<body onload="init();">

  
  <img src="/img/icon/home32.png" height="64" width="64" />
  <img src="/img/waiting_dots.gif" alt="Please wait..." title="Please wait..." height="25" width="196" />
  <img src="http://docs.google.com/images/doclist/logo_docs.gif" />
  <p><h3>Exporting contacts to Google Spreadsheets, please wait...</h3></p>



</body>
</apex:page>

This code is running. I am getting the contacts in Eclipse.but the contacts are not visible in Google spread sheet. How can I handle this.Please help me

Thanku

Anu

Anumca
July 08, 2011
Like
0

2 replies

Export the contacts using google Spreadsheet

Hi All

I need to export the contacts as google spread sheet. for that I wrote the VF page. but it is not working.

my page is

<apex:page standardController="contact"><script type="text/javascript" src="/js/functions.js"></script><script src="/soap/ajax/10.0/connection.js"></script><script type="text/javascript">if (!top) var top={};top.retURL = "/003";var g; function init() { sforce.debug.println = log;     sforce.debug.trace = false;
g = new GoogleSpreadsheet(); g.authSubLogin(top);        var query = 'Select FirstName, LastName, Phone From Contact Limit 5'; var queryResult = sforce.connection.query(query, queryCallback );}
function queryCallback(queryResult) { var cellFeedUrl = getCellFeedUrl(); var contacts = queryResult.getArray('records'); for (var i=0; i<contacts.length; i++) { g.updateCell(cellFeedUrl, i+1, 1, contacts[i].LastName + ", " + contacts[i].FirstName); g.updateCell(cellFeedUrl, i+1, 2, contacts[i].Phone); }
// Return to the contacts page jumpback();   }
function getCellFeedUrl() { var SPREADSHEET_TITLE = 'Salesforce.com Contacts'; var WORKSHEET_REL = 'http://schemas.google.com/spreadsheets/2006#worksheetsfeed'; var CELLSFEED_REL = 'http://schemas.google.com/spreadsheets/2006#cellsfeed';
// Query to find the spreadheet called "Salesforce.com Contacts"    var spreadsheets = g.getFeed(g.feeds + '/spreadsheets/private/full');   var entries = g.getEntryList(spreadsheets); for (var e in entries) { if (g.getTitle(entries[e]) == SPREADSHEET_TITLE) { var worksheetsFeedUrl = g.link(entries[e],WORKSHEET_REL); var worksheets = g.getFeed(worksheetsFeedUrl); var worksheetEntries = g.getEntryList(worksheets); return g.link(worksheetEntries[0], CELLSFEED_REL); } }}
function log(string) { var doc = document.getElementById("log-output"); doc.innerHTML += string + '<br>';}
function jumpback() { retURL = top.retURL; // one more override   if ( window.opener && typeof(window.opener) == 'object' ) { // deal with popup setTimeout("window.close();",100);   window.opener.location.href = retURL; } else { // normal parent close window.parent.parent.location.href = retURL;   }}</script> 
<body onload="init();">
    <img src="/img/icon/home32.png" height="64" width="64" /> <img src="/img/waiting_dots.gif" alt="Please wait..." title="Please wait..." height="25" width="196" /> <img src="http://docs.google.com/images/doclist/logo_docs.gif" /> <p><h3>Exporting contacts to Google Spreadsheets, please wait...</h3></p>

</body></apex:page>

Please help me.

Thanks

Anu.....

Anumca
July 07, 2011
Like
0

0 replies

how to connect to sugar CRM using Sales force API

I need to connect to Sugar CRM using Salesforce API.

Please help me

Thanks & Regards

Anu......

Anumca
July 05, 2011
Like
0

1 replies

How to display the Particular Related list under the Related list of the object In Tabbed View

Hi All

I need to display the Perticular Related list under the Related list in Tabbed view of the Object.

For Example.

I have 2 custom objects Units & Issues

I need to display the Units

Issues ---->( I have completed up to this)

Activity History

I need to display the ActivityHistory of Issues object in Units object VF page.

My Page is

<apex:page standardController="Units__c" showHeader="true" tabStyle="Units__c">

<style>

.activeTab {background-color: #236FBD; color:black;background-image:white}.inactiveTab { background-color: white; color:black;background-image:none}<

/style>

<apex:tabPanel switchType="client" selectedTab="tabdetails" id="UnitTabPanel" tabClass="activeTab" inactiveTabClass="inactiveTab">

<apex:tab label="Details" name="AccDetails" id="tabdetails">

<apex:outputPanel style="background-Color:white">

<apex:detail relatedList="false" title="true"/>

</apex:outputPanel>

</apex:tab>

<apex:tab label="Issues" name="Issues" id="tabIssues">

<apex:outputPanel style="background-Color:white">

<apex:relatedList subject="{!Units__c}" list="Issue__r" />

</apex:outputPanel>

</apex:tab>

</apex:tabPanel>

</apex:page>

Please help me Urgent

Thanks & Regards

Anu...

Anumca
June 27, 2011
Like
0

SOLVED

10 replies

how to export the data from customer portal

Hi All

I need to export the data from Customer portal

please help me....

Thanks & Regards

Anu.....

Anumca
June 22, 2011
Like
0

1 replies

Direct login to the gmail or any using web tab

Hi All

I created the web tab for direct login to the gmail,means I used username & password in the URL. I used the URL like

https://www.google.com/accounts/ServiceLoginAuth?continue=http://www.google.com/ig&service=mail&Email=mailid&Password=pwd&null=Sign+in

but it is diaplaying only username. how to do this.

please help me.....

Thanks & Regards

Anu..........

Anumca
June 18, 2011
Like
0

8 replies

How to display the LOOK UP in VF page

Hi All

I need to display the LOOK UP in VF page without using Sales force Configuration.Its urgent

Please help me

Thanks & Regards

Anu...

Anumca
June 16, 2011
Like
0

1 replies

How can we get the error message when Displaying the Year & Month in VF page

Hi All

I had displayed the dtae in a text box in VF page,But I need to dispaly the Error message when we enter the other than date in the text box.

The format should be while entering into the text box is year & month only. this can be do using VF page,not a validation.

please help me..

Thanks

Anu....

Anumca
June 15, 2011
Like
0

2 replies

Displaying the date picker without using Input Field

Hi All..

I need to display the Date Picker in VF page without using Input field.

Please help me

Thanks & regards

Anu...

Anumca
June 14, 2011
Like
0

3 replies

Displaying First & Last Dates of a month In VF page

Hi All

I want to display the First & last dates of given month in VF page using Controller

forexample: If we given 14/6/2011 date,then it should be display the first date of the month & end date of the month.

Please help me.

Thanks & Regards

Anu

Anumca
June 14, 2011
Like
0

SOLVED

1 replies

How to use the Java Apps in Sales force

Hi All

I have to use the java apps in Sales force. Could you please tell me how to use & where to use in Sales force account.

I Know littile bit, this can be done by using VMForce In Enter Prise Edition.But I dont Know Clearly.

Please help me....

Thanks & Regards

Anu

Anumca
May 28, 2011
Like
0

0 replies

Displaying Hierarchy of a custom Object

Hi All

I have facing the problem when I am displaying the hierarchy of a custom object.

my requirement is:

If I am having the parent record parent1,under this we have the child records.

I need to display parent1 under this ineed to display

child1 if it is having the childs again, we need to display

child2

for this i wrote the code

controller:

public class udahierarchy

{

UDA_Catalog__c udadata;

public set<id> tset=new set<id>();

public set<id> t1set=new set<id>();

public boolean showchild{set;get;}

public boolean showchild1{set;get;}

public boolean showparent{set;get;}

public list <UDA_Catalog__c> ulist=new list<UDA_Catalog__c>();

public list<UDA_Catalog__c> tlist=new list<UDA_Catalog__c>();

public list<UDA_Catalog__c> t1list=new list<UDA_Catalog__c>();

public udahierarchy()

{

ulist.clear();

showchild1=true;

showchild=true;

showparent=true;

for(UDA_Catalog__c u:[select id,name,Lookup__c,UDA_Catalog__c,UDA_Catalog__r.id from UDA_Catalog__c where UDA_Catalog__r.id =: null])

{

ulist.add(u);

}

public list<UDA_Catalog__c> getdata()

{

return ulist;

}

public void udadata1()

{

tlist.clear();

showchild1=true;

showchild=true;

showparent=true;

id i=apexpages.currentpage().getparameters().get('oid');

for(UDA_Catalog__c uu:[select id from UDA_Catalog__c where id=:i])

{

tset.add(uu.id);

}

for(UDA_Catalog__c t:[select name from UDA_Catalog__c where UDA_Catalog__c in:tset])

{

tlist.add(t);

}

public list<UDA_Catalog__c> getdata1()

{

return tlist;

}

public void udadata2()

{

t1list.clear();

showchild1=true;

showchild=true;

showparent=true;

id i=apexpages.currentpage().getparameters().get('kid');

for(UDA_Catalog__c u1:[select id from UDA_Catalog__c where id=:i])

{

t1set.add(u1.id);

}

for(UDA_Catalog__c t1:[select name from UDA_Catalog__c where UDA_Catalog__c in:t1set])

{

t1list.add(t1);

}

public list<UDA_Catalog__c> getdata2()

{

return t1list;

}

page

<apex:page controller="udahierarchy" showheader="false">

<apex:form >

<apex:pageBlock >

<apex:pageBlockTable value="{!data}" var="k" rendered="{!showparent}">

<apex:column headerValue="Parent UDA Catalog ID">

<apex:commandLink value=" {!k.name}" action="{!udadata1}">

<apex:param name="oid" value="{!k.id}"/>

</apex:commandLink>

</apex:column>

</apex:pageBlockTable>

<apex:pageBlockTable value="{!data1}" var="c" rendered="{!showchild}">

<apex:column headerValue="UDA Catalog Child">

<apex:commandLink value=" {!c.name}" action="{!udadata2}">

<apex:param name="kid" value="{!c.id}"/>

</apex:commandLink>

</apex:column>

</apex:pageBlockTable>

<apex:pageBlockTable value="{!data2}" var="c1" rendered="{!showchild1}">

<apex:column headerValue="UDA Catalog Childs" value="{!c1.name}"/>

</apex:pageBlockTable>

</apex:pageBlock>

</apex:form>

</apex:page>

This code is working

But i need design part like this

when we click on the parent ,it will display the child,& click on child it will display the childs. without closing the parent window, means with in the parent only we have to diplay the childs(i.e without having too many pageblock tables)

pls help me

Thanks & Regards

Anu....