Bug 363955 - CSV importer should accept datetime as date column
Summary: CSV importer should accept datetime as date column
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: importer (show other bugs)
Version: git (master)
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-04 18:56 UTC by NSLW
Modified: 2016-06-24 18:48 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In: 5.0


Attachments
CSV Test File (399 bytes, text/csv)
2016-06-04 19:00 UTC, NSLW
Details
Column Assignment for CSV file (96.70 KB, image/png)
2016-06-04 19:00 UTC, NSLW
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NSLW 2016-06-04 18:56:53 UTC
CSV importer should accept datetime as date column

Reproducible: Always

Steps to Reproduce:
1. File->Import->CSV
2. Select "Investments" and create new profile
3. Press select file and choose attached "test file.csv"
4. Set field delimiter to "comma" and text delimiter to "quotes" and press next
5. Assign columns according to attached image and press next
6. Set date format as "y m d" and press next
7. Set decimal symbol to "comma" and press "Import CSV"

Actual Results:  
I get warning that date "2011-02-22-09.32.35" is not valid.

Expected Results:  
CSV Importer should extract date from "2011-02-22-09.32.35".
Comment 1 NSLW 2016-06-04 19:00:24 UTC
Created attachment 99369 [details]
CSV Test File
Comment 2 NSLW 2016-06-04 19:00:53 UTC
Created attachment 99370 [details]
Column Assignment for CSV file
Comment 3 NSLW 2016-06-24 18:45:36 UTC
Git commit 943cd52b91f37b451736a68034d8faa6f9afaac9 by Łukasz Wojniłowicz.
Committed on 24/06/2016 at 18:39.
Pushed by wojnilowicz into branch 'master'.

Accept datetime format in CSV importer
REVIEW: 128099

M  +62   -21   kmymoney/plugins/csvimport/convdate.cpp

http://commits.kde.org/kmymoney/943cd52b91f37b451736a68034d8faa6f9afaac9