This question has been flagged
2 Replies
11327 Views

What is the best Entity Relationship Diagram Tool to design new Odoo modules? How about generating Python and XML templates automatically after design?

Avatar
Discard
Best Answer

I think this is what you are looking for: https://www.odoo.com/event/odoo-experience-2015-2015-06-03-2015-06-05-304/track/xmi2odoo-from-a-uml-map-to-an-odoo-module-in-no-time-234

Avatar
Discard
Author

Thanks a million. That is simply genius. So, can I use any ERD tool that can export the design to XMI?

Actually I haven't used it yet, but I've seen they used it with UML diagrams from ArgoUML: https://www.odoo.com/slides/slide/xmi2odoo-from-an-uml-map-to-an-odoo-module-in-no-time-302/pdf_content

Strictly speaking, you will not need to manage E/R diagrams. You work with UML to model your classes then the ORM Odoo engine will create the database tables for you based on your model (you should not interact directly with the database).

Author

Will it creat python class on .py and .xml views?

As I told you I haven't tried it yet, but I think it will just create the module classes (.py files) and not the views (XML). I'm still managing to understand the basic functions of Odoo and have a lot of problems with inheritance even with simple classes (there are a couple of questions of mine open here in the forum). I will test it as soon as possible. IMHO you create your UML models with classes using ArgoUML and then with xmi2odoo you will obtain the odoo modules (.py files) from your model that you can further personalize (anyway on github there is an example you can follow). Give it a try. It should work on version 8, I'm not sure you can use it with version 9 (you should verify it). Here is the example https://github.com/ingadhoc/xmi2odoo_example

Best Answer

You may want to give this tool a short. 

http://www.sparxsystems.com/products/ea/

This tool have Object  and database ER modelling capabilities.  There are several other tools out there in the market, but this one seems to be very feature rich and inexpensive.

Regards

SK

 

Avatar
Discard
Author

Thanks a million. Looks very powerful. Only down side is no Ubuntu version.