Join the conversation

Sign in to join this conversation, and others like it, in the communities you care about.

Wekan

General

Wekan is an open-source kanban board (Trello like) which allows a card-based task and to-do management.

More active conversations

Wekan / General

Import CSV from Kanboard to Wekan not working

Import CSV from Kanboard to Wekan not working

Wekan/General · April 29, 2021 at 1:38pm

Ovidiu

@ovidiug-uga
rep
50

Import CSV from Kanboard to Wekan not working

Wekan / General · April 29, 2021 at 1:38pm

Hi ! I am working for UGA, a French University, and we are currently self-hosting Wekan (vers 5.26.0) on our servers. We are using it as a Trello and Kanboard alternative. We are trying to import all our boards from Trello and Kanboard. We didn't encounter any problems with Trello export-import. However, the same doesn't go with Kanboard. When we try to import a CSV (previously exported from Kanboard), it does not work (see screenshot bellow):

csv_kanboard_import_error.png

Is this "normal" or is it suppose to work ? Do we need to "work" (format/modify) a little bit the Kanboard csv export in order for it to work with Wekan ?

Thank you,

Load previous messages
April 29, 2021 at 2:52pm
Lauri Ojansivu@xet7
Team
2:52pm

It is import from Wekan CSV, not Kanboard CSV. Try modifying CSV to look like this https://raw.githubusercontent.com/brymut/github-gifs/master/wekan%3Awekan%3Aissues%3A395/board-import.csv

    • reply
    • like
    2:52pm

    CSV import was added here https://github.com/wekan/wekan/pull/3081

      • reply
      • like
      2:53pm

      Other way is to export Wekan board to JSON, and modify Kanboard CSV to Wekan JSON

        • reply
        • like
        2:54pm

        Wekan JSON also includes attachments as base64 encoded

          • reply
          • like
          2:55pm

          Wekan does not yet have direct feature of import/export Kanboard CSV

            • reply
            • like
            2:56pm

            Here is Wekan import/export code: wekanCreator, trelloCreator, export etc https://github.com/wekan/wekan/tree/master/models

              • reply
              • like
              2:58pm

              Here is export links https://github.com/wekan/wekan/blob/master/client/components/sidebar/sidebar.jade#L329

                • reply
                • like
                2:58pm

                And here https://github.com/wekan/wekan/blob/master/client/components/sidebar/sidebar.js#L236

                  • reply
                  • like
                  3:00pm

                  more related code can be found by:

                  git clone https://github.com/wekan/wekan
                  cd wekan
                  ./find.sh import
                  ./find.sh export
                    • reply
                    • like
                    3:01pm

                    And here is how to make pull request https://github.com/wekan/wekan/wiki/Emoji

                      • reply
                      • like
                      3:01pm

                      and build Wekan

                        • reply
                        • like
                        April 30, 2021 at 6:07am
                        Ovidiu@ovidiug-uga
                        6:07am

                        Hello Lauri!

                        Thank you for your quick reply. I will look into these solutions.

                        Have a good day !

                          • reply
                          • like
                          6:12am
                          reply
                          Lauri Ojansivu@xet7

                          It is import from Wekan CSV, not Kanboard CSV. Try modifying CSV to look like this https://raw.githubusercontent.com/brymut/github-gifs/master/wekan%3Awekan%3Aissues%3A395/board-import.csv

                            The import is from Kanboard to Wekan. But, indeed, in Wekan options, it is "import from". Not sure about it... Sorry, I'm not a native english native speaker.

                              • reply
                              • like
                              April 30, 2021 at 1:16pm
                              Lauri Ojansivu@xet7
                              Team
                              1:16pm

                              Hmm, Yes you are correct, it should be developed to import from any CSV, with mapping of CSV to card fields. I'll add feature request.

                                • reply
                                • like
                                1:35pm

                                I added Feature Request https://github.com/wekan/wekan/issues/3775

                                  like-fill
                                  1
                                  • reply
                                  • like