# Reporting for farmOS

**URL:** <https://farmos.discourse.group/t/reporting-for-farmos/2462>\
**Category:** Using farmOS\
**Tags:** feature-request\
**Created:** [January 19, 2026, 7:55pm UTC](https://farmos.discourse.group/t/reporting-for-farmos/2462 "2026-01-19T19:55:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jjarrinf](https://yyz2.discourse-cdn.com/free1/user_avatar/farmos.discourse.group/jjarrinf/32/1914_2.png) [@jjarrinf](https://farmos.discourse.group/u/jjarrinf)\
**Post date:** [January 19, 2026, 7:55pm UTC](https://farmos.discourse.group/t/reporting-for-farmos/2462/1 "2026-01-19T19:55:49Z")

</div>

Has anybody developed reports (a.i. imports data to Excel) for FarmOS?. Is there any documentation about this topic.

---

<div class="post-metadata">

**Author:** ![jjarrinf](https://yyz2.discourse-cdn.com/free1/user_avatar/farmos.discourse.group/jjarrinf/32/1914_2.png) [@jjarrinf](https://farmos.discourse.group/u/jjarrinf)\
**Post date:** [January 20, 2026, 1:58am UTC](https://farmos.discourse.group/t/reporting-for-farmos/2462/2 "2026-01-20T01:58:46Z")

</div>

Actually I was thinking in somthing like this:

 ![image](https://global.discourse-cdn.com/free1/uploads/farm_os/original/2X/7/7be6308a1352cd2ef1182880b88f75671ff38094.png)

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?

---

<div class="post-metadata">

**Author:** ![mstenta](https://yyz2.discourse-cdn.com/free1/user_avatar/farmos.discourse.group/mstenta/32/4_2.png) [@mstenta](https://farmos.discourse.group/u/mstenta)\
**Post date:** [January 20, 2026, 3:39pm UTC](https://farmos.discourse.group/t/reporting-for-farmos/2462/3 "2026-01-20T15:39:42Z")

</div>

This would be great way to explore options and learn the data model @jjarrinf!

> [@jjarrinf](#):
>
> Is there any ER model available?, may be someone already did the diagram, that would be a great contribution.

There isn’t a diagram, but there is [farmOS Data Model | farmOS](https://farmos.org/model/)

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](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](http://farmOS.org).