Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Newbie to XML

easy question...i think

1:25 pm on Sep 28, 2006 (gmt 0)

New User

10+ Year Member

joined:Apr 6, 2006
votes: 0

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.

Thanks in advance for the help everyone.

8:11 am on Oct 6, 2006 (gmt 0)

Full Member

10+ Year Member

joined:Nov 28, 2002
votes: 0

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.

Hope this helps.

10:13 am on Oct 6, 2006 (gmt 0)

Full Member

10+ Year Member

joined:Apr 30, 2006
votes: 0

Why can't you get your website to access your office's db directly?

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.