Please help

nilan · #1 04-17-2008, 05:34 AM

We have lead details in a mysql db and we need to upload them in to Salesforce regularly.
The problem we are facing is that we have professional edition of Salesforce account which doesn’t have the SOAP API access.
Is there any alternative way to bulk upload lead details to Salesforce without using SOAP API?

Thanks

mike · #2 04-17-2008, 06:48 AM

The only thing that I can think of is this:

Login to your instance of salesforce
Then go to Setup
Then go to Administration Setup
Then go to Data Management

From there see if there is a link to Import leads ( will need to be a .csv file)

Other than that that I am aware of, there is no other way

nilan · #3 04-17-2008, 11:18 PM

Thank you very much for your quick response

Need another advice from you, sorry for disturbing
Do you think that we can use apex code to connect to our db and pull leads to Salesforce? Because we need to automate this process as much as possible.

Thanks

mike · #4 04-18-2008, 06:46 AM

not that I know of Nilan. I believe that the APEX code still uses the API to connect to salesforce. Honestly I believe that your hands are tied

BUT

I maybe wrong, I just do not know that much about the professional addition of Salesforce, but I think that I am right

~Mike

nilan · #5 04-20-2008, 11:04 PM

Thank you very much for your advice. I will do some R&D regarding this with little hope

mike · #6 04-21-2008, 08:08 AM

I am sorry that could not be more help. I can see your frustration and I am sorry that salesforce does not allow the use of the API in their professional edition.
Please do not hesitate to ask more questions here. also please do share your experiences if you would so!

nilan · #7 04-21-2008, 11:07 PM

Thanks for your consideration regarding this issue

Currently I am trying to solve this using web to lead method. I think that we can query leads from our db and post them to Salesforce using PHP functions for posting data.

mike · #8 04-22-2008, 06:46 AM

Nilan as long as you do not have the professional version of Salesforce (no API) then you can and will be able to load you leads, either updates or inserts to your organization/instance of SForce without a problem.

As I have stated in the past, all of my company's update, insert, delete, and upsert processes run are processed by php. Not one has ever failed

Hope that helps

~Mike

#9 04-28-2008, 01:28 PM

Nilan:

You can definitely use Web to lead. I wrote some code that captures a web to lead record, does a spam check and then uses cURL to post that data to web to lead. It's all in PHP. You only care about the posting to web to lead part.

See it at arrowpointe - Google Code