Hi,

Im a noob in salesforce and the whole programming and i was asked to create a page that will capture leads from our clients web site, write to mysql and to sales force as well and vice versa. More like database mirroring.

Im not really familiar how it works, i already created a way after a lot of frustrated attempts on how to write into the MySQL and Salesforce but the Salesforce leads keeps on inserting new rows.

Is there a way wherein i can just update them?

I've been reading this forum for a couple of days now and i know a lot of answers are in here. Help me start please.

Thanks a lot..

Thanks for joining and posting on the site, I really appreciate it

So you want to create the following.

You want to create a form that will take the user information from possible leads and store them into MySQL

THEN

you want to create a process that will insert them into Salesforce, into the leads object/table


Do you really need to store them locally in MySQL, or what about just creating a form to process them into Salesforce and let them be the database of record?

You can do either, the MySQL process would have to be done this way:

1. Create a form on your site to take user information.
2. Once the script is ran, store them into MySQL.
3. Once the database insert is completed.
4. Use the same script to insert the data into Salesforce using the CREATE function from the PHPToolKit.

OR

You could use this system that is free and can be downloaded here

If you have to write a form and capture them it can be done quite easily

Do you know PHP? If you do not, it may be a little more involved, but with help from here, you can do it.

Let me know how you want to proceed

~Mike

Thanks Mike.

I know a little PHP since i started this stuff.

I already can write to our MySQL Db and to Salesforce using the auto-generated web-to-lead forms from Salesforce. The problem now is, it does not update the existing leads instead inserts new rows which duplicates the lead data.

I have no idea how to solve this.

By the way, is there a way wherein if the Salesforce user updates the lead data on the salesforce console that it could also update our local Db? I don't know if this could be done though.


I really appreciate your help.

More power.