Chance of getting a definable CSV-seperator?

[laborg]

Hi!

Problem:
At the moment the import(and export) of CSV-files is limited to the "," seperator. Due to the fact that Excel uses ";" as immutable field-seperator in some European countries (for me: Austria) the import-function is not usefull by default.  Hacking all the MapField.php, Preview.php and Upload.php for all types of  imports (members, events...) isn't a very "clean" solution.

Possible solution:
Make a modifiable and global CSV-seperator. Could be set in Administer "CiviCRM -> Global Settings-> Localization".

Benefit:
A whole lot of European users could use the import function ...

I'm happy to see some response!
Gerhard

[Donald Lobo]

can u post an issue for this. we'll fix it in v2.1

ensure that you mention both import and export also link to this forum post from the issue

lobo

[laborg]

filed under:
http://issues.civicrm.org/jira/browse/CRM-2809

[xavier]

I implemented a trivial workaround a while ago, could you test see if it works on your side ?

http://issues.civicrm.org/jira/browse/CRM-2810

X+

[laborg]

Hi!

I didn't try the code but it looks reasonable. A drawback is that it's not helping with exporting CSV-files, so it's rather a hack than a viable solution for the future.

thx
Gerhard