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

Migration from KMyMoney

Tags: None
(comma "," separated)
Vinz
Registered Member
Posts
2
Karma
0

Migration from KMyMoney

Sat Dec 05, 2015 12:52 pm
Hello,

First congratulations to the two developers of Skrooge for this very good software ! :)

I love the GUI of Skrooge (much more better than the one of KMM) and I'd like to migrate to it. I'm using Debian stable (Jessie) with its Skrooge compiled package (1.9.3BETA).

I've tried to import my KMM data but it has failed because of a category which was already existing in the default categories of Skrooge. Renaming the category (from KMM) or removing all default categories in Skrooge before the import has solved it. The import process has finished with success and I can see all my operations and categories wich are well imported into Skrooge.

But.. there's something very strange about the size of my Skrooge saved file: as the KMM file is about 410 kb, the Skrooge file is 48 MB !! And since the Skrooge file format is binary it's not easy to understand why it's so big. Could somebody help me ?

I'd also like to use a more recent version of Skrooge but it doesn't seem very easy to compile Skrooge 2.2.x on a Debian stable. And apparently there's no backports repositories... but I should post another thread for that.

Thanks, Vincent.
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: Migration from KMyMoney

Sat Dec 05, 2015 2:59 pm
Hello,
Vinz wrote:Hello,

First congratulations to the two developers of Skrooge for this very good software ! :)

I love the GUI of Skrooge (much more better than the one of KMM) and I'd like to migrate to it. I'm using Debian stable (Jessie) with its Skrooge compiled package (1.9.3BETA).

I've tried to import my KMM data but it has failed because of a category which was already existing in the default categories of Skrooge. Renaming the category (from KMM) or removing all default categories in Skrooge before the import has solved it. The import process has finished with success and I can see all my operations and categories wich are well imported into Skrooge.

Is it possible to have a sample file to reproduce this issue of import and enhance Skrooge?
Vinz wrote:But.. there's something very strange about the size of my Skrooge saved file: as the KMM file is about 410 kb, the Skrooge file is 48 MB !! And since the Skrooge file format is binary it's not easy to understand why it's so big. Could somebody help me ?

This is simple: this is due to the undo/redo mechanism.
Indeed, Skrooge is able to rollback all actions done including the big import.
You can reduce the size of your file by removing the history.
Vinz wrote:I'd also like to use a more recent version of Skrooge but it doesn't seem very easy to compile Skrooge 2.2.x on a Debian stable. And apparently there's no backports repositories... but I should post another thread for that.

Be aware that:
* Skrooge 1.9.3 is based on Qt4 / KDE4
* Skrooge 2.x.y is based on Qt5 / KF5

If you have the expected prerequisites this is not more complex to build Skrooge 2 than Skrooge 1.
Vinz wrote:Thanks, Vincent.

Regards,
Stephane


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

Re: Migration from KMyMoney

Sat Dec 05, 2015 4:49 pm
Hello Stéphane,

Thanks for your quick response.

Ok so about the big size of Skrooge file it is not a bug but it's a feature ! ;)

I have cleaned my history and now the saved file size is only 3.2 MB (instead 42 MB). It is still much bigger than the KMM file size but it's fine. The possibility to do/undo without any limits is a very good feature.

I have understood than Skrooge 1.x is based on Qt4/KDE4 as Skrooge 2.x is based on Qt5/Kf5 but it looks too much complicate for me to have all the Qt5/Kf5 dependencies on Debian Jessie. In fact I have even problems to compile Skrooge 1.2.13 (I have just posted on the Debian french forum for that).

In order you can reproduce the import bug I will try to prepare a sample file for you. FYI here is the error log I had:
Code: Select all
[ERR-5]: L'importation du fichier « file:///home/turman/Workspace/KMM/Accounting.kmy » a échoué
[ERR-10019]: UNIQUE constraint failed: category.t_name, category.rd_category_id Impossible d'extraire la ligne
[ERR-10019]: UPDATE category SET t_name='Cantine',t_fullname='Alimentation > A000119',t_bookmarked='N',rd_category_id='1' WHERE id=198


Thanks, Vincent.
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS

Re: Migration from KMyMoney

Sun Dec 06, 2015 8:28 pm
Thank you for the sample file, I did a correction (will be available in Skrooge 2.3.0).


Skrooge, a personal finances manager powered by KDE
Image - PayPal


Bookmarks



Who is online

Registered users: abc72656, Bing [Bot], daret, Google [Bot], lockheed, Sogou [Bot], Yahoo [Bot]