[Kmymoney] Issue while importing statement data from CSV file

[Allan]

On 13/04/14 19:28, Marco Dahms wrote:
<snip>

Hi Marco

The error message does go on to say -
"This might not be a problem, but it may be a header line.
  You may accept all similar items, or just this one, or cancel."

So, it was not necessary to delete the header line.  You could have 
accepted it, and any similar following lines.

I don't want to make the message much longer, as that can result in the 
user being too impatient to read it all, but I'll see if I can expand it 
a little.

Allan

> Am 13.04.2014 18:51, schrieb 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
>>>
>>
>