Page 1 of 1

Excel export : all issues are not exported

Posted: 18 Oct 2007, 13:40
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.

Re: Excel export : all issues are not exported

Posted: 13 Dec 2007, 08:21
by plume7
Hello,
I upgraded to Mantis 1.0.8 and have still the same probelm.
Can anybody help?
BR,
Laurent

Re: Excel export : all issues are not exported

Posted: 17 Dec 2007, 07:40
by deboutv
Open the exported file with notepad and post here the last lines.

Re: Excel export : all issues are not exported

Posted: 17 Dec 2007, 09:31
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

Re: Excel export : all issues are not exported

Posted: 17 Dec 2007, 09:58
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

Re: Excel export : all issues are not exported

Posted: 17 Dec 2007, 11:00
by deboutv
Try to increase max_execution_time in your php.ini.

Re: Excel export : all issues are not exported

Posted: 18 Dec 2007, 09:37
by plume7
Thank you very much, this variable setting solved my problem.

BR, Laurent