Edit text.csv within a dashboard

Grafana
1

Hello to the community,

Is it possible to edit a simple csv text file in a dashboard? The file is located on the grafana server.

So that I don’t always have to switch to the server to change settings.

Background:
I have a canvas dashboard on which I display numerous services with their key figures. There is now a csv file on the server in which I can make settings that allow me to set the service tiles to a maintenace mode. The tile is then covered with a colour that symbolises this mode.
Now it would be great to be able to do this step within Grafana. And not have to switch to the file level.

Here is an example.
Service 1 is fine. service 2 has a problem. Service 3 and 4 are in manitenance mode…

image
image729×390 17.4 KB

I think its possible with the Business Forms Panel.
But that sounds like a hard way to go. :wink:

best regards
Jo

2

That will be quite dangerous feature (edit files on the server side).

I would use:

CSV Content, so that “CSV file” will be part of the dashboard and anyone with edit dashboard permission can update also that “CSV file”.

3

Hi Jan,

Unfortunately, that’s not a solution. It must still be possible to change the file from the outside.

4

That’s exactly the case - you can access it from outside and edit it.

E.g. Grafana (of course you need authentication, authorization in this case)

What do you mean by “outside”?

5

“from outside”…it hase to be a csv file on the machine and no part of the dashboard.

First I have used the static data plugin. (Or as it now called “Business input plugin”).
So I have to edit it in the dashboard, but in edit mode.

Now I use the infinity datasource plugin to parse the csv file.
So I have to edit the file “outside” of grafana.

I search a solution to edit a file inside the dashboard without switching to edit mode.

Unfortunately i can’t explain it any better with my limited english. :wink:

I will experiment a little with the TestData source.

Thanks for your help
Jo

6

Do you fill in information into that file manually? I.e. edit file or overwrite it with new version?

Why inline source does not fit for your needs, do you need to use data that CSV file somewhere else apart from Grafana?

inline
inline1077×539 38.7 KB

7

As for writing to file, it probably could be done by creating custom backend plugin, but I believe that would be an overcomplicated way for task that you are trying to solve:

1 Like
8

any reason it has to be csv file? is that a requirement, maybe you get that format from somewhere?

9

Yes, I think I’m making things too complicated.
I need the config file outside of Grafana so that the values can be changed by script or manually.

I could of course create an internal variable for each service which could be used to set it to maintenance mode within the dashboard.

And no, it doesn’t have to be a csv file. But it must contain two values and of course the CI to map the values to those from the database. In which the currently measured values are available.

Thank you for the food for thought

10

use a sqlite file instead. or a proper database