[kmymoney] [Bug 405293] CSV importer does not handle transfers

2019-03-13 Thread Jim Davis
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

2019-03-13 Thread Jim Davis
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

2019-03-13 Thread Jim Davis
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

2019-03-13 Thread Jim Davis
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

2019-03-10 Thread Jim Davis
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.