Build a simple CSV to MySQL script in PHP
$30-250 AUD
Bezahlt bei Lieferung
I have a system that uploads CSV files to a server every hour. the CSV files are in the format:
indicator_<symbol>[login to view URL] (e.g.: [login to view URL])
The contents of each CSV file is:
timestamp, double, double, double
So, 4 columns of CSV information per line.
I want to execute a CRON job that does this:
1) Check to ensure the PHP script isn't already running. If it is, exit
2) Set a flag to indicate the PHP script is running
3) Find all files in the format of indicator_<symbol>[login to view URL]
4) Open each one, read in the CSV data, and populate the <symbol> MySQL table with the data
5) If the <symbol> isn't a table that exits, create that table with the 4 required fields
6) If the timestamp for <symbol> already exists in the table, then skip that line in the CSV file
7) Output a CSV file for each <symbol> in the format of indicator_<symbol>.csv
8) Clear the flag that indicates the PHP script is running
9) Have a basic log file that records each time the script was called, which files were read, which files were written
You'll need:
- good English
- experience with GIT (BitBucket)
- be able to start now, and complete it within 2 days
- be willing to use Freelancer time tracker (with screen shots)
To apply, address the criteria above and add anything else to impress me.
this is a fixed price job - time tracker not required.
Projekt-ID: #16026203
Über das Projekt
22 Freelancer bieten im Durchschnitt $150 für diesen Job
Hi there, Quick and easy project. My bid is to work with direct access on your server. I'll need FTP + phpMyAdmin access and a few CSV files for testing. Can get started right now and complete in 2 hours flat. Mehr
HI There, I can assist you with "Build a simple CSV to MySQL script in PHP", I have experience working with "similar Development". Let's have a quick chat to discuss it further. I have been in this "Development" fi Mehr
Hello. I am an expert on import / export of CSV data. I know GIT and have BitBucket and GitHub accounts. I have been engaged in web development for over 8 years. I have experience with a lot of web technologies. I hav Mehr
Hello, I am an expert in PHP and creating complete custom solutions. I can complete your CSV to MySQL script within the 2 days specified and according to the specifications provided. The reviews on my profile show the Mehr
Hi, Requirements are clear, have worked as Linux ad,min and written shell, php scripts. Were involved with ETL activities too. Thank you, Regards. Relevant Skills and Experience Php, Mysql, linux
Hi I am having 5 years of experience in PHP and more then 8 years of experience in web development. i am interested in your project. just finished my project mtmcglobal.com. i would like to discuss more so kindly drop Mehr
I have accomplished 90% of the project which is similar of your requirement. All I need 10% customization as per your requirement set and specifications. Thank you.
Extensive knowledge in developments of php and mysql also i have worked with CRON Jobs in my current job Relevant Skills and Experience I have developed a file with a code to check a database and check some specifics Mehr
I have experience of working on python for reading/writing data through CSV file and MySQL table. Python script will do the job of reading the data and for the log we can store it in a output file. Please let me kno Mehr