linking gnucash to data in postgres

[Derek Atkins]

Joseph Mack <mack.joseph at epa.gov> writes:

> Derek Atkins wrote:
>> 
>
>> 
>> > Where else might I get this functionality (I presume I'll have to pay for it).
>> 
>> Honestly, I don't know.
>
> Been looking around. SQL-Ledger seems might do it.

Last time I looked at SQL-Ledger was about two years ago, but I wrote
it off for a couple of reasons.  It didn't have a nice UI like
GnuCash, it didn't have any useful reports, and most importantly it
required putting all my financial data onto a web server.  Eww.

> There was an article in July 2004 Linux J about a glade/python front
> end to a home brewed database that did accounting and inventory. I contacted
> the author over the weekend, but the ownership of the code is not clear
> and he has no plans to distribute the code. The article was
> about the gui interface, and his code for this was published.

I really think you might be best served by a custom app, since you
seem to have a fairly custom problem.  Either that or you haven't
really explained your requirements well enough..  I've already
suggested to treat your situation like an ISP, where each player is a
customer.  All customers get invoiced periodically (there is no way to
automate this in gnucash, yet) as well as during sign-up.  The
receivables report tells you who owes what, so you can see all
customers (players) that haven't paid their dues.

The name, address, etc. info for each player is just the customer
info.  But of course you have no clue what I'm talking about because
you're still stuck in 20th century software and haven't even looked at
1.8 to see if it would work for you.

However if you do have 1000 players to keep track of it might be a lot
of work to do all the invoices.

> Joe

-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