[Kmymoney] Issue while importing statement data from CSV file

Marco Dahms marco.dahms at gmx.net
Sun Apr 13 16:12:48 UTC 2014


Hi Allan,

thanks for your valuable input.

Right now I was able to import the CSV file successfully. The point was 
the header line which I deleted in Excel beforehand.
However, it may be helpful in general to give this hint to the end-user 
directly.

Thanks
Marco

Am 07.04.2014 21:25, schrieb Allan:
> On 07/04/14 20:13, Marco Dahms wrote:
>> 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
>
> Hi Marco
>
> Generally, that happens when, apart from the data rows, there are 
> header lines.  The plugin needs to find the number of columns/fields 
> in the file, but often finds that the header line/s have fewer, 
> possibly just one.
>
> However, in case the user has entered the wrong starting line, when it 
> finds fewer fields than expected, that message is output to warn the 
> user.  The user is given the option to accept just that first error, 
> or all later similar errors.
>
> So, when you see that, see what shows in the table and what details 
> the error message gives.  If you've entered the wrong starting row 
> number, go back and correct it.  If you have the correct starting 
> line, then does it look like the header line/s have fewer column?  If 
> so, accept that one line.  If you get another similar message, you can 
> opt to accept all.
>
> If that doesn't fix it, we need to investigate.
>
> Allan
>



More information about the KMyMoney mailing list