Php Script to import a txt file via FTP or SFTP (SSH2) or HTTP
$30-250 USD
Pagado a la entrega
I need a php 2 script (similar to each other)
(file1)
1. reading variables from a mysql table connects according to the "pull type", either via FTP or SFTP or HTTP
Pull types are:
-FTP
-SFTP with password authentication
-SFTP with key file authentication (no password)
-SFTP with key file authentication (password)
-HTTP
-HTTP with basic authentication
2. Copying the file contents to a tmp_files folder and then save it into a mysql (pull_data) table with LOAD DATA LOCAL INFILE, and then save into a log table the results (pull_log).
Requirements:
- The sftp key shall be retrieved from mysql
- Transfer shall make sure the content is only text ascii
- Files bigger than 20M shall be dropped (max size defined in config)
- Post comments in the scripts
(file2)
Also, I need a another script I would call via jquery/Ajax with the same logical process (pull type) to test the connection params and say if the connection is valid. The script shall return a message (i.e. connection successful, file exists, failure message, etc.).
Please also provide a html page with with form fields and the Ajax call to test file2
Later I will provide you with a sample file to import and 3 mysql tables to be used, 1 table that stores the connection values, 1 table to save the values, 1 table with the log structure for file1.
Nº del proyecto: #17458812
Sobre el proyecto
Adjudicado a:
I'm interested in your project very well. I've got an experience in jobs with skills like yours. Please ping me to discuss about this project.
10 freelancers están ofertando un promedio de $188 por este trabajo
Hi, Let me do it for you. I am an Independent Software professional haveing 12+ years of experience on web technologies and would love to work on your project. I look forward to the possibility of working toget Más
I'm really very much interested in this interesting project. Let me know if You are interested in my profile or not.
Hi.. How are you? I saw your description carefully your project. Owing to my rich experience in php script , i can say i can do this perfectly. I have many top skills like AJAX, Javascript, MySQL, PHP, Software A Más
I have seen your description carefully and have a great interest your demand. I have rich 7+ years in php development. Before I solved similar to this problem. I want to discuss more details. thanks.
Hi, I have checked the requirements. Good experience in writing custom scripts. Will do this script using PHP. Please share additional details. Regards, Mohan