Re: insert data from xml page into mysql database
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.
>
Subject
Written By
Posted
September 17, 2008 12:08AM
Re: insert data from xml page into mysql database
October 24, 2008 02:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.