This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Cannot import .mny file

Tags: None
(comma "," separated)
dkorevaar
Registered Member
Posts
5
Karma
0

Cannot import .mny file

Mon Feb 03, 2014 5:36 pm
Hi,

I am using Skrooge V1.8 (from OpenSuse, on KDE V4.10, tried KDE V4.11, got the sources and compiled) but I always have the same error. I have a Microsoft Money file (from the french version of Money 2005). I have removed the password, so I can open it with Money without being asked a password.

When I set the SKGTRACE to 255 and start with skrooge --nofork > traces.txt and try file -> import -> import and select my .mny file, it tells me: 'This file seems to be protected. Please enter the password'. But there is none, so typing the original password, nothing or anything else I get: '[ERR-5] import of file named .... failed'.

I tried to open my file using the sunriise jar file using: java -jar .skrooge/sunriise.jar, I can open the file, but I see the button 'Encrypted' is selected. Removing the 'Encrypted' option gives the same type of error (please enter password).

cat traces.txt
##WARNING: Object::connect: No such signal org::freedesktop::UPower::DeviceAdded(QDBusObjectPath)
##WARNING: Object::connect: No such signal org::freedesktop::UPower::DeviceRemoved(QDBusObjectPath)

What do I need to do the get skrooge to open the file?

Regards
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: Cannot import .mny file

Mon Feb 03, 2014 7:36 pm
You can have this import error on file names with spaces.
Could you try to rename your file by removing space (in file name and path name) and try again?


Skrooge, a personal finances manager powered by KDE
Image - PayPal
dkorevaar
Registered Member
Posts
5
Karma
0

Re: Cannot import .mny file

Tue Feb 04, 2014 7:52 am
Hi,

> pwd
/home/derk
> ls -l Money/*.mny
-rwxr--r-- 1 derk users 4337664 Feb 3 14:49 Money/qdata-nl-copy.mny

No spaces in path or filename.

I tried both versions of sunriise:
> ls -l .skrooge/
total 19724
-rwxr--r-- 1 derk root 3546484 Feb 1 17:14 sunriise-0.0.2-SNAPSHOT-jar-with-dependencies.jar
-rwxr--r-- 1 derk root 13101105 Feb 1 17:14 sunriise-0.0.3-20111220.210334-1-jar-with-dependencies.jar
-rwxr-xr-x 1 derk root 3546484 Feb 4 08:39 sunriise.jar

With the version 0.0.3 I can see all data as in Money. With version 0.0.2 I get names of tables and table data so it is hard to figure out what is what. Both versions give exactly the same issue in skrooge (redemanding the non-existant password).

V0.0.2 came from http://heanet.dl.sourceforge.net/projec ... encies.jar
V0.0.3 from: http://sunriise.sourceforge.net/out/hle ... encies.jar

Regards,
Derk
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: Cannot import .mny file

Tue Feb 04, 2014 7:58 am
Could you tell me what is the output of the following command line?
(This is the command line used in skrooge to export data from mny file)

Code: Select all
mkdir /tmp/skrooge; java -cp ~/.skrooge/sunriise.jar com/le/sunriise/export/ExportToJSON "/home/derk/Money/qdata-nl-copy.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*


Skrooge, a personal finances manager powered by KDE
Image - PayPal
dkorevaar
Registered Member
Posts
5
Karma
0

Re: Cannot import .mny file

Tue Feb 04, 2014 1:24 pm
Hi,

Error: Could not find or load main class com.le.sunriise.export.ExportToJSON

Both for the V0.0.2 and the V0.0.3 file.

Regards,
Derk
dkorevaar
Registered Member
Posts
5
Karma
0

Re: Cannot import .mny file

Tue Feb 04, 2014 2:11 pm
Hi,

What a confusion: yes I discovered that none of the sunriise versions I had, had the class you are using (ExportToJSON). I found a newer one (https://sunriise.googlecode.com/files/s ... 50-app.jar) that DOES have this class. With that one I can open the .mny file.

I do get a lot of errors (673 to be exact). This is the list of uniq messages:
##WARNING: SKGServices::stringToInt(1BA) failed
##WARNING: SKGServices::stringToInt(1DV) failed
##WARNING: SKGServices::stringToInt(1GM) failed
##WARNING: SKGServices::stringToInt(1GT) failed
##WARNING: SKGServices::stringToInt(1IC) failed
##WARNING: SKGServices::stringToInt(1OV) failed
##WARNING: SKGServices::stringToInt(1ST) failed
##WARNING: SKGServices::stringToInt(1VZ) failed

Regards,
Derk
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: Cannot import .mny file  Topic is solved

Tue Feb 04, 2014 9:14 pm
I don't understand. The right version of sunriise is normally downloaded automatically by Skrooge in ~/.skrooge/sunriise.jar
You don't have to use your own version.

Anyway, If I well understood. You successfully imported your file! You just have some warning, but this is normal.


Skrooge, a personal finances manager powered by KDE
Image - PayPal
dkorevaar
Registered Member
Posts
5
Karma
0

Re: Cannot import .mny file

Wed Feb 05, 2014 10:42 am
Hi,

Well, I guess something went wrong with the download then. I read that sunriise is no longer part of the skrooge kit to limit its size, so I went looking for it. And then I discovered that not all sunriise jar files are equal. But I am glad it now works. I will see how I like it compared to the (now defunct) Microsoft Money. I need to cleanup all the French categories to get rid of Money's very special ideas about them.

Thanks for all the clarifications.

Regards,
Derk


Bookmarks



Who is online

Registered users: Bing [Bot], daret, Google [Bot], Sogou [Bot]