Has anybody developed reports (a.i. imports data to Excel) for FarmOS?. Is there any documentation about this topic.
2 Likes
Actually I was thinking in somthing like this:
Once in a SQLite database (local desktop) the reports could be developed in almost any presentation tool using ODBC/JDBC libs.
Is there any ER model available?, may be someone already did the diagram, that would be a great contribution.
I already extract the records from the API, but that is not so easy for the common farmer.. this kind of module for the desktop wod be a great tool.. may be someone already did it. isn’t it?
2 Likes
This would be great way to explore options and learn the data model @jjarrinf!
There isn’t a diagram, but there is farmOS Data Model | farmOS
This describes all the entities and relationships.
You might also try out this module (in a self-hosted farmOS instance): https://www.drupal.org/project/erd
Supposedly it allows you to build ERDs. I tried it once, but didn’t really explore too deeply.
One of the challenges with farmOS is that the ERD will depend on what modules you have installed, because they can add entities/relationships. But even just a “core” ERD (with all core modules installed) might be useful to publish on farmOS.org.
1 Like