software to solve my problem

[Scally_Ally]

Hi,
Was wondering if anyone had come across any software, or anyway i could implement this process on my own server (windows 2003, IIS 6.0)

I have a mysql database that i update with values sent to me via a text file ( ¦(pipe) delimited).

What i need to do is this.
1. Check on the server for a .zip file that contains the text file
2. if its there then unzip it to the same location
3. update the database with values from the text file
4. send out confirmation emails that this process has been completed

This process really needs to be automated because it may have to run on a weekend when i am not in work (i really dont want to be updating databases in my own time..!)

Is there any software that you know of that could do this?

Thanks

[stajer]

Probably not. Even though each step is fairly straightforward, each step is so setup specific that it would't make sense for someone to try and write software for mass consumption to deal with this.

BUT, because each step is actually pretty simple, you should be able to find someone who can write you a simple batch file for a couple hundred $ to automate this.

[Scally_Ally]

thanks for the advice...
do you think that because each of the processes are so simple it would be something i would be able to teach myself, or would it just take too long?
I have alot of experience with PHP and ASP but next to nothing with software programming (apart from some VB).
Thanks

[edited by: Scally_Ally at 9:00 am (utc) on Sep. 22, 2006]

[stajer]

the database stuff is complex if you have never done it before. My advice would be to use elance and spend the $200 to get it in a day or so.