Re: insert data from xml page into mysql database

[Jay Alverson]

maria zotou Wrote:
-------------------------------------------------------
> Hello, I have an xml page from which I want to
> retrieve its data and store it on a mysql
> database. the problem is that I don't want the xml
> page to be stored in my computer (in other words
> to have a static content) but I want to retrieve
> the data from the page's url, as the xml page is
> actually an xml feed from a website and therefore
> changes its information occasionally. So I want
> every time that this xml page refreshes, to
> refresh my database as well. Does anyone know how
> something like this can be done?Thank you in
> advance!


Depends on what system you query from, and how you're getting the XML data.

Windows can use VBScript to obtain the data in a number of ways, or a compiled EXE in Winbatch language can go out to a URL and grab data, extract & format and insert it into MySQL.

Tools like wGET and XMLStarlet can be supplied a URI on the command line from a .BAT file or as I mentioned VBScript can use MSXML to grab data from a web page.

Is that what you mean ?

It also depends on what you mean by "referesh" your database; completely or just the new changes ?

At any rate sounds actually like a moderately difficult task; depending on your network and firewall restrictions and how the script must execute.


>