Csv datatype conversion issue

[harish1992mech]

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]

That did fix it! Thank you.

[paveldanilin]

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

[Moosetracks555]

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

[paveldanilin]

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

[paveldanilin]

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

[harish1992mech]

@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.

Could you please support in the above issue.

Thank you for your time.

Regards,
Harish

[paveldanilin]

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):
   
5. Create a dashboard with a table, at this step you should see the result similar to mine

[harish1992mech]

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

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

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]

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

[paveldanilin]

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 <#28 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAM3DNLZ5RD7O7YQ2CALFXTSO7POTANCNFSM4SJBPJCQ> .

[vjagannath786]

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

Great work!!!

[vjagannath786]

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

[paveldanilin]

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]

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

[paveldanilin]

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

[paveldanilin]

@harish1992mech Hi!

Any updates?