XLS export plugin
Added by Vitaly Klimov over 14 years ago
Up to date plugin page¶
http://www.redmine.org/plugins/redmine_xls_export
XLS export plugin¶
With the help of this plugin you can export issues list with all information to XLS file. Also it is possible to export issues with attachments as a ZIP archive.
Requirements¶
Plugin requires Redmine version 1.3.0 or higher.
Plugin relies on spreadsheet gem for XLS based operations. Please install this gem before running plugin. Also if you want to use attachments export you should install rubyzip gem.
Features¶
- Export active or all columns
- Export issue descriptions
- Export journal entries - both inline or as separate file per each issue
- Export relations information
- Export spent time data
- List attachments information
- Export attachments
- Export watchers
- Split information by sheets based on grouping criteria
- Correct formatting and width of worksheet cells
Details¶
Plugin adds following links with 'XLS export:' prefix at the bottom of the page under 'Also available in' bar:
- Quick
One click export to XLS using default export settings from plugin configuration screen - Detailed
Brings up dialog where user can choose export options before export
Installation and Setup¶
- Install spreadsheet gem ('gem install spreadsheet')
- Install rubyzip gem if you want to use export attachments feature
- Install plugin Plugin views with revisions if you do not have it installed
- Follow the Redmine plugin installation steps at: http://www.redmine.org/wiki/redmine/Plugins
- Run rake task
rake redmine:plugins:process_version_change RAILS_ENV=production - Login and configure the plugin (Administration > Plugins > Configure)
Replies (276)
RE: XLS export plugin
-
Added by Peng Wang over 13 years ago
Here comes the Chinese translation.
Br
-Peng
RE: XLS export plugin
-
Added by Terence Mill over 13 years ago
Terence Mill wrote:
BUG Report for 0.1.1
When clicking on Detailed XLS Export i get "Internal Error" and following message in log
[...]
The buf is solved now, but you took the nione updated german trasnlation - i posted an update yet after the first upload, that is more up to date.
I would like to make a feature request:
- Optionally Export als Comments (history), not only the latest value of the description field. This is needed because it is context for the whole ticket and needful to understand the history and have it with offline an mobile in exported report.
- expoprt attachments as http links to the original documents, so you can click them for download. It would be adavanced even to configure a regexp to replace default https://redmine.domain/attachments/290/file.txt with eg. a webdav access, like "https://redmine.domain/webdav/files/attachments"
RE: XLS export plugin
-
Added by Tatsuya Saito over 13 years ago
Thanks great works :)
I created Japanese translation and put in following github:
https://github.com/two-pack/redmine_xls_export/blob/master/config/locales/ja.yml
RE: XLS export plugin
-
Added by Vitaly Klimov over 13 years ago
Terence Mill wrote:
The buf is solved now, but you took the nione updated german trasnlation - i posted an update yet after the first upload, that is more up to date.
I checked both posts - the files are identical - it seems that you uploaded same version twice.
- Optionally Export als Comments (history), not only the latest value of the description field. This is needed because it is context for the whole ticket and needful to understand the history and have it with offline an mobile in exported report.
Should be relatively easy to do. Will do it as soon as i have some spare time.
- expoprt attachments as http links to the original documents, so you can click them for download. It would be adavanced even to configure a regexp to replace default https://redmine.domain/attachments/290/file.txt with eg. a webdav access, like "https://redmine.domain/webdav/files/attachments"
Same as above.
RE: XLS export plugin
-
Added by Vitaly Klimov over 13 years ago
Updated to version 0.1.3. See plugin page
RE: XLS export plugin
-
Added by Anson Chen over 13 years ago
Hi, I created a traditional chinese tranlation. It is converted from simplified chinese by cconv tool.
You can get the file from https://github.com/jvmgroup/redmine_xls_export/raw/master/config/locales/zh-TW.yml.
RE: XLS export plugin
-
Added by Eddy Edisys over 13 years ago
Hello,
I'm trying to install this wonderful plugin but when I use it, I've got an error 500.
I've installed Redmine v1.1.1 and the last version of xls export plugin.
In the redmine log, I've got this error :
Processing IssuesController#xls_export_action (for x.x.x.x at 2011-05-10 18:25:44) [POST]
Parameters: {"project_id"=>"xxxxx", "commit"=>"Export", "action"=>"xls_export_action", "authenticity_token"=>"xxxxxxxxxxxxxxxxxxx", "controller"=>"issues", "settings"=>{"export_name"=>"issues_export", "issues_limit"=>"0", "watchers"=>"1", "relations"=>"1", "time"=>"1", "description"=>"1", "group"=>"1", "query_columns_only"=>"1", "attachments"=>"1"}}
NoMethodError (undefined method `count' for #<Spreadsheet::Row:0x5fd9314>):
Rendering xxxxxxxxxxxx/public/500.html (500 Internal Server Error)
Does anybody have an idea ?
Thanks
RE: XLS export plugin
-
Added by Terence Mill over 13 years ago
Check if you installed gem "spreadsheet" sucessfully .
RE: XLS export plugin
-
Added by Eddy Edisys over 13 years ago
Thnak you for the reply but, yes I did. The 0.6.5.4 version.
By the way, I've installed Redmine on windows XP.
Any other idea ?
RE: XLS export plugin
-
Added by Tomasz Sawicki over 13 years ago
Same error here:(
NoMethodError (undefined method `count' for #<Spreadsheet::Row:0x2b19d06f7a60>): /usr/lib/ruby/1.8/thread.rb:135:in `synchronize' thin (1.2.11) lib/thin/connection.rb:84:in `pre_process' thin (1.2.11) lib/thin/connection.rb:82:in `catch' thin (1.2.11) lib/thin/connection.rb:82:in `pre_process' thin (1.2.11) lib/thin/connection.rb:57:in `process' thin (1.2.11) lib/thin/connection.rb:42:in `receive_data' eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine' eventmachine (0.12.10) lib/eventmachine.rb:256:in `run' thin (1.2.11) lib/thin/backends/base.rb:61:in `start' thin (1.2.11) lib/thin/server.rb:159:in `start' thin (1.2.11) lib/thin/controllers/controller.rb:86:in `start' thin (1.2.11) lib/thin/runner.rb:185:in `send' thin (1.2.11) lib/thin/runner.rb:185:in `run_command' thin (1.2.11) lib/thin/runner.rb:151:in `run!' thin (1.2.11) bin/thin:6 /usr/bin/thin:19:in `load' /usr/bin/thin:19 Rendering /opt/redmine/public/500.html (500 Internal Server Error)
Versions:
redmine (1.1.3.stable.5761)
ruby (1.8.7)
actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.5)
activeresource (2.3.5)
activesupport (2.3.5)
cgi_multipart_eof_fix (2.5.0)
coderay (0.9.8)
daemons (1.1.3)
eventmachine (0.12.10)
i18n (0.4.2)
pg (0.9.0)
rack (1.0.1)
rails (2.3.5)
rake (0.8.7)
ruby-ole (1.2.11.1)
spreadsheet (0.6.5.4)
thin (1.2.11)
RE: XLS export plugin
-
Added by Andreas Dijkman over 13 years ago
I've installed this plugin on a fresh 1.1.3-installation. However the plugin can't work together with the other plugin of the same developer, Extra query operators plugin. Has anybody else problems with this?
What I'm seeing is either one is working. Or the XLS-plugin or the Extra Query Options, but not both at the same time.
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Excellent plugin, but wants one feature: make mark subissues like in html one. Author, is it possible?
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Alex A wrote:
Excellent plugin, but wants one feature: make mark subissues like in html one. Author, is it possible?
This is a pacth file that mark subissues like in html.
To apply patch
cd redmine/vendor/plugins/redmine_xls_export/lib patch xls_export.rb /path_to_the_patch_file/xls_export.rb.patch
xls_export.rb.patch (2.35 KB) xls_export.rb.patch |
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Terence Mill wrote:
Can u post a screenshot.. tx
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Another visrsion of my patch
1.GIF (11.2 KB) 1.GIF | |||
xls_export.rb.patch (1.22 KB) xls_export.rb.patch |
RE: XLS export plugin
-
Added by Alex A about 13 years ago
sorry, the last patch doesn`t work correctly, it`s have a formatting problems
RE: XLS export plugin
-
Added by Alex A about 13 years ago
This is resolved patch #2
xls_export.rb.patch (1.87 KB) xls_export.rb.patch |
RE: XLS export plugin
-
Added by Terence Mill about 13 years ago
Its not working on redmine 1.1.2 and office 2010
RE: XLS export plugin
-
Added by Terence Mill about 13 years ago
Sory. this is too much pacthes now. Getting patch order errors..
Please post the whole file,s o we can test it
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Terence Mill wrote:
Sory. this is too much pacthes now. Getting patch order errors..
Please post the whole file,s o we can test it
This is whole file
xls_export.rb (9.72 KB) xls_export.rb |
RE: XLS export plugin
-
Added by Terence Mill about 13 years ago
Still not working .. Which excel version your are using?
Seems that that the only thing is doing, is that makuing the whole row fat
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Tested on redmine 1.2, ms excel 2007, 2010, open office calc 3.
Do you have issues hierarchy on html issues list?