GNOME Bugzilla – Bug 504046
QIF creates spurious accounts when parent and sub-account currencies are different.
Last modified: 2018-06-29 21:56:41 UTC
Please describe the problem: When importing a QIF and creating transactions in accounts where the parent accounts have different currencies than the sub-accounts, the QIF importer creates extra accounts and sometimes extra account trees. Steps to reproduce: 1. Create a new file with default common-accounts. Choose currency (hereafter called A). 2. Create a new Asset sub-account under "current assets". Choose currency different from A (hereafter called B). 3. Import a QIF. Choose to import the QIF into the account you created in step 2 4. Choose currency B as the currency of the QIF during import. 5. Finish Import Actual results: A new Asset account tree is created in currency B. Expected results: The QIF data should be imported into the account chosen in step 2. The parent account currencies shouldn't affect the import. Does this happen every time? It seems to. Other information: See thread starting here: https://lists.gnucash.org/pipermail/gnucash-user/2007-December/022808.html
Here are the steps to reliably reproduce the bug for the introductory commodity page (commodity_doc_page in the code). Steps to reproduce: 1. Begin importing a QIF containing a transaction that uses a never-before-seen QIF security. 2. Keep clicking Forward until the final "Apply" page is reached. 3. Click Back until the introductory commodity page is shown.
Here are the steps to reliably reproduce the bug for the duplicates page. Steps to reproduce: 1. Start GnuCash with a data file containing at least one transaction. 2. Begin importing a QIF containing no duplicates of existing transactions. 3. Keep clicking Forward until the final "Apply" page is reached. 4. Notice that the "duplicates" page is not shown. 5. Click Back. 6. The duplicates page is shown.
Charles, Are you getting a bit comment happy? ;) How do these steps have anything to do with this particular bug?
Whoops! Comment 1 and comment 2 were supposed to go on bug 503166, not this one. I must have confused some bugs reports I had open in separate windows. I was wondering what happened... anyway, please ignore them.
I'd try to fix this bug, but I can't reproduce it. Here's what I'm doing: 1. Start a new GnuCash data file. 2. Create "Common Accounts" with the druid with currency USD. 3. Create a new account, Assets:Current Assets:AUD Savings, account type Bank, using currency AUD. 4. Begin importing a QIF containing with the following contents: !Type:Bank D01/31/2008 T-110.00 PMy Payee LSome Expense ^ 5. For the default QIF account name, enter Assets:Current Assets:AUD Savings 6. For the QIF currency, enter AUD. 7. Finish importing. Instead of seeing a parallel tree in AUD, the existing account tree was unchanged except for the addition of a new "Some Expense" account in AUD, as expected. The imported transaction looks fine. Am I missing something? Can you still reproduce this, Ian?
Hmm, I can't really reproduce this anymore either. I swear that I reproduced this before filing the bug. Basically it created a whole new directory tree in the currency you chose during import and imported there. It didn't import into the account you chose even though the currencies matched. I suppose it may have been inadvertently fixed by one of your patches. The only way to know for sure is to try it in an older gnucash version like 2.2.1 or 2.2.0.
Ian, I can't think of any of my patches I've done that would fix this... Perhaps this bug report describes a side effect of bug 504007, which you patched not long ago?
Maybe. I'm not sure. But since neither of us think it's a problem anymore I'll go ahead and close it to get it out of the way. If we find later that it really is a problem then we can re-open the bug or create a new one.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=504046. Please update any external references or bookmarks.