Re: [SQL-Ledger-users] OT: Web-based Checking Software

[Dieter S. <dsi...@sq...>]

Transactions are sent to the backend in the form of 'script.cgi ARGV[0]'

i.e to post a GL transaction first set the environment variable
HTTP_COOKIE to sql-ledger=username and then issue a call to gl.cgi in the
form of

gl.cgi "variable=value&........."

ARGV[0] must be escaped (%20, %2f, etc)

variables must include
  action                             subroutine in gl.cgi
  transdate                          date of transaction
  source                             source
  comment                            comment
  rowcount                           number of debit/credit rows
  accno_(1 .. n)                     account number from chart
  debit_(1 .. n)                     debit
  credit_(1 .. n)                    credit

debit and credit cannot have both a value assigned, one must be zero or
empty, if an error occurs the script dies, nothing will be posted if one
step fails in the posting process

This is your basic API for version 1.2.

The next release uses perl modules for all the backend code.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========


On Thu, 3 May 2001, Linas Vepstas wrote:

> On Thu, May 03, 2001 at 04:37:12PM -0700, Roderick A. Anderson was heard to remark:
> > Slightly off topic but I'm looking for check book software.  I'm
> > currently using GnuCash which is nice but I haven't found a reasonable
> > way to tie into SQL-Ledger.  So I'm hoping someone knows of some
> > web-based software.  Probably, needless to say, but perl based, and
> > using PostgreSQL (or other DBI based method) it preferred.
> 
> If anyone can help the gnucash developers in figuring out how to tie
> into sql-ledger (and/or writing the code to do the same) that would be
> great.   BTW, gnucash has a a beta postgres backend.  It works fine in 
> single-user mode, but has difficulties in multi-user mode.
> 
> If you do debate this further, please cc. the gnu...@gn...
> mailing list.
> 
> --linas
> 
> > 
> > TIA,
> > Rod
> > -- 
> >                  Remove the word 'try' from your vocabulary ... 
> >                      Don't try.  Do it or don't do it ...
> >                                 Steers try!
> > 
> >                                                             Don Aslett
> > 
> 
>