What we need to do is capture the raw XML coming in from the soap message. I have a friend of mine, whom I have asked to take a Loki at this thread. He is a php GURU and runs circles around me. I am sure with all our brains, we'll get this figured out

True, although I am sure that XML will not pass \n characters either. This is probably why the APEX API can pull it and the PHP Toolkit does not. I'm going to look at some of the XML stuff that I have and see if that is the case.

I was working with these scripts on this server and wrote to a database that I created here > http://www.mikesimonds.com/salesforce/extract_lead.php

the funny thing is that in the Description field there were no line breaks.

Then I moved the same script to my localhost, running XAMPP and extracted the exact same record, using the exact same script, there were line breaks? Take a look at the attached screen shot.

Then I extracted the row out of MySQL and it had the line breaks in it. I wonder if it has to do with the version of MySQL or something in the table. This confirms though that it is not a Salesforce API issue.

I did a quick compare between the table and fields, nothing is apparent to me as of yet, but we will find a resolution man and it will not be long

Ahh that screen shot was too small, here is the entry into MySQL:

(mysql): INSERT INTO sforce_lead ( ID, ISDELETED, MASTERRECORDID, LASTNAME, FIRSTNAME, SALUTATION, NAME, TITLE, COMPANY, STREET, CITY, STATE, POSTALCODE, COUNTRY, PHONE, MOBILEPHONE, FAX, EMAIL, WEBSITE, DESCRIPTION, LEADSOURCE, STATUS, INDUSTRY, RATING, ANNUALREVENUE, NUMBEROFEMPLOYEES, OWNERID, ISCONVERTED, CONVERTEDDATE, CONVERTEDACCOUNTID, CONVERTEDCONTACTID, CONVERTEDOPPORTUNITYID, ISUNREADBYOWNER, CREATEDDATE, CREATEDBYID, LASTMODIFIEDDATE, LASTMODIFIEDBYID, SYSTEMMODSTAMP, LASTACTIVITYDATE, EMAILBOUNCEDREASON, EMAILBOUNCEDDATE ) VALUES ( '00Q5000000S2LfjEAF', 'false', '', 'Michael', '', '', 'Michael', '', 'Jordan', '1312 Valley Stream Dr', 'Wylie', 'TX', '75098', 'United States', '(972) 742-7649', '', '', 'sportsrant2002@hotmail.com', 'http://www.mikesimonds.com', 'This is the first line entered \n\nThis is the second line\n\nThis is the third line\n\nthis is the forth line\n\nThis is the fifth line \n\nSixth\n\nEtc', 'Web', 'Working - Contacted', 'Chemicals', 'Warm', 200000.0, 10, '00550000000wI2LAAU', 'false', null, '', '', '', 'false', '2010-04-05T14:47:52.000Z', '00550000000wI2LAAU', '2010-04-07T19:00:11.000Z', '00550000000wI2LAAU', '2010-04-07T19:00:11.000Z', null, '', null )

Do the servers have different data types? What is the data type on the field that kept the \n characters?

The server that is keeping the \n 's is this computer that I am typing on using XAMPP, windows 7 Pro, PHP 5.3.0. The database version of MySQL is MySQL client version: 5.1.37

and on the server that my site is running on the MySQL version is 5.0.90

Tables are identical, data and fields types are identical. PHP on this server is 5.2.8

i have integrated this, is this bring the salesforce database into our database?

it brings the database tables with empty datas, how will i get with datas?


with this empty one what can i do Mr.

Mike
This thread has been helpful and I think I'm now looking in the right place for what I'm trying to solve. But I'm a little lost on where to start.
My overall goal is to take a few fields from my company's mySQL database and populate the values in fields in SalesForce at the Account level. Database stores information on our customers and their transactions. It will be very helpful to our account management team to be able to see these fields at the account record level and also be able to report on the fields at the account record level. I would like the update from mySQL to SF.com to refresh nightly.
My question is, where do I begin to set up this connection. This discussion seems to go into some great detail, but there’s so much I’m a little lost. Is it possible to condense it down into a few steps or maybe a quick call would be able to clear this up for me.
Thanks a lot.
Adam

Originally Posted by Adam

Mike
This thread has been helpful and I think I'm now looking in the right place for what I'm trying to solve. But I'm a little lost on where to start.
My overall goal is to take a few fields from my company's mySQL database and populate the values in fields in SalesForce at the Account level. Database stores information on our customers and their transactions. It will be very helpful to our account management team to be able to see these fields at the account record level and also be able to report on the fields at the account record level. I would like the update from mySQL to SF.com to refresh nightly.
My question is, where do I begin to set up this connection. This discussion seems to go into some great detail, but there’s so much I’m a little lost. Is it possible to condense it down into a few steps or maybe a quick call would be able to clear this up for me.
Thanks a lot.
Adam

Do you use skype at all? if not you can reach me at 469-298-8850


~Mike