sql-ledger-users — SQL-Ledger users

Re: [SQL-Ledger-users] Boa "port"

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

Version 1.2.10 is the last stable release.

Send me a copy of your mods and I'll post it as 1.2.11.

To send emails from different accounts subsribe to the list with all the
email addresses you use and then disable delivery for the accounts you do
not want to receive emails. This way you can post with any of your email
addresses and receive a copy of the email in your favourite email box.


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 Fri, 4 May 2001, Andrew Sharp wrote:

> I made the necessary mods to sql-ledger to use it with boa instead
> of apache.  And *boy*, it is a lot faster.  At least faster than it
> was on my pobre 200MHz powerpc 604e dual processor.  I thought I
> would ask if anyone else is interested in those mods.  The version
> is 1.2, I think.  Is that version still relevant?  Actually I sent
> an email some time ago about this, but apparently the list processor
> is quite finicky about accepting emails only when the return address
> is the same as a subscriber to the list.  Since I use several
> different email addresses, sometimes I send emails and fail to
> notice right away that it didn't get sent to the list.  If you're
> not familiar, boa is a single threaded web server that is quite fast
> compared to apache, but has a very short feature list, by
> comparison.
> 
> a
> 
> 

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

[Designer <wir...@ta...>]

"Roderick A. Anderson" wrote:

Try CBB, or Check Book Balancer. However, it only a personal finance
module, but it is written inter Perl and TK......
> 
> 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.
> 
> TIA,
> Rod
> --
>                  Remove the word 'try' from your vocabulary ...
>                      Don't try.  Do it or don't do it ...
>                                 Steers try!
> 
>                                                             Don Aslett

Re: [SQL-Ledger-users] Another Perl Accounting Package, PGSQL List

[John O'G. <ogo...@ho...>]

I am very interested as a developer.

The SQL-ledger project appeals to me because it
1. is based on very simple database schema
2. works with postgreSQL

Do you envisage that your application will be opensource and free?
I develop software applications mostly for small insurance companies
and brokers using Informix database software.
I don't have any accounting software.

Until now, I have not regarded any free database engines as
acceptable for commercial applications. I think PostgreSQL is
very nearly there now.

John O'Gorman
1/21 Ngake St
Orakei
New Zealand


>From: Ron Pero <rp...@bo...>
>Reply-To: sql...@li...
>To: sql...@li...
>Subject: [SQL-Ledger-users] Another Perl Accounting Package, PGSQL List
>Date: Fri, 04 May 2001 13:17:29 -0400
>
>Date: Fri, 04 May 2001 07:57:43 +0200
>From: Robert <ro...@ro...>
>X-Mailer: Mozilla 4.76 [en] (Win98; U)
>X-Accept-Language: en
>To: pgs...@po...
>CC: Ludwig Meyerhoff <lu...@an...>
>Subject: Re: Invoices
>Sender: pgs...@po...
>
>Ludwig Meyerhoff wrote:
> >
> > Maybe this is a bit off-topic, as this problem is more a "design"-one, 
>but
> > I wanted to write a web-application write invoices more easy.
> > ...
>
>   Hi,
>
>   I write the same application for the same reasons - we're three
>partners and we all want to be able to create invoices and also see what
>others create. A rather experimental version runs at
>http://www.eucto.cz/ login as 'admin_jaskot', no password, you need
>IE5+. It's in Czech, but you just go to 'Faktury' (Invoices), 'Nova
>faktura' (New Invoice), 'Ulozit' (Save) and 'Tisk' (Print). The
>application has grown a bit since I started and now it's slowly becoming
>complete web-based accounting package. When I finish new version (in
>maybe three weeks), it should do receivable, payable, cash, bank, should
>print fine and should have basic support for multiple users and multiple
>companies. Then I clean it up, add a bunch of gettext's to prepare an
>English version and start to think really hard about releasing the
>source. It's based on PostgreSQL/Apache/Perl (currently mod_perl &
>HTML::Embperl) and it (almost) works with recent Mozilla builds. I
>expect to get paid as a consultant by accounting companies that would
>offer this as a web service to their clients and/or for running this
>service for them.
>
>   So, here's the preliminary inquiry: anybody interested in such a thing
>as a user or as a developer?
>
>   - Robert
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

[SQL-Ledger-users] Boa "port"

[Andrew S. <an...@me...>]

I made the necessary mods to sql-ledger to use it with boa instead
of apache.  And *boy*, it is a lot faster.  At least faster than it
was on my pobre 200MHz powerpc 604e dual processor.  I thought I
would ask if anyone else is interested in those mods.  The version
is 1.2, I think.  Is that version still relevant?  Actually I sent
an email some time ago about this, but apparently the list processor
is quite finicky about accepting emails only when the return address
is the same as a subscriber to the list.  Since I use several
different email addresses, sometimes I send emails and fail to
notice right away that it didn't get sent to the list.  If you're
not familiar, boa is a single threaded web server that is quite fast
compared to apache, but has a very short feature list, by
comparison.

a

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

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

source is used to store a cheque number, receipt number, etc; it's a text
field.

debit_1=100&credit_2=50 is correct

you can also use debit_1=100&credit_1=&debit_2=&credit_2=50

If you edit a transaction then the 'id' from the gl table must be sent to
the backend too.


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 Fri, 4 May 2001, Linas Vepstas wrote:

> On Fri, May 04, 2001 at 10:30:12AM -0600, Dieter Simader was heard to remark:
> > 
> > variables must include
> >   action                             subroutine in gl.cgi
> >   transdate                          date of transaction
> >   source                             source
> 
> what's 'source'?  is it another account number from the chart?
> 
> >   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
> 
> I assume you mean debit_k and credit_k cannot both occur, but that
> debit_1=100.0&credit_2=50.0  is perfectly valid.
> 
> --linas
> 
> 

Re: [SQL-Ledger-users] PostgreSQL triggers?

[<li...@li...>]

On Fri, May 04, 2001 at 09:27:37AM -0700, Damon Torgerson was heard to rema=
rk:
> a) letting the database manage business logic with triggers and constrain=
ts is=20
> a good thing for design and performance reasons
> b) unfortunately, most rdbms have proprietary formats for triggers so wri=
ting a=20
> trigger for Postgres would either eliminate other rdbms or necessitate=20
> different database code for different rdbms.

My impression was (may be very wrong) that postgress triggers and e.g.
oracle triggers are pretty similar/same.   Its stored proceedures where
all hell breaks loose.  (in postgres, you can link in arbitrary .so's.=20
Basically if you can link it into a shared library, you can turn it into
a postgress stored proceedure. SO its very very general).

--linas
--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

[SQL-Ledger-users] Another Perl Accounting Package, PGSQL List

[Ron P. <rp...@bo...>]

Date: Fri, 04 May 2001 07:57:43 +0200
From: Robert <ro...@ro...>
X-Mailer: Mozilla 4.76 [en] (Win98; U)
X-Accept-Language: en
To: pgs...@po...
CC: Ludwig Meyerhoff <lu...@an...>
Subject: Re: Invoices
Sender: pgs...@po...

Ludwig Meyerhoff wrote:
> 
> Maybe this is a bit off-topic, as this problem is more a "design"-one, but
> I wanted to write a web-application write invoices more easy.
> ...

  Hi,

  I write the same application for the same reasons - we're three
partners and we all want to be able to create invoices and also see what
others create. A rather experimental version runs at
http://www.eucto.cz/ login as 'admin_jaskot', no password, you need
IE5+. It's in Czech, but you just go to 'Faktury' (Invoices), 'Nova
faktura' (New Invoice), 'Ulozit' (Save) and 'Tisk' (Print). The
application has grown a bit since I started and now it's slowly becoming
complete web-based accounting package. When I finish new version (in
maybe three weeks), it should do receivable, payable, cash, bank, should
print fine and should have basic support for multiple users and multiple
companies. Then I clean it up, add a bunch of gettext's to prepare an
English version and start to think really hard about releasing the
source. It's based on PostgreSQL/Apache/Perl (currently mod_perl &
HTML::Embperl) and it (almost) works with recent Mozilla builds. I
expect to get paid as a consultant by accounting companies that would
offer this as a web service to their clients and/or for running this
service for them.

  So, here's the preliminary inquiry: anybody interested in such a thing
as a user or as a developer?

  - Robert

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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

[<li...@li...>]

On Fri, May 04, 2001 at 10:30:12AM -0600, Dieter Simader was heard to remar=
k:
>=20
> variables must include
>   action                             subroutine in gl.cgi
>   transdate                          date of transaction
>   source                             source

what's 'source'?  is it another account number from the chart?

>   comment                            comment
>   rowcount                           number of debit/credit rows
>   accno_(1 .. n)                     account number from chart
>   debit_(1 .. n)                     debit
>   credit_(1 .. n)                    credit
>=20
> 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

I assume you mean debit_k and credit_k cannot both occur, but that
debit_1=3D100.0&credit_2=3D50.0  is perfectly valid.

--linas

--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

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

[<li...@li...>]

On Thu, May 03, 2001 at 09:22:01PM -0500, cbb...@he... was heard to rem=
ark:
> On Thu, 03 May 2001 20:19:27 CDT, the world broke into rejoicing as
> li...@li... (Linas Vepstas)  said:
> > List-Archive: <http://lists.sourceforge.net/archives//sql-ledger-users/>
> >=20
> > On Thu, May 03, 2001 at 04:37:12PM -0700, Roderick A. Anderson was hear=
d to=3D
> >  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.
> >=20
> > 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=
=3D20
> > single-user mode, but has difficulties in multi-user mode.
> >=20
> > If you do debate this further, please cc. the gnu...@gn...
> > mailing list.
>=20
> I've been trying out SQL-Ledger recently.  [Aside: Looking at doin'
> some writing for fun and profit.]
>=20
> Pretty slick.  Simple, but slick.
>=20
> The problem with interfacing GnuCash with SQL-Ledger will be that
> they've got quite _vastly_ different data models.  The GnuCash tables
> tie together via GUIDs, whilst SQL-Ledger ties together data in A/R,
> A/P, Inventory, and G/L.  While SQL-Ledger has a somewhat more
> sophisticated set of journals, the data _in_ the tables for GnuCash
> looks a lot fancier, particularly in terms of commodity handling.

gnucash unifies g/l and inventory into one.  I should study up
on the sql-ledger data strucutres a bit, though ...

> One thing that SQL-Ledger "buys" is that it basically does database
> queries on demand; _no_ need for the "event notification" that makes
> the GnuCash Register a fairly hairy chunk of code.  That is, if you
> make a change to a bit of data, the view of the register doesn't
> automagically get updated.  And you don't get to see more than one
> transaction's data at a time.

This is a classic example of the difference between distributed and=20
centralized apps. SQL-ledger is centralized, thus making things easy.
(the web browser is used as a slightly prettier version of a dumb
mainframe-attached green-weenie terminal.  It has the same performance
charateristics, and the same limitations on how data can be manipulated
and displayed as any mainframe based software.  The more things
change...)

Gnucash could do a similar stunt with a little bit of clever X11
protocol forwarding.   Say I ran one instance of gnucash on a server
somewhere. Then with some X11-magic, I could make it "multi-user"
by having it display some windows on one users remote desktop, and other
windows on another remote desktop.   Because its only X11 traffic that
is getting distributed, most of the 'hairy' issues are handled entirely
within the single instance of gnucash, thus making the difficult
distributed problems 'go away'.

Taking the distributed computing 'high-road' is hard.  Maybe folly?
Maybe we should focus on getting a multi-X11 connection stunt actually
usable?  That way, it could display on mswin desktops as well...

> That difference has the "negative" implication that SQL-Ledger doesn't
> provide "friendly, dynamic" views.  You only get to closely look at
> one transaction at a time, and if you fiddle the date, the transaction
> doesn't "magically" move to another spot on the screen, and balances
> don't change.

So gnucash is glitzier.  Functional purists don't need glitziness.=20
But the general computing public has clearly voted for style ovr
substance ...=20

> On the other hand, there's not the complex register code.  It's pretty
> easy to write an HTML screen to edit one transaction at a time.
> Furthermore, there's the merit that SQL-Ledger is a _LOT_ easier to
> make play well as a multi-user application, because there's no vast
> interlocking set of event notifications to worry about.

Nahh, that's not that hard. I can make it work.  Its' the running
balances (as explained in other note) that are giving me heartburn.

--linas

> --
> (reverse (concatenate 'string "gro.mca@" "enworbbc"))
> http://vip.hyperusa.com/~cbbrowne/resume.html
> Rules of  the Evil  Overlord #148. "Before  ridiculing my  enemies for
> wasting time  on a device  to stop me  that couldn't possibly  work, I
> will first acquire a copy of the schematics and make sure that in fact
> it couldn't possibly work."  <http://www.eviloverlord.com/>
> _______________________________________________
> gnucash-devel mailing list
> gnu...@li...
> http://www.gnumatic.com/cgi-bin/mailman/listinfo/gnucash-devel

--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

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

[<li...@li...>]

Hi John,

On Fri, May 04, 2001 at 10:34:31AM -0500, John Foster was heard to remark:
> Linas Vepstas wrote:
> >=20
> > On Thu, May 03, 2001 at 04:37:12PM -0700, Roderick A. Anderson was hear=
d 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.
> >=20
> > 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.
> >=20
> > If you do debate this further, please cc. the gnu...@gn...
> > mailing list.
> >=20
> > --linas
> --------------------------------------------------------------
> Hi Linas! I recently suggested that SQL-Ledger incorporate the ability
> to import/export ".qif" style files directly into its database. That may
> not be the best solution, but by putting a table or tables in place that

The QIF format is a nasty, nasty format that is very hard to handle
correctly.  For example, it fails to denote the currency.   So, for
example, say you export a transaction for 100.  Thats what, 100 dollars?
pesos? widgets in stock?   Thats only the crowd-warmer for the stock of
sick jokes that QIF has in store ...

> handle bank related functions it would be possible to use gnucash or
> moneydance (or most other money management systems) to include realtime
> cash management functions into SQL-Ledger. I am very weak in postgresql
> skills, there may be a way to do the same thing from some postgresql
> management system. I have also proposed that to the developers at
> Webmin.

Note that gnucash has a prototype xml protocol for querying a server
to get the financial data it displays.   There might be a way of
stapling that into sql-ledger, and then one gets the live data
manipulation, reports, etc.=20

(There is also an rpc backend ... lets talk more if this get serious).


> If/when the beta gnucash with a postgresql backend becomes stable in a
> multiuser environment=20

Well, its 'almost' usable, except for one interesting technical problem
I'd like to tell you about.  GnuCash likes to display accounts in a
'checkbook register style': that means that there is a running balance
displayed in one of the columns (far right column).

Say one has a millions transactions in the database. Clearly its insane
to fetch all of them to compute a running balance.  We could store a
running balance with each transaction, but this has a nasty update
semantic: changing one transaction would require updates to hundreds
or thousands of others that occur at a later date.  We talked about
storing 'balance checkpoints' to solve that problem.  But this
introduces another problem: I would need to query a contiguous set of
transactions between checkpoints.  At this point, the sql queries start
getting complex, there's a lot of traffic to the database, and yuck,
so we left it to ferment a bit more.    If you are willing to ignore
the running balance column, then I think the multi-user mode is not far
off.  (there's some minor misc stuff that needs to be brushed up, I
forget what).


> the procedure becomes simply a matter of using a
> single incorporated database that has all of the tables necessary. ( a
> dream come true)

Uh, not quite.  You could put all the tables in one database, but so
what?  Unless you modified some code somewhere, you'd still have to
enter any giving transaction twice, by hand.   The gnucash sql tables
are no doubt quite different than the sql-ledger tables.

> This is very important to me as it is an integral part of the
> development of a complete retail environment using only open source

Ohh. ahh.

Let me just say that I'd like to have gnucash develop more/better
sophisitcated capabilites, and I'd rather do so in cooperation with
sql-ledger, than in competition.  I think we can accomplish more
if we can avoid re-inventing each-others core features.

--linas


> software. Please cc: jf...@au... with any discussion on this.=
=20
> Thanks.
> John Foster

--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

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
> > 
> 
> 

Re: [SQL-Ledger-users] PostgreSQL triggers?

[Damon T. <da...@ra...>]

I haven't looked too closely at the code but here are my thoughts...

a) letting the database manage business logic with triggers and constraints is 
a good thing for design and performance reasons
b) unfortunately, most rdbms have proprietary formats for triggers so writing a 
trigger for Postgres would either eliminate other rdbms or necessitate 
different database code for different rdbms.

Damon

Quoting Benjamin Lee <ben...@co...>:

> This is just a thought...
> 
> I was going through the code, and I was wondering to myself whether it
> would robustify matters any to move the 'update_balance' code into the
> database layer with triggers and then have the 'chart' table updated
> by the triggers.
> 
> Using triggers would of course put MySQL in a bit of a muddle, but it
> would simplify the business processes in the application layer. I was
> almost confused reading the bits between old_this and new_this. ;-)
> 
> I might stuff around with this trigger idea in the not too distant
> future.
> 
> Comments?
> 
> P.S. Don't flame me about MySQL. I love MySQL; and in fact, I'm more
> of a newcomer to PostgreSQL. I'm just poking around and the like.
> 
> -- 
> B.      http://makelinux.org/    "Always real."   
> http://realthought.net/
> 
> 



Damon Torgerson
President, Ranksix Inc.
da...@ra...
250.884.7171

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

[John F. <jf...@au...>]

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
--------------------------------------------------------------
Hi Linas! I recently suggested that SQL-Ledger incorporate the ability
to import/export ".qif" style files directly into its database. That may
not be the best solution, but by putting a table or tables in place that
handle bank related functions it would be possible to use gnucash or
moneydance (or most other money management systems) to include realtime
cash management functions into SQL-Ledger. I am very weak in postgresql
skills, there may be a way to do the same thing from some postgresql
management system. I have also proposed that to the developers at
Webmin.
If/when the beta gnucash with a postgresql backend becomes stable in a
multiuser environment the procedure becomes simply a matter of using a
single incorporated database that has all of the tables necessary. ( a
dream come true)
This is very important to me as it is an integral part of the
development of a complete retail environment using only open source
software. Please cc: jf...@au... with any discussion on this. 
Thanks.
John Foster

[SQL-Ledger-users] PostgreSQL triggers?

[Benjamin L. <ben...@co...>]

This is just a thought...

I was going through the code, and I was wondering to myself whether it
would robustify matters any to move the 'update_balance' code into the
database layer with triggers and then have the 'chart' table updated
by the triggers.

Using triggers would of course put MySQL in a bit of a muddle, but it
would simplify the business processes in the application layer. I was
almost confused reading the bits between old_this and new_this. ;-)

I might stuff around with this trigger idea in the not too distant
future.

Comments?

P.S. Don't flame me about MySQL. I love MySQL; and in fact, I'm more
of a newcomer to PostgreSQL. I'm just poking around and the like.

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/

[SQL-Ledger-users] erro: table does not exist

[Harald <ha...@vi...>]

Dear all

I'm running on a Debian system, and after loggin in I get a
"DBI::errstr" and in the Apache erro log it says "erro: table does not
exist"

Apache on Debian runs as www-data/www-data.
I=B4m using Psql 6.5 and DBD+DBI - all from the standard stable realese.

Hoping and fighting

Harald me. Viuff

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

[<li...@li...>]

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=20
single-user mode, but has difficulties in multi-user mode.

If you do debate this further, please cc. the gnu...@gn...
mailing list.

--linas

>=20
> TIA,
> Rod
> --=20
>                  Remove the word 'try' from your vocabulary ...=20
>                      Don't try.  Do it or don't do it ...
>                                 Steers try!
>=20
>                                                             Don Aslett
>=20

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

[Roderick A. A. <raa...@ti...>]

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.

TIA,
Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Roderick A. A. <raa...@ti...>]

On Wed, 2 May 2001, Ibrahim Shaame wrote:

> Changed to that but still no success.
> Any other proposal?
> I wonder if someone can send me a working httpd.conf so that I can try it on my
> machine (maybe one running Slackware)

Did you remember to restart the web server so it re-reads the
configuration files? (This gets me all the time.)


Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Ibrahim S. <gtk...@ya...>]

Changed to that but still no success.
Any other proposal?
I wonder if someone can send me a working httpd.conf so that I can try it on my
machine (maybe one running Slackware)

Thanks

Ibrahim

"Roderick A. Anderson" wrote:

> On Mon, 30 Apr 2001, Ibrahim Shaame wrote:
>
> > Hi,
> >     Thanks for the advice. I have trying to make it work following your tips.
> > Unfortunately I have not been able. The problem still persist. I am attaching
> > here my httpd.conf file if you can try to seen where I am missing.
> >
> > Sorry for bothering everybody, but really I want to run sql-ledger.
>
> Use
>
>         ScriptAlias /sql-ledger/ /var/lib/apache/sql-ledger/
>
> instead of
>
>         Alias /sql-ledger/ /var/lib/apache/sql-ledger/
>
> Rod
> --
>                  Remove the word 'try' from your vocabulary ...
>                      Don't try.  Do it or don't do it ...
>                                 Steers try!
>
>                                                             Don Aslett


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: [SQL-Ledger-users] problem & suggestion

[adrian <ad...@sn...>]

"Roderick A. Anderson" wrote:
> 
> On Tue, 1 May 2001, adrian wrote:
> 
> > The ammounts are 1.xxxE-13 i.e. very small.
> 
> What platform are you running SQL-Ledger on?
> 
Slackware 7 on A Toshiba laptop pentium 166 MHz

Adrian

Re: [SQL-Ledger-users] problem & suggestion

[Roderick A. A. <raa...@ti...>]

On Tue, 1 May 2001, adrian wrote:

> The ammounts are 1.xxxE-13 i.e. very small.

What platform are you running SQL-Ledger on?

Sounds like a BCD module is needed.  Or might be needed.  I checked CPAN
but a search didn't turn anything up for 'BCD' or 'binary coded
decimal'.  Is there another term for this that I missed in the years
between CS 102 and really getting into computers?


Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: [SQL-Ledger-users] problem & suggestion

[adrian <ad...@sn...>]

Jonas Smedegaard wrote:
> 
> On Mon, 30 Apr 2001, adrian wrote:
> 
> > My accounts payable has several zero balances showing which are in
> > reality very small ammounts. The calculations need to rounded to the
> > neatest cent ( 1/2 cent).
> >
> > How can I now manually "zero" these accounts?
> 
> >From an accounting perspective (and mathematical too, I guess ;-) even
> small amounts can't "disappear". What you should do is make an account
> only for rounding, and move the amounts over there.
> 
The ammounts are 1.xxxE-13 i.e. very small.

Adrian

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Roderick A. A. <raa...@ti...>]

On Mon, 30 Apr 2001, Ibrahim Shaame wrote:

> Hi,
>     Thanks for the advice. I have trying to make it work following your tips.
> Unfortunately I have not been able. The problem still persist. I am attaching
> here my httpd.conf file if you can try to seen where I am missing.
> 
> Sorry for bothering everybody, but really I want to run sql-ledger.

Use

	ScriptAlias /sql-ledger/ /var/lib/apache/sql-ledger/

instead of

	Alias /sql-ledger/ /var/lib/apache/sql-ledger/


Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: [SQL-Ledger-users] problem & suggestion

[Antonio G. <ag...@ib...>]

Adrian,

I made some SQl Queries that helps with this kind of problem.

Please Check:
http://www.geocrawler.com/lists/3/SourceForge/7966/25/5563385/

Regards,

Antonio.
> 
> From: adrian <ad...@sn...>
> Date: 2001/04/30 Mon PM 05:00:49 GMT+06:00
> To: "sql...@li..." 
>  <sql...@li...>
> Subject: [SQL-Ledger-users] problem & suggestion
> 
> My accounts payable has several zero balances showing which are in
> reality very small ammounts. The calculations need to rounded to the
> neatest cent ( 1/2 cent).
> 
> How can I now manually "zero" these accounts?
> 
> Adding bank reconcilation is high priority from our pospective.
> 
> Adrian
> 
> 
> 

Re: [SQL-Ledger-users] problem & suggestion

[Jonas S. <jo...@au...>]

On Mon, 30 Apr 2001, adrian wrote:

> My accounts payable has several zero balances showing which are in
> reality very small ammounts. The calculations need to rounded to the
> neatest cent ( 1/2 cent).
>
> How can I now manually "zero" these accounts?

From an accounting perspective (and mathematical too, I guess ;-) even
small amounts can't "disappear". What you should do is make an account
only for rounding, and move the amounts over there.

Hope I understood your question correctly.

 - Jonas
(not an accountant, but doing my own accounting for some years - and soon
through SGL-Legder)

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

GNU GPL: "The source will be with you... always."