Re: [Gnumed-devel] Starting work on gnumed->LedgerSMB gateway

[Karsten Hilbert]

The below sounds reasonable to me.

Karsten

On Sun, Feb 26, 2012 at 07:18:41AM -0800, Chris Travers wrote:

> So I have started ultimate design work on the gnumed->LSMB gateway.  I have
> decided to follow the previous advice in trying to do the minimum required
> (but I would do the best I can on that) and I have a lead on a project to
> cover the development costs and so....
> 
> Here's my thinking:
> 
> 1)  A plugin that allows the doctor to export a patient or encounter to
> billing.  This would copy data into an export log, mark it as un-exported,
> and NOTIFY GNUMED_EXPORT;
> 
> 2)  A script (probably in Python just for dependency reasons) whose logic
> is as follows:
> 
>    * poll for NOTIFY
>    * when received, try to connect to LedgerSMB database
>    * If connection fails, write to a log, sleep thirty seconds, and try
> again, repeat until connection is had
>    * Once connection is had, select every outgoing record that has not been
> marked as exported is selected into memory and marked as exported.
>    * These are then written to the import schema for LedgerSMB
>    * Run a stored procedure to turn imported records into LedgerSMB items.
>    * Use 2 phase commit to ensure everything on both sides is committed
> 
> The first version would be solely a connection from gnumed to LedgerSMB.
>  Adding customers would be disabled and bills would come in as sales
> orders.  Future versions might convert sales order to invoice
> automatically.  Future work may include a script from LedgerSMB to go the
> other way too.
> 
> The idea is that this approach would work with the LSMB and gnumed db's on
> the same server, or the same cluster, or separated over an unreliable
> internet connection.
> 
> Best Wishes.
> Chris Travers

-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346