wekan: Export Board to CSV / TSV throws error
On some boards, the Export to CSV / TSV feature is throwing a very generic error in the browser of ‘Couldn’t Download - Server Problem’. The logs show an error reading the length of something undefined. @brymut , are you able to help?
Logs:
2020-06-10T02:58:49Z wekan.wekan[2597]: (node:4095) UnhandledPromiseRejectionWarning: TypeError: Cannot read property ‘length’ of undefined 2020-06-10T02:58:49Z wekan.wekan[2597]: at models/export.js:88:32 2020-06-10T02:58:49Z wekan.wekan[2597]: at doCall (packages/meteorhacks_picker.js:128:14) 2020-06-10T02:58:49Z wekan.wekan[2597]: at PickerImp._processRoute (packages/meteorhacks_picker.js:122:5) 2020-06-10T02:58:49Z wekan.wekan[2597]: at processNextRoute (packages/meteorhacks_picker.js:90:14) 2020-06-10T02:58:49Z wekan.wekan[2597]: at processNextMiddleware (packages/meteorhacks_picker.js:78:7) 2020-06-10T02:58:49Z wekan.wekan[2597]: at PickerImp._dispatch (packages/meteorhacks_picker.js:72:3) 2020-06-10T02:58:49Z wekan.wekan[2597]: at packages/meteorhacks_picker.js:162:10 2020-06-10T02:58:49Z wekan.wekan[2597]: at /snap/wekan/893/programs/server/npm/node_modules/meteor/promise/node_modules/meteor-promise/fiber_pool.js:43:40 2020-06-10T02:58:49Z wekan.wekan[2597]: (node:4095) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag
--unhandled-rejections=strict(see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 42)
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Comments: 62 (39 by maintainers)
Commits related to this issue
- Try to prevent errors on CSV/TSV export. Thanks to xet7 ! Related #3173 — committed to wekan/wekan by xet7 4 years ago
- Add back checks about can user export CSV/TSV. Thanks to marc1006 and xet7 ! Related #3173 — committed to wekan/wekan by xet7 4 years ago
- Exports now work at #3173 at least for small boards. TODO: Fix EdgeHTML to work, before I can release this. Thanks to xet7 ! — committed to wekan/wekan by xet7 4 years ago
- Fixed CSV/TSV export. Please test. Thanks to xet7 ! Related #3173 — committed to wekan/wekan by xet7 4 years ago
- Export to Excel XLSX. Does work, but does not export all fields yet correctly. In Progress. Thanks to gameendman, alfredgu and xet7 ! Related #3173 — committed to wekan/wekan by xet7 3 years ago
- Added many more fields to Export to Excel, and better formatting. Does not yet have all fields. Thanks to xet7 ! Related #3173 — committed to wekan/wekan by xet7 3 years ago
I confirm that export does work with wekan 4.22 on a ~300KB board and a ~800KB board (JSON output size).
Thanks for the quick fix 👍
@papimla
Yes, new Wekan release with fix for JSON export will come sometime today or tomorrow.
Sorry, i was vague.
It’s an error downloading, just chrome / edge saying there’s a server error and that the download failed.
I’m not sure I have an answer to your second question.
And I have tried Exporting to Excel, we LOVE it. However, it doesn’t include custom fields right now and we have deliverables that rely on us including the custom fields in our export. If all the fields are exported in the excel export we’d be overjoyed. I’d wet myself with joy!
I’m getting a different result
Both large and small boards with custom fields are working for me (i could kiss @xet7)
The only teeny tiny hiccup i’m getting is that for some odd reason excel isn’t recognizing the comma’s in the CSV correctly, it’s literally doing a line and seperating the values with comma’s but not into columns.
i commended before i looked at your roadmap, then deleted my comment.
you’re a lifesaver. I shall name my first born after you
“xet7” has a nice ring to it…
Problem currently is, that with export fixes, EdgeHTML (Microsoft Legacy Edge browser) does not load Wekan webpage. There are no errors in Chrome. And when I try to start Edge developer tools, developer tools do not open. Someone could test this docker image:
using docker-compose.yml from https://github.com/wekan/wekan
I did try that pull request that is at https://github.com/adaltas/node-csv-stringify/pulls , it did not fix it. There are some issues at https://github.com/adaltas/node-csv-stringify/issues .
On that docker image above, all export options do work, at least for small boards. But I would like to not break EdgeHTML support, because then my Microsoft Store app on Windows 10 desktop would not open at all, because it requires EdgeHTML support.
Thanks @brymut !!
I did send you JSON file. You can test with it export big board to CSV, and import that big CSV back to Wekan.
@brymut
Please send email to support@wekan.team so I get your email address, and then I can send you example exported Wekan board JSON file. Thanks!