On 26/05/14 02:23, Chris wrote:
https://bugs.kde.org/show_bug.cgi?id=334995
Chris <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #10 from Chris <[email protected]> ---
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
_______________________________________________
KMyMoney-devel mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/kmymoney-devel
