Skip to content

Support importing data from CSV to the database #10405

Not planned
@shuojie819

Description

@shuojie819

希望数据库增加导入功能

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

Activity

changed the title [-]希望数据库增加导入功能[/-] [+]Support creating database from CSV[/+] on Feb 23, 2024
self-assigned this
on Feb 23, 2024
88250

88250 commented on Feb 23, 2024

@88250
Member

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

shuojie819

shuojie819 commented on Feb 23, 2024

@shuojie819
Author

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

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

changed the title [-]Support creating database from CSV[/-] [+]Support importing data from CSV to the database[/+] on Mar 9, 2024
cnrot

cnrot commented on Mar 9, 2024

@cnrot

期待支持导入

KrzysztofChrisMaciejczuk

KrzysztofChrisMaciejczuk commented on Apr 2, 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

shuojie819 commented on Apr 2, 2024

@shuojie819
Author

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

KrzysztofChrisMaciejczuk commented on Apr 2, 2024

@KrzysztofChrisMaciejczuk

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

shuojie819 commented on Apr 3, 2024

@shuojie819
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

88250

88250 commented on Sep 11, 2024

@88250
Member

这个不考虑,就用 Excel 中转拷贝一下吧。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

    Development

    No branches or pull requests

      Participants

      @88250@shuojie819@cnrot@KrzysztofChrisMaciejczuk

      Issue actions

        Support importing data from CSV to the database · Issue #10405 · siyuan-note/siyuan