Hi all,

          Is it possible to insert the fields from salesforce to mysql.if so can anyone guide me with the possibilities.

Regards,

Nalini.s

Hi,

We have a custom object that records the time that an event starts.  On creating this event it fires a SOAP packet to an external webservice.  This webservice treats the date as a string and doesn't perform any logic on it.  However, when the date reaches the external webservice the date is an hour out, the date was put into Salesforce as a BST date and appears to be exported as a GMT date.  I have checked the settings in our salesforce and it is set to BST Europe/London.  On exporting the users from our salesforce account their details match the accounts timezone. TIMEZONESIDKEY = 'Europe/London'.  there is no logic firing on the custom object side.  Any ideas what is going on here and how to fix it?

Thanks

Pete

Hi,

We are working with a developer who has set up an external webservice that is called by work flow.  When we fired the workflow on another sandbox it worked fine, but now when we fire it, it is failing.  We would like to look at the SOAP error returned but the Outbound Messaging Delivery Status screen truncates the error to:

 I've added a log to the account that fires the workflow but it doesn't pick up on the returned message.  Any ideas how I can find out what the "Could no l....." actually means?

I can't seem to find Setup | Monitoring | Outbound Message Notifications. when following the help guide here:

https://cs1.salesforce.com/help/doc/user_ed.jsp?section=help&target=workflow_outbound_messages_notifications.htm&loc=help&hash=topic-title

Thanks

Pete

I've written and tested a salesforce to MySQL backup tool in php (https://sourceforge.net/projects/unforced/).  I did all the testing in the sandbox and would now like to switch over to our live org.  I've changed the username and password and even refreshed the partner wsdl though it won't connect to the live org with security token or without.  Any idea what I'm doing wrong?  I get the following error:

SoapFault Object
(
[message:protected] => INVALID_LOGIN: Invalid username or password or locked out.
[string:private] =>
[code:protected] => 0
[file:protected] => C:\xampp\htdocs\test\salesforcebu\includes\soapclient\SforceBaseClient.php
[line:protected] => 155
[trace:private] => Array

 EDIT:

I notice that the WSDL I am getting from the live org says api version 15.0whilst the toolkit is only 13.0.  Also I have changed line

<soap:address location="https://www.salesforce.com/services/Soap/u/15.0"/>

 To point to the cs2 or live depnding on which login I use.  for the test accounts it doesn't matter, but for the live account, neither works.
I have checked my user rights on the live server and I am a System Administrator with API enabled == True.  Is there a setting on the live org that I am missing?

Thanks

Pete

Hi,

It seems that SF to mySQL replicators are the flavour of the month.  Having used Mike's code to build my own and back up our entire Salesforce instance, I was wondering if there was a way to extract the relationships between objects?  Getting secondary keys and enforcing the relationships when you build the mysql tables would allow for a proper copy of salesforce.  I was hoping there would be a neat way to do this with the partner wsdl.  Also it would be good to get the the optional values for fields such as salutation = Mr. Mrs. Ms. Miss. Dr. ... directly from the database so when you are editing your mysql you are under the same restrictions as you would be on salesforce.

I suppose what I'm asking for is access to the Salesforce database schema using php.

I can kind of  see how this could be achieved through the enterprise wsdl, but haven't played with that yet.

Any help would be great.

Thanks

Pete

 Hi,

I'm trying to replicate data from Salesforce to a local MySQL database, I can pull the salesforce objects successfully and they each look like this:

[0]=> object(SObject)#11 (3) { ["type"]=> string(7) "Account" ["fields"]=> object(stdClass)#213 (4) { ["IsDeleted"]=> string(5) "false" ["MasterRecordId"]=> string(0) "" ["Name"]=> string(4) "Acme" ["Type"]=> string(8) "Prospect" }

["Id"]=> string(18) "0012000000162QEAAY" }

You can clearly see that there is a 'fields' object inside the sObject.  However, when I create an sObject variable to deal with thisI can no longer access the fields

for ($i = 0; $i < $record_count; $i++) //foreach ($records as $r) { $r = new SObject($records[$i]); $pass_this['id'] = $r->Id; foreach ($r->fields as $key => $value) { $pass_this[$key] = addslashes($r->fields->$key); }

 You can see that the fields obecjt is now empty?! It cannot parse the foreach statement and it gives the following error

object(SObject)#211 (3) { ["type"]=> string(7) "Account" ["fields"]=> NULL ["Id"]=> string(1) "0" } Warning: Invalid argument supplied for foreach()

 I am using version 13 of the php toolkit.  Any idea where I am going wrong?

Thanks

Pete

I have been following the cookbook and would like to add fields to edit objects on my visual force page.  I have used the following code:

<apex:pageBlockSectionItem > <apex:outputLabel value="Name"/> <apex:inputField value="{!account.name}"/> </apex:pageBlockSectionItem>

 and the apex:

public Account getaccount() { return [select id, salutation, name from Account where id = :System.currentPageReference().getParameters().get('id')]; }

When referencing account.name with inputField, you must select isPersonAccount in your SOQL query

 I have tried using SOQL that selects isPersonAccount = true but this doesn't seem to fix the proble, what is the error asking for?

Thanks

Pete

I have been following the cookbook and want to display a list using visualforce of all the accounts that are applying and awaiting 2 screenings. I have tested the code using apex explorer and this apex returns a list of sobjects. But when I try to move through them using visual force I get the following error. How can I rewrite this code to display all the names?

<apex:pageBlock title="Select a Candidate">
<apex:dataTable value="{!account}" var="u" cellPadding="4" border="1">
<apex:column >{!u.name}</apex:column>
<apex:column >{!u.id}</apex:column>
</apex:dataTable>
</apex:pageBlock>

public Account getaccount() {
return [select id, name from Account where Recruitment_status__pc = 'Applying' AND Application_sub_stage__pc = 'Awaiting 2 screenings'];
}

Hi,

We have a custom object that records the time that an event starts.  On creating this event it fires a SOAP packet to an external webservice.  This webservice treats the date as a string and doesn't perform any logic on it.  However, when the date reaches the external webservice the date is an hour out, the date was put into Salesforce as a BST date and appears to be exported as a GMT date.  I have checked the settings in our salesforce and it is set to BST Europe/London.  On exporting the users from our salesforce account their details match the accounts timezone. TIMEZONESIDKEY = 'Europe/London'.  there is no logic firing on the custom object side.  Any ideas what is going on here and how to fix it?

Thanks

Pete

Hi,

We are working with a developer who has set up an external webservice that is called by work flow.  When we fired the workflow on another sandbox it worked fine, but now when we fire it, it is failing.  We would like to look at the SOAP error returned but the Outbound Messaging Delivery Status screen truncates the error to:

 I've added a log to the account that fires the workflow but it doesn't pick up on the returned message.  Any ideas how I can find out what the "Could no l....." actually means?

I can't seem to find Setup | Monitoring | Outbound Message Notifications. when following the help guide here:

https://cs1.salesforce.com/help/doc/user_ed.jsp?section=help&target=workflow_outbound_messages_notifications.htm&loc=help&hash=topic-title

Thanks

Pete

I've written and tested a salesforce to MySQL backup tool in php (https://sourceforge.net/projects/unforced/).  I did all the testing in the sandbox and would now like to switch over to our live org.  I've changed the username and password and even refreshed the partner wsdl though it won't connect to the live org with security token or without.  Any idea what I'm doing wrong?  I get the following error:

SoapFault Object
(
[message:protected] => INVALID_LOGIN: Invalid username or password or locked out.
[string:private] =>
[code:protected] => 0
[file:protected] => C:\xampp\htdocs\test\salesforcebu\includes\soapclient\SforceBaseClient.php
[line:protected] => 155
[trace:private] => Array

 EDIT:

I notice that the WSDL I am getting from the live org says api version 15.0whilst the toolkit is only 13.0.  Also I have changed line

<soap:address location="https://www.salesforce.com/services/Soap/u/15.0"/>

 To point to the cs2 or live depnding on which login I use.  for the test accounts it doesn't matter, but for the live account, neither works.
I have checked my user rights on the live server and I am a System Administrator with API enabled == True.  Is there a setting on the live org that I am missing?

Thanks

Pete

Hi,

It seems that SF to mySQL replicators are the flavour of the month.  Having used Mike's code to build my own and back up our entire Salesforce instance, I was wondering if there was a way to extract the relationships between objects?  Getting secondary keys and enforcing the relationships when you build the mysql tables would allow for a proper copy of salesforce.  I was hoping there would be a neat way to do this with the partner wsdl.  Also it would be good to get the the optional values for fields such as salutation = Mr. Mrs. Ms. Miss. Dr. ... directly from the database so when you are editing your mysql you are under the same restrictions as you would be on salesforce.

I suppose what I'm asking for is access to the Salesforce database schema using php.

I can kind of  see how this could be achieved through the enterprise wsdl, but haven't played with that yet.

Any help would be great.

Thanks

Pete

Hi all,

          Is it possible to insert the fields from salesforce to mysql.if so can anyone guide me with the possibilities.

Regards,

Nalini.s

 Hi,

I'm trying to replicate data from Salesforce to a local MySQL database, I can pull the salesforce objects successfully and they each look like this:

[0]=> object(SObject)#11 (3) { ["type"]=> string(7) "Account" ["fields"]=> object(stdClass)#213 (4) { ["IsDeleted"]=> string(5) "false" ["MasterRecordId"]=> string(0) "" ["Name"]=> string(4) "Acme" ["Type"]=> string(8) "Prospect" }

["Id"]=> string(18) "0012000000162QEAAY" }

You can clearly see that there is a 'fields' object inside the sObject.  However, when I create an sObject variable to deal with thisI can no longer access the fields

for ($i = 0; $i < $record_count; $i++) //foreach ($records as $r) { $r = new SObject($records[$i]); $pass_this['id'] = $r->Id; foreach ($r->fields as $key => $value) { $pass_this[$key] = addslashes($r->fields->$key); }

 You can see that the fields obecjt is now empty?! It cannot parse the foreach statement and it gives the following error

object(SObject)#211 (3) { ["type"]=> string(7) "Account" ["fields"]=> NULL ["Id"]=> string(1) "0" } Warning: Invalid argument supplied for foreach()

 I am using version 13 of the php toolkit.  Any idea where I am going wrong?

Thanks

Pete

I have been following the cookbook and would like to add fields to edit objects on my visual force page.  I have used the following code:

<apex:pageBlockSectionItem > <apex:outputLabel value="Name"/> <apex:inputField value="{!account.name}"/> </apex:pageBlockSectionItem>

 and the apex:

public Account getaccount() { return [select id, salutation, name from Account where id = :System.currentPageReference().getParameters().get('id')]; }

When referencing account.name with inputField, you must select isPersonAccount in your SOQL query

 I have tried using SOQL that selects isPersonAccount = true but this doesn't seem to fix the proble, what is the error asking for?

Thanks

Pete

I have been following the cookbook and want to display a list using visualforce of all the accounts that are applying and awaiting 2 screenings. I have tested the code using apex explorer and this apex returns a list of sobjects. But when I try to move through them using visual force I get the following error. How can I rewrite this code to display all the names?

<apex:pageBlock title="Select a Candidate">
<apex:dataTable value="{!account}" var="u" cellPadding="4" border="1">
<apex:column >{!u.name}</apex:column>
<apex:column >{!u.id}</apex:column>
</apex:dataTable>
</apex:pageBlock>

public Account getaccount() {
return [select id, name from Account where Recruitment_status__pc = 'Applying' AND Application_sub_stage__pc = 'Awaiting 2 screenings'];
}