Re: Automating an upload of data

On Feb 23, 9:56 am, "Neil" <n...@xxxxxxxxxxxxxxx> wrote:
Hi Adrian,

You can easily write a script (well, it needs 2 actually) to interrogate the
ftp folder, and upload the file to your local computer, and then run the
routine on it.

The first script fires an ftp session, the second script does the upload.

Once created, set a Scheduled Task to call it as often as you require.

I do this every night and then process the data locally with VB, but the app
can be of your choosing.

NEIL

"Adrian Jones" <AdrianJo...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:FF22E277-54AE-4477-983A-B44FF77F6615@xxxxxxxxxxxxxxxx



Hi,

I need to regularly check an FTP folder for the presence of a file, and if
found, run a routine.

Given that this is all on our ISP's servers, what is the best way to
automate such a routine in ASP.NET?

The end target of the routine is likely to be a MySQL database. If we were
using SQL Server, I assume I could use DTS to trigger the process, but I'm
fairly ignorant of MySQL.

Thanks!- Hide quoted text -

- Show quoted text -

As I understand it, there is no need for any FTP actions. ASP.NET
needs to check if the file is in the local directory and if the file
is there, open it and import to the database. I'm right? So, if the
source file is small I don't see any problem to implement such
function - schedule aspx, depends on input format open the file and
make a connection to MySQL, import your data. That's all :-)

.

Relevant Pages

  • Re: IIS & Frontpage permissions?
    ... you could use FTP to upload the image. ... "username" is username used to logon to this FTP ... Most important thing about this script is that it is stored in secured ...
    (microsoft.public.inetserver.iis.security)
  • Re: automated upload with PHP
    ... have your script one once per day and upload any images not already ... providing it can have an ftp serve running on it, ... tiffs and the php script, ...
    (comp.lang.php)
  • Re: automated upload with PHP
    ... have your script one once per day and upload any images not already ... providing it can have an ftp serve running on it, ... tiffs and the php script, ...
    (comp.lang.php)
  • FrontPage publishing (was Bob Pullen at Plusnet, thanks but I am going)
    ... got some bright spark telling me that he had tried my ftp ... actual file upload itself. ... the trend to use Indina call centres who can only work off a script. ... them MUCH easier to deal with than BT, Wanadoo or AOL. ...
    (uk.telecom.broadband)
  • Re: Uploading files to FTP via dialog
    ... Currently I just have it so that the user needs to upload the ... image himself to the FTP, ... My problem is that after selecting a file from the local computer (e.g. ... only the filename AND the file. ...
    (php.general)