[Bug 213250] New: QIF Import creates numerous Unneeded Accounts
|
View:
New views
7 Messages
—
Rating Filter:
Alert me
|
 |
[Bug 213250] New: QIF Import creates numerous Unneeded Accounts
by allan anderson
::
Rate this Message:
|
|
|
Re: [Bug 213250] New: QIF Import creates numerous Unneeded Accounts
by allan anderson
::
Rate this Message:
|
|
|
Re: [Bug 213250] New: QIF Import creates numerous Unneeded Accounts
by Thomas Baumgart
::
Rate this Message:
Hi,
on Thursday 05 November 2009 allan wrote: > aga wrote: > > https://bugs.kde.org/show_bug.cgi?id=213250 > > > > Summary: QIF Import creates numerous Unneeded Accounts > > Product: kmymoney2 > > Version: unspecified > > Platform: Compiled Sources > > OS/Version: Linux > > Status: UNCONFIRMED > > Severity: normal > > Priority: NOR > > Component: general > > AssignedTo: kmymoney2-developer@... > > ReportedBy: aganderson@... > > > > > > Version: 1.0.2-CVS (using KDE 4.3.1) > > OS: Linux > > Installed from: Compiled From Sources > > > > I have imported from Quicken 2002 a file containing Accounts List, > > SecurityList, and Transactions for an investment account. There is no > > brokerage account in Quicken, and the file has not been modified in any > > way, just imported. > > > > The import completes successfully, but the particular account appears > > five times, as follows:- > > 1) Account name Type - Investment > > 2) " Type - Stock > > 3) Account name (Brokerage) Type - Current - empty > > 4) Account name (Investment) Type - Investment - empty > > 5) " Type - Stock - empty > > > > This sort of duplication occurs every time for me. > > > > Allan > > Hi Thomas > > Further information, and some thoughts. > > This time, I export only Security list and transactions, no Account list. > > On import, I get a dialog asking for an account. I create one and the > import completes. Securities list shows all securities from Quicken and > all prices for all securities are in the Prices list. Only the expected > accounts appear, the created investment account and the imported stock > account. > > Finally, I export Account list and transactions. > On import, four > accounts have been created - an investment account, a current > account(Brokerage), an investment account(Investment) and its Stock > account. The Securities and Prices lists are empty, as expected. The > transactions that are in the qif file have not been imported. Hmm, why did it not import the transactions? > So, to me it appears that the Accounts list processing produces the > unneeded accounts. To me, a Brokerage account should not be created > automatically,but only if one is imported. In general I agree. There is a limitation though in KMyMoney, that does not handle some constructs used in Quicken w/o a brokerage account. Since we don't know upfront, if those constructs are used or not, we simply create the brokerage account to be on the safe side during the import and leave it to the user to remove it if unused. The problem is, that with the current version of KMyMoney you cannot use the investment account itself as current account. This is what can be done in MS- Money and Quicken. Maybe (I am pretty sure) a future version will support this w/o an artificial brokerage account. But I expect to see larger changes to the business logic and reporting code while allowing to store funds in the investment account and that is why we decided not to allow it in 1.0. > The Securities list appears > to be processed more or less correctly, needing only to have an > investment account supplied. However, if the Account list has already > created an investment account, then the security processing should > perhaps look for an existing account,before creating a new one in > addition. Similarly for its stock account. Or, create only one > investment account from the Account list, and one stock account from the > Securities list. Something like that. I don't remember all the details of the QIF importer at this point. Maybe a future version of the QIF importer will allow to run over a whole set of files in multiple rounds underneath the hood to detect all those problems. OTOH, how long is QIF still around? -- Regards Thomas Baumgart GPG-FP: E55E D592 F45F 116B 8429 4F99 9C59 DB40 B75D D3BA ------------------------------------------------------------- I don't think any of us need any help in this regard, getting rid of money is probably the single most userfriendly interface since breast-feeding... unfortunately. -- A.J. Venter ------------------------------------------------------------- ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ KMyMoney2-developer mailing list KMyMoney2-developer@... https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer |
|
|
[Bug 213250] QIF Import creates numerous Unneeded Accounts
by Bugzilla from ipwizard@users.sourceforge.net
::
Rate this Message:
|
|
|
Re: [Bug 213250] New: QIF Import creates numerous Unneeded Accounts
by allan anderson
::
Rate this Message:
|
|
|
Re: [Bug 213250] New: QIF Import creates numerous Unneeded Accounts
by Thomas Baumgart
::
Rate this Message:
Hi,
on Thursday 05 November 2009 allan wrote: > Thomas Baumgart wrote: > > Hi, > > > > on Thursday 05 November 2009 allan wrote: > >> aga wrote: > >>> https://bugs.kde.org/show_bug.cgi?id=213250 > >>> > >>> Summary: QIF Import creates numerous Unneeded Accounts > >>> Product: kmymoney2 > >>> Version: unspecified > >>> Platform: Compiled Sources > >>> OS/Version: Linux > >>> Status: UNCONFIRMED > >>> Severity: normal > >>> Priority: NOR > >>> Component: general > >>> AssignedTo: kmymoney2-developer@... > >>> ReportedBy: aganderson@... > >>> > >>> > >>> Version: 1.0.2-CVS (using KDE 4.3.1) > >>> OS: Linux > >>> Installed from: Compiled From Sources > >>> > >>> I have imported from Quicken 2002 a file containing Accounts List, > >>> SecurityList, and Transactions for an investment account. There is no > >>> brokerage account in Quicken, and the file has not been modified in any > >>> way, just imported. > >>> > >>> The import completes successfully, but the particular account appears > >>> five times, as follows:- > >>> 1) Account name Type - Investment > >>> 2) " Type - Stock > >>> 3) Account name (Brokerage) Type - Current - empty > >>> 4) Account name (Investment) Type - Investment - empty > >>> 5) " Type - Stock - empty > >>> > >>> This sort of duplication occurs every time for me. > >>> > >>> Allan > >> > >> Hi Thomas > >> > >> Further information, and some thoughts. > >> > >> This time, I export only Security list and transactions, no Account > >> list. > >> > >> On import, I get a dialog asking for an account. I create one and the > >> import completes. Securities list shows all securities from Quicken and > >> all prices for all securities are in the Prices list. Only the expected > >> accounts appear, the created investment account and the imported stock > >> account. > >> > >> Finally, I export Account list and transactions. > > > > I assume of a single investment account. > > Yes, sort of. The Quicken Accounts list includes *all* accounts (names, > etc., not transactions) it knows of, but only one account may be > exported at a time. A Securities list includes all securities and all > their prices. > > >> On import, four > >> accounts have been created - an investment account, a current > >> account(Brokerage), an investment account(Investment) and its Stock > >> account. The Securities and Prices lists are empty, as expected. The > >> transactions that are in the qif file have not been imported. > > > > Hmm, why did it not import the transactions? > > I think because on this run there were no !Type:Security entries. They > are in the Accounts list. If both are imported together, all is well. > Si, I think this is a red herring. I was trying to identify where all > the accounts came from, so ran the two separately. I think this can > probably be ignored. > > >> So, to me it appears that the Accounts list processing produces the > >> unneeded accounts. To me, a Brokerage account should not be created > >> automatically,but only if one is imported. > > > > In general I agree. There is a limitation though in KMyMoney, that does > > not handle some constructs used in Quicken w/o a brokerage account. Since > > we don't know upfront, if those constructs are used or not, we simply > > create the brokerage account to be on the safe side during the import and > > leave it to the user to remove it if unused. > > I'm pretty sure it used to though, before the big rework. When I was > doing all my testing before that, I'm sure this didn't happen. with many details wanted to get things like dividend payments w/o a given checking/current account to work (which makes sense) and that is why we needed the brokerage account as a last resort (that is the Div vs. DivX record type in QIF). > > The problem is, that with the current version of KMyMoney you cannot use > > the investment account itself as current account. This is what can be > > done in MS- Money and Quicken. Maybe (I am pretty sure) a future version > > will support this w/o an artificial brokerage account. But I expect to > > see larger changes to the business logic and reporting code while > > allowing to store funds in the investment account and that is why we > > decided not to allow it in 1.0. > > > >> The Securities list appears > >> to be processed more or less correctly, needing only to have an > >> investment account supplied. However, if the Account list has already > >> created an investment account, then the security processing should > >> perhaps look for an existing account,before creating a new one in > >> addition. Similarly for its stock account. Or, create only one > >> investment account from the Account list, and one stock account from the > >> Securities list. > > > > Something like that. I don't remember all the details of the QIF importer > > at this point. > > > > Maybe a future version of the QIF importer will allow to run over a whole > > set of files in multiple rounds underneath the hood to detect all those > > problems. OTOH, how long is QIF still around? > > Well, it seems at the moment to be the only accepted way to import and > export across apps. Do you see KMM exporting in OFX? It's still not > that widely supported. Will KMM import and export in csv at some stage? > Perhaps there will be some bloat of xml? people leaving KMyMoney? LOL. I know, the exporter needs to be fixed at some point. Not sure if OFX is the way to go, it certainly would get rid of a lot of ambiguities and trouble we have with QIF. XML? Just use the KMyMoney file directly :) No need to write an exporter for that. -- Regards Thomas Baumgart GPG-FP: E55E D592 F45F 116B 8429 4F99 9C59 DB40 B75D D3BA ------------------------------------------------------------- "I know, a 'real Linux geek' doesn't walk around the wall: He bangs his head against it until it tumbles down!" -- wobo on FLUG ml ------------------------------------------------------------- ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ KMyMoney2-developer mailing list KMyMoney2-developer@... https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer |
|
|
Re: [Bug 213250] New: QIF Import creates numerous Unneeded Accounts
by allan anderson
::
Rate this Message:
|
signature.asc (232 bytes) | Free embeddable forum powered by Nabble | Forum Help |
