I want to try to automate a process using Perl. At the moment, there is a web page which has got a text file as an attachment. Currently I open up the web page, save the attachment and then FTP it to a unix box. I then log onto another unix machine and navigate to a perl script called MarginReport.pl. Finally I run the perl script passing the saved text file as its only argument, i.e. MarginReport.pl new_margins.txt. This is a very manual process and I want to try to automate it using Perl. The existing perl script just opens the text file, does some formatting and then runs a stored procedure to insert the data into a database table. The web site is an online incident management ticketing system which has got a unique reference number on each web page.
How can the above manual process be more automated?
How can the above manual process be more automated?