We have an accounting system which has a well developed API functionality. We want to fetch data regarding our projects from the accounting system and store in a Mysql database.
For this purpose we need a PHP program which will be started by cron once a day.
What has to be done in the project:
1. Create a program so connection can be established and make the first selection of data
2. Discuss with client regarding what data to fetch and set up database tables
3. Develop program to fetch the right data and validate data so the same data is not added to the database more than once
4. Testing and validating of full solution on developers server
5. Implementation and verification on clients server
The exact structure of data and the database tables are not known but will be something like:
Table with financial transactions:
project_nr account_nr verification_nr verification_text type date period amount currency
Table with time spent per project (we have just started with time reporting per project and staff person):
project_nr staff hours date period amount currency
Table with account names:
Some more fields or tables could be needed.
Program must be written in PHP (not object oriented) and e-conomic API web service SOAP should be used. Program should be well written, commented and easy to follow.
Database structure and naming must follow clients requirements.
There is a developer kit available at: [url removed, login to view] and there is a developer forum for API-developer at [url removed, login to view]
There is also support for API:s available from accounting system supplier.
More information can be found from [url removed, login to view]
Please have a look at the developer kit before bidding. We have no experience in building API:s for this system so you must be able to sort out all technical matters by yourself. Please provide information about what kind of similar projects you have experience from.
We will set up mile stones for steps 1,4 and 5 in the list above.
16 freelance ont fait une offre moyenne de 1034 $ pour ce travail
We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality. Please check PMB. Thanks.
We are a Web design and development company that focuses on regular communication with our clients and timely delivery for all our projects. Some of the technologies/area that we focus include: