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

[Resolved] Import From MS Money

Tags: None
(comma "," separated)
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: [Resolved] Import From MS Money

Sat Dec 28, 2013 1:14 pm
Could you remove spaces in the file name? A bug exists on 1.8.0.


Skrooge, a personal finances manager powered by KDE
Image - PayPal
xenomorphe
Registered Member
Posts
4
Karma
0
OS

Re: [Resolved] Import From MS Money

Sat Dec 28, 2013 1:43 pm
Ok
with no spaces in the file name and path the import works! Thank you very much for your help!
And happy new year's eve!

Nicolas
ehoffman
Registered Member
Posts
2
Karma
0

Re: Import From MS Money

Fri Jan 03, 2014 4:28 pm
Got a similar problem with a big unprotected MsMoney 2005 file.

So I removed the spaces in the file name and it went a bit further. With the spaces, it was asking for the password immediately. Now it processes the file for a quite some time before asking again for a password.

Regards
ehoffman
Registered Member
Posts
2
Karma
0

Re: [Resolved] Import From MS Money

Fri Jan 03, 2014 4:36 pm
And if I run the command line from above, I am getting the following error:

Code: Select all
mkdir /tmp/skrooge; java -cp ~/.skrooge/sunriise.jar com/le/sunriise/export/ExportToJSON "/home/eric/Documents/hof.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*
0 [main] INFO  com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:258) - dbFile=/home/eric/Documents/hof.mny
34 [main] INFO  com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:259) - outDir=/tmp/skrooge
69 [main] INFO  com.le.sunriise.Utils.openDb(Utils.java:171) - # Opening dbFile=/home/eric/Documents/hof.mny
18813 [main] INFO  com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:268) - < DONE
Exception in thread "main" java.lang.IllegalStateException: Internal error: constructor for java.util.HashMap$2 has mismatch: 1 parameters; 0 sets of annotations
   at com.fasterxml.jackson.databind.introspect.AnnotatedClass._constructConstructor(AnnotatedClass.java:787)
   at com.fasterxml.jackson.databind.introspect.AnnotatedClass.resolveCreators(AnnotatedClass.java:335)
   at com.fasterxml.jackson.databind.introspect.AnnotatedClass.getConstructors(AnnotatedClass.java:227)
   at com.fasterxml.jackson.databind.introspect.POJOPropertiesCollector._addCreators(POJOPropertiesCollector.java:381)
   at com.fasterxml.jackson.databind.introspect.POJOPropertiesCollector.collect(POJOPropertiesCollector.java:224)
   at com.fasterxml.jackson.databind.introspect.BasicClassIntrospector.collectProperties(BasicClassIntrospector.java:139)
   at com.fasterxml.jackson.databind.introspect.BasicClassIntrospector.forSerialization(BasicClassIntrospector.java:65)
   at com.fasterxml.jackson.databind.introspect.BasicClassIntrospector.forSerialization(BasicClassIntrospector.java:11)
   at com.fasterxml.jackson.databind.SerializationConfig.introspect(SerializationConfig.java:468)
   at com.fasterxml.jackson.databind.ser.BeanSerializerFactory.createSerializer(BeanSerializerFactory.java:129)
   at com.fasterxml.jackson.databind.SerializerProvider._createUntypedSerializer(SerializerProvider.java:938)
   at com.fasterxml.jackson.databind.SerializerProvider._createAndCacheUntypedSerializer(SerializerProvider.java:894)
   at com.fasterxml.jackson.databind.SerializerProvider.findValueSerializer(SerializerProvider.java:429)
   at com.fasterxml.jackson.databind.SerializerProvider.findTypedValueSerializer(SerializerProvider.java:520)
   at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:87)
   at com.fasterxml.jackson.databind.ObjectWriter._configAndWriteValue(ObjectWriter.java:567)
   at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:477)
   at com.le.sunriise.json.JSONUtils.writeValue(JSONUtils.java:47)
   at com.le.sunriise.json.JSONUtils.writeValue(JSONUtils.java:55)
   at com.le.sunriise.json.JSONUtils.writeValue(JSONUtils.java:62)
   at com.le.sunriise.export.ExportToJSON.exportMnyContext(ExportToJSON.java:91)
   at com.le.sunriise.export.ExportToJSON.visitAccounts(ExportToJSON.java:121)
   at com.le.sunriise.report.AbstractAccountVisitor._visit(AbstractAccountVisitor.java:72)
   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)
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: [Resolved] Import From MS Money

Tue Jan 14, 2014 7:16 am
This is a bug in sunriise. You can may be submit a bug on suriise project:
http://sourceforge.net/projects/sunriise/


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

Re: [Resolved] Import From MS Money

Tue Aug 12, 2014 11:42 pm
Hi smankowski,

I m bigginer in ubuntu and trying to move from MSmoney to skrooge.
I just download it and updated it on you website.
But when i want to import .mny, skrooge ask for a code. and there is no protection on the file.
if i press "annuler"
I have that
[ERR-5]: L'importation du fichier « file:///home/ct/Bureau/money.mny » a échoué
I tried this:
ct@Toshiba:~$ mkdir /tmp/skrooge; java -cp ~/.skrooge/sunriise.jar com/le/sunriise/export/ExportToJSON "file:///home/ct/Bureau/Money.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*

And i got that

mkdir: impossible de créer le répertoire «/tmp/skrooge»: Le fichier existe
0 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:258) - dbFile=file:/home/ct/Bureau/Money.mny
9 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:259) - outDir=/tmp/skrooge
19 [main] INFO com.le.sunriise.Utils.openDb(Utils.java:171) - # Opening dbFile=/home/ct/file:/home/ct/Bureau/Money.mny
63 [main] ERROR com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:266) - java.io.FileNotFoundException: given file does not exist: file:/home/ct/Bureau/Money.mny
java.io.FileNotFoundException: given file does not exist: file:/home/ct/Bureau/Money.mny
at com.healthmarketscience.jackcess.Database.open(Database.java:636)
at com.healthmarketscience.jackcess.Database.open(Database.java:601)
at com.le.sunriise.Utils.openDb(Utils.java:230)
at com.le.sunriise.Utils.openDb(Utils.java:56)
at com.le.sunriise.Utils.openDbReadOnly(Utils.java:60)
at com.le.sunriise.report.AbstractAccountVisitor.visit(AbstractAccountVisitor.java:45)
at com.le.sunriise.export.ExportToJSON.export(ExportToJSON.java:212)
at com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:264)
67 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:268) - < DONE
ls: impossible d'accéder à /tmp/skrooge/*: Aucun fichier ou dossier de ce type

I tried this

ct@Toshiba:~$ mkdir /tmp/skrooge; java -cp ~/.skrooge/sunriise.jar com/le/sunriise/export/ExportToJSON "file:///home/ct/Bureau/money.mny" /tmp/skrooge && echo "rc="$?

And got that

mkdir: impossible de créer le répertoire «/tmp/skrooge»: Le fichier existe
0 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:258) - dbFile=file:/home/ct/Bureau/money.mny
9 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:259) - outDir=/tmp/skrooge
19 [main] INFO com.le.sunriise.Utils.openDb(Utils.java:171) - # Opening dbFile=/home/ct/file:/home/ct/Bureau/money.mny
64 [main] ERROR com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:266) - java.io.FileNotFoundException: given file does not exist: file:/home/ct/Bureau/money.mny
java.io.FileNotFoundException: given file does not exist: file:/home/ct/Bureau/money.mny
at com.healthmarketscience.jackcess.Database.open(Database.java:636)
at com.healthmarketscience.jackcess.Database.open(Database.java:601)
at com.le.sunriise.Utils.openDb(Utils.java:230)
at com.le.sunriise.Utils.openDb(Utils.java:56)
at com.le.sunriise.Utils.openDbReadOnly(Utils.java:60)
at com.le.sunriise.report.AbstractAccountVisitor.visit(AbstractAccountVisitor.java:45)
at com.le.sunriise.export.ExportToJSON.export(ExportToJSON.java:212)
at com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:264)
68 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:268) - < DONE
rc=0

Voila, je comprend rien au code, mais visiblement, il ne trouve pas mon fichier money? pourtant il est bien sur le bureau.

Y a t il une solution?
Merci
cyrilcd
Registered Member
Posts
9
Karma
0

Re: [Resolved] Import From MS Money

Wed Aug 13, 2014 7:53 am
oups, i don t anderstand anything... but i try.

I saw my mistake in th first command, i have done it again:

mkdir /tmp/skrooge; java -cp ~/.skrooge/sunriise.jar com/le/sunriise/export/ExportToJSON "/home/ct/Bureau/money.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*

and i got:

1 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:258) - dbFile=/home/ct/Bureau/money.mny
43 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:259) - outDir=/tmp/skrooge
132 [main] INFO com.le.sunriise.Utils.openDb(Utils.java:171) - # Opening dbFile=/home/ct/Bureau/money.mny
427 [main] INFO com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:268) - < DONE
Exception in thread "main" java.lang.IllegalStateException: Incorrect password provided
at com.healthmarketscience.jackcess.MSISAMCryptCodecHandler.verifyPassword(MSISAMCryptCodecHandler.java:145)
at com.healthmarketscience.jackcess.MSISAMCryptCodecHandler.<init>(MSISAMCryptCodecHandler.java:68)
at com.healthmarketscience.jackcess.MSISAMCryptCodecHandler.create(MSISAMCryptCodecHandler.java:81)
at com.healthmarketscience.jackcess.CryptCodecProvider.createHandler(CryptCodecProvider.java:66)
at com.le.sunriise.Utils$1.createHandler(Utils.java:188)
at com.healthmarketscience.jackcess.PageChannel.initialize(PageChannel.java:106)
at com.healthmarketscience.jackcess.Database.<init>(Database.java:906)
at com.healthmarketscience.jackcess.Database.open(Database.java:662)
at com.healthmarketscience.jackcess.Database.open(Database.java:601)
at com.le.sunriise.Utils.openDb(Utils.java:230)
at com.le.sunriise.Utils.openDb(Utils.java:56)
at com.le.sunriise.Utils.openDbReadOnly(Utils.java:60)
at com.le.sunriise.report.AbstractAccountVisitor.visit(AbstractAccountVisitor.java:45)
at com.le.sunriise.export.ExportToJSON.export(ExportToJSON.java:212)
at com.le.sunriise.export.ExportToJSON.main(ExportToJSON.java:264)
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: [Resolved] Import From MS Money

Wed Aug 13, 2014 4:37 pm
Hi,

Could you try to remove ~/.skrooge/sunriise.jar and retry the import with Skrooge?


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

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 9:00 am
Hello Thank youfor the response.
I removed ~/.skrooge/sunriise.jar

I tried :
ct@Toshiba:~$ mkdir /tmp/skrooge; java -cp com/le/sunriise/export/ExportToJSON "file:///home/ct/Bureau/money.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*

I got

mkdir: impossible de créer le répertoire «/tmp/skrooge»: Le fichier existe
Erreur : impossible de trouver ou charger la classe principale file:...home.ct.Bureau.money.mny

I tried

ct@Toshiba:~$ ~$ mkdir /tmp/skrooge; java -cp com/le/sunriise/export/ExportToJSON "/home/ct/Bureau/money.mny" /tmp/skrooge && echo "rc="$?
I got
~$ : commande introuvable
Erreur : impossible de trouver ou charger la classe principale .home.ct.Bureau.money.mny

I tried to import money.mny with skrooge but it still ask me for Keyword.

I understood that my file is not found so i tried:
ct@Toshiba:~$ find . -name "*.mny"
And i got
./Bureau/money.mny

have I done something wrong?
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 11:59 am
Yes, you have to retry the import FROM SKROOGE first to download the last version of sunriize.


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

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 12:49 pm
I uninstall Skrooge and went to your web site.

I made:

sudo add-apt-repository ppa:s-mankowski/ppa

after

sudo apt-get update

and finally

sudo apt-get install skrooge

It s skrooge 1.9.0

I tried again to launch import with the graphic interface.
Result
[ERR-5]: L'importation du fichier « file:///home/ct/Bureau/money.mny » a échoué

Je tryed again:
ct@Toshiba:~$ mkdir /tmp/skrooge; java -cp com/le/sunriise/export/ExportToJSON "file:///home/ct/Bureau/money.mny" /tmp/skrooge && ls -artl /tmp/skrooge/*
result
mkdir: impossible de créer le répertoire «/tmp/skrooge»: Le fichier existe
Erreur : impossible de trouver ou charger la classe principale file:...home.ct.Bureau.money.mny

I don t understand how to get the last sunriise?

Sorry for my poor english and my bad programm skills.
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 1:15 pm
Normally, when you tried to import the .mny file from Skrooge. You should have a message to propose you to install sunriize.


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

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 1:26 pm
It doesn t propose me to install it
In skrooge, i go in "import"
"importer..."
I select the file
and skrooge directly ask for a pasword.
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 1:32 pm
You don't really understand.

Could you remove THE FILE ~/.skrooge/sunriise.jar ?
You just have to execute this;
rm ~/.skrooge/sunriise.jar

Then, could you retry the import from Skrooge?


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

Re: [Resolved] Import From MS Money

Thu Aug 14, 2014 1:39 pm
Oupps, exact, i didn t undrestand :<
Sorry

Know, i made

ct@Toshiba:~$ rm ~/.skrooge/sunriise.jar

I whent into skrooge and try to import.
Skrooge told me: [ERR-13]: L'application « sunriise » est nécessaire pour l'importation « Microsoft Money » mais elle n'est pas installée dans ...
I click on "installer"
Skrooge says : L'installation sera faite durant la prochaine importation
I try to import again
And Skrooge ask me for a password.
Image

it s still not working.
do you see any other option?
thank you

Last edited by cyrilcd on Thu Aug 14, 2014 3:38 pm, edited 1 time in total.


Bookmarks



Who is online

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