Re: [GNC] Error importing quicken 2017 qif / qfx

[Maf. King]

On Monday, 17 September 2018 17:10:10 BST Diogo Maciel wrote:
> I think it's a bug in the 3.2 version. Installed the 2.6 version and it
> imported without problems
> 

Or, logically, it could be a bug in 2.6.x to allow something bogus into GC 
(that has been fixed in 3.x)? 

0.02
Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: [GNC] Error importing quicken 2017 qif / qfx

[Diogo Maciel]

I think it's a bug in the 3.2 version. Installed the 2.6 version and it
imported without problems

On Mon, Sep 17, 2018, 20:24 David T.,  wrote:

> Hello,
>
> In fact, the error is quite clear: something in the QIF file is not as the
> importer expects. As another David has noted, the QIF importer itself is
> functional, and has worked for many users before you. Unfortunately, in
> this case, that erro message is not particularly helpful, as your QIF file
> probably has a lot of transactions in it, any one of which could have
> caused the error. Locating such errors is, quite simply, a challenge.
>
> You might open your QIF file and try to determine whether anything looks
> out of order there, although that is difficult.
>
> You don’t say where you are located, but one of the most common situations
> that causes this error is date formatting. GnuCash attempts to guess
> whether you follow US-style date (MM-DD-) or European-style
> (DD-MM-), but often it fails to guess correctly. I believe it defaults
> to US-style (but I am sure the experts will correct me on this).
>
> One way forward for you at this time would be to try using a subset of
> your data to test the import first; if you can figure out how to get a
> smaller file to import, it will make additional imports easier. Many
> actually recommend using this piece-by-piece approach for import for this
> very reason.
>
> David
>
>
> > On Sep 16, 2018, at 12:19 PM, Diogo Maciel 
> wrote:
> >
> > Hi, hope someone can help me move out from Quicken
> >
> >
> >
> > I tried exporting my data from Quicken in both qif and qfx. The qif
> importer
> > gives me the error below
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Qfx will only show an empty window
> >
> >
> >
> >
> >
> >
> >
> > My file has multiple securities and currencies, so this may be relevant.
> I
> > understand that with such a generic error one may need more information,
> > which I can surely provide.
> >
> >
> >
> > Thanks!
> >
> >
> ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

> On Sep 17, 2018, at 10:17 AM, cicko  wrote:
> 
> GnuCash - User mailing list wrote
>> It’s not clear that the OP has determined that the content of their QIF
>> file is properly structured ...
>> 
>> The bug to which you refer addresses a very particular aspect of QIF
>> import, while the OP is having troubles importing their Quicken data for
>> the first time.
> 
> I hope you are not implying that a .qif file exported from Quicken, the
> maker of the QIF standard, is "not properly structured". :)

Quicken has been known to play fast and loose with its own “standard” on 
numerous occasions. Regardless, I thought that my further comments regarding 
date formats were a clear example of how ambiguities in the data set could 
result in errors on import. Perhaps I wasn’t clear enough on that point.

> 
> The OP has indicated that he has "multiple securities and currencies" which
> sounds pretty much with the scenario I had when the import failed. It could
> very well be the exact same issue.
> 
> However, without a more comprehensive error message or a log we won't be
> able to know more. One thing for the OP would be to check the GC log files,
> which are generally placed in the Temp folder.
> 
> Not sure if that is convenient here, but I ended up manually entering all
> the investment transactions for the financial year and not importing the
> historical transactions due to this issue. 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

Hello,

In fact, the error is quite clear: something in the QIF file is not as the 
importer expects. As another David has noted, the QIF importer itself is 
functional, and has worked for many users before you. Unfortunately, in this 
case, that erro message is not particularly helpful, as your QIF file probably 
has a lot of transactions in it, any one of which could have caused the error. 
Locating such errors is, quite simply, a challenge. 

You might open your QIF file and try to determine whether anything looks out of 
order there, although that is difficult.

You don’t say where you are located, but one of the most common situations that 
causes this error is date formatting. GnuCash attempts to guess whether you 
follow US-style date (MM-DD-) or European-style (DD-MM-), but often it 
fails to guess correctly. I believe it defaults to US-style (but I am sure the 
experts will correct me on this).

One way forward for you at this time would be to try using a subset of your 
data to test the import first; if you can figure out how to get a smaller file 
to import, it will make additional imports easier. Many actually recommend 
using this piece-by-piece approach for import for this very reason.

David


> On Sep 16, 2018, at 12:19 PM, Diogo Maciel  wrote:
> 
> Hi, hope someone can help me move out from Quicken
> 
> 
> 
> I tried exporting my data from Quicken in both qif and qfx. The qif importer
> gives me the error below
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Qfx will only show an empty window
> 
> 
> 
> 
> 
> 
> 
> My file has multiple securities and currencies, so this may be relevant. I
> understand that with such a generic error one may need more information,
> which I can surely provide.
> 
> 
> 
> Thanks!
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David T. via gnucash-user]

I think it’s a little premature to refer to this bug. 

It’s not clear that the OP has determined that the content of their QIF file is 
properly structured and being properly interpreted by the GnuCash importer—and 
that is a more profitable avenue for them to explore at this time.

The bug to which you refer addresses a very particular aspect of QIF import, 
while the OP is having troubles importing their Quicken data for the first time.

> On Sep 17, 2018, at 3:16 AM, cicko  wrote:
> 
> You may want to subscribe to this issue and add any extra information you
> find useful:
> https://bugs.gnucash.org/show_bug.cgi?id=788474
> 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: [GNC] Error importing quicken 2017 qif / qfx

[David Cousens]

Diego,

I have just imported an example file given in the W3C article on QIF format
(https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm) without any
problem using the Import QIF wizard  ( have to cut off the comments on the
end of the lines).A copy of the file is attached example1.qif
  . I don't
use qif files or Quicken so it was the only qif files I could dig up
quickly.  You may want to check your file out against the format description
given in that article.

There is also a QFX file viewer available on this page you can check the 
.qfx file with (https://fileinfo.com/extension/qfx).  that file vewer should
also be able to open the QIF file as well.

the manual entry for QIF importer is here 
https://www.gnucash.org/docs/v3/C/gnucash-help/import-qif.html


And  migration from Quicken is covered here  
https://wiki.gnucash.org/wiki/Quicken_Migration

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: [GNC] Error importing quicken 2017 qif / qfx

[cicko]

You may want to subscribe to this issue and add any extra information you
find useful:
https://bugs.gnucash.org/show_bug.cgi?id=788474




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.