Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support importing data from CSV to the database #10405

Open
shuojie819 opened this issue Feb 22, 2024 · 7 comments
Open

Support importing data from CSV to the database #10405

shuojie819 opened this issue Feb 22, 2024 · 7 comments
Assignees

Comments

@shuojie819
Copy link

shuojie819 commented Feb 22, 2024

希望数据库增加导入功能

In what scenarios do you need this feature?

一个一个打太慢了也不能批量复制贴贴,特别麻烦

Describe the optimal solution

  1. 增加一个导入CSV的功能
  2. 可以将普通表格转换为数据库表格

类似于Obsidian 的 DataLoom 插件也可以
image

Describe the candidate solution

No response

Other information

No response

@88250 88250 changed the title 希望数据库增加导入功能 Support creating database from CSV Feb 23, 2024
@88250 88250 self-assigned this Feb 23, 2024
@88250
Copy link
Member

88250 commented Feb 23, 2024

第二点暂时不考虑了,感谢提议。

@shuojie819
Copy link
Author

第二点暂时不考虑了,感谢提议。

好的👌,拥有一种方式也就足够用了。

@88250 88250 changed the title Support creating database from CSV Support importing data from CSV to the database Mar 9, 2024
@CoryRowe
Copy link

CoryRowe commented Mar 9, 2024

期待支持导入

@KrzysztofChrisMaciejczuk

Is this features already released? Where do I find it? I wish to import a CSV file into SiYuan as a database table. Thank you.

@shuojie819
Copy link
Author

shuojie819 commented Apr 2, 2024

Is this features already released? Where do I find it? I wish to import a CSV file into SiYuan as a database table. Thank you.

导入CSV的功能还没有发布,但是现在已经支持从Excel中复制了(你可以使用Excel打开CSV文件,再复制到数据库表格中)
The CSV import feature has not been released yet, but now it is supported to copy from Excel (you can open the CSV file with Excel and then copy it into the database table).

recording-9Pl4vg9

@KrzysztofChrisMaciejczuk
Copy link

KrzysztofChrisMaciejczuk commented Apr 2, 2024

Ok, thanks! That helps a lot.

Though as I understand - I first need to create enough space for the data I am copying, is that correct?
Is there a workaround, if I have 590 rows to copy?
Perhaps I could use API to make SQL insert to the table?
Is there a planned date for releasing CSV/Excel import?
Thank you!

@shuojie819
Copy link
Author

Ok, thanks! That helps a lot.

Though as I understand - I first need to create enough space for the data I am copying, is that correct? Is there a workaround, if I have 590 rows to copy? Perhaps I could use API to make SQL insert to the table? Is there a planned date for releasing CSV/Excel import? Thank you!

你可以批量插入空行后进行粘贴。
You can insert blank lines in bulk and then paste afterwards.
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants