search

sytone / obsidian-queryallthethings

Query all your data stored in Obsidian, this plugin allows SQL based queries against the data collections available in Obsidian and Dataview. Output can then be rendered by Handlebars
https://sytone.github.io/obsidian-queryallthethings/
MIT License
116 stars 2 forks source link

Guide on loading and querying a csv file #30

Open aikruger opened 5 days ago

aikruger commented 5 days ago

I would greatly appreciate some more guidance on how to load and query a csv file. If I list the csv in the setup for start up it cannot find the table. And I cannot find instructions to load the csv as a table in a query. But otherwise this seems like the perfect solution

sytone commented 5 days ago

I just fixed a bug with the loading of markdown tables and CSV. Let me get that change in and then add an example for you.

sytone commented 5 days ago

ok, fix is in place with 1.2.1 and I added a page to the docs with an example. https://sytone.dev/obsidian-queryallthethings/examples-tutorials/csv-loader.

If you download the sample vault from the release and open locally you can see it load the CSV file and the query use it to get data.

sytone commented 5 days ago

Added another example explaining how the web-based download of a CSV works with example.

https://sytone.dev/obsidian-queryallthethings/examples-tutorials/csv-loader-web

aikruger commented 3 days ago

This is great, and super fast with large tables, many thanks, it is a bit of a pain creating a template to render as markdown table, it would be fabulous to be able to have the ability to call predefined templates within the code block editor (in my set up this is live and does not wait for save to change, so it is not currently usable)

sytone commented 2 days ago

You can use templates. There is the templateFile property. Put the path to the file with the render template. I use this so the render is same across pages and I only have to update in one place.

This page has an example.

https://sytone.dev/obsidian-queryallthethings/examples-tutorials/active-tasks-grouped-by-day#using-query-and-template-files