Bug 37027 - Blanks in field date of birth confuse import
Blanks in field date of birth confuse import
Product: UCS@school
Classification: Unclassified
Component: UMC - CSV Import
UCS@school 3.2 R2
Other Linux
: P5 normal (vote)
: UCS@school 3.2 R2 Errata
Assigned To: Sönke Schwardt-Krummrich
Florian Best
: 36451 (view as bug list)
Depends on:
Blocks: 36450 37154 37155
  Show dependency treegraph
Reported: 2014-11-26 08:26 CET by Jan Christoph Ebersbach
Modified: 2015-02-27 15:18 CET (History)
3 users (show)

See Also:
What kind of report is it?: ---
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Blank in date of birth (121 bytes, text/csv)
2014-11-26 08:26 CET, Jan Christoph Ebersbach
Data consistency error (12.50 KB, image/png)
2014-11-26 08:27 CET, Jan Christoph Ebersbach

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Christoph Ebersbach univentionstaff 2014-11-26 08:26:54 CET
Created attachment 6470 [details]
Blank in date of birth

A customer reported that heading and trailing blanks in field date of birth confuse the CSV import in a way that it doesn't recognized the date anymore.  Everything looks fine when assigning columns but it breaks when the data is checked.

The attached file demonstrates the issue.
Comment 1 Jan Christoph Ebersbach univentionstaff 2014-11-26 08:27:30 CET
Created attachment 6471 [details]
Data consistency error
Comment 2 Sönke Schwardt-Krummrich univentionstaff 2014-12-03 09:47:23 CET
Stripping leading and trailing whitespace (space, tab, \n, \r) from all given values in the CSV file should fix this problem.
Comment 3 Jan Christoph Ebersbach univentionstaff 2014-12-09 12:52:03 CET
*** Bug 36451 has been marked as a duplicate of this bug. ***
Comment 4 Sönke Schwardt-Krummrich univentionstaff 2015-02-11 16:12:06 CET
Used the suggested patch. Found another similar misbehaviour that has been split off into bug 37776.

r57980 | Bug #37027: drop leading/trailing whitespaces from CSV cells to prevent simple syntax errors

ucs-school-umc-csv-import (1.0.24-1) unstable; urgency=low

Package has been rebuilt in scope ucs-school-3.2r2.
Comment 5 Sönke Schwardt-Krummrich univentionstaff 2015-02-12 17:45:02 CET
Changelog entry has been added
Comment 6 Florian Best univentionstaff 2015-02-16 14:35:40 CET
UCS@school 3.2 changes: OK
Changelog: OK
Comment 7 Sönke Schwardt-Krummrich univentionstaff 2015-02-27 15:18:37 CET
UCS@school 3.2 R2 v3 has been released:

If this error occurs again, please use "Clone This Bug".