Guide on loading and querying a csv file
Opened this issue · 7 comments
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
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.
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.
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
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)
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.
Sorry I have not had a chance to test it out fully yet, yes I think it does, just how would you set out a fundamental view like a table