How to configure Excel export?

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
karl.reichert
Posts: 38
Joined: 02 Apr 2009, 12:22

How to configure Excel export?

Post by karl.reichert »

Hello all,

is there a way to configure the excel export in Mantis? Which options do I have?

Thanks
Karl
Mantis: 1.2.1
OS: Windows Server 2003 R2
WampServer 2.0g-1 [03/12/09]
Includes :
- Apache 2.2.11
- MySQL 5.1.36
- PHP 5.2.11
atrol
Site Admin
Posts: 8553
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to configure Excel export?

Post by atrol »

AFAIK, this is not possible with MantisBT 1.1.x by configuration, you would have to tweak the code.
With 1.2.x this is possible in page "My Account" -> "Manage Columns"

Alternative for 1.1.x: Use CSV-Export which can be configured the same way like configuring view issues page which is exlained at
http://www.mantisbt.org/forums/viewtopic.php?f=4&t=8621

Just replace "view_issues_page_columns" by "csv_columns"
Please use Search before posting and read the Manual
karl.reichert
Posts: 38
Joined: 02 Apr 2009, 12:22

Re: How to configure Excel export?

Post by karl.reichert »

Looks good, but where do I find the names of the columns?

For example, I tried the following for csv_columns:

Code: Select all

array (
  0 => 'id',
  1 => 'category',
  2 => 'summary',
  3 => 'description',
  4 => 'additional_info',
  5 => 'severity',
  6 => 'reporter',
  7 => 'tags',
  8 => 'status',
  9 => 'comments',
)
It works fine until row 3:

Code: Select all

ID,Kategorie,Zusammenfassung,<br />
<b>Fatal error</b>:  Call to undefined function print_column_title_description() in <b>C:\wamp\www\Mantis\csv_export.php</b> on line <b>83</b><br />
So obviously 'description' is not the correct name. Where can I find all the possible names which can be used here?
Mantis: 1.2.1
OS: Windows Server 2003 R2
WampServer 2.0g-1 [03/12/09]
Includes :
- Apache 2.2.11
- MySQL 5.1.36
- PHP 5.2.11
atrol
Site Admin
Posts: 8553
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to configure Excel export?

Post by atrol »

for the names of the columns, have a look at core/columns_api.php

But I found that extended fields ar not implemented in 1.1.x
Which means, you can not use at least:
'description'
'steps_to_reproduce'
'additional_information'

Do you use your MantisBT installation for evaluation or production environment?

In case of evalutation, I would recommend to go on with 1.2.x
Please use Search before posting and read the Manual
Post Reply