Integrating LedgerSMB with a member database

[Nicolas Couchoud <..hidden..>]

  Dear LedgerSMB authors and users,

  I am one of the treasurers of an alumini association. I intent to
modernize our treasury, and I'm considering using LedgerSMB to do that.
  Our association has a PostgreSQL alumni database containing financial
data, such as which alumni paid their subscription, and I would like this
to be linked with our accounting data. The fact that LedgerSMB also uses
PostgreSQL to store accounting data is very promising from this point of
view.
  So I have some questions to ask :

1) To ease integration between alumni and accounting data, I would like to
have them both in the same database. This implies to put accounting data in
a different namespace than alumni data to avoid name clashes. Is this
possible ? If I change the db_namespace variable in
/etc/ledgersmb/ledgersmb.conf, is it enough to ensure that LedgerSMB will
never do anything in namespace "public" ?

2) In that case, then my intent is to add a transaction in the accounting
data each time a new subscription appears in the alumni data, probably via
a TRIGGER. After reading some parts of the source, it seems to me that
adding a transaction just consists in :
a) adding a new line in table "gl" ;
b) for each account affected by the transaction, adding a new line in table
"acc_trans".
Is this correct ? Will this remain true in future versions of LedgerSMB ?

  Regards.

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users