Bug 322892 - freeeze when importing a QIF file
Summary: freeeze when importing a QIF file
Status: RESOLVED UNMAINTAINED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.6.3
Platform: unspecified Microsoft Windows
: NOR crash
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-27 16:49 UTC by noftal
Modified: 2014-09-01 11:08 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
One of the QIF files that leads to the bug (188 bytes, text/plain)
2013-07-27 16:52 UTC, noftal
Details
new kmymoneyrc (7.82 KB, application/octet-stream)
2013-07-28 19:22 UTC, noftal
Details
old kmymoneyrc (7.43 KB, application/octet-stream)
2013-07-28 19:23 UTC, noftal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description noftal 2013-07-27 16:49:22 UTC
I already successfully imported 27 bank accounts. Now I try to import my investment accounts. I created an empty investment account and its liquidity bank account. I renamed the liquidity bank account so that its name is the same as my corresponding MS Money account
Then I tried to import data for this account from a QIF file coming from MS Money.
When I select the QIF file in the box named "Import a QIF File" and press OK, the box disappear but the process in the task bar freezes at 0%. I don't access to the following box which displays the KMM accounts where data should be imported in. 

It doesn't happen whith all selected QIF files but I didn't find the common points between all QIF files making this bug


Reproducible: Sometimes

Steps to Reproduce:
1.File/Import QIF File
2.Select certain QIF files (it doesn't happen with all)
3. Choose the option "other applications"
4. click OK
Actual Results:  
The screen freezes. Process displays 0% in the task bar

Expected Results:  
Should open the following box where I should select the KMM account where data should be imported in

Probably you will need one of the QIF files that causes the bug. How can I send it to you ?
This bug also appears with a new KMY file
Comment 1 noftal 2013-07-27 16:52:03 UTC
Created attachment 81384 [details]
One of the QIF files that leads to the bug

you should be able to make the bug happen if you create a simple bank account in a new KMY file then try to import the QIF file I sent you
Comment 2 allan 2013-07-27 17:08:34 UTC
(In reply to comment #1)
> Created attachment 81384 [details]
> One of the QIF files that leads to the bug
> 
> you should be able to make the bug happen if you create a simple bank
> account in a new KMY file then try to import the QIF file I sent you

I was able to load your file into an existing .kmy and also into a new file.
Comment 3 noftal 2013-07-27 18:55:37 UTC
here you can download my kmy file.
https://www.dropbox.com/s/x7e9iwttll7j3uz/stephmag_save2.anon.xml
Can you load my qif file into it ?
Comment 4 allan 2013-07-27 19:32:50 UTC
(In reply to comment #3)
> here you can download my kmy file.
> https://www.dropbox.com/s/x7e9iwttll7j3uz/stephmag_save2.anon.xml
> Can you load my qif file into it ?

Yes, no problem, three transactions.

It might be worth renaming your kmymoneyrc file, possibly in ~/.kde/share/config/ so that a new setup of KMM is used.

From where did you obtain your kmm version?
Comment 5 noftal 2013-07-27 20:54:15 UTC
I can't find such a file in :
C:\Program Files (x86)\KMyMoney\share\config

I work on Windows 7
I can't remember wher I donwloaded my kmm version. I remember it wasn't easy to find the french version.
would you recommend a secure URL where I can reinstall it ?
Indeed, I have some other minor troubleshooting which I can't explain such as : Why the prices format is still "1234.56" and not "1 234.56" since my Win7 is ruled that way and so is my kmm config ?
Anyway, I need to solve my first pb which is the subject of this topic. So maybe the solution is to reinstall a proper version ?
Comment 6 Jack 2013-07-27 21:45:47 UTC
Under Windows, the kmymoneyrc file will probably be somewhere under your own home directory (C:\Users\YourName\).  Also, as far as I know, for Windows, there is only one place to get KDE (http://windows.kde.org) although I admit I have no experience with non English versions.
Comment 7 allan 2013-07-27 22:42:50 UTC
(In reply to comment #6)
> Under Windows, the kmymoneyrc file will probably be somewhere under your own
> home directory (C:\Users\YourName\).  Also, as far as I know, for Windows,
> there is only one place to get KDE (http://windows.kde.org) although I admit
> I have no experience with non English versions.

Before considering a reinstall, I think it's worthwhile doing a search for the resource file.  I'm pretty sure Windows will have such a search.

So far as a French version is concerned, see if the KMM Settings/KDE Language settings helps.    If that doesn't show up, and if you do reinstall, look also to install a program called system settings (possibly preceded by KDE).
Comment 8 noftal 2013-07-28 08:42:17 UTC
I'm sure I didn't install KMM through a KDE installer as it si recommended on http://windows.kde.org/.
My installer was : kmymoney-x86-setup-4.6.3.exe 
I probably got it from here : 
https://sourceforge.net/projects/kmymoney2/files/KMyMoney-Windows/4.6.3/

I finally found kmymoneyrc and renamed it into kmymoneyrc.old. Then I launched KMM again and tried to import my QIF file unsuccessfully.
Do you think I should re-install KMM from windows.kde.org, now ?
Comment 9 allan 2013-07-28 09:46:28 UTC
(In reply to comment #8)
> I'm sure I didn't install KMM through a KDE installer as it si recommended
> on http://windows.kde.org/.
> My installer was : kmymoney-x86-setup-4.6.3.exe 
> I probably got it from here : 
> https://sourceforge.net/projects/kmymoney2/files/KMyMoney-Windows/4.6.3/

Well, well!  I didn't know about that one.  Whilst that is probably OK, and there does appear to have been quite an number of downloads, it's possible that something went wrong, or got corrupted.

> I finally found kmymoneyrc and renamed it into kmymoneyrc.old. Then I
> launched KMM again and tried to import my QIF file unsuccessfully.
> Do you think I should re-install KMM from windows.kde.org, now ?

  So, yes, I would reinstall from http://windows.kde.org/.  Look out for the systemsettings program during the process, too.
Comment 10 noftal 2013-07-28 09:57:28 UTC
In installed it along whith KDE.
The environment is a little different.
But It's worse :
- KMM is very, very slow (takes several seconds after clicking in th Browse button in the import box
- Chosing Settings/Kmm settings causes KMM to crash
- Regional settings of KDE like number formats are still not taken into account
- I still freeze when trying to import my QIF file 

When installing KDE I chose MinGW4 64 bits because my computer is a 64bits engine. Maybe I should have kept the default setting MSCV 2010 32 bit ?
Comment 11 allan 2013-07-28 10:22:18 UTC
(In reply to comment #10)
> In installed it along whith KDE.
> The environment is a little different.
> But It's worse :
> - KMM is very, very slow (takes several seconds after clicking in th Browse
> button in the import box
> - Chosing Settings/Kmm settings causes KMM to crash
> - Regional settings of KDE like number formats are still not taken into
> account
> - I still freeze when trying to import my QIF file 
> 
> When installing KDE I chose MinGW4 64 bits because my computer is a 64bits
> engine. Maybe I should have kept the default setting MSCV 2010 32 bit ?

That was quick!  I was expecting that to take several hours to install everything needed.

Did you uninstall the original first?  This is outside my area, but I think you have to delete the whole folder containing KMM.

Did you actually see the systemsettings file to install during the install process?
Comment 12 allan 2013-07-28 13:27:19 UTC
I've just installed KMM from Sourceforge and imported your file into a copy of the KMM file I created under Linux yesterday, also into a newly created file in Windows.

Also, to reassure you, the installation was very quick.
Comment 13 allan 2013-07-28 13:53:05 UTC
(In reply to comment #12)
> I've just installed KMM from Sourceforge and imported your file into a copy
> of the KMM file I created under Linux yesterday, also into a newly created
> file in Windows.
> 
> Also, to reassure you, the installation was very quick.

And also imported it into your anon file.
Comment 14 noftal 2013-07-28 16:10:06 UTC
I also did. It works ! 
Sometimes, the bug reappears but I can fix it by renaming Kmymoneyrc.
I still have around 15 investment accounts to import...
Comment 15 allan 2013-07-28 16:47:18 UTC
(In reply to comment #14)
> I also did. It works ! 
> Sometimes, the bug reappears but I can fix it by renaming Kmymoneyrc.
> I still have around 15 investment accounts to import...

Whilst it's good to make progress, you shouldn't get trouble with kmymoneyrc.  Might you be able to compare bad with good?
Comment 16 noftal 2013-07-28 19:21:52 UTC
I'm afraid not.
But I can attach both files : old and new
Comment 17 noftal 2013-07-28 19:22:41 UTC
Created attachment 81406 [details]
new kmymoneyrc
Comment 18 noftal 2013-07-28 19:23:07 UTC
Comment on attachment 81406 [details]
new kmymoneyrc

new kmymoneyrc
Comment 19 noftal 2013-07-28 19:23:51 UTC
Created attachment 81407 [details]
old kmymoneyrc
Comment 20 allan 2013-07-28 20:59:04 UTC
It wasn't clear between old and new as to which was believed good and which bad.  Anyway, I tried both with your qif file and both imported without problem.  Looking at both files I could see some differences, but nothing seemed particularly significant.

So, a few suggestions.

Firstly, can you run KMM from a terminal.  I don't know about your version of Windows,  but in my start menu, I have Command prompt, and also Run.  If you enter kmymoney.exe into either, that should launch and produce some output which might give a clue.  Also, in the bottom right of the KMM window you should see a status indicated -for instance, Loading Prices, which takes quite some time on your anon file.

If you've produced any reports, it might be worth deleting them - not the originals but your customised ones.  Also, in Settings/Configure KMM, in the Home view, untick  all boxes in the frame, which might speed thing up.  Later, just add back slowly any you particularly want.
Comment 21 allan 2013-07-28 21:15:31 UTC
(In reply to comment #20)
> It wasn't clear between old and new as to which was believed good and which
> bad.  Anyway, I tried both with your qif file and both imported without
> problem.  Looking at both files I could see some differences, but nothing
> seemed particularly significant.
> 
> So, a few suggestions.
> 
> Firstly, can you run KMM from a terminal.  I don't know about your version
> of Windows,  but in my start menu, I have Command prompt, and also Run.  If
> you enter kmymoney.exe into either, that should launch and produce some
> output which might give a clue.  

Ignore this bit as neither seem to produce output.  Also, it would be necessary to specify the full path to KMM.
The rest might help though.

> Also, in the bottom right of the KMM window
> you should see a status indicated -for instance, Loading Prices, which takes
> quite some time on your anon file.
> 
> If you've produced any reports, it might be worth deleting them - not the
> originals but your customised ones.  Also, in Settings/Configure KMM, in the
> Home view, untick  all boxes in the frame, which might speed thing up. 
> Later, just add back slowly any you particularly want.
Comment 22 Cristian Oneț 2013-09-13 09:25:06 UTC
(In reply to comment #10)
> In installed it along whith KDE.
> The environment is a little different.
> But It's worse :
> - KMM is very, very slow (takes several seconds after clicking in th Browse
> button in the import box
> - Chosing Settings/Kmm settings causes KMM to crash
> - Regional settings of KDE like number formats are still not taken into
> account
> - I still freeze when trying to import my QIF file 

These were known issues of the previous KDE on windows releases. If you only use KMyMoney on Windows from the KDE package please use the standalone installers is https://sourceforge.net/projects/kmymoney2/files/KMyMoney-Windows/ because they are better suited to run only KMyMoney.

> 
> When installing KDE I chose MinGW4 64 bits because my computer is a 64bits
> engine. Maybe I should have kept the default setting MSCV 2010 32 bit ?
Comment 23 Cristian Oneț 2013-09-13 09:30:47 UTC
Does the application freeze (does not respond) or only the import fails without a message? If the import fails without a message it could be fixed by this commit https://projects.kde.org/projects/extragear/office/kmymoney/repository/revisions/66a09c2516879642c9bf67860fe15c815286fb3a which will be available in the next release scheduled on 06.10.2013.
Comment 24 Cristian Oneț 2014-09-01 11:08:35 UTC
Closing these issues as unmaintained since we have been waiting for feedback on them for a year now.