Re: Auto parsing XML from a folder into MySQL

[Jay Alverson]

anton blaga Wrote:
-------------------------------------------------------

Quote

> Hello,
>
> I'm looking for a method that will allow me to
> monitor a folder on a server for changes. Say a
> new XML file is added to it for an order, I want
> to be able to have that detected and automatically
> entered into my database. Do you know of any
> Windows based tools that will allow me to do
> this?
>
>
> Thanks in advance.
> anton

Well if you know VBScript or VB then you could use something like this...

http://www.microsoft.com/technet/scriptcenter/resources/qanda/may07/hey0522.mspx

There's others too but I doubt if you're familiar with the language (Winbatch). I think Winbatch would let you do a DLL call that monitors the folder as well, but I haven't used it.

I would probably keep the folder empty save for non-processed XML files then after importing them, move them to a another folder, this way you always know when there are files to work with.

VBScript or VB can also run .SQL files via CMD.exe, or if you know ADO you can connect directly to MySQL via ODBC and a fileDSN.

>

Thanks, Jay