In Progress

Automate FTP script

I'm looking for a way to automate an FTP transfer. These are the steps that have to be done (I'll explain why in a minute):

(1) FTP a CSV text file that is compressed with gzip, ([url removed, login to view])

(2) Unpack the file to memory or to my own server.

(3) Transfer the information found in the CSV file to an SQL database (possibly MySQL, SQL Server--we've got options)

Then later I would like to run SQL queries on that data, but that's not a part of this project. This script would need to be run once a day so the 4th step is:

(4) A script of some sort that runs once a day and executes the other script or program. It also maybe backs up the former database before it updates it.

I don't care what language you use but I'm interested to see if there is a way to do this in ASP.NET, Perl or PHP. I am looking for either someone to walk me through the project how to do it in ASP.NET, Perl, etc. or someone who can do the entire project on their own in a timely fashion. I put a low budget on this project but if it costs more I'm flexible -- I just want to pay how much it's worth.

When you give your bid I would like specifics on how you will accomplish this project (i.e. languages, platform, methods, etc.) and how long it will take. I have not select a host server yet so this could be on a Microsoft or Linux server, it depends on what language I end up using for the scripts.

Skills: .NET, ASP, Java, Perl, PHP

See more: automate ftp php, why do we sort data, what am i worth, transfer methods, server languages, how much am i worth, $5 script, automate ftp feed, automate ftp script asp net, php end script, walk, sql server scripts, sql script , script, script linux, my pay options, minute script, low budget, Linux script, language options

About the Employer:
( 0 reviews ) Conway, United States

Project ID: #15950