Hi,

I'm trying to leave the last bit of Microsoft that I still use : MS Money 98.
I've read that skrooge can import .mny files, so I gave it a try.

Unfortunately, I receive a dialog box asking for a password though I have no password on my .mny file.
I tried to run MS Money again and put a password. But still Skrooge cannot import it after I enter the new password.

In another article, Stephane was suggesting to run :

mkdir /tmp/skrooge; java -cp ~/.skrooge/sunriise.jar com/le/sunriise/export/ExportToJSON "/home/christian/Documents/noscomptes7.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*

I've done that and this is the error I get:
Exception in thread "main" java.lang.IllegalArgumentException: JetFormat VERSION_3 does not currently support index lookups

I'm sure there must there must be something wrong in my .mny file: when I try with a new .mny file, the import works perfectly.

Thanks for helping
Christian

Hello Christian,

Skrooge uses sunriise. jar to extract transactions from a mny file.
The mny file must not be password-protected.
In your case, sunriize cannot extract the data. Indeed, your file seems to contain data that is not compatible with sunriize.

You may want to try saving your mny file with a newer version of Microsoft Money (example: Microsoft Money Plus Sunset).
Otherwise, you can pass by the QIF format but some data will be lost (example: programmed operations).

Regards.
Stéphane

Where can I find the sunriise.jar file that is required to import the MS Money (mny) files?
I have searched including the source code for skrooge 2.18 and 2.21 and I'm not able to find it anywhere?
BTW, I want to import my 2003 MS Money file.

Hi,

If sunriise.jar is not installed, Skrooge will propose you to download it and install it for you.
You just have to click on a button to accept it.

For information, the jar file is downloaded from here: https://skrooge.org/files/sunriise.jar

Hi,
I downloaded the file. There are no instructions included as to where this file is to be installed.
Can you please provide me with those instructions?
BTW, I am using a 64 bit debian GNU/Linux 10 (buster) under the MX-Linux distro.
The Skrooge version is 2.21.1.

Best Regards
Roger

Further to my previous post,

This is the error message that I get when trying to import the 2003 MNY file using Skrooge 2.21.1.
I took the password protection off and still get the same error.
[ERR-5]: Import of file named 'file:///home/Roger/Desktop/THERRIEN_2020.MNY' failed.

I went to version 2.18.0 and tried the MNY import again.
It works perfectly as it imported all of my different accounts from the password protected MNY file.

I then tried it again using version 2.21.1. The import doesn't work as I still get the same error.
Something is obviously different as to how the program handles the NNY import.

I have not yet tried to read OFX files from my bank download using both versions.
Depending on which version works best with the OFX, that is the version that I will use.

Is version 2.18.0 more stable than version 2.21.1?

Best Regards
Roger

Hi,

No Skrooge 2.18.0 is not more stable than 2.21.1.
This part of code has not been changed, so I don't understand the change of behavior.
Are you sure this is on the same file?
When you have the error, do you have a button to display more details? Could you paste here these details?
Could you provide traces ?
Execute following lines in the console.

Code: Select all

    export SKGTRACE=255
    skrooge > traces.txt

Replay your scenario.
Send me the file traces.txt by email (you can find my email in the About of Skrooge)

Regards.

Hello,
I reverted back to v 2.180 as it works without any issues.
On version 2.21.1, the MNY import does not work at all. It only shows the error message at the top in red without any other notification.
Also, on version 2.21.1, whenever I press on a URL link, it opens my Thunderbird email instead of Firefox.
Under v2.18, I don't have those strange problems.

By reinstalling v 2.21.1, will that corrupt my existing SGK file?

BTW, with version 2.21.1, the only way that I can install it is using flatpack.
I'm wondering if this is the problem.
With v2.18.0, the install is through the regular stable debian repositories.

good morning,

i found this thread and I have the same issue! The errors in my application are described above.

I use siduction linux (all updates are installed) and skrooge 2.21.1. The mny-file is created with MSMONEY 99 PLUS; last German edition.
The file sunriise.jar is installed in ~/skrooge. If I start this file with the command

~/.skrooge$ java -jar sunriise.jar

can I open the mny-file without issues. I see the tables and so on (no password have to input). Skrooge keeps asking for a password! This loop can only be ended with CANCEL.

What is the reason for this behaviour and how can I import my mny-file?

Thanks in advanced for help.
Michael

rogert wrote:BTW, with version 2.21.1, the only way that I can install it is using flatpack.
I'm wondering if this is the problem.
With v2.18.0, the install is through the regular stable debian repositories.

Hi,

This could be due to the flatpack version. I will investigate.
If you are on ubuntu, you can install the last version by using my ppa.
See here: https://skrooge.org/ubuntu_installation

It's definitely related to the flatpack installation.
I deleted the flatpack version and installed the debian 2.21.1 version from the bullseye repository as the stable depository only has the 2.18 version.
Skrooge v2.21.1 now works with the MNY import as do the URL links.

Best Regards
Roger

Hello,

I asked for help on 23th of February. Unfortunately, no response has been received. What can I do to solve my problem? Which information do I have to provide?

michibaby

michibaby wrote:Hello,

I asked for help on 23th of February. Unfortunately, no response has been received. What can I do to solve my problem? Which information do I have to provide?

michibaby

Hi,

Sorry, I missed your post.
Could you try this from a console (replace your_file by the path to your file)?

Code: Select all

java -cp sunriise.jar com/le/sunriise/export/ExportToJSON your_file

What is the output?

Hi,

the output is:
0 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:258) - dbFile=1997_Kopie_-_wo_passwd.mny
2 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:259) - outDir=test_2020-03-23
5 [main] INFO com.le.sunriise.Utils.openDb(Utils.java:171) - # Opening dbFile=/mnt/Daten_HomeServer/All_Users_Share/Global_Windows_Share/0_Datentransfer/Money/Datenuebernahme/1997_Kopie_-_wo_passwd.mny
63 [main] INFO com.healthmarketscience.jackcess.Database.readSystemCatalog(Database.java:1239) - Could not find expected index on table MSysObjects
338 [main] INFO com.le.sunriise.accountviewer.AccountUtil.retrieveTransactions(AccountUtil.java:114) - > getTransactions, account=Auto
373 [main] INFO com.le.sunriise.accountviewer.AccountUtil.retrieveTransactions(AccountUtil.java:192) - < getTransactions, delta=32, 0.7619047619047619 per txn
373 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:268) - < DONE
Exception in thread "main" java.lang.IllegalArgumentException: JetFormat VERSION_3 does not currently support index lookups
at com.healthmarketscience.jackcess.IndexCursor.createCursor(IndexCursor.java:138)
at com.healthmarketscience.jackcess.IndexCursor.createCursor(IndexCursor.java:105)
at com.healthmarketscience.jackcess.IndexCursor.createCursor(IndexCursor.java:82)
at com.healthmarketscience.jackcess.Cursor.createIndexCursor(Cursor.java:124)
at com.le.sunriise.accountviewer.AccountUtil.handleSplit(AccountUtil.java:218)
at com.le.sunriise.accountviewer.AccountUtil.retrieveTransactions(AccountUtil.java:146)
at com.le.sunriise.accountviewer.AccountUtil.retrieveTransactions(AccountUtil.java:109)
at com.le.sunriise.report.AbstractAccountVisitor._visitAccount(AbstractAccountVisitor.java:89)
at com.le.sunriise.report.AbstractAccountVisitor._visit(AbstractAccountVisitor.java:75)
at com.le.sunriise.report.AbstractAccountVisitor.visit(AbstractAccountVisitor.java:46)
at com.le.sunriise.export.ExportToJSON.export(ExportToJSON.java:212)
at com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:264)

The files in the output directory:
-rw-r--r-- 1 michael vmware 24589 Mär 23 18:01 categories.json
-rw-r--r-- 1 michael vmware 3749 Mär 23 18:01 currencies.json
-rw-r--r-- 1 michael vmware 10476 Mär 23 18:01 payees.json
-rw-r--r-- 1 michael vmware 4903 Mär 23 18:01 securities.json

michibaby