[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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.


"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:   compression library - runtime

kexi recommends no packages.

-- no debconf information

Reply to: