Import Trello JSON export

[gempain]

Hi,

It would be awesome if one can import in Planka a JSON file exported from Trello. This feature exists in Wekan (but wasn't fully working) and it is a huge obstacle which would ease adoption very much.

Keep up the great work !

Could be related to #22 but is not focused on the same topic.

[nickbe]

Imports are of course important but will have to wait until the basic structures are completely finished.

[christophenne]

Hi, I just discovered planka and it looks like a promising Trello alternative for me.

Regarding the Trello import, is someone already working on it? I'm thinking of doing it by myself and would happily contribute here if it works out, but if you tell me you're halfway through already, I'd rather wait.
Are the "basic structures" kind of finished? Or might there be breaking changes any time soon?

[meltyshev]

Hi!

There is still no import from Trello and we are not working on it at the moment. So it would be great if you could contribute 🙏

Regarding "basic structures" - yes, the current state is quite stable. There are no breaking changes expected in the near future.

[christophenne]

I've been analyzing a bit, and it seems there is not one major trello export, but multiple. You can export JSON for each board individually, and a general one, including some masterdata.
Another way would be to access trello directly via their API.

I don't know what would be best for the user, exporting a lot of files (depending on how many boarsd you have) and importing them seems tedious, but so does setting up a direct Trello API integration.

I'll be working on a first proof of concept in form of a command line tool, see trello2planka, to figure out the mapping from trello to planka data.
However I would be up for some input on how the user should interact with that whole process.

[christophenne]

Hi @meltyshev,

I'm done with a first proof of concept that is basically a command line api client -> trello2planka. Labels are still missing (and attachments, but these will be a bit more difficult since they are not included in a json export but only available via Trello API) - other than that it fulfills my personal needs.
However I would like to integrate it into the planka project, so that others can benefit of it too.

The technically most obvious way now would be to implement an "upload trello json" - component somewhere, and then have the react app read the json and fire the corresponding API calls against the backend. It could be either on project level (additionally to "Create Project" there could be a "Import from Trello"), or on board level (additionally to the "Create Board" an "Import from Trello").

The other option is to upload the file to the backend, and let the server do all the import logic.

Also, for now it's just a board-level import. An even more sophisticated option would be to connect to the Trello API and let the user pick multiple boards, without having to deal with the JSON export at all - but I think that would be way more complicated.

What are your thoughts? And are you missing anything substantial that should also be imported from Trello?

[meltyshev]

Hi!

Nice job, it works great 👍

You're right about integration, it would be easier to use. In this case, I would prefer to upload the entire json file to the server and do the import there. So we just need to «convert» your code to use server helpers to create everything and add a button to load a file when creating a board on the front-end.

I should also add a link to trello2planka in the readme.

[christophenne]

Alright, thanks! Then I'll start to work on this in the upcoming days.