mahara-contributors team mailing list archive

[Mahara Bot <1393472@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/3992
Committed: http://gitorious.org/mahara/mahara/commit/7be6438a3908e41ed8bafbc7a3e3361ee4a14274
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    master

commit 7be6438a3908e41ed8bafbc7a3e3361ee4a14274
Author: Tobias Zeuch <tobias.zeuch@xxxxxxx>
Date:   Wed Nov 19 10:44:42 2014 +0100

Make CSV-Import autodetect delimiter

Bug 1393472: Automatically detect the delimiter used to store the fields in the
csv field. The problem this should solve is that Microsoft Excel uses a
semicolon instead of a comma if the language setting of Windows is set to
German.
The first line of the csv-file contains the header fields so we use that line
to check, if it contains a comma or a semicolon since none of these appears in
the header field names itself.

Change-Id: I833041eb2169fc5ccc9557e0debf3f03c8daf7cc
Signed-off-by: Tobias Zeuch <tobias.zeuch@xxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1393472

Title:
  CSV-Import: auto-test for separation character: Semicolon

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  This also came up on the Mahara Barcamp 2014: Microsoft Excel has the strange behavior to determine the separation character based on the system language setting, which for German users turns out to be a semicolon instead of a comma. Therefore, CSV-files generated on a German-set windows usually cannot be imported directly but have to be opened in a plaintext editor and the semicolons replaced by commas. Alternatively, the language setting in Windows(!) has to be changed before saving the document as CSV to export the file correctly. 
  Apparently, Moodle lets you specify if your file is semicolon-separated  but I think it should be easy to check automatically, if the first line is separated by commas or by semicolons.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1393472/+subscriptions