[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #13 from Jack --- Note I did not expect Payee matching to create a transfer. That make sense to me, as transfers very rarely need a Payee, although there are use cases, which have been discussed on the mailing list in the past. I actually wonder what happens if there is already a transfer transaction for that Payee - might the imported transaction match, and thus be imported as a transfer. Remember importing involves both Payee matching and transaction matching, which are not the same thing. Transaction matching fills in some of the fields missing from the import if it finds a an existing transaction which matches closely enough. More stuff to test. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #12 from Don S. --- I just tried using Payee Matching to import a test file and that didn't work to create a transfer transaction. It didn't work. It created a new category like it did before. Jack: Your idea of entering a unique category in the csv and changing the transactions manually seems to be the quickest way to handle it. Thanks! -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #11 from Don S. --- Good idea. Also, after years of using KMyMoney, I just realized that I can select multiple transactions and it can change their categories in one step. Using the filter to find them will make it even easier. But I'll try the other idea with the Payee processing tomorrow and let you know how it goes. I have to go somewhere, otherwise I'd try it now. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #10 from Jack --- As far as I know, it does, so give that a try and let us know how it works. As a separate possibility, what about just using a single dummy Category with no Payee? You could even put the other account in the memo if it's not going to be obvious to you what it should be. That way, you would just have to change the dummy Category to the other account, and not need to remove the (dummy?) Payee. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #9 from Don S. --- Jack, I should have said 'impractical' rather than 'impossible'. It make my play to pre-process the csv files to save time every month impractical. But,, I just thought of a ?possible? workaround. I can put something in the csv Payee field and use KMyMoney's Payees Match and Default category. That's assuming that KMyMoney's csv import processes those rules when importing. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #8 from Jack --- Yes, the "bug" still exists, but how does that make it impossible for you to import your data? The only issue is that you will need to manually edit each transfer transaction and specify the other account. In case a new category was created with the name of the other account, you can delete it. Finding unused Categories is not as easy as finding unused Payees, but if you make sure not to hide unused Categories, you can sort the Categories view by Total Value, putting the unused ones at the top of the expense and income lists. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #7 from Don S. --- This bug bit me too while trying to import a csv file that contains a lot of tranfers. I tried putting [brackets] around the account name in the csv file but that didn't work either. I hoped to be able to pre-process csv files and import into KMyMoney to save some time and errors but that doesn't seem possible since this bug has existed for more than 3 years. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 d...@donstrenzwood.com changed: What|Removed |Added CC||d...@donstrenzwood.com --- Comment #6 from d...@donstrenzwood.com --- This bug bit me too while trying to import a csv file that contains a lot of tranfers. I tried putting [brackets] around the account name in the csv file but that didn't work either. I hoped to be able to pre-process csv files and import into KMyMoney to save some time and errors but that doesn't seem possible since this bug has existed for more than 3 years. -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 Dawid Wróbel changed: What|Removed |Added See Also||https://bugs.kde.org/show_b ||ug.cgi?id=440935 -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #5 from Jim Davis --- Attached are three csv files labelled BankA, BankB, and BankA_all_accts. These are a sample of 1 month of historical transactions, with redacted (replaced) account numbers and in some cases a note in the format (jd note: xxx). Bank "B" is my primary checking & savings, Bank "A" is a secondary checking but has better organizational and external account linking abilities. In both cases, csv output can be combined (all internal and external linked accounts) or separated by account. Currently only Bank "A" is linked to Bank "B" but both have an option to link to other (external) bank transactions. Bank "A" allows for both a custom description as well as 2 levels of categories with splits, plus tags. Bank "B" allows for a custom "nickname (description) and has only 1 category with splits and call them "tags" in the csv. Bank "A" web software: MX http://www.mx.com/company/ also ref: https://webcache.googleusercontent.com/search?q=cache:uZjwPbc_rVoJ:https://www.crunchbase.com/organization/moneydesktop+=4=en=clnk=us Bank "B" web software: Fiserv https://www.fiserv.com/customer-channel-management/internet-banking.aspx -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #4 from Jim Davis --- Created attachment 118795 --> https://bugs.kde.org/attachment.cgi?id=118795=edit Sample Bank CSV Export #3 of 3 Sample Bank CSV Export #3 of 3 -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #3 from Jim Davis --- Created attachment 118794 --> https://bugs.kde.org/attachment.cgi?id=118794=edit Sample Bank CSV Export #2 of 3 Sample Bank CSV Export #2 of 3 -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293 --- Comment #2 from Jim Davis --- Created attachment 118793 --> https://bugs.kde.org/attachment.cgi?id=118793=edit Sample Bank CSV Export #1 Attached are three csv files labelled BankA, BankB, and BankA_all_accts. These are a sample of 1 month of historical transactions, with redacted (replaced) account numbers and in some cases a note in the format (jd note: xxx). Bank "B" is my primary checking & savings, Bank "A" is a secondary checking but has better organizational and external account linking abilities. In both cases, csv output can be combined (all internal and external linked accounts) or separated by account. Currently only Bank "A" is linked to Bank "B" but both have an option to link to other (external) bank transactions. Bank "A" allows for both a custom description as well as 2 levels of categories with splits, plus tags. Bank "B" allows for a custom "nickname (description) and has only 1 category with splits and call them "tags" in the csv. Bank "A" web software: MX http://www.mx.com/company/ also ref: https://webcache.googleusercontent.com/search?q=cache:uZjwPbc_rVoJ:https://www.crunchbase.com/organization/moneydesktop+=4=en=clnk=us Bank "B" web software: Fiserv https://www.fiserv.com/customer-channel-management/internet-banking.aspx -- You are receiving this mail because: You are watching all bug changes.
[kmymoney] [Bug 405293] CSV importer does not handle transfers
https://bugs.kde.org/show_bug.cgi?id=405293
Jim Davis changed:
What|Removed |Added
CC||jd...@jd4x4.net
--- Comment #1 from Jim Davis ---
As I was the one who had the problem which Thomas describes in opening this bug
(and heled me fix- Thanks Thomas!), I want to clarify that here in the U.S. it
appears to be common for banks to go to CSV file formats as the ONLY
transaction download option.
In the case of my two banks ("Credit Union" Banks) both offer "Category" AND
"Tag" columns, and both include an "Account" column. Both banks allow a user of
their web site to custom categorize transactions, one bank putting these in a
"tags" column and the other in 2 cols of "Parent Category" and "Category".
Understanding how KMyMoney processes (Allocates Payee/Description vs. Category)
these columns was my dilemma, and I think the documentation should detail the
process, unless Thomas's suggested fix is considered a better option.
--
You are receiving this mail because:
You are watching all bug changes.
