On 21/01/12 01:20, Jack wrote:
On 2012.01.20 19:07, Jack wrote:
I've been trying to import a csv file I just created myself. The
purpose is to add a transaction for a cash tip to match every one of a
particular set of transactions I exported with a custom report. A
typical line in the file is:
2011-02-04,Personal: Appearance/Grooming,Hair Shop,-5.00,Tip
I also tried adding double quotes around the text fields, but that
didn't make any difference.
Clearly most of the errors I'm getting are just due to careless
fingers, as they don't repeat. However, some are persistent.
When I click "import" I get a popup asking me to enter the debit flag
column number. I cancel, hit import again, and it imports. I assume a
debit flag would be something to tell whether the "amount" column is a
debit or credit - but why not put this on the main dialog?
Still not sure about this.
Even though "Hair Shop" (actually the name of the person) is already a
payee, it always creates a new payee - with the identical name, as far
as I can tell. Is there any way to assure it uses an existing payee?
OK - the existing payee had matching turned off. Once I checked "Match
on Payee" it did, and stopped creating a duplicate Payee. This also let
it set the default category for that payee, as desired.
Yes, I twigged this later, too, but was in bed trying to get to sleep.
The amount has been imported as $500.00 not $5.00. Do I explicitly
need to specify the decimal symbol?
I first tried changing it to -$5.00, but no change. Explicitly setting
the decimal symbol on the settings tab fixed it. Since my locale already
has (as far as I can tell) this set - should this have been necessary?
Is there any way to get the category assigned, or will that work once
I get it to use the existing payee?
See above - taken care of by getting the payee to match.
Thanks for any suggestions. (I know I could just leave the import as
is and then edit all the transactions at once, since this is just a
one time exercise, but I figured I'd prefer to understand what, if
anything, I'm doing wrong.
One new issue is that with the correct amount at $5.00, three of the
transactions matched, even though the payee was different. Fortunately,
all I had to do was "unmatch" them.
Jack
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
