Bug 363068 - Can't change table field type to Time
Summary: Can't change table field type to Time
Status: RESOLVED UPSTREAM
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 2.9.11
Platform: Arch Linux Linux
: NOR normal
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
: 371894 (view as bug list)
Depends on:
Blocks:
 
Reported: 2016-05-14 13:54 UTC by Albrecht Will
Modified: 2018-12-31 12:34 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
during cvs-import (17.93 KB, image/png)
2016-05-14 13:55 UTC, Albrecht Will
Details
result in form (5.08 KB, image/png)
2016-05-14 13:56 UTC, Albrecht Will
Details
Result in report (5.73 KB, image/png)
2016-05-14 13:56 UTC, Albrecht Will
Details
result in form_new (11.12 KB, image/png)
2016-05-14 14:03 UTC, Albrecht Will
Details
Kexi 3.2: Importing CSV with date/time/date-time values (41.79 KB, image/png)
2018-12-31 12:25 UTC, Jarosław Staniek
Details
Resulting KEXI file: Imported CSV with date/time/date-time values (14.00 KB, application/x-kexiproject-sqlite2)
2018-12-31 12:26 UTC, Jarosław Staniek
Details
Imported CSV file with date/time values (61 bytes, text/csv)
2018-12-31 12:30 UTC, Jarosław Staniek
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Albrecht Will 2016-05-14 13:54:27 UTC
If I use the usual way of creating a table with editing it, I only find the data-typ "date/time". In the right property-table there is a sub-property of "date/time" = "time". Unfortunately this is not persistent. In this way its for now not possible to create time-fields.
If I go the path "B" I create a table with LO, create a column (field) with "time" (example 15:00).
Importing this as cvs, kexi recognizes the field really as "time" (!) but finally the import ends in a date.
Am I right, that earlier versions of kexi worked better in this case? Somehow I remember.

Reproducible: Always
Comment 1 Albrecht Will 2016-05-14 13:55:43 UTC
Created attachment 98960 [details]
during cvs-import
Comment 2 Albrecht Will 2016-05-14 13:56:06 UTC
Created attachment 98961 [details]
result in form
Comment 3 Albrecht Will 2016-05-14 13:56:43 UTC
Created attachment 98962 [details]
Result in report
Comment 4 Albrecht Will 2016-05-14 14:03:45 UTC
Created attachment 98963 [details]
result in form_new

The image "result in form" must be replaced by the image "result in form_new"
Comment 5 Jarosław Staniek 2018-12-15 23:28:32 UTC
*** Bug 371894 has been marked as a duplicate of this bug. ***
Comment 6 Jarosław Staniek 2018-12-31 12:07:36 UTC
Regarding:
> If I use the usual way of creating a table with editing it, I only find the 
> data-typ "date/time". In the right property-table there is a sub-property of 
> "date/time" = "time". Unfortunately this is not persistent. In this way its for 
> now not possible to create time-fields.

I confirm this works as expected in 3.1 or even in 3.0. 2.9 can't be fixed. 

However this topic is not related to the summary of the bug report (Forms/report) so I will update the summary.

I'll also test the CSV topic and create bug if needed. 

In the future it's better to keep on topic in one bug report -- here are three topics already if I understood them correctly.
Comment 7 Jarosław Staniek 2018-12-31 12:25:40 UTC
Created attachment 117205 [details]
Kexi 3.2: Importing CSV with date/time/date-time values
Comment 8 Jarosław Staniek 2018-12-31 12:26:24 UTC
Created attachment 117206 [details]
Resulting KEXI file: Imported CSV with date/time/date-time values
Comment 9 Jarosław Staniek 2018-12-31 12:30:43 UTC
Created attachment 117207 [details]
Imported CSV file with date/time values
Comment 10 Jarosław Staniek 2018-12-31 12:34:20 UTC
Please find attachment from comments 7, 8, 9 to see evidence of support for proper date/time CSV import in KEXI 3.2. I think it was OK like this in 3.1.0 too after we fixed unrelated regression of https://bugs.kde.org/show_bug.cgi?id=386102.