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

[allan]

https://bugs.kde.org/show_bug.cgi?id=334995

--- Comment #2 from allan <agander93 at gmail.com> ---
On 20/05/14 20:03, Barry Scott wrote:
> Allen,
>
> here is an example of what I am trying to import.
>
> Date,Reference,Transaction Type,Money In, Money Out
> 25/02/2014,,Cheque Deposit,115.00,0.00
> 11/02/2014,,Cheque Deposit,15.94,0.00
> 25/10/2013,,Cheque Deposit,28.99,0.00
> 25/10/2013,,Cheque Deposit,175.23,0.00
> 28/06/2013,BARRY SCOTT,Inter-Account Transfer,0.00,5.12
> 18/05/2013,Coffee on us,Bank Welcome,3.00,0.00
> 17/05/2013,BARRY SCOTT,Inter-Account Transfer,1000.00,0.00
>
> I should raise another bug that the CSV dialog does not remember the "." decimal seperator.
>
>
> Barry
>

Hi Barry

Well, over the last several years I've seen I don't know how many 
different file formats, but this is the first one I've seen that 
actually uses both the debit and credit fields for each transaction. 
Needless to say, that is the cause of your problem.

Harking back to QIF format, each entry will have either a debit or a 
credit, but not both.  I think OFX is probably the same.

However, after I replied to your first post, I did wonder if this could 
be the cause.

I could disregard any zero debit or credit entry, but what if both have 
a value?  Which do I disregard?  They could both have similar or 
identical values.

I think the safest might be to output a message indicating an invalid 
format, and asking what the user wishes to do, perhaps?

So far as the decimal symbol is concerned, the previous value is saved 
in that profile and does get picked up and used.  I'll need to do some 
more checking.  You don't need to raise another bug.  If there is a 
problem, we can edit the heading so that both issues can be picked up in 
a search.

I had actually had in mind to determine the setting from the imported 
file, to save the user having to possibly make a choice.  It's a bit 
more complicated than that, as clicking that choice triggers a validity 
scan of the entries, and highlights the column/s.

Allan

-- 
You are receiving this mail because:
You are the assignee for the bug.