We’re trying to use eBridge to connect Magento to Peachtree - but we’ve run into a problem with the Magento API that eBridge connects to. While Magento accepts up to 2 streets for an address, when the API outputs the XML data for eBridge, the two streets are concatenated together. For instance, if we had an address like the following:
12345 Test Dr.
The xml for the street would look like:
<street>12345 Test Dr.Apt #42</street>
Now this is a serious problem because Peachtree needs BOTH Street 1 and Street 2 to be separate… and Magento seems to store this correctly (both streets are stored in the same text-type column using \n as a delimiter), but they output together incorrectly since the \n is stripped before the XML is generated.
Now, in order to get eBridge to put the correct information into the correct places in Peachtree, I need to find where this XML value is being processed and the \n stripped create separation between these two values somehow. I’m thinking we can possibly replace the \n with a pipe symbol as a delimiter within the existing <street> element so that eBridge can split those out on their end… but I haven’t the faintest idea WHERE to look in the code to do this. So far, nosing around the /app/code/core/Mage/Api/ folder hasn’t given me much in the way of leads.
Can anyone point me in the right direction? I need the api to split or delimit these two street values somehow (as humanly possible). Thanks!