Syncronization PHP script between JSON API and MySQL Database.

Our company is actually using an accounting software, called Manager, which can be freely downloaded from [url removed, login to view], written in Mono. We are actually using the server edition.

Via one can access to the API with a map of all the businesses (1 level), active tables (2 level), lines (3 level), fields (level 4). Every level is populated only with the active business/tables/fields (Manager hides the inactive ones). There is no other way to access to the internal database.

I need a dynamic script in PHP that starting from the API populates a MySQL database:

1) query the API in order to get dynamically all the business and create/update the table structure in MySQL;

2) query the API in order to get dynamically the table structure and create/update the table structure in MySQL;

3) query the API to get dynamically all the data of each line and create/update the data in MySQL;

4) the sync will be one way from JSON to MySQL: every eventual changes in MySQL will be discarded in the next synchronization;

5) i need a separate ".php" file that should include all the parameters to connect to Manager (url, ID, Password etc) and to MySQL (url, DB, ID, Password) so that can easily changed;

6) the code should be well commented in order to be upgradable in the future.

The developer should create a local installation of Manager Server edition and of the LAMP/WAMP server since we cannot give access to our working server.

Here are some help references:

1) the ".exe" server service can be easily disassembled with [url removed, login to view] Just open [url removed, login to view] with this software and you can navigate in the whole code

2) you can download a Northwind sample business for Manager from [url removed, login to view]

3) there is a PHP basic API that can be downloaded from [url removed, login to view]

4) there is a Pyton basic API that can be downloaded from [url removed, login to view]

5) there is an help forum for Manager under [url removed, login to view]

Taidot: tietojenkäsittely, JSON, MySQL, PHP, Ohjelmistokehitys

Näytä lisää: insert data mysql database using json php, mysql database crud table php, open api connection php script, complete mysql database design project php, mysql edit row data php script, mysql database event calendar php, encoding mysql database accept encoding php windows1256, connect mysql database google maps php, api kelkoo php script, detect mysql database crash using php, populating mysql database web app php, orkut api use php script, develop mysql database excelsheet using php, export database csv using php script, yahoo api kelkoo php script

Tietoa työnantajasta:
( 0 arvostelua ) Milano, Italy

Projektin tunnus: #14654431

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

€133 EUR 1 päivässä
(25 arvostelua)

Hello! my name is Viktor. We are IT Company «Webin». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. We got acquainte Lisää

€43 EUR 2 päivässä
(10 arvostelua)

Hey, please share details with me .i'll check it and let you know for the estimate cost and prices. Thanks, Mukesh

€9 EUR 1 päivässä
(8 arvostelua)
€23 EUR 1 päivässä
(10 arvostelua)

Hi, I am expert with PHP, MySQL and Json. I can create this script like in your requirements above. Rocky

€130 EUR 3 päivässä
(13 arvostelua)

Hello, I am Expert in JSon Work Share Your Work Relevant Skills and Experience Portfolio List [login to view URL] [login to view URL] [login to view URL] [login to view URL] http://www.e-travels. Lisää

€23 EUR 1 päivässä
(0 arvostelua)

Hi I just read your requirement. I have long experience in this field. I can provide you good solution. And I can work full time or part time for you. Thanks Relevant Skills and Experience yes Proposed Milestones €4 Lisää

€8 EUR 1 päivässä
(0 arvostelua)

Hello I am Web Developer having experience in PHP and Mysql of 4 years. I have done lots of task based project. I would like to work on your task too. Relevant Skills and Experience PHP MySQL Js ajax Proposed Milest Lisää

€21 EUR 3 päivässä
(0 arvostelua)