CSV colum seperator

Post about your customizations to share with others.

Moderators: Developer, Contributor

Post Reply
bandrack
Posts: 7
Joined: 29 Feb 2008, 15:47

CSV colum seperator

Post by bandrack »

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
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Re: CSV colum seperator

Post by vboctor »

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
bandrack
Posts: 7
Joined: 29 Feb 2008, 15:47

Re: CSV colum seperator

Post by bandrack »

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.
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Re: CSV colum seperator

Post by vboctor »

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
bandrack
Posts: 7
Joined: 29 Feb 2008, 15:47

Re: CSV colum seperator

Post by bandrack »

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.
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Re: CSV colum seperator

Post by vboctor »

Great. Thanks for testing.
Migrate your MantisBT to the MantisHub Cloud
bandrack
Posts: 7
Joined: 29 Feb 2008, 15:47

Re: CSV colum seperator

Post by bandrack »

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
Post Reply