Peruttu

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 [url removed, login to view] 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, software write mq4, software write chip epson, useful software write book, software write web specs, detect mysql database crash using php, free software write user guide, populating mysql database web app php, software write edid, free software write company profile, orkut api use php script, software write websites idea

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

Projektin tunnus: #14611139

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

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Lisää

€105 EUR 1 päivässä
(194 arvostelua)
8.3
€157 EUR 3 päivässä
(907 arvostelua)
8.6
octaservices

hello,I have 6+ year experience in Magento,Wordpress,PHP.I have huge experience of creation custom module, Magento extentions,Magento Theme Customization & Creation,Wordpress Plugin & many other task Relevant Skills a Lisää

€50 EUR 7 päivässä
(78 arvostelua)
5.8
shaochao555

I did review your requirements. Your job is to match my skills and quite interesting. Please call me and discuss details. Relevant Skills and Experience I am a web developer. I have experiences with PHP, JS, HTML5, My Lisää

€23 EUR 1 päivässä
(51 arvostelua)
5.2
technoweb7

Greetings, we are a team of 35 developers and 20 designers and each having more than 8 years experience. I would very much happy to work with you on your project and I have already checked detail your requirement and Lisää

€23 EUR 1 päivässä
(7 arvostelua)
4.6
hightechrider

In addition, I have a excellence knowledge in the 3rd party API as Facebook, Twitter, Google API, shopping engines, etc. Relevant Skills and Experience In addition, I have a excellence knowledge in the 3rd party API a Lisää

€29 EUR 1 päivässä
(28 arvostelua)
5.1
€23 EUR 1 päivässä
(21 arvostelua)
5.1
vbizsolutionss

Dear Sir, We specialize in web development and have developed over 100+ web portals. We are dynamic and energetic group of professionals. We value our customers and are committed to delivering high quality results t Lisää

€30 EUR 1 päivässä
(23 arvostelua)
4.6
prithivi004

This is Prithivi. I have strong knowledge in PHP & Mysql. I also done lot of features added in Json & PHP api. Shall we discuss about it. Relevant Skills and Experience I'm a web developer with 5 years developing ex Lisää

€30 EUR 1 päivässä
(2 arvostelua)
2.4
syncnologies

Hello Sir/Mam Greetings!!! We are fastest growing Software Development company, I surmise we will be great fit for your new brand. I might love to have a chance to discuss your approaching project for you. We have r Lisää

€28 EUR 2 päivässä
(2 arvostelua)
0.6
€23 EUR 1 päivässä
(0 arvostelua)
0.0
€23 EUR 1 päivässä
(0 arvostelua)
0.0