[GNC] Error importing QIF file

Frank H. Ellenberger frank.h.ellenberger at gmail.com
Mon Nov 8 15:54:34 EST 2021


Hi Parag,

Am 08.11.21 um 09:04 schrieb parag puranik via gnucash-user:
> Just a FYI - my past experience in a massive import of over 10K+ transaction via QIF has been that the wild west of date format used by other apps, specifically multiple formats in the same file,  trips up GNC as it tries to import only single formatted date. There is no clear cut authority on this so both are right as there was not strict adherence to one way of specifying this, especially when accounting for variation between American style of date (month / date / year) and English style of date ( date / month / year). One of the hard ones that I found was for likes of Quicken used apostrophes (‘) as delimiter instead of forward slash (/) for year after 1999 for two digits year format, something like “2/ 1’20” to identify Feb 1nd of 2020 for example, in a file that crossed the millennium.  This was undertaken in 3.x of GNC and since then there has been great improvements made towards this import process. 

Can you create a similar page like
https://wiki.gnucash.org/wiki/CSV_Import/Export
and add it there as Troubleshooting section?

Regards
Frank


More information about the gnucash-user mailing list