I've recently worked on our MySQL / E-conomic integration and would like to help and share with others how we use the API to add/update our customers and products from our MySQL database to E-conomic.
These scripts runs through our customers and products tables in a MySQL database and for every row with a timestamp not older that 24 hours check if customer / product exists in E-conomic and add/update.
These files are meant as examples to illustrate how to use the E-conomic API - and as inspiration to build your own E-conomic integration. It's not fully working scripts and there's no further documentation or support than the comments inside them. However with a few adjustments you should be able to just upload and use the scripts pretty much as they are.
As long as you agree that whatever you do with the scripts it happens at YOUR OWN RISK
Feel free to use, share, edit and do whatever you want with them
This was made 2011 by Kenneth Peter Nielsen on behalf of Open Company
Got any comments? Hit me at
http://www.twitter.com/kennethpnielsen
Also read about how we saved more that 400 hours a year by using the E-conomic API at our blog (in danish)
http://www.opencompany.dk/blog/index.php/2011/01/inside-sadan-sparede-vi-over-400-timer-pa-arets-forste-arbejdsuge/
- Kenneth
Download examples:
http://www.opencompany.dk/economic/economic_add_update_debtors_products_scripts_php.zip
