Hi ALL EXPERTS
Ultimately I split the QIF file in Text editor and isolated the corrupted
record. In that record out of the text in Notes (Memo) field, the letter
capital "I" somehow came to occupy the first position in the row, Now, as per
the QIF file protocol, "I" indicates Price. Hence the importing desktop program
interpreted it as "share price" and since there was some other text after "I" ,
the error message got generated. I simply removed the "I" from the first
position of the row and imported the file successfully.
(Big)-Thanks to YOU ALL for your valuable guidance and persistent follow-up on
the issue.
On Monday, 25 October, 2021, 08:22:48 pm IST, Kalpesh Patel
<[email protected]> wrote:
Parag – are you able to send me the QIF file privately either as is or
anonymized? I will flag down the offending entry. It won’t be any easier than
this.
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.
----------------------------------------------------------------------
Message: 1
Date: Sun, 24 Oct 2021 17:19:21 +0000 (UTC)
From: parag puranik <[email protected]>
To: "[email protected]" <[email protected]>
Subject: Re: [GNC] Error importing QIF file
Message-ID: <[email protected]>
Content-Type: text/plain; charset=UTF-8
Okay, I'll try to find out the fault by myself. Thanks a lot for your continued
support David.
Sent from Yahoo Mail on Android
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
