<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugs.kde.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.6"
          urlbase="https://bugs.kde.org/"
          
          maintainer="sysadmin@kde.org"
>

    <bug>
          <bug_id>435488</bug_id>
          
          <creation_ts>2021-04-07 22:32:31 +0000</creation_ts>
          <short_desc>CSV  importer does not support ISO date format</short_desc>
          <delta_ts>2021-04-07 22:35:36 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>2</classification_id>
          <classification>Applications</classification>
          <product>kmymoney</product>
          <component>importer</component>
          <version>5.1.1</version>
          <rep_platform>Other</rep_platform>
          <op_sys>Other</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>NOR</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>0</everconfirmed>
          <reporter name="Dawid Wróbel">me</reporter>
          <assigned_to name="KMyMoney Devel Mailing List">kmymoney-devel</assigned_to>
          
          
          <cf_commitlink>https://invent.kde.org/office/kmymoney/commit/a08966c1cc6fc417755e9d280cec61ba2fb0976a</cf_commitlink>
          <cf_versionfixedin>5.1.2</cf_versionfixedin>
          <cf_sentryurl></cf_sentryurl>
          <votes>0</votes>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>2023384</commentid>
    <comment_count>0</comment_count>
    <who name="Dawid Wróbel">me</who>
    <bug_when>2021-04-07 22:32:31 +0000</bug_when>
    <thetext>SUMMARY

It&apos;s not uncommon for financial institutions to use ISO date format. CSV Importer, however, does not currently support it.


STEPS TO REPRODUCE
1. Attempt to a CSV file with a Date column that contains an ISO-formatted entries, e.g. 2019-07-08T18:30:01

OBSERVED RESULT
1. Notice that importer cannot detect a format and none of the default formats suggested are suitable


EXPECTED RESULT
1. Importer should detect the ISO format</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>2023385</commentid>
    <comment_count>1</comment_count>
    <who name="Dawid Wróbel">me</who>
    <bug_when>2021-04-07 22:34:42 +0000</bug_when>
    <thetext>Git commit fa0b69e8ed33d52cd8aacfb466f67bb98f8436b7 by Dawid Wróbel.
Committed on 07/04/2021 at 22:32.
Pushed by wrobelda into branch &apos;5.1&apos;.

Make CSV importer support ISO formatted date

Try parsing using ISO formatting first and only continue with
heurestics if unsuccessful.
FIXED-IN: 5.1.2

M  +6    -0    kmymoney/plugins/csv/import/core/convdate.cpp

https://invent.kde.org/office/kmymoney/commit/fa0b69e8ed33d52cd8aacfb466f67bb98f8436b7</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>2023386</commentid>
    <comment_count>2</comment_count>
    <who name="Dawid Wróbel">me</who>
    <bug_when>2021-04-07 22:35:36 +0000</bug_when>
    <thetext>Git commit a08966c1cc6fc417755e9d280cec61ba2fb0976a by Dawid Wrobel, on behalf of Dawid Wróbel.
Committed on 07/04/2021 at 22:35.
Pushed by wrobelda into branch &apos;master&apos;.

Make CSV importer support ISO formatted date

Try parsing using ISO formatting first and only continue with
heurestics if unsuccessful.
FIXED-IN: 5.1.2


(cherry picked from commit fa0b69e8ed33d52cd8aacfb466f67bb98f8436b7)

M  +6    -0    kmymoney/plugins/csv/import/core/convdate.cpp

https://invent.kde.org/office/kmymoney/commit/a08966c1cc6fc417755e9d280cec61ba2fb0976a</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>