https://bugs.kde.org/show_bug.cgi?id=334995
--- Comment #11 from allan <[email protected]> --- 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 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ KMyMoney-devel mailing list [email protected] https://mail.kde.org/mailman/listinfo/kmymoney-devel
