Hi everybody.
I'm writing from italy, so my english could not be so understandable.
I'm REALIZING a procedure to transfer a .mdb file from a pc client to a web server.
This mdb file needs to be cleaned and some data will be exported from there to a mysql db.
The mdb file is created by an external program 3 times a day.
I've realized a batch file:
---------------------
@ECHO OFF
ftp -i -n ftp.mydomain.itstart explorer http://www.mydomain.it/runtheprocedure.asp
---------------------
The file send.txt contains all the ftp information, username, password, path and filename to send and the quit after the send file has done.
---------
user ftpuser password
cd path/
send file.mdb
quit
----------

When the file is on the web the ftp calls explorer and launches the webpage that cleans and transfers the data on mysql database.

The batch file is programmed with the win scheduler to be runned 3 times a day, 1h later then the creation of the mdb file.

Now the problems.
1. the web page still open. At the end of the procedure the web page displays an ok message [or eventually en error msg ;-( ] but it stills open. It this procedure is runned 3 times a day for x days at the end there will be thousands opened pages! I need to close it! how can i do it?
2. Is there another, DIFFERENT, way to open the web procedure?
3. what happens if SOMETHING goes wrong? How do I check if all the procedure worked out?
I thought about deleting the cleaned mdb file at the end of the procedure (or renaming it... imported_ok1/1/2006-part1.mdb) but if it does arrive to this point? when starts the second time the procedure will overwrite the previous mdb file.
Is there a way to rename the ftp transferred file with date/time so I can be sure not to overwrite files?
I've tried but it seems batch files don't LIKE it (i've tried this [emailprotected]@[emailprotected]@[emailprotected]) but i should rename the transferred file in the ftp command...

well... it should be all.

Hope I've been clear and the someone can help!
Ciao,
cesare
Have Blue screen SAYS cannot rebootJust to let you know.
I've solved another problem.
in the file send.txt are stored the user and password information.
This is not a good idea...
So using this file I solved the problem:
-----------------------
@ECHO OFF
> script.ftp ECHO user ftpuser password
>>script.ftp ECHO cd path/
>>script.ftp ECHO send filename.mdb
ftp -i -n ftp.mywebsite.itTYPE NUL >script.ftp
DEL script.ftp
----------------------------
This creates the file with the user/pwd on the fly, then after the usage it is emptied and then deleted.
And this can be compiled as exe so no-one will know the user/pwd!
Just like Mission Impossible
Quote

Have Blue screen Says cannot reboot