homepage Welcome to WebmasterWorld Guest from 54.211.157.103
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

    
xml help
davidh6781




msg:4260514
 11:58 am on Jan 31, 2011 (gmt 0)

I have a slight issue that i cannot work out.

I ahve a doc of parts with part numbers and prices etc. roughly 3000 items.

Is there such a way that i can call an xml file to a webpage and display the results.

also how easy would it be to convert an excel .xls sheet into valid xml?

 

httpwebwitch




msg:4260556
 2:12 pm on Jan 31, 2011 (gmt 0)

1) create an XSLT stylesheet for the XML document. Here's a quick example of that [webmasterworld.com]

2) use a server-side programming language (such as PHP or C# or Perl or Python or Ruby etc) to parse the XML, loop through the data, and display it as HTML.
For an XML document with 3K items, showing them all on one page may be cumbersome. You may want to show the data paginated, in which case #1 is not an option.

If you're showing all 3000 items, constructing HTML stright from XML is as fast as any other technique. But if you're paginating the results, or sorting them, or filtering / searching them, then you'll definitely want to import that data into a relational SQL database. Thankfully, importing data from Excel into SQL is easy; most SQL tools have that facility built in. Plus, IMHO SQL is easier to use than XML.

and I believe Excel has an "export as XML" option, if memory serves me right...

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