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

Error importing QIF transaction with multiple line comment

Tags: qif, import qif, import qif, import
(comma "," separated)
snem
Registered Member
Posts
3
Karma
0
Hi,

I'm importing QIF and I have noticed that only the first line of comment field is imported. Next lines are lost.

For example, with this QIF statement:

^
D02/02/13
PTEST_PAYEE
Mcomment line 1
comment line 2
T-13,27
CX
LCategory

only "comment line 1" is imported.

I have used this regex to find multiple line in comment field: \n[EM].*\n[^\$\^TR]
I know it is not perfect (for instance if a comment line start with "T"), but it is a good workaround while this issue is not solved.

Regards,
Danilo
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS
You are right this kind of QIF file is imported as you expect because this seems to be not aligned with QIF format.
Code: Select all
^
D02/02/13
PTEST_PAYEE
Mcomment line 1
comment line 2
T-13,27
CX
LCategory


Indeed, as you can see here, each line should have a first character explaining the meaning of the following text.
(see http://svn.gnucash.org/trac/browser/gnucash/branches/1.8/src/import-export/qif-import/file-format.txt)

Without this rule, how to understand this example?
Code: Select all
^
D02/02/13
PTEST_PAYEE
Mcomment line 1
Line2
T-13,27
CX

Is it a multi line comment with "comment line 1\nLine2" as comment?
Or
Is it a simple transaction with "comment line 1" as comment and "ine2" as category?

So, the question is how did you get this kind of file?
Is this file generated by your bank or by another software?


Skrooge, a personal finances manager powered by KDE
Image - PayPal
snem
Registered Member
Posts
3
Karma
0
The QIF I used is generated by iBank on mac os x. I agree with you, it seems a bug of ibank.
I also assume that multiple line comment is not supported in skrooge, is it?

Regards
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS
snem wrote:I also assume that multiple line comment is not supported in skrooge, is it?

Right, multiple line comment is not supported in skrooge.


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


Bookmarks



Who is online

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