Ok so I have zero knowledge of XML but have programmed in other languages before. I have what seems to be a pretty easy question. Our company has contracted with an outside vendor to re-create our online store. We want to transfer the orders placed online to our office system as to remove the manual entry of orders we're doing now. We also want to export inventory quantities from our office system to the website so that an accurate count is always listed.
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.
I think what they mean by "intermediary program" is basically a script that parses the XML and gets it in to the format required to do something with it, ie turn the XML into a series of SQL statements so that it can be entered into your office database.
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.