Bug#475671: kexi: csv import fails with type "date"
Package: kexi
Version: 1:1.6.3-5+b1
Severity: normal
If a comma-separated-value file, which contains a column of type "date", is
imported into kexi, the column will be changed into type "text".
It does not matter, whether type "date" is automatically recognized by the
import routine or manually selected by the user, the result will always be of
type "text". It is not possible to change the type later into "date", because
then kexi will loose all data.
Example:
"id", "familyname", "firstname", "birthday"
1, "Simpson", "Homer", "1970-11-11"
2, "Simpson", "Marge", "1974-01-01"
3, "Simpson", "Bart", "1998-04-01"
4, "Simpson", "Lisa", "2000-05-08"
5, "Simpson", "Maggie", "2007-05-06"
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.24-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages kexi depends on:
ii kdelibs4c2a 4:3.5.9.dfsg.1-2+b1 core libraries and binaries for al
ii koffice-libs 1:1.6.3-5+b1 common libraries and binaries for
ii libacl1 2.2.45-1 Access control list shared library
ii libart-2.0-2 2.3.20-1 Library of functions for 2D graphi
ii libattr1 1:2.4.41-1 Extended attribute shared library
ii libaudio2 1.9.1-2 Network Audio System - shared libr
ii libc6 2.7-10 GNU C Library: Shared libraries
ii libfam0 2.7.0-13.2 Client library to control the FAM
ii libfontconfig1 2.5.0-2 generic font configuration library
ii libfreetype6 2.3.5-1+b1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.3.0-1 GCC support library
ii libice6 2:1.0.4-1 X11 Inter-Client Exchange library
ii libidn11 1.4-1 GNU libidn library, implementation
ii libjpeg62 6b-14 The Independent JPEG Group's JPEG
ii libmysqlclient15off 5.0.51a-3 MySQL database client library
ii libpng12-0 1.2.15~beta5-3 PNG library - runtime
ii libpqxx-2.6.9ldbl 2.6.9-5 C++ library to connect to PostgreS
ii libqt3-mt 3:3.3.8b-5 Qt GUI Library (Threaded runtime v
ii libreadline5 5.2-3 GNU readline and history libraries
ii libsm6 2:1.0.3-1+b1 X11 Session Management library
ii libstdc++6 4.3.0-1 The GNU Standard C++ Library v3
ii libx11-6 2:1.0.3-7 X11 client-side library
ii libxcursor1 1:1.1.9-1 X cursor management library
ii libxext6 2:1.0.4-1 X11 miscellaneous extension librar
ii libxft2 2.1.12-2 FreeType-based font drawing librar
ii libxi6 2:1.1.3-1 X11 Input extension library
ii libxinerama1 2:1.0.3-1 X11 Xinerama extension library
ii libxrandr2 2:1.2.2-1 X11 RandR extension library
ii libxrender1 1:0.9.4-1 X Rendering Extension client libra
ii libxt6 1:1.0.5-3 X11 toolkit intrinsics library
ii zlib1g 1:1.2.3.3.dfsg-11 compression library - runtime
kexi recommends no packages.
-- no debconf information
Reply to: