[GNC] QFX vs OXR/QXF

[David T.]

The most common issue that crops up with importing QIF data seems to be date formatting, such as a date that is in dd-mm-yyyy format (when the rest of the file is mm-dd-yyyy format). 

Unfortunately, there really isn't any easy way to locate such errors, short of scanning through the source file for the errors (remember that QIF is a text file). Some have had success by breaking the file into pieces to narrow down the error. 

David

 
 
  On Thu, May 16, 2019 at 14:15, Richard<rpink01 at gmail.com> wrote:   Thanks so much for the assistance, Derek. If I understand correctly, my 
Quicken 2016 exports to a proprietary file format - QXF.  GnuCash 
imports the more open/robust file format - QFX. These formats are not 
compatible. However, my bank does download to QFX so that should work 
with GnuCash. (I misspoke in my original statement saying that my 
Quicken exports to QFX - this stuff gets a bit confusing)

The trick now is to get my historical data from Quicken into GnuCash 
since my Quicken export QXF can not be imported by GnuCash QFX format.

I've exported from Quicken using the QIF format and that appears to work 
fine. However, when I try to import the QIF file into GnuCash, all seems 
to go fine through the first 14 steps but at step 15 (QIF Import - 
Start), it ends with the message "failed". At step 19 - QIF Import 
Summary, I get the message "There was a problem with the import" No 
additional information follows. See below.

Any ideas?

Thanks,

Richard


On 5/15/2019 9:27 AM, Derek Atkins wrote:
> Hi,
>
> Richard <rpink01 at gmail.com> writes:
>
>> Both my Quicken 2016 and my bank institutions export to QFX files. But
>> GnuCash only offers import from OXF/QXF files. Is this a GnuCssh typo
>> or bug, i.e., misplacement of the "X" in the file extension?
> It is not a typo.  There is a difference between
> OFX/QFX and QXF.
>
> OFX/QFX is the Open Financial eXchange (and a quicken variant).  GnuCash
> can import this.
>
> However, QXF is the Quicken eXchange Format, which is their new,
> proprietary storage format.  GnuCash cannot import QXF.
>
> Are you sure your bank is exporting QFX and not QXF?  Also, could you
> get quicken to export QIF?
>
> Hope this helps,
>
>> Thanks,
>>
>> Richard
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> -derek
>
_______________________________________________
gnucash-user mailing list
gnucash-user at 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.