Bug 233930 - QIF address field is not imported
Summary: QIF address field is not imported
Status: RESOLVED FIXED
Alias: None
Product: skrooge
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Gentoo Packages Linux
: NOR wishlist
Target Milestone: ---
Assignee: Stephane MANKOWSKI
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-10 11:16 UTC by Nico Schlömer
Modified: 2010-04-17 18:48 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
QIF file with address field (4.76 KB, text/plain)
2010-04-10 15:22 UTC, Nico Schlömer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nico Schlömer 2010-04-10 11:16:11 UTC
Version:            (using KDE 4.3.5)
OS:                Linux
Installed from:    Gentoo Packages

Hi,

when importing QIF files, Skrooge will just silently drop the address field (as documented on <http://svn.gnucash.org/trac/browser/gnucash/branches/2.2/src/import-export/qif-import/file-format.txt>, see "Non-investment transaction format").

Cheers,
Nico
Comment 1 Stephane MANKOWSKI 2010-04-10 14:28:09 UTC
Could you provide me an example of QIF file containing address ?
Comment 2 Nico Schlömer 2010-04-10 15:22:17 UTC
Created attachment 42650 [details]
QIF file with address field

Certainly!
Attached is a manually modified file according to what is stated on

http://svn.gnucash.org/trac/browser/gnucash/branches/2.2/src/import-export/qif-import/file-format.txt

and

http://en.wikipedia.org/wiki/Quicken_Interchange_Format#Detail_Items
Comment 3 Stephane MANKOWSKI 2010-04-10 19:11:41 UTC
Hi,

Are you sure that your file is correct ?
For me, the right syntax should be the following one:
!Type:Bank
D2010-03-30
T26.00
PDOE JOHN
ADOE JOHN
ARUE DE QIF 43
A12345 NEW YORK CITY
ANY
MMY MESSAGE
C
^

instead of:
!Type:Bank
D2010-03-30
T26.00
PDOE JOHN
ADOE JOHN
RUE DE QIF 43
12345 NEW YORK CITY
NY
MMY MESSAGE
C
^

Could you confirm ?
Comment 4 Nico Schlömer 2010-04-11 01:24:48 UTC
Hi,
I think you are right, the rows should all start with A.
--Nico


On Sat, Apr 10, 2010 at 7:11 PM, smankowski <stephane@mankowski.fr> wrote:
> https://bugs.kde.org/show_bug.cgi?id=233930
>
>
>
>
>
> --- Comment #3 from smankowski <stephane mankowski fr>  2010-04-10 19:11:41 ---
> Hi,
>
> Are you sure that your file is correct ?
> For me, the right syntax should be the following one:
> !Type:Bank
> D2010-03-30
> T26.00
> PDOE JOHN
> ADOE JOHN
> ARUE DE QIF 43
> A12345 NEW YORK CITY
> ANY
> MMY MESSAGE
> C
> ^
>
> instead of:
> !Type:Bank
> D2010-03-30
> T26.00
> PDOE JOHN
> ADOE JOHN
> RUE DE QIF 43
> 12345 NEW YORK CITY
> NY
> MMY MESSAGE
> C
> ^
>
> Could you confirm ?
>
> --
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 5 Stephane MANKOWSKI 2010-04-11 15:34:57 UTC
SVN commit 1113678 by smankowski:

BUG: 233930: QIF address field is not imported 

 M  +1 -0      CHANGELOG  
 M  +3 -4      skg_dashboard2/skgdashboard2pluginwidget.cpp  
 M  +8 -7      skgbankmodeler/skgimportexportmanager.cpp  
 M  +15 -0     skgbankmodelertest/skgtestimportqif.cpp  
 A             tests/input/skgtestimportqif/233930.qif  
 M  +1 -1      tests/ref/skgtestimportqif/E0269787_ref.qif  
 M  +1 -1      tests/ref/skgtestimportqif/ref.qif  


WebSVN link: http://websvn.kde.org/?view=rev&revision=1113678
Comment 6 Nico Schlömer 2010-04-14 22:51:25 UTC
Hi,

thanks for the quick fix. I'm not sure now in how far Skrooge can
handle addresses now, though. -- Is it possible to have them listed in
column with the "Operations"?
Considering that QIF *and OFX have considerable address field support,
it may well be worth putting it in. For me personally it'd be very
useful to see at one glance in which country a certain transaction has
been done.

Shall I file another feature request for that?

--Nico



On Sun, Apr 11, 2010 at 3:35 PM, smankowski <stephane@mankowski.fr> wrote:
> https://bugs.kde.org/show_bug.cgi?id=233930
>
>
> smankowski <stephane@mankowski.fr> changed:
>
>           What    |Removed                     |Added
> ----------------------------------------------------------------------------
>             Status|ASSIGNED                    |RESOLVED
>         Resolution|                            |FIXED
>
>
>
>
> --- Comment #5 from smankowski <stephane mankowski fr>  2010-04-11 15:34:57 ---
> SVN commit 1113678 by smankowski:
>
> BUG: 233930: QIF address field is not imported
>
>  M  +1 -0      CHANGELOG
>  M  +3 -4      skg_dashboard2/skgdashboard2pluginwidget.cpp
>  M  +8 -7      skgbankmodeler/skgimportexportmanager.cpp
>  M  +15 -0     skgbankmodelertest/skgtestimportqif.cpp
>  A             tests/input/skgtestimportqif/233930.qif
>  M  +1 -1      tests/ref/skgtestimportqif/E0269787_ref.qif
>  M  +1 -1      tests/ref/skgtestimportqif/ref.qif
>
>
> WebSVN link: http://websvn.kde.org/?view=rev&revision=1113678
>
> --
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 7 Stephane MANKOWSKI 2010-04-17 18:48:44 UTC
(In reply to comment #6)
> Hi,
> 
> thanks for the quick fix. I'm not sure now in how far Skrooge can
> handle addresses now, though. -- Is it possible to have them listed in
> column with the "Operations"?
> Considering that QIF *and OFX have considerable address field support,
> it may well be worth putting it in. For me personally it'd be very
> useful to see at one glance in which country a certain transaction has
> been done.
> 
> Shall I file another feature request for that?
> 
> --Nico
> 

Ye, open one feature request even if this is not sure that we will implement it. ;-)