Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
We've been told by the company that an "intermediary program" will be needed to make the transfer happen. I'm guessing the reason for this is that the tags used in the online store will be different from what our office system uses. My big question is how do I go about doing this conversion.? Do I need to write a script to do this, and if so what language would be appropriate (php)?
I've started reading on XML but I figured I'd go to the experts. Everyone on these forums has been great for the other posts I've done.
Thanks in advance for the help everyone.
If this is the case then you can use a variety of languages to parse the XML, you could try PHP. There are lots of pre written modules for parsing XML in PHP and Perl, so have a look out for those.
My suggestion is to use an event based parser like Expat (available for both PHP and Perl) as it uses less memory for larger files, but if your only dealing with a small feed you could use the XML DOM. There is plenty information out there on both to help you make the right choice.
Hope this helps.
Or since you have an online store, then you might want your primary db on the server and interface with that from your office, then have the website actually modify the db on purchase.