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: http://y.e-static.net/file-att/e-conomic-api-1-4-5-2/e-conomic-api-1-4-5-2.zip and there is a developer forum for API-developer at http://apiforum.e-conomic.com/
There is also support for API:s available from accounting system supplier.
More information can be found from http://www.e-conomic.com/.
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.