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

Batch QIF import?

Tags: None
(comma "," separated)
JantarMantar
Registered Member
Posts
36
Karma
0

Batch QIF import?

Fri Mar 20, 2009 5:16 pm
Hi,

I tried KMM a while ago and it was a bit buggy then. I'd like to try again, but I am reluctant to give up on MS Money just yet. I want to transfer all my historical and current accounts from MS Money -- which now number in hundreds. I can export all accounts in separate QIF files. Is there a way I can import a whole bunch of QIF files into KMM? Ideally, a command line mode would be perfect, so i can use shell script or something similar.

Thanks


JantarMantar, proud to be a member of KDE forums since 2008-Dec.
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

RE: Batch QIF import?

Fri Mar 20, 2009 8:17 pm
JantarMantar wrote:Is there a way I can import a whole bunch of QIF files into KMM? Ideally, a command line mode would be perfect, so i can use shell script or something similar.


If you're familiar with some sort of scripting (shell, Perl, ??) you can combine all your QIF files into a single one and then import that into KMyMoney.

Check (for example) http://xl2qif.chez-alice.fr/download/QIF99.pdf which contains some information about the record format used. If you need more information, please let us know.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
JantarMantar
Registered Member
Posts
36
Karma
0

RE: Batch QIF import?

Mon Apr 20, 2009 3:08 pm
ipwizard wrote:you can combine all your QIF files into a single one and then import that into KMyMoney.


Finally, I got around trying your suggestion, but it didn't work :-( It appears, KMM expects only one !Type record in one QIF file. I was hoping a subsequent !Type records will signal a start of next logical QIF file, but instead all transaction records from the file were attached to the first account defined with the !Type record.

Over the years I have accumulated a large MS Money file. Luckily, I figured out a semi-automated way to export all my 125 accounts into (either separate or one) QIF files. But getting these loaded into KMM is proving to be a challenge. I tried loading files one at a time, but along the way the data gets corrupted. The corruption could be the way I created QIF files, but it is tedious to try to load back 125 files one at a time to recreate the problem.

Please let me know if I can try any other alternatives.

Also couple of minor issues,

All my imported accounts, including credit cards show up under Assets. Anyway to import them in proper place (liability) in the hierarchy?

It would be nice if the import could remember the last location the file was imported from, instead of defaulting to ~/Documents folder each time (this happens in kubuntu).

Thanks for your response.


JantarMantar, proud to be a member of KDE forums since 2008-Dec.
JantarMantar
Registered Member
Posts
36
Karma
0

RE: Batch QIF import?

Mon Apr 20, 2009 6:52 pm
JantarMantar wrote:It appears, KMM expects only one !Type record in one QIF file. I was hoping a subsequent !Type records will signal a start of next logical QIF file, but instead all transaction records from the file were attached to the first account defined with the !Type record.


My bad. I guess I didn't understand the document correctly. I now realize that I need an !Account record in addition to the !Type record. I'll try recreating QIF file and hopefully KMM will like it better.

Thanks for your help.


JantarMantar, proud to be a member of KDE forums since 2008-Dec.


Bookmarks



Who is online

Registered users: Bing [Bot], claydoh, Evergrowing, Google [Bot], rblackwell