LinkBack URL
About LinkBacks
Inbound Email formatting
Hi All
I am having a problem with formatting in inbound emails. The email account we are using is a gmail account. We have receiving automotive leads in that gmail account. The gmail account is set up as our group inbound email account. The leads we receive are in the adf format(basically an xml document with a specific structure). When the emails are imported into SugarCRM, the formatting is weird and when we try to grab the xml in the body of the email and Simple XML throws a 'not a xml object' type error. Below is how the information looks when imported.
Notice all of the equal(=) signs at the end of line. When I log directly into the gmail account, those equal signs aren't there. Can someone point to a reason why this is happening?Code:<adf>=0A<pros= pect>=0A<id>1033742</id>=0A<requestdate><![CDATA[1/23/2012 4:51:0= 1 PM]]></requestdate>=0A<vehicle interest="buy" status="used"= >=0A<make>Honda</make>=0A<model>Civic</model>=0A<bodystyle>=0A<![= CDATA[Sedan, Wagon]]></bodystyle>=0A<pricecomments>=0A<![CDATA[Pr= ice Range = 2000 to 6000 / =0AMonthly Payment = 150 / =0AUsed= cars / Trade Vehicle = 1996 Chevrolet Lumina 4dr Sedan 3.1L = =0A 122000 Med Adriatic Blue (Met) Offer: $501 / ]]>=0A</pricec= omments>=0A<finance>=0A<amount type="monthly" currency="USD">= 150</amount>=0A</finance>=0A</vehicle><customer>=0A<contact>=0A<n= ame part="first">Some</name>=0A<name part="last">Customer</n= ame>=0A<email>some@email.net</email>=0A<phone type="voi= ce" time="evening">555-555-5555</phone>=0A<phone type="voice"= time="afternoon">555-555-5555</phone>=0A<phone type="voice" = time="morning">555-555-5555</phone>=0A<address>=0A<city>Medford= </city>=0A<regioncode>NY</regioncode>=0A<postalcode>11763</postal= code>=0A<country>USA</country>=0A</address>=0A</contact>=0A<timef= rame>=0A<description>Within 1 month</description>=0A</timeframe>=0A= <comments>=0A<![CDATA[Pref 2= Toyota Camry / =0APref 3= Ford = Escort / =0ACredit Score= 600 - 650 / =0APrice Range= 2000 to= 6000 / =0AMonthly Payment= 150 / =0AContact Pref: Morning, Aft= ernoon, Email / =0APurchase Timeframe= Within 1 month / =0ATrad= e Vehicle = 1996 Chevrolet Lumina 4dr Sedan 3.1L =0A 122000 = Med Adriatic Blue (Met) Offer: $501=0A / =0ATraffic Source: Kell= y Blue Book=0AThe shopper received the following information from= Kelley Blue Book on: Date: 01-23-2012, Vehicle: 1996 Chevrolet L= umina, Mileage: 122000.=0A Kelley Blue Book Values, based on cond= ition:=0AExcellent: $1100=0AGood: $925=0AFair: $650=0A=0A]]>=0A</= comments>=0A</customer>=0A<vendor>=0A<id source=" "> </id>=0A<i= d source="SomeProvider.com">66179931</id>=0A<vendorname>Some Mot= ors</vendorname>=0A<contact primarycontact="1">=0A<name part== "full">Some Dealer</name>=0A<email>dealer@somedealer.net</email>= =0A<phone type="voice">555-555-5555</phone>=0A<address>=0A<stre= et line="1">451 Some St.</street>=0A<city>Somecity</city>= =0A<regioncode>PA</regioncode>=0A<postalcode>19047</postalcode>=0A= <country>US</country>=0A</address>=0A</contact>=0A</vendor>=0A<pr= ovider>=0A<id source="SomeSource.com"> </id>=0A<name part="fu= ll">SomeProvider.com TIM</name>=0A<service>Trade-In Marketplace</se= rvice>=0A<url> http://tradein.autotrader.com</url>=0A<email>at-maj= oraccountssupport@autotrader.com</email>=0A<phone>877-547-7780</p= hone>=0A<contact primarycontact="1">=0A<name part="full">TIM = Support Team</name>=0A<email>at-majoraccountssupport@autotrader.c= om</email>=0A<phone type="voice" time="day">877-547-7780</pho= ne>=0A<address>=0A<street line="1">5775 Peachtree Dunwoody Rd.,= Suite A100</street>=0A<city>Atlanta</city>=0A<regioncode>GA</reg= ioncode>=0A<postalcode>30342</postalcode>=0A<country>US</country>= =0A</address>=0A</contact>=0A</provider>=0A</prospect>=0A</adf>
Thanks
Eric Windham
Reply With Quote
Originally Posted by ericwindham 
Bookmarks