search

paveldanilin / grafana-csv-plugin

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

cannot query data if there are spaces in the name #41

Open karanpreetsingh1990 opened 3 years ago

karanpreetsingh1990 commented 3 years ago

I have a csv with spaces in the headers and comma as delimiter and I can add the datasource correctly but get an error while trying to explore the data stating there are multiple files with the same name. It looks like it's using the comma delimiter and space to separate out the fields. This needs to be corrected.

paveldanilin commented 3 years ago

Could you share your CSV file?

adriantaw commented 3 years ago

Hi @paveldanilin thanks for developing the plugin. Great job! However, I do have a problem with my csv. With your example everything works fine. Whenever I do a query, I got the following error "Query failed: near "(": syntax error" Could this be because I have character with space on my column header? I attach my csv as your reference. Thanks ! testquery.zip

adriantaw commented 3 years ago

by the way I removed the "space" character and looks like the error is gone, but there is no data to be shown (see attachment)

Screenshot 2021-03-27 113423

paveldanilin commented 3 years ago

Hi!

Let me check, I will update you as soon as I figure out what’s the problem is.

27 марта 2021 г., в 13:35, Adrian @.***> написал(а):

 by the way I removed the "space" character and looks like the error is gone, but there is no data to be shown (see attachment)

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.