View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003728 | mantisbt | other | public | 2004-04-07 05:35 | 2004-05-17 10:26 |
Reporter | astax | Assigned To | vboctor | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 0.18.2 | ||||
Summary | 0003728: CSV export shows " instead of real quotes in bug title | ||||
Description | When clicking "CSV export" link on bugs list page, resulting file contains " instead of real quotes in "summary" column. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
I re-implemented csv export in CVS code, and I think I fixed this problem. Check it out and let me know if you find any issues. |
|
Sorry, I'm not familiar with mantis CVS tree and don't know how to get latest snapshot. Can anybody else test this? |
|
Backup your csv_export.php, then copy the two files in the zip file to your Mantis directory. They should work with 0.18.2 (I think). |
|
Yes, this fixed the problem with quotes, thank you. But now when I'm opening resulting CSV file in Excel (Office 2000 russian, bild 9.0.2812) it says "SYLK: invalid file format". I had already seen this problem earlier. It's caused by capitals in header line: If I manually replace "ID" with "id" or even "Id", file is open without any problems. I believe Excel tries to identify file format and for some reason thinks it's not CSV, but SYLK. |
|
This problem is described in Microsoft Knowledge Base As you can see it applies to all versions of MS Office, so I think it's reasonable to make a workaround for this. Probably just slightly changing name of the first column - Bug ID, Id, ID or whatever. |
|
Fixed in CVS. Will be available in the next release. Thanks astax for chasing up the SYLK problem. |
|
MantisBT: master 39631f16 2004-04-08 07:05 Details Diff |
Fix 0003728: CSV export shows " instead of real quotes in bug title. M csv_export.php - The main bug was fixed in the re-implementation of the csv export done earlier. - This commit fixes the error "SYLK: invalid file format" error that used to be prompted by Excel. git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@2482 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9 |
Affected Issues 0003728 |
|
mod - csv_export.php | Diff File | ||
mod - doc/ChangeLog | Diff File |