[Kmymoney-devel] [kmymoney4] [Bug 334995] CSV import Debit/Credit mode only looks at one column, credits become 0.00

[Allan]

On 26/05/14 02:23, Chris wrote:
> https://bugs.kde.org/show_bug.cgi?id=334995
>
> Chris <developerchris at rebel.com.au> changed:
>
>             What    |Removed                     |Added
> ----------------------------------------------------------------------------
>                   CC|                            |developerchris at rebel.com.au
>
> --- Comment #10 from Chris <developerchris at rebel.com.au> ---
> If I can add my 2c.
>
> Allan you are correct in stating there are no rules around csv. just
> guidelines, this means if you are going to use a column then it needs to be
> validated. you cannot even trust delimiters. at work we have one piece of
> software that outputs tildes ~ as the delimiter.
>
> It also means you cannot make assumptions about why there is something
> unexpected.
>
> Both credit and debit fields can be blank/zero. My bank uses such as advice
> lines. They should be ignored or entered in as a zero balance transaction.
>
> In my opinion a blank numeric entry field should be interpreted as 0.
>
> I personally would ignore lines without valid dates, but would advise the user
> this is happening and ask if they want to make it the default for that
> template. so they aren't asked again.
>
> Personally I would like to see the all imported transactions listed at the end
> of the import with the ability to edit individual transactions or cancel the
> import if it didn't go to plan.
>
> But I guess that is a wishlist item.
>

Hi Chris

Thanks for the input.

I'm still wrestling with the blank/zero issue.  It's much more 
complicated than I expected.

So far as separators are concerned, presently I allow for the four, 
although I don't recollect having encountered the colon, yet.  I 
actually determine which of those is the relevant one, and that hasn't 
yet failed.  In the event of failure or ambiguity, I could then allow 
the user to choose, or to input a new one.  Such a choice could be added 
to that profile.

With dates, if the importer can't make sense of one, it hands the issue 
over to KMM, where the user can opt to use the current date.  Generally, 
though, an invalid date is usually caused by the user failing to remove 
a trailer line, which is unlikely to contain a date.

This is more than a wish-list item, it's a wish-list!  Do you think you 
could submit it as a wish-list item, so I don't overlook it.

Thanks

Allan