mahara-contributors team mailing list archive

[Tobias Zeuch <tobias.zeuch@xxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
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:
  New

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