Bug 363955

Summary: CSV importer should accept datetime as date column
Product: [Applications] kmymoney Reporter: wojnilowicz <lukasz.wojnilowicz>
Component: importerAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: RESOLVED FIXED    
Severity: wishlist    
Priority: NOR    
Version: git (master)   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: http://commits.kde.org/kmymoney/943cd52b91f37b451736a68034d8faa6f9afaac9 Version Fixed In: 5.0
Sentry Crash Report:
Attachments: CSV Test File
Column Assignment for CSV file

Description wojnilowicz 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 wojnilowicz 2016-06-04 19:00:24 UTC 
Created attachment 99369 [details]
CSV Test File
Comment 2 wojnilowicz 2016-06-04 19:00:53 UTC 
Created attachment 99370 [details]
Column Assignment for CSV file
Comment 3 wojnilowicz 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