Export/import [$30]

[jospoortvliet]

So Desk is awesome and we have decided to start using it for our marketing coordination (hi @NinaNC !)

One thing I'd like to see, but probably crazy, is a way to export boards. Both because I'm always worried something breaks but also it'd be nice to have them available off line.

Even nicer would be if the actual boards could be stored in markdown-ish text files on Nextcloud itself so I have full access to them and can keep working when flying but I realize that that is probably a bit too far fetched 🙄

---

There is a $30 open bounty on this issue. Add to the bounty at Bountysource.

[radiantwave]

Would love to see a Export/Import function!

[wgregori]

speaking of import function. It would be nice to be able to import a templated structure of tasks to be completed. In my business I have a series of tasks that must be tracked for every transaction. The tasks are the same for each transaction. It would be great to be able to import the template and just go. Thanks!

[xenithorb]

I'm looking for this feature mostly because I'm concerned about putting a lot of effort into setting up and detailing many boards for myself, and then somehow losing all of it through an app-update or some nextcloud quirk. I'd like to not only be able to export it in an importable format, but in some kind of flat-file way too - perhaps a spreadsheet - so that I know my work and time I put into this is safe.

[dairaine]

+1 on the possibiliy to export decks, e.g. in a simple csv.

[juliusknorr]

@dairaine Please use the Github Reactions feature instead of commenting that also need a specific feature. That way we can see your support without notifying all users subscribed to a given issue.

Besides that adding a bounty at https://www.bountysource.com/issues/43773651-request-export-import might encourage community members to jump on and implement a specific feature. 😉

A WIP implementation for user data export is in #470

[NebriBlackwing]

@juliushaertl How should this be implemented? My initial thoughts is to create a page in the admin to export various boards / everything (for example a list of check boxes that represents the boards, the stacks, and cards in a tree) or to have an export button on the board pages themselves available to admins.

And yes I'm loving the "bounty hunter" role that I have found via Bounty source. It makes priorities / features that are in demand very clear for a contributor like myself.

[juliusknorr]

I think we will limit import/export to boards, so we can add the export action to the 3-dots menu in the board list. The should always create a new board then. We could put that one at the bottom of the app navigation (left sidebar).

[karloluiten]

As long as there is no export/import, is there a way to manually transfer the data to a new server? Via sql for example? I changed from VPS hosted NC to a server at home and would like to transfer this data as well.

Edit: exported the sqlite, used a converter, then imported the cards, that worked. First boards, then tags, then cards, then assigned tags.

Exporting/importing would be awesome. Having the board as a 'real' file on NC (like notes) would be best and would mean exporting is not really needed (or at that point easy to implement).

[woosting]

Thanks for making exports possible! Is the JSON import option still within scope?

@juliushaertl I see you removed this from the Backlog? Does this mean it is off scope for the near future (or the other way around; has it been picked up by someone)?

Im asking as an export/import combination would provide a Deck-content migration (and even backup) functionality (as also pointed out by @karloluiten ). Not having an import feature (or better yet: migration feature) keeps people in my organization (including myself) from using Deck for mission critical planning (which is a shame because Deck is such an elegant addition to Nextcloud).

[blitzdesigner]

to give this issue maybe a push, the bounty went up to 20$ :-)

[gary-kim]

I'm thinking of working on the import function. Would that still be eligible for the bounty?

[putt1ck]

We're interested in working on it in relation to Trello exports i.e. a migration tool - but wouldn't compete for the bounty because it's client work :)

[gary-kim]

That's nice. I was thinking of adding an occ command for now so if we go that route, maybe we should also have that command allow the admin to specify whether the export is from another Nextcloud instance or Trello?
Should not be too difficult to then reuse the code for occ imports for the web interface.

[putt1ck]

Was assuming occ and the JSON export from Trello (i.e. assuming those migrating are not paying for business class or enterprise). Also assumed board by board export/import for much the same reason - and that issues were more likely to arise with a bulk import.

[spackmat]

The export feature is a nice begin, thanks for that!

But implementing it only as a cli command and make it always export all boards of a User is quite limiting. The missing import (or even duplication) of a board is the last thing what prevents me from using Deck.

[putt1ck]

Isn't cloning (duplication) dealt with in #119 ?

[spackmat]

Yes, cloning belongs to #119. I mentioned that, because this would also be solved with a working import/export of single boards available in the backend.

[daveriedstra]

Hi! No action on this since end of October, it looks like. Trello is now prompting users to "update their account" & accept new Atlassian terms by April 1. Really wish I could import my Trello data to Deck so I don't have to!

[putt1ck]

It's still on our list, just there's a lot of things on it! I think the Deck API is more or less functionally complete from the import perspective, so our main focus would be the translation between Trello output and Deck features

[varac]

I already just lost data in one of my shared boards (whole list got accidenitally removed). The lack of a backup/restore (import/export) is quite a bummer, other apps like calendar/contacts support it and that already saved my ass in the past.
Please consider prioritizing it, a lot of ppl voted for this feature already.
I'm happy to top the bounty but it would be good to have a trustworthy bounty provider first (any news on that ?).

[varac]

This is the export script that I use: https://0xacab.org/-/snippets/928. It pulls all boards, details and cards and dumps them as json to stdout. Still better than nothing.

[th23x]

@varac Thanks for this snippet! Do you by any chance know such a script also for the restore of such dump?

[varac]

@varac Thanks for this snippet! Do you by any chance know such a script also for the restore of such dump?

@th23x The only reference I have is the original scipt (see #87 (comment)), which I only modified for my purposes. The original script copies over the decks from one to another NC instance, so it shouldn't be hard to modify the script to restore a backup to the original server. But I have not tried that so far.

[Klemet]

I just wanted to propose a small workaround for people worried of losing most of their information contained in their boards, like I do.

You can download your Deck boards as tasks list, and import them as tasks list if needed.

For this, you need three apps : Calendar, Tasks and Decks.

1. Go on Deck; open the options of Deck (bottom-left corner); enable "Show boards in calendars/tasks"
2. Go in tasks; for each of your deck, in the left menu of Tasks, click on the three dots and choose "download". This will download your board as a task list file (ics/Icalendar file).
3. If you lose data concerning your board, go in the Calendar app; open the option of Calendar (bottom-left corner); select "import calendar"; choose the Icalendar file corresponding to your board that you backup up; et voila. Now, you can transform those tasks back into board. Comments on each card are kept; I don't know about attached files.

This solution is, of course, very imperfect. I don't know how to automatize it; and if you do import your backup back into your nextcloud after a data loss, you still have to transform the board that is under the form of tasks back into the form of a board.

An import/export function directly for Decks would be wonderful indeed, and I'm really looking forward to it.

[dtcg]

I just wanted to propose a small workaround for people worried of losing most of their information contained in their boards, like I do.

You can download your Deck boards as tasks list, and import them as tasks list if needed.

For this, you need three apps : Calendar, Tasks and Decks.

1. Go on Deck; open the options of Deck (bottom-left corner); enable "Show boards in calendars/tasks"

2. Go in tasks; for each of your deck, in the left menu of Tasks, click on the three dots and choose "download". **This will download your board as a task list file** (ics/Icalendar file).

3. If you lose data concerning your board, go in the Calendar app; open the option of Calendar (bottom-left corner); select "import calendar"; choose the Icalendar file corresponding to your board that you backup up; _et voila_. Now, you can transform those tasks back into board. Comments on each card are kept; I don't know about attached files.

This solution is, of course, very imperfect. I don't know how to automatize it; and if you do import your backup back into your nextcloud after a data loss, you still have to transform the board that is under the form of tasks back into the form of a board.

An import/export function directly for Decks would be wonderful indeed, and I'm really looking forward to it.

Hey @Klemet , it all works apart from the last step.
So my imported boards all show up as tasks in the tasks app. Now, how to "transform tasks back into boards"? Manually?

[Klemet]

Yeah, this has to be done manually, @dtcg. That is why I consider this workaround as very imperfect. Still, you can copy/paste the cards's titles, tags and comments, allowing you to recreate the structure of your boads if needed.

[vitormattos]

I created this repository. I just rewrote this project in PHP.

Suggestions for next steps:

• Make a Deck Command
• Remove API requests and transform them into requests for Services classes
• Implement in json configuration a from/to Trello accounts for Deck accounts

Can I continue with the next steps?

[vitormattos]

I created a pull request to import a json file exported from a Trello board. I will be happy with the comments and code review.

[bugzy]

I have been waiting on this for a while so I decided to search github for implementations and it looks like some other folks have been tackling this issue in various ways. just thought to post this here for inspiration and ideas towards an official solution (Note: I have NOT tested any of these applications):

• https://github.com/newroco/DeckImportExport (this may just be a junk repo: an unmodified fork of an unrelated project)
• https://github.com/keitalbame/nextcloud-deck-export-import
• https://github.com/filipizydorczyk/next-cloud-deck-backup
• https://github.com/matchish/nextcloud-deck-transfer-ownership
• https://github.com/mclang/nextcloud-deck-import-trello-json
• https://github.com/jonasof/kb-to-nd

[vitormattos]

@bugzy on this #3182 I already imported everything that is possible from the Trello to the Deck. What is pending is the code review, who can cooperate will be good.

[bugzy]

@vitormattos great to hear that. Am I understanding correctly that your pull request addresses only trello JSON import and not NC Deck JSON import?

[vitormattos]

@bugzy I'm happy to help! :-D

The import I implemented accepts for now two methods:

• Trello JSON files. It has a limit of 1000 actions.
• Trello API. This is the most recommendable, it matters everything that is possible from Trello.

There are more details in the PR description and in the documentation that I implemented.

This PR I made opens the possibility to import from other board systems like Asana for example.

[sunjam]

edit: Seems import and export within Deck are not available yet. Just mentioning since the Pull Request that closed this is for Trello import.

Should a new issue be opened for Import Board ?
Export board #3065

[vitormattos]

Hi @sunjam ,
To import it is necessary to define from which system the data will be imported.
With #3182 I implemented the tool to import from Trello Json and Trello API and to make easy and possible implement the ETL to import probably from any board system.
The export already was implemented as a command (occ deck:export) and the frontend is WIP on #3065.

[juliusknorr]

I've wrapped the remaining parts into smaller and separated tickets

https://github.com/nextcloud/deck/issues?q=is%3Aopen+label%3Aenhancement+label%3A%22feature%3A+export%2Fimport%22

[Majed610]

I have one quick question, because my coding-experience is not the best.

In OCC after using the command deck:export (which use export a JSON dump of users Cards). Where is the exported file stored. I can't find it anywhere.

Would it function with the command deck:import on the new NextCloud ?

[gabmert]

Hi @Majed610, when you use occ deck:export the info gets dumped to standard output, usually your terminal. If you want to have it in a file, you could use following command, which is bash redirection occ deck:export > ~/deck-export.json.

If you follow above post you can see that the import function doesn't seem to be implemented yet.

[ne0YT]

so this (import) still just doesn't work? if so.. why are those issues closed? why are the docs suggesting otherwise? and if not.. how tf would I import?

[sunjam]

The remaining current issues were linked above, but here they are directly:

• Export through the UI #3508
• Import through the user interface #3506

[ne0YT]

@sunjam still there is no functional import using the ci. those remaining issues are about a ui feature

[sunjam]

All I know is they are occ commands for import and export. Listed above or in docs. https://deck.readthedocs.io/en/latest/User_documentation_en/#6-import-boards