API Forum

This forum is in read-only mode.
Please refer to our API support in case you have any questions.
We can be reached at api@e-conomic.com
e-conomic API developer forum

Debtors/Products from MySQL to E-conomic FREE examples

0
Hi there

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/2011/01/inside-sadan-sparede-vi-over-400-timer-pa-arets-forste-arbejdsuge/

- Kenneth

Download examples:
http://www.opencompany.dk/download/economic_add_update_debtors_products_scripts_php.zip
created Jan 11, 2011 by Kennethpnielsen
0% Accept Rate

edited Jul 1, 2013 by Kennethpnielsen
Q 1 A 4 C 0

4 Answers

0
Hov !  Det er sgu da Kenneth fra (tidl.) LinuxShoppen. Alt vel ?
Kan vi måske mødes og udveksle nogle erfaringer med e-conomics ?
Hils Kevin !
answered Nov 25, 2011 by thomas.k
0
Hi Kenneth,

Thanks for sharing this - both the code and your story. Truly inspirational!


Best regards,
answered Nov 26, 2011 by Christian Estrup
0


Hej Thomas

Naturligvis - jeg har sendt dig en mail

/Kenneth
answered Dec 15, 2011 by Kennethpnielsen
0



Thanks!
/Kenneth
answered Dec 15, 2011 by Kennethpnielsen
Visma e-conomic A/S
...