Thread: Salesforce PHP MySQL Database Replication Tool

Peter thanks for joining the site! Listen I read your posts but I am a little confused. Are you stating that you have something built that runs on CRON or are you asking if someone actually has this working?

Let me know and I can try and help you from there If it is the fact that you are wondering if someone has this built, I do and it works perfectly. I also have been able to get the getUpdated and getDeleted methods working on scripts. This has realy sped up the whole process of getting our data into MySQL/Oracle


~Mike

Hi Mike,

Thanks for the response, I should have held back until I was in the office as I haven't had the chance to run your code. What we are looking at doing is having a social network for the organisation I work for, storing user details that they can change, having events and keeping track of who is attending what etc. We've implemented it with the php SOAP toolkit, however this is too slow and we can't expect users to wait. This functionality is really easy and fast with MySQL but we would like to make sure that all our organisational information is stored in Salesforce, only using MySQL as a fast interface for the user. Then updating the MySQL data to salesforce and visa versa. I'll give it a spin and get back to you on how it's working out. Thanks for hosting this website and forum, it's invaluable!

Pete

Pete

Okay Pete I appreciate your statement and look forward to reading your results

DOH ! Error

I am bit lost, as I downloaded the script, have it in my server, and trying to access it via my browser, but it fails on calling the

Code:

[Wed Feb 04 11:52:05 2009] [error] [client 212.68.132.106] PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required '/usr/lib/php/modules/soapclient/SforcePartnerClient.php' (include_path='.:') in /var/www/vhosts/optitex.com/httpdocs/ms/salesforce_mysql_build.php on line 27

Now, the file is there, I can VI it, it's chmoded to 755, same is it's parent dir.

Do you have a clue?

I tried moving the html code from the php to an external file, but again, the php fails.

Any idea?

thanks

Hey sorry for the delay in posting and Thanks for joining the site man

That error is showing that you are missing a required file from the Salesforce PHP Toolkit. You have that path set in some of the other examples you have here, so double check that

/usr/lib/php/modules/soapclient/SforcePartnerClient.php





~Mike

Hi Mike,

I'm pleased to sere your site is back online, I was getting a little worried there. I've started hooking this code up with your replication tool (Salesforce MySQL Full Replication Script Process), where people can select which objects they want to update or set them to cron tasks. I've noted the error encountered here: Community - SObjects null field attributes - Perl, PHP, Python & Ruby Development - Force.com Discussion Boards

Any ideas what is going wrong?

Thanks

Pete

Originally Posted by Peter Kemp

Hi Mike,

I'm pleased to sere your site is back online, I was getting a little worried there. I've started hooking this code up with your replication tool (Salesforce MySQL Full Replication Script Process), where people can select which objects they want to update or set them to cron tasks. I've noted the error encountered here: Community - SObjects null field attributes - Perl, PHP, Python & Ruby Development - Force.com Discussion Boards

Any ideas what is going wrong?

Thanks

Pete

Let me take a look at it

Peter were you able to get my tool working on your localhost/server?

Just curious

~Mike


PS: The reason that the site was down is that we moved to a new server with a better processor and operating system, no worries, this is not going anywhere

~Mike

So you are trying to get your data from Salesforce into a MySQL database table? Is that what I am reading on the salesforce forums?


Can I see your scrpit? Is it an example taken from this site?

Sorry for all the questions, maybe we need to chat about this offline

~Mike

Originally Posted by saariko

DOH ! Error

I am bit lost, as I downloaded the script, have it in my server, and trying to access it via my browser, but it fails on calling the

Code:

[Wed Feb 04 11:52:05 2009] [error] [client 212.68.132.106] PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required '/usr/lib/php/modules/soapclient/SforcePartnerClient.php' (include_path='.:') in /var/www/vhosts/optitex.com/httpdocs/ms/salesforce_mysql_build.php on line 27

Now, the file is there, I can VI it, it's chmoded to 755, same is it's parent dir.

Do you have a clue?

I tried moving the html code from the php to an external file, but again, the php fails.

Any idea?

thanks

You need to correct the path to your Salesforce PHP toolkit sir

that is the reason you are getting that error

~Mike

Thanks Mike,

No matter what I did, I just couldn't get the API to work from outside the web directories, so unpleasantly, I have created a symlink to it , and it works. Amazing :-/

I will work on what data I want replicated, but only now I figured that I don't want a replication. All I really want is even a sqldump of Salesforce :-/

ill try to make something similar like it.