On Sat, Mar 27, 1999 at 05:42:06PM -0500, Dirk Eddelbuettel wrote:
>
> Shawn> I just installed xacc 1.0.18-2 from Debian Slink (but help|About
> Shawn> says it's 1.0.17?). Then I went to my bank's web site and
> Shawn> downloaded a QIF file. When I import it, all the transactions in
> Shawn> 1999 show up as being in 2099. I looked at the QIF, and sure enough
> Shawn> they use a 2-digit year field.
>
> You could upgrade to Debian's new gnucash package. While it is in potato, you
> can run it (as whatever else it needs, see below) on a slink system. I'm
> quite happy with, even though it segfaulted quite a bit on me the other
> day. "Save often" :)
Ah, didn't see that. Thanks.
BTW I did download the latest gnucash and got it compiled (after installing
a slew of other stuff). The QIF import blew up completely with this message:
Error: Internal Error: SplitRebalance(): no common split currencies
Error: account=Quicken Bank Account currency=(null) security=(null)
gnucash: Transaction.c:748: xaccSplitRebalance: Assertion `0' failed.
I looked at the code a bit and I guess maybe it's trying to make sure the
currency of each "split" matches the currency of the account being imported
into, but in the QIF the currency is undefined. I'll show you a snippet
of my QIF with amounts xxx'd out:
!Type:Bank^M
D03/25/099Share Withdrawal^M
T-xx.xx^M
C*^M
PShare Withdrawal^M
M^M
^^M
D03/24/099Point of Sale Transaction^M
T-xx.xx^M
C*^M
PPoint of Sale Transaction^M
M TGI FRIDAYS #1859 SCOTTSDALE AZUS^M
^^M
D03/22/099Check Number: 200^M
T-xx.xx^M
C*^M
PCheck Number: 200^M
M^M
^^M
D03/21/099Point of Sale Transaction ABCO^M
T-xx.xx^M
C*^M
PPoint of Sale Transaction ABCO^M
MFOODS #425 4101 N. 28TH STREET PHOENIX^M
^^M
D03/20/099Point of Sale Transaction FRY'S^M
T-xx.xx^M
C*^M
PPoint of Sale Transaction FRY'S^M
MFOOD STOR 7770 E. MCDOWELL SCOTTSDALE^M
^^M
D03/19/099Direct Deposit^M
Txx.xx^M
C*^M
PDirect Deposit^M
M ADMINISTAFF COMP^M
^^M
D03/18/099Check Number: 203^M
T-xx.xx^M
C*^M
PCheck Number: 203^M
M^M
(etc).
Actually this is slightly modified: originally the dates all said 199 for the
year, but that is what caused it to become 2099 in Xacc, so I changed it to
099 and got 1999. I guess the 0 or 1 is supposed to mean which century,
but xacc interpreted 1 as 2000 and my bank thinks 1 is 1900. So it's not
quite a 2 digit year, but I'm just guessing on what the significance of
the third digit is.
Anyhow... as you can see this is a simple list of transactions, no account
name and no currency definition or any other account-related stuff.
So when I import it, rather than importing the data into my existing
account that I created, it creates a new one called "Quicken Bank Account".
If you can tell me what the format is supposed to be to specify what account,
I could at least write a perl script to add some extra lines to the QIF.
Ideally the program would prompt "which account" (a dialog with a combobox
selector, one of which would be "create new account") in this situation.
> edd@sonny:~> dpkg -s gnucash
> Package: gnucash
> Status: install ok installed
> Installed-Size: 1473
> Maintainer: Tyson Dowd <[EMAIL PROTECTED]>
> Version: 1.1.26-1
> Depends: lesstifg (>= 1:0.85.2), libc6, libguile4 (>= 1:1.3-12), libjpeg62,
>libncurses4, libpng2, libreadlineg2 (>= 2.1-12), xlib6g (>= 3.3-5), xmhtml1, xpm4g
>(>= 3.4j-0), zlib1g (>= 1:1.1.3)
> Description: A personal finance tracking program.
> Gnucash can track finances in multiple accounts, keeping running
> and reconciled balances. It has an X based graphical user interface,
> double entry, a hierarchy of accounts, expense accounts (categories),
> and can import Quicken QIF files.
>
> Shawn> The usual way to fix bugs like this is to assume that years past 70
> Shawn> or so are in the 1900's and the rest are past 2000. Why is it not
> Shawn> done this way with QIF import?
>
> I only tried one QIF import, and it blew up on me. Very old version of
> quicken, though.
I don't have quicken at all so don't know how compliant the qifs from my
bank's website are.
>
> Shawn> Should I just get a Motif 1.1.x series GnuCash or is that not stable
> Shawn> enough?
>
> You might to try them both. The new series has a slew of features, and
> probably a few bugs as well.
>
> --
> If the current stylistic distinctions between open-source and commercial
> software persist, an open-software revolution could lead to yet another
> divide between haves and have-nots: those with the skills and connections
> to make use of free software, and those who must pay high prices for
> increasingly dated commercial offerings. -- Scientific American
--
_______ KB7PWD @ KC7Y.AZ.US.NOAM [EMAIL PROTECTED]
(_ | |_) Shawn T. Rutledge on the web: http://www.bigfoot.com/~ecloud
__) | | \__________________________________________________________________
----- %< -------------------------------------------- >% ------
The GnuCash / X-Accountant Mailing List
To unsubscribe, send mail to [EMAIL PROTECTED] and
put "unsubscribe gnucash-devel [EMAIL PROTECTED]" in the body
