Interface development to display and manage ODKCentral data

I would like to know if any user or developer has created or made available a system with a frontend interface to process the data coming from ODKCentral, in a more dynamic way, with a display of imagens and other things.

Hi @BrunoAngelo , in 2024 we will to try, as a test, a low/no code tool to create a frontend in an "easy" way for data from one specific form that cannot be modified in our internal thematic tools nor in Central.

We will not connect it directly to Central but to a dedicated PostgreSQL database. Anyway, such low/no code tools can also connect to rest API.

We chose Appsmith_ but there are other opensource (or not) tools like this.

4 Likes

wow, what wonderful news, and how will this work? You will make this system available for free, how will the community be able to use it? Will it be customizable? Will it show the media simultaneously with the data, graphs and map will also be configured in the system?
I'm very excited, can you tell me more about this?

Hi @BrunoAngelo ,
I'm affraid we will have nothing to share except our beginners experience :pensive:
The platform (appsmith_) is generic as it can connect to a lot of datasources and because it helps you to build an app with a lot of available widgets.
But we'll still need to develop one app per form that need it...
So nothing to connect to central that will alloc to modify data from all forms...

Have a look at https://nifi.apache.org/ which can link through a postgresql database.... Linked through ODK API and managed through an SQL scripts for updating and processing

2 Likes

As a company using ODK and ODK Aggregate for a lot of projects, we built a platform for data validation and presentation for the surveys we manage. We started this long before ODK Central, and still rely on ODK Aggregate, although we are looking at how best to migrate.

It is not totally automated. We write triggers and procedures in Postgres to extract data, and have a front end that allows users to validate and in some cases edit data, view images and view data on maps and charts. We have also been using Looker Studio and Apache Superset to create dashboards which are then embedded into the application. The platform was built on .Net by our in-house developers and has been evolving over the last 8 years or so.

2 Likes

There is also flutterflow, I think everyone here has heard of it..
It's a very complete and low-code tool, with it we can connect a database like Supabase, which has easy integration, and through an API make the request to ODK Central, I haven't tested it yet and I haven't developed anything either. , but through my research I observed that it is the best and most complete tool to process what we are discussing here in this conversation.

If anyone has already developed something by today's date and can share it, I would be very grateful.

1 Like