Hello;
I imported a markdown file that I want in a database, but the import placed it in a table. Is there anyway to convert a table to a database or import the markdown dirrectly to a database.
Thank you
Table to Database (Solved)
This post was last updated for 398 days ago, and the information may already be changed
1 Operate
jtruchon
updated this article at 2024-04-14 09:49:14
Related articles
-
jtruchon •PRO Author
I just found the DateBase Table Plugin in that has a import tool that will import a table to a database...not a 100% import but got most of the data in to the database
-
massivebox • via LinuxPRO
Sorry for the necropost, but I found this article while searching online, and I've found there's an alternative solution that doesn't use plugins, I hope this can be useful for someone!
As mentioned in Issue #10405 · siyuan-note/siyuan, you can simply copy the table data, for example form Excel, and paste it into your database.
However, the database must already have the columns correctly set to accomodate the data, and it must have enough rows to fit all the content. So you may want to use the "row menu" to add enough rows: hover on a row, then click on the 6 dots that appear on the left, then "Insert x rows below".
Select the top-left field in your table and paste, and that's it!
This method works pretty well, but it has some issues with dates and weird formats, so for example if your table has a column of type currency, you may want to first switch it to simple numbers, paste it into SiYuan, and then set the column to currency afterwards.
Hope this helps!
Welcome to here!
Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.
Signup About