Automating FTP

[Bengal313]

I am currently using Dreamweaver MX 2004 to do most of my web designs. It has a FTP client built in but is does not allow for scheduling a ftp session. I have a document that needs to be updated everyday. I am looking for a program that will allow me to do this. Maybe a plugin for dreamweaver or a stand alone is fine as well. Thanx

[mlseim]

What kind of document, and is it always the same document?

Maybe it would be better to use a server-side language such as
Perl to upload the file to your webspace. I'm not sure about the
automatic part though.

There must be other FTP programs that have those features.

... wait and see if anyone else can find one.

[gsnedders]

Are you on Windows or Mac?

If your on Mac OS X you could get Transmit, and I could write an Apple Script to upload it.

[Bengal313]

I am using a windows machine xp-pro). And I am uploading a MS Access Database file (daily.mdb). On the server side the host is running a Microsoft Web Server. Thanx

[raf]

why do you need a daily upload? what changes in the bb?
it would be better, like mlseinm suggests, to make these daily changes directly on the live db using a server side language. In your case, probably ASP or ASP.NET

[Bengal313]

Well the database contain sales info that users can login and view their daily sales. This MS Database is generated by a priortory program that generates the records. There are about 1000 records. So it would be hard to update it manually. Also I need to do this daily early morning and automatically, because there isn't a specific person in charge of this. and after I am done creating the internal site, I am done and the company wants everything automated.

[raf]

Hmm. I don't realy know your situation, but mixing offlineprocesses with online processes is always a bit of problem.

Preferably, the records wouls be immedeately created on the wbebserver, but i suppose this isn't possible.
Without knowing your exact situation, i think it would be the easiest to set up a scheduled task, that then ftp the oflline db and overwrited the online db.
But i never tried something like that.
(on a unix, i'd run a cron to call a php page that would then ftp the file)

[mlseim]

and after I am done creating the internal site, I am done ...

:eek: You're writing a program to eliminate yourself?

I'm hoping you mean that you're leaving on your own, and this happens to be your last assignment.

This integration between their database and internet access sounds to me like something that would take some expensive software ... something that would be more complex to accomplish with just one person.

Just the security issues would be overwhelming for me :o

[Bengal313]

Well I am not writing myself out. I am writing this for anther department that handles all this. I work with various departments. As for the integration, I am using ASP.net and Access database. They work well together. Basically the way it works is I have an Access file (daily.mdb) on the server the gets replaced everyday. There isn't much more than that. As for the security, the information is worth nothing. It is bunch of numbers at percents.