Quote:
Originally Posted by ejayqueja
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:
- Create a form on your site to take user information.
- Once the script is ran, store them into MySQL.
- Once the database insert is completed.
- 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