Excel export : all issues are not exported

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
plume7
Posts: 28
Joined: 28 Sep 2006, 10:03

Excel export : all issues are not exported

Post by plume7 »

Hello,

With Mantis 1.0.0a2, I try to export all my issues to Excel.

First, I list all my issues with View Issues
Then, I use the Print Report link, then select the Excel icon.
Only 1143 issues among 1423 are exported !

(Using the Excel export link, all issues are exported, but in that case all fields are not exported. So this way does not satisfy me)

Has anybody an idea to solve that?

Thanks.
plume7
Posts: 28
Joined: 28 Sep 2006, 10:03

Re: Excel export : all issues are not exported

Post by plume7 »

Hello,
I upgraded to Mantis 1.0.8 and have still the same probelm.
Can anybody help?
BR,
Laurent
deboutv
Posts: 507
Joined: 15 Jan 2007, 14:31
Location: La Ciotat, FRANCE
Contact:

Re: Excel export : all issues are not exported

Post by deboutv »

Open the exported file with notepad and post here the last lines.
Want more plugins to customize Mantis?
=> http://deboutv.free.fr/mantis/

Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
plume7
Posts: 28
Joined: 28 Sep 2006, 10:03

Re: Excel export : all issues are not exported

Post by plume7 »

Here are the last lines :
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>2680</td>
<td class=xl26>BO</td>
<td class=xl26>minor</td>
<td class=xl26>always</td>
<td class=xl26>11-23-07 10:15</td>
<td class=xl26>11-27-07 09:40</td>
<td class=xl26>Denis Gadais</td>
<td class=xl26>Yves Lothier</td>
<td class=xl26>normal</td>
<td class=xl26>feedback</td>
<td class=xl26>&nbsp;</td>
<td class=xl26>none</td>
<td class=xl26>none</td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'>&nbsp;</td>
<td class=xl26>0.9.7.0</td>
<td class=xl26>open</td>
<td class=xl26>0</td>
<td class=xl26>Rafraichissement VVMS bug</td>
<td class=xl26 colspan=3 style='mso-ignore:colspan'>Le rafraichissement de la
vue d'assemblage de VVMS Bug, les images disparaissent</td>
<td class=xl26>Rafraichissement VVMS bug.doc (216 <span style='display:none'>KB)
01-01-70 01:33</span></td>
<td colspan=3 class=xl25 width=541 style='width:406pt'>&nbsp;</td>
<td class=xl25 width=97 style='width:73pt'>Anomalie</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'>&nbsp;</td>
<td class=xl25 width=147 style='width:110pt'>VVMS</td>
<td class=xl25 width=168 style='width:126pt'>[None]</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'>&nbsp;</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>2675</td>
<td class=xl26>BO</td>
<td class=xl26>minor</td>
<td class=xl26>always</td>
<td class=xl26>11-22-07 15:09</td>
<td class=xl26>11-27-07 09:38</td>
<td class=xl26>Martine Roussel</td>
<td class=xl26>Grégory Lussu</td>
<td class=xl26>normal</td>
<td class=xl26>assigned</td>
<td class=xl26>&nbsp;</td>
<td class=xl26>none</td>
<td class=xl26>none</td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'>&nbsp;</td>
<td class=xl26>0.9.7.0</td>
<td class=xl26>open</td>
<td class=xl26>0</td>
<td class=xl26>Refreshing Squelette tree in CDMS ha<span style='display:none'>s
no effect.</span></td>
<td class=xl26 colspan=3 style='mso-ignore:colspan'>User gets the following
message : "votre arbre n'est pas à jour. Veuillez rafraîchir."
because another user worked o<span style='display:none'>n it. Trying several
times : no effect. User needs to close CDMS</span></td>
<td class=xl26>refresh.doc (179 KB) 01-01-70 01:33</td>
<td class=xl26>Dominique Guillot</td>
<td class=xl26>11-24-07 14:28</td>
<td class=xl26>Planned</td>
<td class=xl25 width=97 style='width:73pt'>Anomalie</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'>&nbsp;</td>
<td class=xl25 width=147 style='width:110pt'>CDMS</td>
<td class=xl25 width=168 style='width:126pt'>[None]</td>
<td class=xl25>&nbsp;</td>
<td colspan=4 class=xl24 style='mso-ignore:colspan'>&nbsp;</td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=39 style='width:29pt'></td>
<td width=67 style='width:50pt'></td>
<td width=62 style='width:47pt'></td>
<td width=142 style='width:107pt'></td>
<td width=113 style='width:85pt'></td>
<td width=113 style='width:85pt'></td>
<td width=133 style='width:100pt'></td>
<td width=172 style='width:129pt'></td>
<td width=73 style='width:55pt'></td>
<td width=79 style='width:59pt'></td>
<td width=37 style='width:28pt'></td>
<td width=73 style='width:55pt'></td>
<td width=39 style='width:29pt'></td>
<td width=61 style='width:46pt'></td>
<td width=65 style='width:49pt'></td>
<td width=79 style='width:59pt'></td>
<td width=112 style='width:84pt'></td>
<td width=142 style='width:107pt'></td>
<td width=87 style='width:65pt'></td>
<td width=256 style='width:192pt'></td>
<td width=256 style='width:192pt'></td>
<td width=256 style='width:192pt'></td>
<td width=256 style='width:192pt'></td>
<td width=256 style='width:192pt'></td>
<td width=172 style='width:129pt'></td>
<td width=113 style='width:85pt'></td>
<td width=256 style='width:192pt'></td>
<td width=97 style='width:73pt'></td>
<td width=127 style='width:95pt'></td>
<td width=56 style='width:42pt'></td>
<td width=100 style='width:75pt'></td>
<td width=127 style='width:95pt'></td>
<td width=111 style='width:83pt'></td>
<td width=147 style='width:110pt'></td>
<td width=168 style='width:126pt'></td>
<td width=147 style='width:110pt'></td>
<td width=214 style='width:161pt'></td>
<td width=141 style='width:106pt'></td>
<td width=111 style='width:83pt'></td>
<td width=203 style='width:152pt'></td>
</tr>
<![endif]>
</table>

</body>

</html>

BR, Laurent
plume7
Posts: 28
Joined: 28 Sep 2006, 10:03

Re: Excel export : all issues are not exported

Post by plume7 »

Just to complete: only the first 526 issues are exported among 1761
I choose the Open (Excel) option on the File download window.
The last issue is not fully exported

All issues are visible on the print_all_bug_page.php page, but not all are exported to Excel.
It looks like a timeout or a limitation to the export up to 1.81Mo.

Trying with a filter, 602 issues filtered, 571 exported, 1.66Mo, option Open
Moreover I tried this with the Save option, 1.75Mo, and got a bad result excel file, still uncomplete and with surely an off-setting, names appear in the ID field ...

Thank for your help.

BR, Laurent
deboutv
Posts: 507
Joined: 15 Jan 2007, 14:31
Location: La Ciotat, FRANCE
Contact:

Re: Excel export : all issues are not exported

Post by deboutv »

Try to increase max_execution_time in your php.ini.
Want more plugins to customize Mantis?
=> http://deboutv.free.fr/mantis/

Mantis: 1.1.0, 1.1.0a2
PHP: 5.0.4
SQL: MySQL 5.0.19
OS: Linux
plume7
Posts: 28
Joined: 28 Sep 2006, 10:03

Re: Excel export : all issues are not exported

Post by plume7 »

Thank you very much, this variable setting solved my problem.

BR, Laurent
Post Reply