[Kmymoney] Issue while importing statement data from CSV file

[Ryan Novosielski]

It may just be my bank. OFX imports very poorly from their online site whereas QFX is OK. I don't understand it myself, as I expect the formats to be roughly the same (and they use the same importer). 

Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Jack <ostroffjh at sbcglobal.net>
Sender: kmymoney-bounces at kde.orgDate: Sun, 13 Apr 2014 19:42:16 
To: KMyMoney Users' mailing list<kmymoney at kde.org>
Reply-To: KMyMoney Users' mailing list <kmymoney at kde.org>
Subject: Re: [Kmymoney] Issue while importing statement data from CSV file

On 2014.04.13 19:29, Allan wrote:
> On 13/04/14 20:25, Ryan Novosielski wrote:
>> CSV is almost always the worst format for an export to KMyMoney. In  
>> my experience, QFX is best, followed by OFX (may be nearly the  
>> same), followed by QIF.
>> 
>> Sent from my Verizon Wireless BlackBerry
>> 
> 
> I'm not sure about "....QFX is best, followed by OFX....".
> 
> OFX is the best, except if it not made available.  Since MS ceased  
> support for MSMoney, some banks no longer support it.  OFX, if it is  
> available, is best because it was designed for purpose, and it has an  
> appropriate spec.  Unfortunately, however, it is then a lottery as to  
> how well the institution follows the spec.  Also, I doubt that it  
> imports very well into spreadsheets.  The direct connect capability  
> is very good, if available.  We have at least one user who can't, so  
> far, get his files to import in a useful way.  So, I'm more inclined  
> to think of it as the least bad.
> 
> QIF is good, because of the wide support.  Sadly, its spec is very  
> loose and it comes in many different flavours.
> 
> Sometimes,CSV is all that is available.  Then, however, the user can  
> immediately see what he is going to receive and can adapt it to his  
> own requirements.  It also may be easily pre-processed, if  
> necessary.  It certainly beats manual entry.
> 
> Allan

As far as I know, QFX is essentially the same as OFX, except as  
provided by Intuit/Quicken.  One of my banks or credit cards (I  
actually can't remember now) provided QFX, and it imported to KMM as  
OFX with no more or less problems than I have had with any other.   
(except for my Merrill Lynch imports, which have their own problems.)   
I haven't seen any reason to actually distinguish OFX from QFX.

Jack

>> -----Original Message-----
>> From: Marco Dahms <marco.dahms at gmx.net>
>> Sender: kmymoney-bounces at kde.orgDate: Mon, 07 Apr 2014 21:13:50
>> To: <kmymoney at kde.org>
>> Reply-To: KMyMoney Users' mailing list <kmymoney at kde.org>
>> Subject: [Kmymoney] Issue while importing statement data from CSV  
>> file
>> 
>> Dear KMyMoney Experts,
>> 
>> A friend of mine encouraged me to manage my financial stuff with  
>> KMyMoney.
>> Therefore I started by exporting my bank statements as CSV from my
>> online banking system.
>> During the import I receive the error message "Row 2 does not have  
>> the
>> expected number of columns".
>> 
>> Do you have any advice what this message means?
>> I think I have chosen the correct columns for the amount, the payee  
>> etc.
>> 
>> Let me know your comments.
>> 
>> Thanks and regards,
>> Marco
> 
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
_______________________________________________
KMyMoney mailing list
KMyMoney at kde.org
https://mail.kde.org/mailman/listinfo/kmymoney