← Back to team overview

mahara-contributors team mailing list archive

[Bug 1393472] Re: CSV-Import: auto-test for separation character: Semicolon

 

I don't see the necessity for a confirmation. The first line that
defines the fields to import has a pretty strict syntax, we have a
couple of fields that are required and we have a fixed set of fields
that are valid. If one of the required fields is not identifiable or an
invalid field appears, the import is canceled. So basically the first
line of a valid input file can only contain semicolons or commas but
never both. Or am I missing something?

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

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


References