QIF Import and accounts

[Ian Lewis]

Georg,

There is a bug in the QIF importer in which the currency is only asked for
if you create new accounts. I have provided a patch in the bug report.

See: http://bugzilla.gnome.org/show_bug.cgi?id=504007

Ian

2008/1/6, Georg Stapper <georgstapper at yahoo.com>:
>
> Hi there,
>
> After a lot of struggling I managed to import my Excel data via QIF files
> into an account hierarchy with 3 different currencies. The key was to change
> the locale to the corresponding currencies.
>
> However, I am wondering why the QIF importer sometimes asks for the
> account currency, but most of the times not? Is there anybody who knows?
>
> Kind regards,
> Georg
>
> ----- Original Message ----
> From: Derek Atkins <warlord at MIT.EDU>
> To: Georg Stapper <georgstapper at yahoo.com>
> Cc: GnuCash <gnucash-user at gnucash.org>
> Sent: Tuesday, 18 December, 2007 7:55:02 PM
> Subject: Re: QIF Import and accounts
>
> Honestly, my answer would be "Start from scratch on January 1st".
> Yeah, it wont give you your history, but you'll still be able to
> work going forward.  But if you WANT to work on the QIF importer,
> many people would be very happy!
>
> -derek
>
> Quoting Georg Stapper <georgstapper at yahoo.com>:
>
> > My intention was actually to reduce the work.
> > It seems that it's not so easy. There seems to be no perfect solution
> around.
> >
> > ----- Original Message ----
> > From: Derek Atkins <warlord at MIT.EDU>
> > To: Georg Stapper <georgstapper at yahoo.com>
> > Cc: Mike Alexander <mta at umich.edu>; gnucash-user at gnucash.org
> > Sent: Tuesday, 18 December, 2007 9:33:56 PM
> > Subject: Re: QIF Import and accounts
> >
> > With multiple currencies???
> > Umm, I'm afraid I dont have a good answer for you.
> > Maybe write a PERL script that generates a gnucash data file?  ;)
> > Or learn enough scheme to fix the current importer..
> > Or finish the implementation of the new importer?
> >
> > Sorry,
> >
> > -derek
> >
> > Quoting Georg Stapper <georgstapper at yahoo.com>:
> >
> >> So what should be my strategy to get my Excel data history (and
> >> future data) into GNC?
> >>
> >> Try completely different account hierarchies for each currency?
> >> Try little QIF files to train the importer?
> >> Try little QFX files to train the importer?
> >>
> >> What is the most promissing way?
> >>
> >> Thanks a lot,
> >> Georg
> >>
> >>
> >> ----- Original Message ----
> >> From: Derek Atkins <warlord at MIT.EDU>
> >> To: Georg Stapper <georgstapper at yahoo.com>
> >> Cc: Mike Alexander <mta at umich.edu>; gnucash-user at gnucash.org
> >> Sent: Tuesday, 18 December, 2007 6:48:26 PM
> >> Subject: Re: QIF Import and accounts
> >>
> >> Georg Stapper <georgstapper at yahoo.com> writes:
> >>
> >>> If I remember correctly, OFX does not take care of categories. That
> >>> is why I tried to use QIF. Or can I tell OFX files to consider
> >>> account structures?
> >>
> >> Nope.  nor can OFX handle split transactions.
> >>
> >>> I tried already Big Red's QIF Fixer. There is also an a preogram
> >>> called MT2OFX that can be used to convert all sorts of formats. But
> >>> finally I would like to import my categories/accounts.
> >>
> >> Okay..
> >>
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>
> >> -derek
> >>
> >> --
> >>      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>      Member, MIT Student Information Processing Board  (SIPB)
> >>      URL: http://web.mit.edu/warlord/    PP-ASEL-IA    N1NWH
> >>      warlord at MIT.EDU                        PGP key available
> >>
> >>
> >>      __________________________________________________________
> >> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
> >>
> >>
> >
> >
> >
> > --
> >      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >      Member, MIT Student Information Processing Board  (SIPB)
> >      URL: http://web.mit.edu/warlord/    PP-ASEL-IA    N1NWH
> >      warlord at MIT.EDU                        PGP key available
> >
> >
> >      __________________________________________________________
> > Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
> >
> >
>
>
>
> --
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA    N1NWH
>       warlord at MIT.EDU                        PGP key available
>
>
>       __________________________________________________________
> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>