homepage Welcome to WebmasterWorld Guest from 54.161.155.142
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / XML Development
Forum Library, Charter, Moderators: httpwebwitch

XML Development Forum

    
Newbie to XML
easy question...i think
mattyb515




msg:3100418
 1:25 pm on Sep 28, 2006 (gmt 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.

 

Mike12345




msg:3110650
 8:11 am on Oct 6, 2006 (gmt 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.

pixeltierra




msg:3110764
 10:13 am on Oct 6, 2006 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / XML Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved