www.webdeveloper.com
Results 1 to 4 of 4

Thread: Can XML do this?

  1. #1
    Join Date
    Dec 2002
    Location
    UK
    Posts
    2

    Question Can XML do this?

    I have been running a flat HTML site that mimics a database. It does this by having about 30 HTML pages with flat data, eg telephone numbers and addresses. And the user can define which data they see by using several pages drop down menu by drop down menu.

    When I set this up it was approx 1000 html pages (a bit of a headache to build and even worse to update)

    The reason for doing this was that the company I work for do not own the servers that the corporate intranet is hosted on and charges are made by file and; any scripting/server side projects are supposed to be built by their consultants at a large cost.

    The raw data for this project comes in Excel format.

    I would like to find a way of automating the processing of the Excel files to speed up updates. Whilst still not employing any technologies on the server like mySQL.

    Speaking to a colleague they mentioned that XML may offer a way of doing this. I must confess I am a newbie to XML but would like to know if anyone knows a way of doing this or can point me in the direction of anywhere to get advice on this.

    TIA

  2. #2
    Join Date
    Dec 2002
    Location
    Calgary, Canada
    Posts
    6,119
    Here is usefull reading about XML+Client side abilities

    http://www.webreference.com/programming/javascript/xml/

    XML is not limited to the uses mentioned in the article,however,from your question it seems like you do not want to resort to any webserver functionality,that will limit the XML useablilty a great deal.

    I'd say try looking into free technologies that will not cost you a penny ..such as.

    MySQL Database,
    apache HTTP web server
    and PHP
    or
    MySQL
    Tomcat Servlet engine
    and Java(serlets or jsp)

    Any of the combinations above will not require any new hardware on your part,

    Thoug when it comes to XML Java is the most suited language out there.
    Cheers

    Khalid

    Message Posting Guidelines In These Forums, Please read these before posting any question.
    Web site: webapplikations.com
    Web Resources Page:Web Resources

  3. #3
    Join Date
    Sep 2003
    Location
    Australia
    Posts
    37
    Well at in theory, XML can be used as a database. Heres a small example of this....something that took me just a few hours to make....

    Its a log database for some helpdesk.....and i have 2 html pages one to edit and other to view..and 3 XSL, while the data is stored in an XML file....to make it work..save all the files in the same directory and start with helpdesk_log.html.....i dont claim that this is the best possible solution..at lot of things like archiving and search have not been taken care of.....but at the same time it serves the prupose (to act as a database..which i think ur also aiming at...)

    feel free to use any of the code....(and let me know if u find bugs ) )

    HTH
    Attached Files Attached Files

  4. #4
    Join Date
    Oct 2003
    Posts
    37
    Just because you can use XML as a "database" doesn't mean it is the best candidate for the job.

    Sure, you can use xpath as a "query engine" and find information that you are looking for and xslt to pretty up the output; but to truly take advantage of the data, you would need a database sytem.

    Having said that, XML works best for tranferring information between two systems. That's its strong suit. Sure, you can use Excel to write a letter to your boss, but are you using the best tool for the job?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles