Is there a way to change the colum seperator when exporting as csv? My german version of MS Excel needs a ';' as seperator.
Is there a wish list for new features in mantis?
I'm using Version 1.1.1 on WinXP
Best regards,
Ben
CSV colum seperator
Moderators: Developer, Contributor
Re: CSV colum seperator
You can change this in config_inc.php.
Code: Select all
# --- CSV Export ---------------
# Set the csv separator
$g_csv_separator = ';';
Migrate your MantisBT to the MantisHub Cloud
Re: CSV colum seperator
Thanks, that was easy.
Now I've got the same problem if I click 'Print reports' and then choose the Excel symbol. All the information is put into one field then.
Now I've got the same problem if I click 'Print reports' and then choose the Excel symbol. All the information is put into one field then.
Re: CSV colum seperator
The code in the main development branch (to be included in 1.2.0) supports exporting to Excel 2003 SP2 and above via a link on the View Issues page. This export uses the Excel XML format, and hence, I believe it should fix this issue for you. It would be great if you can get the latest Mantis code from trunk and test it. This way you can provide feedback on the feature.
Migrate your MantisBT to the MantisHub Cloud
Re: CSV colum seperator
Great job!
Excel Export works for me.
I just did a short test using Mantis 1.2.0-SVN, WinXP, MS Excel 2007 german version.
Regards.
Excel Export works for me.
I just did a short test using Mantis 1.2.0-SVN, WinXP, MS Excel 2007 german version.
Regards.
Re: CSV colum seperator
Another utf-8 problem.
If I use Mantis with german language, Excel doesn't show the special german characters correctly.
I had a look in the net. Some people say utf-8 isn't supported by excel at all and utf-16 is.
May be you could convert the file?
If you want to test it, here are 4 letters: test üöäß endtest
If I use Mantis with german language, Excel doesn't show the special german characters correctly.
I had a look in the net. Some people say utf-8 isn't supported by excel at all and utf-16 is.
May be you could convert the file?
If you want to test it, here are 4 letters: test üöäß endtest