[GNC] Error importing QIF file

[parag puranik]

 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 <kalpesh.patel at usa.net> 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 <parag_puranik at yahoo.com>

To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>

Subject: Re: [GNC] Error importing QIF file

Message-ID: <384139489.1092075.1635095961260 at mail.yahoo.com>

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