MySQL Forums
Forum List  »  Connector/Node.js

Re: Auto parsing XML from a folder into MySQL
Posted by: Jay Alverson
Date: March 16, 2009 08:46AM

anton blaga Wrote:

> 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...

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

Options: ReplyQuote

Written By
Re: Auto parsing XML from a folder into MySQL
March 16, 2009 08:46AM

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.