Syncronization PHP script between JSON API and MySQL Database.

Cancelado Publicado hace 6 años Pagado a la entrega
Cancelado Pagado a la entrega

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

Via [login to view URL] 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 [login to view URL] Just open [login to view URL] with this software and you can navigate in the whole code

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

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

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

5) there is an help forum for Manager under [login to view URL]

Procesamiento de datos JSON MySQL PHP Desarrollo de software

Nº del proyecto: #14654431

Sobre el proyecto

7 propuestas Proyecto remoto Activo hace 6 años

7 freelancers están ofertando un promedio de €37 por este trabajo

Webln

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 Más

€43 EUR en 2 días
(20 comentarios)
5.7
abbalove

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

€130 EUR en 3 días
(44 comentarios)
5.1
mukeshwebdev11

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

€9 EUR en 1 día
(9 comentarios)
4.0
ashik5177

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 Más

€8 EUR en 1 día
(0 comentarios)
0.0
Bdgizmo

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 Más

€21 EUR en 3 días
(1 comentario)
0.0