Modifcation of a php script
- or -
Post a project like this$30
- Posted:
- Proposals: 6
- Remote
- #1211215
- PRE-FUNDED
- Expired
Hybrid Web Developer (PHP, MySQL, HTML, CSS, JS, JQuery, Laravel, WordPress, AWS, Git, SVN et al)
East Grinstead
Full stack developer | MEAN | Javascript | Python |AWS | noSQL | PostgreSQL | MySQL | Blockchain | AI
Pune
121073610931971222431127118212761241330256
Description
Experience Level: Intermediate
General information for the business: transformation of an php script
Database management system (DBMS): MySQL
Description of requirements/functionality: The script (process_dukascopy_data.php) is creating several csv tables from input sources (from exchange rate from 1.1.2016 to the latest date). I'd like to modify this scrip in order to:
1) export data to mysql tables instead of CSV files; (Each currency pair such as EURUSD should be in one table with the name of the pair: "I_EURUSD" or "I_GBPUSD" (generic name: I_xxxxxx) within the database named "vwr_data")
2) The script will run as a schedule task (every hours), the script should only export to mysql the latest records that are not yet in MySQL (and not perform a full export (from 1.1.2016) at each run) in order to save time. The process should be efficient.
NB:
0) the script is called by a batch file (See file named process_VCO.BAT)
1) if the table I_xxxxxx does not exist in mysql, the script should create it automatically
2) the field format should be set correctly in the (date/time format for date/time info and numeric for numeric)
2) the attached files show only partial data for EURUSD but the full script handle arround 30 PAIRS (e.g. USDCHF, GBPUSD, ETC)
3) You need to install Visual C++ Redistributable for Visual Studio 2015 : https://www.microsoft.com/en-us/download/details.aspx?id=48145
4) I do not provide the MySQL environment but let me know in your final script where you put the information regarding the different MySQL settings (e.g username/password, table names, etc.)
5) In the attachement I have provided, I put only partial EURUSD data just for your own testing.
CMS and Admin requirements: You need to install Visual C++ Redistributable for Visual Studio 2015 : https://www.microsoft.com/en-us/download/details.aspx?id=48145
Specific technologies required: MySQL, PHP
Extra notes: The script and related data could be downloaded for evaluation of the difficulties here: https://it-cm.ch/myowncloud/index.php/s/qSy8tEnF3F8Eziw
Database management system (DBMS): MySQL
Description of requirements/functionality: The script (process_dukascopy_data.php) is creating several csv tables from input sources (from exchange rate from 1.1.2016 to the latest date). I'd like to modify this scrip in order to:
1) export data to mysql tables instead of CSV files; (Each currency pair such as EURUSD should be in one table with the name of the pair: "I_EURUSD" or "I_GBPUSD" (generic name: I_xxxxxx) within the database named "vwr_data")
2) The script will run as a schedule task (every hours), the script should only export to mysql the latest records that are not yet in MySQL (and not perform a full export (from 1.1.2016) at each run) in order to save time. The process should be efficient.
NB:
0) the script is called by a batch file (See file named process_VCO.BAT)
1) if the table I_xxxxxx does not exist in mysql, the script should create it automatically
2) the field format should be set correctly in the (date/time format for date/time info and numeric for numeric)
2) the attached files show only partial data for EURUSD but the full script handle arround 30 PAIRS (e.g. USDCHF, GBPUSD, ETC)
3) You need to install Visual C++ Redistributable for Visual Studio 2015 : https://www.microsoft.com/en-us/download/details.aspx?id=48145
4) I do not provide the MySQL environment but let me know in your final script where you put the information regarding the different MySQL settings (e.g username/password, table names, etc.)
5) In the attachement I have provided, I put only partial EURUSD data just for your own testing.
CMS and Admin requirements: You need to install Visual C++ Redistributable for Visual Studio 2015 : https://www.microsoft.com/en-us/download/details.aspx?id=48145
Specific technologies required: MySQL, PHP
Extra notes: The script and related data could be downloaded for evaluation of the difficulties here: https://it-cm.ch/myowncloud/index.php/s/qSy8tEnF3F8Eziw
Valery C.
100% (3)Projects Completed
6
Freelancers worked with
6
Projects awarded
50%
Last project
18 Dec 2019
Switzerland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please let me know if still available?
56562
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies