linking gnucash to data in postgres

[Derek Atkins]

Hi,

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

> Derek Atkins wrote:
>> 
>
>> > Is it possible to on receipt of registation for a kid, to update the
>> > information for the kid as well as enter the financial information
>> > (check number, amount paid) and have the financial information appear
>> > in the gnucash view of the database?
>> 
>> No.
>
> Thanks
>
> Is this planned for gnucash?

In general, probably not.  Gnucash has no plans to add arbitrary SQL
hooks, at the moment.  We _do_ plan to improve the SQL backend, but
not to the point where gnucash can make changes to arbitrary tables in
an arbitrary database.  In other words, gnucash will only touch
gnucash's tables, not your secondary "registration" database/table.

> Where else might I get this functionality (I presume I'll have to pay for it).

Honestly, I don't know.  Within GnuCash I suppose you could
theoretically set up each child as a customer, and once we gain the
ability to invoice multiple clients at once you could send out one
invoice and keep track of who owes money and who does not.

It sounds like what you want is something very similar to what ISPs
use to keep track of their monthly (or otherwise recurring) customers.
I have no idea what billing system(s) they use.  Maybe someone else
does.

You may be able to refashion your description into the gnucash model
and use the gnucash business features, but at the moment there's no
SQL support for the business features so that wont help at the short
term.

-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