The Data Manipulation panel is a unique plugin for Grafana. Please share your experience using it. Check out documentation to get started: volkovlabs.io/plugins/volkovlabs-form-panel/
Interesting Plugin, thank you Volkov Labs for your efforts to make our work easier. One doubt!!! Can we use the database which we have configured in the data source sections?
I just love the data manipulation panel - made life so mush easier creating user interfaces and brings so much more value to Grafana. Warning. You need some JS coding understanding to fully utilize the plugin, but when that is under the skin the possibilities is almost unlimited ,0)
Awesome plugin and video! We are interested in having a "Feedback" button that activates a modal with a feedback form. Is it possible to activate modals with embedded plugins in a Grafana dashboard? Thanks!
The Data Manipulation plugin is still under review to include in the Grafana repository. Meanwhile, you can download and install manually from Github or our private Grafana repository. You can find links in the description.
I have to double check the code. With the slider and Number input you can set a step to 0.1 and then floats allowed to adjust it moving slider or clicking on up-down button for the Number input. Unfortunately, Number input does not allow to enter symbols. String type have to be used instead.
This is one of the first videos for Business Forms (Data Manipulation) panel. Since then we published various solutions and updated documentation: volkovlabs.io/plugins/business-forms/. Please check it out, you may found answers to your questions. We provide consultations thru sponsorship github.com/sponsors/VolkovLabs?frequency=one-time if you have a specific questions.
Mam I have a doubt My dashboard have 30 panels in query format . I give userid to change the existing dashboard to update the dashboard .in data manipulation panel is it possible? If not possible how to give the data dynamic to change the existing dashboard
Your question is not clear. I would recommend to review recent videos and documentation for Data Manipulations to understand it's capabilities: volkovlabs.io/plugins/volkovlabs-form-panel/ -- Mikhail
I have a problem. When i try this plugin to call my API (my API is generate csv file), the response is true. But, csv file can't be downloaded when i try call my API in browser (firefox or google chrome) the csv file can be downloaded. Can you give me solution? Thanks
Reset button is executing the Initial Request. I plan to add customization in the upcoming version: github.com/VolkovLabs/volkovlabs-form-panel/issues/100
Is there a way to integrate this plugin wit the echarts one? For example I see on the video you set some graphs, wondering if there is way to mix them or something like that.
Data Manipulation updates data in the database using API, and Apache ECharts can visualize it from API or database using data sources. You can mix and match any panels on your Grafana dashboard.
Is it possible to include a variable for the server address in the GET and POST URLs? The handler is on the same server bit on a different port, so can get it to work on the local LCD screen (localhost) but then it doesn't work on a remote computer. Great plugins, Thanks,
Hi, is there any way that the form elements can display the values from the initial SQL query? ie. if (in your example) "question" field is already on the database record you have retrieved, can it be pre-populated in the Form Element ?
Yes, we described it in the documentation: volkovlabs.io/plugins/volkovlabs-form-panel/dynamic/. You can create a new or fill values for the existing elements. Let me know if it's clear. -- Mikhail
@@volkovlabs Thanks for your reply, and i'm now populating elements from data fields in the initial query, however only as type String input. When I change the type to Radio Buttons with Custom options (the values allowed in the returned data fields, eg. Y or N), it is not populating. What i'd like is for it to highlight the value returned from the query. Hope this makes sense, are you able to help out? i can give some off-youtube contacts if that helps. thanks,db.
@@deanbetts2301 Please open an issue in GitHub repo: github.com/VolkovLabs/volkovlabs-form-panel/issues with details. We have a backlog of the issue to work on before we can look into it, go thru all of them is our plan for the July.
Is it possible to write sql or flux queries in custom code section and pass it as request payload to the POST url, as this plugin doesn't give any body section to enter payload
All elements are included in the request payload, so you can use Code Editor or Input to write your SQL and it will be a part of the POST payload. We are working on updating documentation to make it clear. Alternatively, you can create your own Requests: volkovlabs.io/plugins/volkovlabs-form-panel/request/ -- Mikhail
@@volkovlabs ok and even i enable cors using reverse proxy server, my response type is still cors and i couldn't find a way to parse my response any solution for it? Also in network tab i could see REST api call has happened and the response is of CSV type, can't i fetch the data as json?
Our plugins are signed for the default Root URL localhost:3000. If you are using a different URL: 1) You can allow unsigned plugins and delete MANIFEST.txt file. Take a look at github.com/grafana/grafana/issues/31125. Unfortunately, official Grafana documentation is broken at the moment. 2) Another option is to use NGINX reverse proxy and keep the default root URL for which the plugin was signed. 3) We can sign the plugin for your domain and help you install and configure it by sponsoring our open-source plugins: github.com/sponsors/VolkovLabs. Please let us know if you have any issues in the repository github.com/VolkovLabs/volkovlabs-form-panel/issues
Hello , I currently have a grafana dashboard set up that is a simple table of data that is pulled from InfluxDB in csv format, is it possible to utilize this plugin to manually add data to the table/influxDB? Please let me know thank you
The plugin was originally created to GET/POST data using REST API. It should be possible to add data manually directly using Data Source, we have similar request opened in the GitHub github.com/VolkovLabs/volkovlabs-form-panel/issues/83. Please watch it for the response. We are working on the upcoming release of the panel and will look into it.
The latest version 3.1.0 supports any data source and allows to provide custom payload for Initial and Update requests. The upcoming version 3.2.0 has a new feature to read element values directly from the Query configured for the data source. We are working on a new tutorial for the Data Manipulation to cover all the latest features. We plan to premier next week.
@@volkovlabs many thanks, do you also have some kind of input enforcement like the String must end with a given suffix? I could also imagine this can be done with some code.
@@holgerwinkelmann6219 Good idea, we don't have validation yet. It can be done similar to the conditional element visibility we just implemented: volkovlabs.io/blog/form-panel-3.1.0-20230823/
Do you see any errors? We need more information to understand the issue. Check out the latest blog post, which may help: volkovlabs.io/blog/form-panel-file-upload-20240310/
@@AnatolijKrieger We provide short-term support using GitHub Sponsors: github.com/sponsors/VolkovLabs?frequency=one-time. After sponsoring you will receive instructions how to contact us.
DM provides basic token authentication out of the box. OAuth can be used when using custom Data source or NGINX as we explained in the blog post: volkovlabs.io/blog/how-to-connect-the-data-manipulation-plugin-for-grafana-to-api-server-1abe5f60c904/. We are adding direct support for Data Sources in Data Manipulation v3, which we expect to release this week. We will dive deeper into various authentication methods in the documentation and videos. Stay tuned. -- Mikhail
Hi @volkovlabs Just wanted to know if the release has happened yet or if there is any timeline to it? I was getting errors while trying to use authentication using custom data source for my use-case.
@@user-ql1ye6ht9e We have not published it yet. We got delayed working on updating plugins to Grafana 10 and new Variable panel. You can check the timeline for any of our plugins at release.volkovlabs.io.
Hi, thanks for this great plugin, it fit perfectly to our company. I'm sorry if this isn't the correct channel to ask but I'm trying to reset my dropdown (Custom options) in the plugin but can't get it. I do it in the text box but not the dropdown, even I got to fill it. I'm adding and receiving from database perfectly so far but need a little assistance with this. Didn't find any documentation to help me with some details. Can you help me or someone else, or recommend me where can I ask or get this kind of detailed info? Thanks in advance.
@@volkovlabs Wow, is incredible your fast response. If I loved the plugin from before, I now love it more. And with this attention I confirm my desire of continue improving in this great plugin. Thanks a lot
@@volkovlabs I found a way that helps me enough. But I will keep the post in the link you give me in case any advice from your side. as example: newOptionsArray = { value: "Id of my item", label: "name of my item" } options.elements[0].options = newOptionsArray options.elements[0].value = newOptionsArray[0].value onOptionsChange(options) I hope the code is clear for who need it. If not, just let me know. Thanks again!
Hi, nice work! However, I've encountered an issue while using it in my case. After submitting an update to my existing data using the PUT method, I receive a CORS error. In my REST API code, I have added the line 'w.Header().Set("Access-Control-Allow-Origin", "localhost:3000")', but the error persists. Do you have any suggestions to help resolve this problem? Thank you!
Allow Origin may not be enough. We described the CORS configuration for Data Manipulation in the blog post: volkovlabs.io/blog/how-to-connect-the-data-manipulation-plugin-for-grafana-to-api-server-1abe5f60c904/#publicly-available-server
The Data Manipulation panel is a unique plugin for Grafana. Please share your experience using it.
Check out documentation to get started: volkovlabs.io/plugins/volkovlabs-form-panel/
Wow, most plugins have no documentation. This is amazing! Well done.
Thank you! It's nice to hear that our work helps.
Your product is amazing. It really increase the value of Grafana. Thank YOU!!
Appreciate the feedback!
Thank you so much mam for make more involved in grafana after viewing ur videos mam
Glad you liked it! Welcome to the Grafana Community!
Interesting Plugin, thank you Volkov Labs for your efforts to make our work easier. One doubt!!! Can we use the database which we have configured in the data source sections?
Yes, we demonstrated data sources in the latest video: czcams.com/video/hVy9NfFiI5U/video.html
I just love the data manipulation panel - made life so mush easier creating user interfaces and brings so much more value to Grafana. Warning. You need some JS coding understanding to fully utilize the plugin, but when that is under the skin the possibilities is almost unlimited ,0)
Great to hear that!
Awesome plugin and video! We are interested in having a "Feedback" button that activates a modal with a feedback form. Is it possible to activate modals with embedded plugins in a Grafana dashboard? Thanks!
Love love this plugin, life saver
That's great to hear! Would love to learn more about your use case.
Can you show the installation and usage in detail?
I couldn't import it into grafana.
Thanks in advance
The Data Manipulation plugin is still under review to include in the Grafana repository. Meanwhile, you can download and install manually from Github or our private Grafana repository. You can find links in the description.
Is it possible to use float format for data with Number slider and Number input?
I have to double check the code. With the slider and Number input you can set a step to 0.1 and then floats allowed to adjust it moving slider or clicking on up-down button for the Number input. Unfortunately, Number input does not allow to enter symbols. String type have to be used instead.
We are going to need some expert help to get our DM panels up and running. Do you have a consulting service?
This is one of the first videos for Business Forms (Data Manipulation) panel. Since then we published various solutions and updated documentation: volkovlabs.io/plugins/business-forms/. Please check it out, you may found answers to your questions.
We provide consultations thru sponsorship github.com/sponsors/VolkovLabs?frequency=one-time if you have a specific questions.
well done! amazing plug-in.
Thank you for the feedback. Feel free to share what you are building.
Mam I have a doubt
My dashboard have 30 panels in query format .
I give userid to change the existing dashboard to update the dashboard .in data manipulation panel is it possible?
If not possible how to give the data dynamic to change the existing dashboard
Your question is not clear. I would recommend to review recent videos and documentation for Data Manipulations to understand it's capabilities: volkovlabs.io/plugins/volkovlabs-form-panel/
--
Mikhail
I have a problem. When i try this plugin to call my API (my API is generate csv file), the response is true. But, csv file can't be downloaded when i try call my API in browser (firefox or google chrome) the csv file can be downloaded. Can you give me solution? Thanks
What do you plan to do with the CSV file in the Data Manipulation panel? Maybe you need to use CSV Data Source instead to fetch it?
Hi,
How the reset Button works for data manipulation plugin? is there any Customization need to be done in javascript?
Reset button is executing the Initial Request. I plan to add customization in the upcoming version: github.com/VolkovLabs/volkovlabs-form-panel/issues/100
Is there a way to integrate this plugin wit the echarts one? For example I see on the video you set some graphs, wondering if there is way to mix them or something like that.
Data Manipulation updates data in the database using API, and Apache ECharts can visualize it from API or database using data sources. You can mix and match any panels on your Grafana dashboard.
Is it possible to include a variable for the server address in the GET and POST URLs? The handler is on the same server bit on a different port, so can get it to work on the local LCD screen (localhost) but then it doesn't work on a remote computer. Great plugins, Thanks,
Yes, it's possible. You can find example in the README: github.com/volkovlabs/volkovlabs-form-panel#custom-code
BTW: if such a Panel is authored, can this ba packed easily to deploy across many grrafana instances?
The panel can be auto-installed or provisioned in the Docker image.
Hi, is there any way that the form elements can display the values from the initial SQL query? ie. if (in your example) "question" field is already on the database record you have retrieved, can it be pre-populated in the Form Element ?
Yes, we described it in the documentation: volkovlabs.io/plugins/volkovlabs-form-panel/dynamic/. You can create a new or fill values for the existing elements.
Let me know if it's clear.
--
Mikhail
@@volkovlabs Thanks for your reply, and i'm now populating elements from data fields in the initial query, however only as type String input. When I change the type to Radio Buttons with Custom options (the values allowed in the returned data fields, eg. Y or N), it is not populating. What i'd like is for it to highlight the value returned from the query.
Hope this makes sense, are you able to help out? i can give some off-youtube contacts if that helps. thanks,db.
@@deanbetts2301 Please open an issue in GitHub repo: github.com/VolkovLabs/volkovlabs-form-panel/issues with details. We have a backlog of the issue to work on before we can look into it, go thru all of them is our plan for the July.
Is it possible to write sql or flux queries in custom code section and pass it as request payload to the POST url, as this plugin doesn't give any body section to enter payload
All elements are included in the request payload, so you can use Code Editor or Input to write your SQL and it will be a part of the POST payload. We are working on updating documentation to make it clear. Alternatively, you can create your own Requests: volkovlabs.io/plugins/volkovlabs-form-panel/request/
--
Mikhail
@@volkovlabs ok and even i enable cors using reverse proxy server, my response type is still cors and i couldn't find a way to parse my response any solution for it? Also in network tab i could see REST api call has happened and the response is of CSV type, can't i fetch the data as json?
I download the plugin from GitHub but i'm having difficulties to import into Grafana. Can you help me?
Our plugins are signed for the default Root URL localhost:3000. If you are using a different URL:
1) You can allow unsigned plugins and delete MANIFEST.txt file. Take a look at github.com/grafana/grafana/issues/31125. Unfortunately, official Grafana documentation is broken at the moment.
2) Another option is to use NGINX reverse proxy and keep the default root URL for which the plugin was signed.
3) We can sign the plugin for your domain and help you install and configure it by sponsoring our open-source plugins: github.com/sponsors/VolkovLabs.
Please let us know if you have any issues in the repository github.com/VolkovLabs/volkovlabs-form-panel/issues
Hello , I currently have a grafana dashboard set up that is a simple table of data that is pulled from InfluxDB in csv format, is it possible to utilize this plugin to manually add data to the table/influxDB? Please let me know thank you
The plugin was originally created to GET/POST data using REST API. It should be possible to add data manually directly using Data Source, we have similar request opened in the GitHub github.com/VolkovLabs/volkovlabs-form-panel/issues/83. Please watch it for the response. We are working on the upcoming release of the panel and will look into it.
Does the Plugin support GraphQL data source as Server to speak to?
The latest version 3.1.0 supports any data source and allows to provide custom payload for Initial and Update requests. The upcoming version 3.2.0 has a new feature to read element values directly from the Query configured for the data source.
We are working on a new tutorial for the Data Manipulation to cover all the latest features. We plan to premier next week.
@@volkovlabs many thanks, do you also have some kind of input enforcement like the String must end with a given suffix? I could also imagine this can be done with some code.
@@holgerwinkelmann6219 Good idea, we don't have validation yet. It can be done similar to the conditional element visibility we just implemented: volkovlabs.io/blog/form-panel-3.1.0-20230823/
Volkova, Is it possible to use .csv file as data source in this plugin?
You can use CSV file using CSV data source, which is supported in the latest versions of the Data Manipulation panel.
it's not working for me:
return {
rawSql: 'INSERT INTO [test].[dbo].[re](re) VALUES($re)',
format: 'table',
};
Do you see any errors? We need more information to understand the issue.
Check out the latest blog post, which may help: volkovlabs.io/blog/form-panel-file-upload-20240310/
@@volkovlabs вы мне можете дать сапорт, за оплату. немогу разобратся. Как с вами связатся?
@@AnatolijKrieger We provide short-term support using GitHub Sponsors: github.com/sponsors/VolkovLabs?frequency=one-time. After sponsoring you will receive instructions how to contact us.
@@volkovlabs What languages do you do support in, I only speak Russian and German
@AnatolijKrieger we can do Russian
Does it support Oauth in update request?
DM provides basic token authentication out of the box. OAuth can be used when using custom Data source or NGINX as we explained in the blog post: volkovlabs.io/blog/how-to-connect-the-data-manipulation-plugin-for-grafana-to-api-server-1abe5f60c904/.
We are adding direct support for Data Sources in Data Manipulation v3, which we expect to release this week. We will dive deeper into various authentication methods in the documentation and videos. Stay tuned.
--
Mikhail
@@volkovlabs Thanks, will be waiting
Hi @volkovlabs Just wanted to know if the release has happened yet or if there is any timeline to it? I was getting errors while trying to use authentication using custom data source for my use-case.
@@user-ql1ye6ht9e We have not published it yet. We got delayed working on updating plugins to Grafana 10 and new Variable panel. You can check the timeline for any of our plugins at release.volkovlabs.io.
Hi, thanks for this great plugin, it fit perfectly to our company.
I'm sorry if this isn't the correct channel to ask but I'm trying to reset my dropdown (Custom options) in the plugin but can't get it. I do it in the text box but not the dropdown, even I got to fill it. I'm adding and receiving from database perfectly so far but need a little assistance with this. Didn't find any documentation to help me with some details.
Can you help me or someone else, or recommend me where can I ask or get this kind of detailed info?
Thanks in advance.
Please open GitHub issue: github.com/VolkovLabs/volkovlabs-form-panel/issues
We are planning to release a new version of the Data Manipulation Panel this week and will look into it.
@@volkovlabs Wow, is incredible your fast response. If I loved the plugin from before, I now love it more. And with this attention I confirm my desire of continue improving in this great plugin. Thanks a lot
@@yoslandymesa5560 Appreciate it. I will check the issue.
@@volkovlabs I found a way that helps me enough. But I will keep the post in the link you give me in case any advice from your side.
as example:
newOptionsArray = {
value: "Id of my item",
label: "name of my item"
}
options.elements[0].options = newOptionsArray
options.elements[0].value = newOptionsArray[0].value
onOptionsChange(options)
I hope the code is clear for who need it. If not, just let me know.
Thanks again!
Great Video
Thank you.
Hi, nice work! However, I've encountered an issue while using it in my case. After submitting an update to my existing data using the PUT method, I receive a CORS error. In my REST API code, I have added the line 'w.Header().Set("Access-Control-Allow-Origin", "localhost:3000")', but the error persists. Do you have any suggestions to help resolve this problem? Thank you!
Allow Origin may not be enough. We described the CORS configuration for Data Manipulation in the blog post: volkovlabs.io/blog/how-to-connect-the-data-manipulation-plugin-for-grafana-to-api-server-1abe5f60c904/#publicly-available-server