search

paveldanilin / grafana-csv-plugin

CSV datasource for Grafana 6.x.x / 7.x.x
MIT License
36 stars 12 forks source link

Csv datatype conversion issue #28

Open harish1992mech opened 3 years ago

harish1992mech commented 3 years ago

Hi Pavel,

Not able to visualize the time series data which is similar to the data coming from a sensor. Please see the actual csv file in the attachment. https://drive.google.com/file/d/1BhDHXhbOlp9G9QGhSjQ6mgzNaKq-2aCM/view?usp=sharing

The issue, in detail is mentioned in the below link by user harish1992mech https://community.grafana.com/t/csv-as-datasource/18520/23

Thank you, Harish

Moosetracks555 commented 3 years ago

That did fix it! Thank you.

paveldanilin commented 3 years ago

Hi @Moosetracks555, I suppose your message is related to another issue This issue is still open and scheduled to be fixed

Moosetracks555 commented 3 years ago

I am sorry! Yes I meant to reply to the other issue.

paveldanilin commented 3 years ago

Dear @harish1992mech, Is this (below) the right visualization of your data? image

paveldanilin commented 3 years ago

@harish1992mech Could you test the fix and confirm that your problem has been solved?

harish1992mech commented 3 years ago

@paveldanilin Thanks a lot for the quick fix.

The visualization looks good in the screenshot which you've provided. But in my PC, I am getting the below error. Not sure, if I am doing everything correct.

image

Could you please support in the above issue.

Thank you for your time.

Regards, Harish

paveldanilin commented 3 years ago

Dear @harish1992mech , I accidentally broke a building script for windows yesterday so the windows binary was broken. I just re-built it, please test once again the fix.

Let me clarify a couple of things:

  1. You don't have to define columns with types likewise at your screenshot. You can skip that step.
  2. You may explicitly define a column and its type in the case when auto detection works wrong.
  3. According to your CSV file it does not make any sense to defined the time column as Timestamp, since values are not a valid date or timestamp (-0.98, -0.96, -0.94 can't be converted to date)

At this point, I would propose the following steps:

  1. Unpack the last build of the plugin (please find the link above)
  2. Restart Grafana
  3. Delete your datasource
  4. Create a new one datasource, without column definition, you should have something like this (but the file path should be different): image
  5. Create a dashboard with a table, at this step you should see the result similar to mine
harish1992mech commented 3 years ago

Dear @paveldanilin ,

Thank you for the quick reply.

I've followed your suggestions and now I think the previous error got solved and I am able to see the values in the table as below

image

One more small help. Could you kindly tell if its possible to view this as a graph. Because when I tried changing the visualization mode to Graph, I get the result like this

image

I am also not sure if this kind of time series values can be plotted in grafana. Could you kindly help me with this query too.

Thank you, Regards, Harish

paveldanilin commented 3 years ago

Hi @harish1992mech! Try this build with the dashboards that I had sent to you earlier by mail.

paveldanilin commented 3 years ago

Hi! What version of Grafana do you use? How did you configure the data source (share the screenshot)? It's strange because I do not have the same problem with your CSV structure.

пн, 9 нояб. 2020 г. в 22:41, vjagannath786 notifications@github.com:

The dashboards are not displaying simple text columns for example : name,age varun,30 john, 35

Only the integer values are shown but not the string.

Any idea why this is happening.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/paveldanilin/grafana-csv-plugin/issues/28#issuecomment-723988552, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAM3DNLZ5RD7O7YQ2CALFXTSO7POTANCNFSM4SJBPJCQ .

vjagannath786 commented 3 years ago

Please ignore. It is working I had to select the view as table but selected time series.

Great work!!!

vjagannath786 commented 3 years ago

@paveldanilin , what if I want to display the above values as Time series option. Is this valid ?

paveldanilin commented 3 years ago

Hi @vjagannath786 ! I am not sure that I completely understand what you want to do. Please open a new issue for your question and provide your CSV file. I will try to help you.

vjagannath786 commented 3 years ago

For example below is the csv file ;

name,age varun, 30 aswini,29

if select this as datasource and also Time series instead of Table data then only numeric values are displayed

Capture

paveldanilin commented 3 years ago

Hi @vjagannath786 ! Please open a new issue with your question since it is not related to the current issue!

paveldanilin commented 3 years ago

@harish1992mech Hi!

Any updates?