search

mattermost-community / focalboard

Focalboard is an open source, self-hosted alternative to Trello, Notion, and Asana.
https://www.focalboard.com
Other
21.9k stars 1.97k forks source link

Feature Idea: Import from CSV #450

Open brimwats1 opened 3 years ago

brimwats1 commented 3 years ago

Summary: Related to #53, creating another FR for importing from CSV.

Ideally one could just copy/paste from excel or another program, or focalboard could provide a template, or it could try to read a CSV and spit out what it gets.

chenilim commented 3 years ago

Bumping up the priority on this, and putting it up for grabs. I think the basic requirements would be:

  1. Upload a .CSV file, with column headers that exactly match the property names of the cards a. This should match the columns when exporting a CSV file, but note that those columns depend on what's visible in the view b. There must be a "Name" column at a minimum. Cancel if not.
  2. P2: Confirm adding N cards with the user (show a Ok / Cancel dialog)
  3. Create new cards, one per row

cc @asaadmahmood, @wuwinson, @sbishel. Feel free to add additional thoughts. Bumping up in priority because Finance is asking for this feature to import their AORs, and it's also a workaround to bulk import data / create cards.

brimwats1 commented 3 years ago

it may also help to look at exports to csv from airtable or notion as they currently exist, a checkbox is exported as "checked" from both for example. this would be useful if a future feature that allowed auto-importing of property types was implemented

tinkicker commented 2 years ago

I'd really like to see this as a current user of Notion with a voluminous (to me) recently established setup. I wish I'd heard of Focalboard before I imported/converted all of my GDrive, OneNote, Trello, et al notes into Notion! It would be GLORIOUS if I could use the Notion "Markdown and CSV" export (or PDF or HTML export) to get everything into Focalboard without rebuilding the Empire State Building. Again.

wuwinson commented 2 years ago

I'd really like to see this as a current user of Notion with a voluminous (to me) recently established setup. I wish I'd heard of Focalboard before I imported/converted all of my GDrive, OneNote, Trello, et al notes into Notion! It would be GLORIOUS if I could use the Notion "Markdown and CSV" export (or PDF or HTML export) to get everything into Focalboard without rebuilding the Empire State Building. Again.

Hi @tinkicker, thanks for sharing your feedback! We have basic import scripts for Trello, Notion, Asana, Jira, and Todoist. Hope that helps!

tinkicker commented 2 years ago

Thank you!

On Mon, Jan 24, 2022 at 2:13 PM Winson Wu @.***> wrote:

I'd really like to see this as a current user of Notion with a voluminous (to me) recently established setup. I wish I'd heard of Focalboard before I imported/converted all of my GDrive, OneNote, Trello, et al notes into Notion! It would be GLORIOUS if I could use the Notion "Markdown and CSV" export (or PDF or HTML export) to get everything into Focalboard without rebuilding the Empire State Building. Again.

Hi @tinkicker https://github.com/tinkicker, thanks for sharing your feedback! We have basic import scripts https://github.com/mattermost/focalboard/tree/main/import for Trello, Notion, Asana, Jira, and Todoist. Hope that helps!

— Reply to this email directly, view it on GitHub https://github.com/mattermost/focalboard/issues/450#issuecomment-1020503455, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABR2KT3AGS6CUMVE2ULAVRLUXWXG3ANCNFSM45HI2IYA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you were mentioned.Message ID: @.***>

EngiBenchi commented 1 year ago

Import cards from a CSV would be a great feature. How I imagine it: Create a card template, and in there having an option to create and export a sample CSV. Fill your sample CSV with your existing Data and in the Board there should be an option to import the card CSV Unfortunately I don't have the skills to support with coding. I do have an Excel sheet with 150 rows with potational card data though. And would love to test.

wiggin77 commented 1 year ago

CSV Import ticket

Jneville0815 commented 1 year ago

https://github.com/mattermost/focalboard/pull/4920