Hi Cristian

My glee was premature. I had thought that the Import had worked ok, but it has not. There is an Import Failed error msg with a strange code ... how can i attach an image here so that you can see this error, pls?

Steffie.

You can post just the text of the message, you can copy it from the messagebox or upload the image somewhere and post a link to it.

This is the text of the error msg:

"Import failed:
Unknown account id '8334de269475ee1b6aaf10a38265c86e' "

After i acknowledge it, it gives a similar error msg to the one that initiated this Post, ie, "Cannot load file C:/Users/Steffie/Documents/My Safes/Steffie 2003+ (created 20101229).gnucash. Reason: No storage object attached to MyMoneyFile".

Once i acknowledge this, after a few moments the KMM window updates with all my accounts listed, apparently as hyperlinks [but they don't work]. The icons in the row across the top also do not work, & all the icons in the LHS column also don't work [in fact are all ghosted out]. This page is "fragile", in that i can't save it, & if i click the link at the very bottom saying "Show KMM welcome page", then all my account listings vanish & cannot be retrieved.

I like the look of KMM from the little i have seen, but obviously there's some serious problem importing my GnuCash data.

Thanks.
Steffie.

"Import failed:
Unknown account id '8334de269475ee1b6aaf10a38265c86e' "

To be able to help you from here on I guess we would need a sample GnuCash file with which to reproduce this to try to figure out what went wrong. Does GnuCash support anonymous files?

Hi Cristian

Sorry for my delayed reply. No, sadly GnuCash does not have an equivalent feature to KMM's "anonymous files". GnuCash is very frustrating for the range of features that it does not have, & flexible methods of exporting its data is just one complaint of mine. It does have a means to export merely my account structures [containing what in KMM & Quicken parlance are all my Categories, as well as Accounts], without any transaction data at all. It exports that into a new GnuCash file, which i can then import to KMM. To my surprise that import is repeatedly successful [ie, does not suffer any of the faults i described in earlier post].

I find this puzzling, as the KMM error msg i get every time i try to import my real GnuCash file [ie, containing years of data], specifically says "Unknown account"... yet KMM seems perfectly happy to import those identical Accounts so long as there's no associated transaction data. I hope that might make sense to you, because it confuses me!

From the little look that this has now given me of KMM, i think it looks very good, & i feel that i really would like to migrate to it from GnuCash ... but the lack of data is a great pity.

I have read that one of the incompatibilities between GnuCash & KMM is that KMM does not support GnuCash's use of formulae. Many of my Scheduled Transactions do use formulae. Do you think this might cause the KMM import failures? It would be tedious to remove all my formulae, but i would happily do it if that then meant i could import all my data ok.

I have noted KMM is supposed to have a CSV Import Plugin, which i thought might give me another way to try to bring my data in from GnuCash. However this Plugin seems not installed in my KMM, despite me ticking its box. At http://kmymoney2.sourceforge.net/plugins.html this plugin is not listed... so maybe this plugin has been withdrawn???

One of my major reasons that i have grown dissatisfied with GnuCash is its primitive & restricted Reports, & its non-existent graphical Forecast capability. Both of these look promising to me in KMM, but i have noticed one limitation that surprises me... its current Forecast limit seems to be only 999 days, which is less than 3 years. Is there any reason for this unfortunate limit? I would like to model my prospective long-range Forecast taking into account funding my kids' university costs, my eventual retirement, etc, & this needs a Forecast Days' capability to 4 digits, not only 3 digits like now. Could that enhancement be possible in future pls?

Thanks.
Steffie.

steffie wrote:I find this puzzling, as the KMM error msg i get every time i try to import my real GnuCash file [ie, containing years of data], specifically says "Unknown account"... yet KMM seems perfectly happy to import those identical Accounts so long as there's no associated transaction data. I hope that might make sense to you, because it confuses me!

You could try looking into you gnucash file for account '8334de269475ee1b6aaf10a38265c86e' to figure out where it appears and maybe you can fix the problem by removing just that entry.

Code: Select all

zcat you_gnu_cash_file > uncompressed_gnu_cash_file

Open 'uncompressed_gnu_cash_file' with your favorite text editor and search for '8334de269475ee1b6aaf10a38265c86e'.

Thanks Cristian, that was a good idea, & i tried it. I found 7 instances of that string, so i deleted them [in a copy of my GC file of course] & then retried the import. Unfortunately the same type of error msg came up, but this time with a different long string. I suspect this behaviour will simply iterate.

I've decided to give up trying to import my data, regrettably, & have simply created my various accounts in KMM with starting balances matching my GC ending balances. Given as previously advised, i was able to import all my GC Categories into KMM, i've then also manually recreated all my Scheduled Transactions from GC in KMM. This was all a bit tedious, but the result seems worth it, as now i can see just how impressive KMM really is... it's quite wonderful !!

Well done to you & all other developers past & present; it's a very good product.

Steffie.

Code: Select all

Thanks Cristian, that was a good idea, & i tried it. I found 7 instances of that string, so i deleted them [in a copy of my GC file of course] & then retried the import. Unfortunately the same type of error msg came up, but this time with a different long string. I suspect this behaviour will simply iterate.


In what context did those accounts appear? Are they still present when importing only the account structure and not the actual transactions?

I've decided to give up trying to import my data, regrettably, & have simply created my various accounts in KMM with starting balances matching my GC ending balances. Given as previously advised, i was able to import all my GC Categories into KMM, i've then also manually recreated all my Scheduled Transactions from GC in KMM. This was all a bit tedious, but the result seems worth it, as now i can see just how impressive KMM really is... it's quite wonderful !!

You can ignore my previous questions if you don't want to pursue this anymore.

Well done to you & all other developers past & present; it's a very good product.

Thanks.

It would probably quite helpful to understand what causes this import error. If you have some time to experiment, and like tinkering, you could try a couple of things:

- Is the unknown erroneous account really an account, or is it an investment, or a category? Knowing your GC accounts, can you think of anything that is referenced seven times?

- How many times does the second error string occur, after you delete the first one? That may give an extra hint.

- Gather some small excerpts of your GC xml file into a subset and try importing it. If successful, try expanding the subset until you hit the error message.

- If you define one of your GC accounts manually in KMM, can you import successfully into it? Idem for categories or investments. Maybe this is a way of error-free piece-wise import?

I used these techniques when migrating fro MSMoney, importing chunks from a big CSV file one at a time, until I had everything. I did rely extensively on scripting to extract data selectively.

Hi Cristian

"In what context did those accounts appear? Are they still present when importing only the account structure and not the actual transactions?"

In my "complete" GC file [containing all my historical data], there are 7 instances of that Account Code [scattered through the file], thus:
<act:id type="guid">8334de269475ee1b6aaf10a38265c86e</act:id>
<act:parent type="guid">8334de269475ee1b6aaf10a38265c86e</act:parent>
<act:parent type="guid">8334de269475ee1b6aaf10a38265c86e</act:parent>
<act:parent type="guid">8334de269475ee1b6aaf10a38265c86e</act:parent>
<slot:key>8334de269475ee1b6aaf10a38265c86e</slot:key
<slot:key>8334de269475ee1b6aaf10a38265c86e</slot:key>
<slot:key>8334de269475ee1b6aaf10a38265c86e</slot:key>

In my "reduced" GC file [containing only my Account structure], there are only 4 instances of that Account Code [scattered through the file], thus:
<act:id type="guid">8334de269475ee1b6aaf10a38265c86e</act:id>
<act:parent type="guid">8334de269475ee1b6aaf10a38265c86e</act:parent>
<act:parent type="guid">8334de269475ee1b6aaf10a38265c86e</act:parent>
<act:parent type="guid">8334de269475ee1b6aaf10a38265c86e</act:parent>

I've spent many hours today playing around on this, & frustratingly i've not been able to replicate the behaviour that i previously posted [wrt my "complete" GC file]. Today, every attempt that i've made to delete either just the specific string "8334de269475ee1b6aaf10a38265c86e", OR alternatively the complete line containing the string, in all cases resulted in a GC file that would no longer open in GC [instead giving this error msg: "No suitable backend was found for file://E:\Temp\Steffie 2003+ (SNIP).gnucash[/i]"] ... AND this response when trying to Import to KMM: "[i]File E:/Temp/Steffie 2003+ (SNIP).gnucash contains the old binary format used by KMyMoney. Please use an older version of KMyMoney (0.8.x) that still supports this format to convert it to the new XML based format.". I cannot fathom what i'm doing differently today.

The only previous behaviour today that i can replicate from before, is KMM's response when i repeat attempts to import my complete GC file [with no editing]. That is, as per earlier post: After i acknowledge the "Import failed: Unknown account id:..." error msg, it gives a similar error msg to the one that initiated this Post, ie,

(a) "Cannot load file E:\Temp\Steffie 2003+ (SNIP).gnucash. Reason: No storage object attached to MyMoneyFile".

(b) Once i acknowledge this, after a few moments the KMM window updates with all my accounts listed, apparently as hyperlinks [but they don't work]. The icons in the row across the top also do not work, & all the icons in the LHS column also don't work [in fact are all ghosted out]. This page is "fragile", in that i can't save it, & if i click the link at the very bottom saying "Show KMM welcome page", then all my account listings vanish & cannot be retrieved."

Even though it would have been fab to be able to import all my data, the fact that i'm not a programmer, don't understand any of this code, & feel that i'm just wasting time now, drives me to have to just give up on this.

Thanks all the same. Steffie.

Hi Zebulon, thanks.

"Is the unknown erroneous account really an account, or is it an investment, or a category? Knowing your GC accounts, can you think of anything that is referenced seven times?"

--> It's certainly not an account / investment / category in that format, however i suspect that its plain-text name is very different to that meaningless [to me] code; to me [as a non-programmer] it's like plain-english names have been converted to hexadecimal or similar, which i cannot interpret. I have observed today however that when reading the uncompressed GC file in my text editor, there's gazillions of other similarly unintelligible strings throughout.

"How many times does the second error string occur, after you delete the first one? That may give an extra hint."

--> "Import failed: Unknown account id '471f86d00d84ca2b54312bb4b59d72eb' " is the subsequent string, & it occurs 11 times. Sadly it's equally incomprehensible to me.

"If you define one of your GC accounts manually in KMM, can you import successfully into it?"

--> No, if i have *any* non-empty KMM file open, & then try to import *any* GC file, KMM tells me that's not possible & that i must begin a new [empty] file for the import.

As per my reply to Cristian a few minutes ago, i feel that i'm just wasting time & i have become demoralised, so think it's best that i give up. On the upside, per a previous post, even though it does not have my historical data, my new KMM file in which i manually created all my Scheduled Transactions to mimic GC, & which did at least successfully import all my GC accounts & categories, looks pretty good, is functional, & will over time obviously contain all new "history" from creation date a few days ago.

Best wishes.
Steffie.

"Import failed: Unknown account id '471f86d00d84ca2b54312bb4b59d72eb' " is the subsequent string, & it occurs 11 times.

Good news, with the help of another user who managed to provide a testfile we've managed to fix this Bug #283848.

Hi Cristian -- thanks for the update... but i'm sorry i don't really understand exactly what i now need to do. I followed your link & read that other bug, & it seems that the clue is "Disable MyMoneyFile signals while we import a GnuCash file" ... but i don't know what that means. I noticed that the other user uses Linux, whereas i use Windows ... is that maybe partly why i don't understand?

Steffie.

The comment written by Cristian is a development issue, not meant to be understood by normal users, but a pointer for other developers reviewing the bug.

If Cristian says the issues are similar, then you should wait until the Windows version is updated and give it a try

Hei Ku -- thanks. Oh, i see ... sorry for my ignorance. Would it be silly of me to ask if anyone might know approximately when the next Windows version might be released? I'm guessing at least another couple of months... Steffie.