[Kmymoney] Issue while importing statement data from CSV file

[Allan]

On 13/04/14 17:12, Marco Dahms wrote:
> 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
>

Hi Marco

Glad you were able to complete the import.

So far as your suggestion of a hint, well, that was the purpose of the 
error message you encountered.  I'm happy to change it, if you care to 
make a suggestion.

An updated user manual is in progress, too, where this could well be 
covered.

Allan

> 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
>>
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>