CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Chance of getting a definable CSV-seperator?
Pages: [1]

Author Topic: Chance of getting a definable CSV-seperator?  (Read 5207 times)

laborg

  • Guest
Chance of getting a definable CSV-seperator?
March 06, 2008, 02:43:25 am
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Chance of getting a definable CSV-seperator?
March 06, 2008, 04:21:27 am

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

laborg

  • Guest
Re: Chance of getting a definable CSV-seperator?
March 06, 2008, 06:01:46 am
filed under:
http://issues.civicrm.org/jira/browse/CRM-2809

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Chance of getting a definable CSV-seperator?
March 06, 2008, 06:05:09 am
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+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

laborg

  • Guest
Re: Chance of getting a definable CSV-seperator?
March 06, 2008, 08:30:12 am
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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Chance of getting a definable CSV-seperator?

This forum was archived on 2017-11-26.