Em Andamento

Backend FTP Program + Front End Search Tool

On a nightly basis a file is generated on our partner site which contains thousands of deleted domains. We need an automated way of pulling it, pumping it into a database and making it available for search.

This is the process we need setup.

Part 1 - This will best be done in Perl by certainly PHP is an option (Your Choice)

- Pull file form remote ftp (9MB to 12MB / On Average)

- Unzip file (85MB to 95MB Extracted / On Average) - The file exported is a standard CSV, so plain text will do.

- Check database line by line. This can be done at the file level of using MySQL for caching. You need to check line by line with domain is in the database and which isn't. If it is, the move to the next, if not, insert into database.

- Delete CSV file.

- Generate report overview and email to preset email address. Just a general overview of what's happened.

Part 2 - This part is pretty basis and anyone with MySQL and PHP experience should be able to accomplish it and that's the part of the front end interface. Must be in PHP.

- Create a front end interface to search for domains. We are looking for something professional. Basically record by record displayed based on search options. Would like a simple search options and advanced search options. I wont go into detail on this as it's pretty self explanatory but the better front end interface, the better this project will work.

Fields Inserted Include:

- Domain Name

- Top Level Name, .com, .net, .org, .uk

- Deletion Date Format m/dd/yyy

- Time Stamp - Date Record Created Format m/dd/yyy hh:mm:ss AM/PM

- Registered Years

- Page Rank

- MSN Link Count

- Yahoo Link Count

- Alex Traffic Rank

Please keep in mind, this is a very basic project requiring FTP knowledge and MySQL knowledge, however please consider that you are dealing with a large file here so you have to consider timeouts.

Habilidades: Processamento de Dados, Processamento de dados, Perl, PHP, XML

Ver mais: backend ftp, php ftp frontend, web ftp frontend php, unzip ftp, project end time, professional looking email address, part standard, move domain name, ftp unzip, delete tool, ftp front end software, simple frontend ftp tool, frontend ftp, build ftp frontend, design front end ftp, ftp front end, ftp php frontend, html ftp front end, database caching, best remote, alex t, program line, time stamp, mm, insert date

Acerca do Empregador:
( 15 comentários ) New York, United States

ID do Projeto: #135172

Premiar a:

halz

Please refer to PMB for details.

$80 USD em 6 dias
(2 Avaliações)
2.3

5 freelancers estão ofertando em média $86 para este trabalho

Webworkzone

We can surely do the job for you in PHP/Mysql and we can retrieve the data from the third server and extract the data from the CSV file also and do the further coding also. Looking forward for your reply. Regards Web Mais

$100 USD in 10 dias
(9 Comentários)
3.9
fidokomik

I have something similar for my servers. I use Perl for all but I can to use PHP for searching as you need.

$70 USD in 7 dias
(6 Comentários)
3.6
philipstanton

Available now. FREE support offered on completion. Further details and questions available in PMB.

$100 USD in 10 dias
(0 Comentários)
0.0
neuralhead

The batch will be made in perl, the search engine in php as you require, we will offer a demo online to adjust search engine functionability.

$80 USD in 7 dias
(0 Comentários)
0.0