Bug 37027 – Blanks in field date of birth confuse import

Bug 37027 - Blanks in field date of birth confuse import


Summary:	Blanks in field date of birth confuse import

Status:	CLOSED FIXED

Product:	UCS@school
Classification:	Unclassified
Component:	UMC - CSV Import
Version:	UCS@school 3.2 R2
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	UCS@school 3.2 R2 Errata
Assigned To:	Sönke Schwardt-Krummrich
QA Contact:	Florian Best

URL:
Keywords:

Duplicates:	36451 (view as bug list)
Depends on:
Blocks:	36450 37154 37155
	Show dependency tree / graph

Reported:	2014-11-26 08:26 CET by Jan Christoph Ebersbach
Modified:	2015-02-27 15:18 CET (History)
CC List:	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:

Attachments
Blank in date of birth (121 bytes, text/csv) 2014-11-26 08:26 CET, Jan Christoph Ebersbach	Details
Data consistency error (12.50 KB, image/png) 2014-11-26 08:27 CET, Jan Christoph Ebersbach	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Jan Christoph Ebersbach

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

2014-11-26 08:27:30 CET

Created attachment 6471 [details]
Data consistency error

Comment 2 Sönke Schwardt-Krummrich

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

2014-12-09 12:52:03 CET

*** Bug 36451 has been marked as a duplicate of this bug. ***

Comment 4 Sönke Schwardt-Krummrich

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

2015-02-12 17:45:02 CET

Changelog entry has been added

Comment 6 Florian Best

2015-02-16 14:35:40 CET

UCS@school 3.2 changes: OK
Changelog: OK

Comment 7 Sönke Schwardt-Krummrich

2015-02-27 15:18:37 CET

UCS@school 3.2 R2 v3 has been released:
http://docs.univention.de/release-notes-ucsschool-3.2R2v3-de.html

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