Export cvs doesn't work with German Excel

[tronics]

Hello!

Ok the reason is that German Excel uses the locale Listseperator. http://www.google.at/search?q=tuwis&...ient=firefox-a

However the clients will not want to adapt their system settings for this to work.

However is there a workaround. Where can I change it in SugarCRM which file has to be adapted?
I will post updates if I get it running.

Thanks.

Regards,
tronics

[clint]

In Germany, the export file delimiter is ";" rather than the "," used in other countries. So you just need to go into your My Account settings page and change your "Export Delimiter" value to ";".

You can also do this system-wide in the Admin->Locale Settings screen.

[tronics]

Thank you, that helped me to get into the right direction.

However I was not able to save my uservalue. So I could not use your information directly
The saving button does not work on my Release Candidate.

--

Then I realised that I want to hack it for all users and came to this solution:

/include/export_utils.php

Link 48
function getDelimiter() {
global $sugar_config;
global $current_user;
$delimiter = ';'; // default to "comma"
return $delimiter;
}

Yeah it is aggressive but it works

Regards,
tronics

[rzhou]

tronics,

Could you please let us know what browser and which release candidate (1-4) you used?

Thanks.

Thank you, that helped me to get into the right direction.

However I was not able to save my uservalue. So I could not use your information directly
The saving button does not work on my Release Candidate.

--

Then I realised that I want to hack it for all users and came to this solution:

/include/export_utils.php

Link 48
function getDelimiter() {
global $sugar_config;
global $current_user;
$delimiter = ';'; // default to "comma"
return $delimiter;
}

Yeah it is aggressive but it works

Regards,
tronics

[tronics]

Thanks for feedback and asking.

Version 5.5.0beta2 (Build 6523)

I have uploaded a screenshot of all values in there:
http://img109.imageshack.us/img109/9534/unbenannt3r.jpg

There is no errormessage when I try to klick the submit button. Also no loading starts or something.

Is it a common problem that the account form cannot be saved?
The only modification (module) is a German language pack.

One problem could be that I have too many tabs hidden but the translation doesn't show the error message.
But I doubt it.

Regards

[clint]

You will definitely want to move to Sugar 5.5 RC4. We were not able to reproduce the user saving issue in RC4. However, please note that the Sugar betas are not production ready and there is no upgrade package from the 5.5 beta 2. They are just for testing. You will need to install the 5.5 RC4 build and export/import any data and customizations from the beta version you're working with to the latest Sugar 5.5 build.