sql-ledger-users — SQL-Ledger users

RE: [SQL-Ledger-users] evaluation of sql-ledger

[<mp...@ma...>]

Can you give us some information about the how and maybe if were lucky
then when(like its in design phase, were coding, internal testing etc)?

Scott
On Sat, 27 Jan 2001, Dieter Simader wrote:
> I should mention here that the new version (not yet released) seperates
> the backend code from the display. It will be possible to use sql-ledger
> from a browser such as Netscape, MS Explorer, ... and lynx for now, a
> console and wap interface is also planned. 

Re: [SQL-Ledger-users] evaluation of sql-ledger

[Craig J. <cr...@sm...>]

           >Ah, the original lite (or light, as in green) client.=20
Pretty much, I have a Wy120 (Black and White), a Wy50+ (Green) and 2=20
Wy99gt (Green) Terminals.
 >What does linx do with sql-ledger? I would guess if can do frames=20
 >it's got a chance ...=20
Lynx works ok with it. The only problem is Lynx doesn't support frames=20
and make navigation a tedious process & time consuming.

Re: [SQL-Ledger-users] parse error

[dave w. <dw...@dl...>]

Thanks alot Allan....

Dave Wolff



----- Original Message ----- 
From: "Alan Hodgson" <aho...@si...>
To: <sql...@li...>
Sent: Saturday, January 27, 2001 1:19 PM
Subject: Re: [SQL-Ledger-users] parse error

Re: [SQL-Ledger-users] dir templates moved from default location

[Jody B. <jo...@sa...>]

is there any reason you cant simply symlink it?
ln -s /var/www/html/templates /var/www/html/sql-ledger/templates

user <us...@co...> said:

> Hello there.
> i just installed sql-ledger for the first time. everything seems to
> work  well. but i need to move dir "templates" from
> /var/www/html/sql-ledger to var/www/html/templates.
> 
> where exactly i should change path to it, so software will recognize new
> directory as templates dir. must be glbal varieble for templates dir
> somewhere.
> 
> please help me out. i really stucked there.
> 
> kindest regards.
> Alexander Moloksher
> 
> us...@co...
> 
> 



-- 

Re: [SQL-Ledger-users] parse error

[Alan H. <aho...@si...>]

On Fri, Jan 26, 2001 at 07:39:59PM -0600, dave wolff wrote:
> Has anyone come accross the problem
>=20
> Content-type: text/html=20
> Error!
> No such file or directory: balance_sheet.html
>=20
> when they try to generate a  balance sheet
>


You have to set the template directory correctly in the user file.

--=20
"Our job is to give people not what they want, but what we decide they
ought to have." -- Richard Salant, former President of CBS News

RE: [SQL-Ledger-users] evaluation of sql-ledger

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

SQL-Ledger was never intended to be just a webbased accounting system. 
This is the reason for not using php or CGI and perl instead. Perl is
available on every platform I can think off which makes it virtually
platform independant.

I don't have a preference which SQL servers is used as long as
transactions are supported. Early versions did work with mySQL but I
dropped support starting with Version 1.0


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 Sat, 27 Jan 2001, Ing. Antonio A. Gallardo wrote:

> Hi Craig!
> 
> Please explain why you are creating a terminal frontend to SQL-Ledger. I
> think that Web based Aplications is the new wave of office products. Let see
> at MS .net project for example.
> 
> If you want, you can do anything with SQL-Ledger source. But the goal to
> archive is to create a account application Web-based.
> 
> PHP is great, and maybe he will save us many problems about UI. Please
> Dieter explain us why you dont choose PHP in the develop of SQL-Ledger.
> 
> I think that MySQL is a low-end DBMS. PostgreSQL is more powerfull and we
> will approach the powerful features of PostgreSQL. Dieter again, please
> answer us what you think about that.
> 
> I will be glad to open a discussion about the Roadmap of SQL-Ledger to all
> the users.
> 
> Regards,
> 
> Antonio Gallardo.
> 
> 
> 
> -----Mensaje original-----
> De: sql...@li...
> [mailto:sql...@li...]En nombre de Craig
> Jansen
> Enviado el: Viernes, 26 de Enero de 2001 04:41 a.m.
> Para: sql...@li...; ma...@ro...
> Asunto: Re: [SQL-Ledger-users] evaluation of sql-ledger
> 
> 
> Hi Matthew
> 
> I am currently developing a seperate app to use on Wyse Terminal's as a 
> frontend to SQL-Ledger. Ultimatley (The way I see it) SQL-Ledger is 
> simply a frontend to the postgresSQL database.
> 
> So writing another type of Frontend should not really pose too much of a 
> problem. The linux console scripts I am putting together for my own 
> business simply write to the same database and tables. The only thing 
> that's really different is the user interface.
> 
> So I don't see why you couldn't do it from another application. The tests 
> I've come up with on my consoles appear to work and I havn't noticed any 
> problems with SQL-Ledger itself after using the console app.
> 
> For those of you on this list interested in a Console application, I will 
> be releasing it as soon as I feel comfortable with it's performance.
> 
> Hope that helps out a little.
> 
> Regards
>   Craig Jansen (CeeJay Computer Services)
>   PH: +64 21 144 1851    FAX: 64 6 323 2060
>   http://www.cjcs.yi.org
> 
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
> 
> > 2. Can anyone, maybe Dieter, comment on integrating sql-ledger with
> > front-office software. We are writing a CRM app with PHP / mySQL (but may
> > change to PostgreSQL) and I need to integrate with an accounting package.
> 
> > I haven't yet looked under the hood of sql-ledger as we don't have
> > postgresSQL installed, but am I right in guessing that I'll be able to 
> write
> > a function to create invoices in sql-ledger from our CRM package ... ie 
> from
> > outside sql-ledger?
> 
> 
> 
> 

RE: [SQL-Ledger-users] evaluation of sql-ledger

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

I should mention here that the new version (not yet released) seperates
the backend code from the display. It will be possible to use sql-ledger
from a browser such as Netscape, MS Explorer, ... and lynx for now, a
console and wap interface is also planned. 


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 Sat, 27 Jan 2001, Craig Jansen wrote:

> Hi Antonio,
> It is true the GUI interface to applications is by far more inviting to a 
> lot of people. MS aside (I Don't Use Any MS Products) :) While 95% of the 
> terminals in my office are running X-Windows and are capable of graphical 
> web browsing I also have a number of "OLD" Wyse dumb terminals which are 
> currently being used for stock control & order entry. In the long term I 
> plan on getting SQL-Ledger to integrate with with my current stock 
> control software. The only role of these terminals is for employees who 
> have no need for me to spend money on setting them up with a fully 
> fledged PC. I may upgrade them to X-Terms one day but at this point in 
> time it's easier for me to develop something for SQL-Ledger in my spare time.
> I also have a client who has a string of these type of terminals on his 
> shop floor. I currently have him interested in setting up a Linux box 
> with SQL-Ledger in the future.
> Hope that sheds some light on why I'm developing a "Terminal" frontend. 
> :)
> Regards
>   Craig Jansen (CeeJay Computer Services
>   PH: 64 21 144 1851		FAX: 64 6 323 2060
>   http://www.cjcs.yi.org
> 
> 
> Original Message dated 1/27/01, 8:23:26 PM
> Author: "Ing. Antonio A. Gallardo" <ag...@ma...>
> Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:
> 
> Please explain why you are creating a terminal frontend to SQL-Ledger. I 
> think that Web based Applications is the new wave of office products. Let 
> see at MS .net project for example.
> 

Re: [SQL-Ledger-users] dir templates moved from default location

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

The templates directory is part of the sql-ledger tree and cannot be
moved. You can symlink to another directory though.

sql-ledger/templates => /var/www/html/templates


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 Sun, 28 Jan 2001, user wrote:

> Hello there.
> i just installed sql-ledger for the first time. everything seems to
> work  well. but i need to move dir "templates" from
> /var/www/html/sql-ledger to var/www/html/templates.
> 
> where exactly i should change path to it, so software will recognize new
> directory as templates dir. must be glbal varieble for templates dir
> somewhere.
> 
> please help me out. i really stucked there.
> 
> kindest regards.
> Alexander Moloksher
> 
> us...@co...
> 

Re: [SQL-Ledger-users] evaluation of sql-ledger

[ivan <iva...@42...>]

On Sat, Jan 27, 2001 at 11:58:17AM -0500, Kurt Seel wrote:
> Craig Jansen wrote:
> 
> >
> >
> > Hi Antonio,
> >
> > It is true the GUI interface to applications is by far more inviting to a lot
> > of people. MS aside (I Don't Use Any MS Products) :)
> 
>  Kudos. I am glad that I am not the only one trying to do this :-)
> 
> > While 95% of the terminals in my office are running X-Windows and are capable
> > of graphical web browsing I also have a number of "OLD" Wyse dumb terminals
> 
>  Ah, the original lite (or light, as in green) client.
> 
> > which are currently being used for stock control & order entry. In the long
> > term I plan on getting SQL-Ledger to integrate with with my current stock
> > control software. The only role of these terminals is for employees who have
> > no need for me to spend money on setting them up with a fully fledged PC. I
> > may upgrade them to X-Terms one day but at this point in time it's easier for
> > me to develop something for SQL-Ledger in my spare time.
> 
>  What does linx do with sql-ledger? I would guess if can do frames
> it's got a chance ...

Dunno about `lynx', but w3m
<http://ei5nazha.yz.yamagata-u.ac.jp/~aito/w3m/eng/index.html> or links
<http://artax.karlin.mff.cuni.cz/~mikulas/vyplody/links/> will get you a
text interface to SQL ledger that works just fine.  No rewrite necessary. 

> 
> >
> >
> > I also have a client who has a string of these type of terminals on his shop
> > floor. I currently have him interested in setting up a Linux box with
> > SQL-Ledger in the future.
> >
> > Hope that sheds some light on why I'm developing a "Terminal" frontend. :)
> >
> > Regards
> >
> > Craig Jansen (CeeJay Computer Services
> >
> > PH: 64 21 144 1851 FAX: 64 6 323 2060
> >
> > http://www.cjcs.yi.org
> >
> >
> > -------------------------------------------------------------------------------
> >
> > Original Message dated 1/27/01, 8:23:26 PM
> >
> > Author: "Ing. Antonio A. Gallardo" <ag...@ma...>
> >
> > Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:
> > -------------------------------------------------------------------------------
> >
> > Please explain why you are creating a terminal frontend to SQL-Ledger. I think
> > that Web based Applications is the new wave of office products. Let see at MS
> > .net project for example.
> >
> >
> >
> 
> --
>  In theory, there is no difference between theory
> and practice. In practice, however, there is.
>  - Albert Einstein
> 
> 

-- 
meow
_ivan

Re: [SQL-Ledger-users] evaluation of sql-ledger

[Kurt S. <ks...@ut...>]

Craig Jansen wrote:

>
>
> Hi Antonio,
>
> It is true the GUI interface to applications is by far more inviting to a lot
> of people. MS aside (I Don't Use Any MS Products) :)

 Kudos. I am glad that I am not the only one trying to do this :-)

> While 95% of the terminals in my office are running X-Windows and are capable
> of graphical web browsing I also have a number of "OLD" Wyse dumb terminals

 Ah, the original lite (or light, as in green) client.

> which are currently being used for stock control & order entry. In the long
> term I plan on getting SQL-Ledger to integrate with with my current stock
> control software. The only role of these terminals is for employees who have
> no need for me to spend money on setting them up with a fully fledged PC. I
> may upgrade them to X-Terms one day but at this point in time it's easier for
> me to develop something for SQL-Ledger in my spare time.

 What does linx do with sql-ledger? I would guess if can do frames
it's got a chance ...

>
>
> I also have a client who has a string of these type of terminals on his shop
> floor. I currently have him interested in setting up a Linux box with
> SQL-Ledger in the future.
>
> Hope that sheds some light on why I'm developing a "Terminal" frontend. :)
>
> Regards
>
> Craig Jansen (CeeJay Computer Services
>
> PH: 64 21 144 1851 FAX: 64 6 323 2060
>
> http://www.cjcs.yi.org
>
>
> -------------------------------------------------------------------------------
>
> Original Message dated 1/27/01, 8:23:26 PM
>
> Author: "Ing. Antonio A. Gallardo" <ag...@ma...>
>
> Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:
> -------------------------------------------------------------------------------
>
> Please explain why you are creating a terminal frontend to SQL-Ledger. I think
> that Web based Applications is the new wave of office products. Let see at MS
> .net project for example.
>
>
>

--
 In theory, there is no difference between theory
and practice. In practice, however, there is.
 - Albert Einstein

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Marco De L. <del...@mt...>]

Someone get me of this mailing list please!!!


Thank you,

Marco
del...@mt... <mailto:del...@mt...>

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Ing.
Antonio A. Gallardo
Sent: Saturday, January 27, 2001 1:23 AM
To: 'sql...@li...'
Subject: RE: [SQL-Ledger-users] evaluation of sql-ledger

Hi Craig!
Please explain why you are creating a terminal frontend to SQL-Ledger. I
think that Web based Aplications is the new wave of office products. Let see
at MS .net project for example.
If you want, you can do anything with SQL-Ledger source. But the goal to
archive is to create a account application Web-based.
PHP is great, and maybe he will save us many problems about UI. Please
Dieter explain us why you dont choose PHP in the develop of SQL-Ledger.
I think that MySQL is a low-end DBMS. PostgreSQL is more powerfull and we
will approach the powerful features of PostgreSQL. Dieter again, please
answer us what you think about that.
I will be glad to open a discussion about the Roadmap of SQL-Ledger to all
the users.
Regards,
Antonio Gallardo.

-----Mensaje original-----
De: sql...@li...
[ mailto:sql...@li...]En nombre de Craig
Jansen
Enviado el: Viernes, 26 de Enero de 2001 04:41 a.m.
Para: sql...@li...; ma...@ro...
Asunto: Re: [SQL-Ledger-users] evaluation of sql-ledger

Hi Matthew
I am currently developing a seperate app to use on Wyse Terminal's as a
frontend to SQL-Ledger. Ultimatley (The way I see it) SQL-Ledger is
simply a frontend to the postgresSQL database.
So writing another type of Frontend should not really pose too much of a
problem. The linux console scripts I am putting together for my own
business simply write to the same database and tables. The only thing
that's really different is the user interface.
So I don't see why you couldn't do it from another application. The tests
I've come up with on my consoles appear to work and I havn't noticed any
problems with SQL-Ledger itself after using the console app.
For those of you on this list interested in a Console application, I will
be releasing it as soon as I feel comfortable with it's performance.
Hope that helps out a little.
Regards
  Craig Jansen (CeeJay Computer Services)
  PH: +64 21 144 1851    FAX: 64 6 323 2060
  http://www.cjcs.yi.org
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
> 2. Can anyone, maybe Dieter, comment on integrating sql-ledger with
> front-office software. We are writing a CRM app with PHP / mySQL (but may
> change to PostgreSQL) and I need to integrate with an accounting package.
> I haven't yet looked under the hood of sql-ledger as we don't have
> postgresSQL installed, but am I right in guessing that I'll be able to
write
> a function to create invoices in sql-ledger from our CRM package ... ie
from
> outside sql-ledger?

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Marco De L. <del...@mt...>]

Someone get me of this mailing list please!!!


Thank you,

Marco
del...@mt... <mailto:del...@mt...>

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Craig
Jansen
Sent: Saturday, January 27, 2001 3:38 AM
To: sql...@li...
Subject: RE: [SQL-Ledger-users] evaluation of sql-ledger

Hi Antonio,
It is true the GUI interface to applications is by far more inviting to a
lot of people. MS aside (I Don't Use Any MS Products) :) While 95% of the
terminals in my office are running X-Windows and are capable of graphical
web browsing I also have a number of "OLD" Wyse dumb terminals which are
currently being used for stock control & order entry. In the long term I
plan on getting SQL-Ledger to integrate with with my current stock control
software. The only role of these terminals is for employees who have no need
for me to spend money on setting them up with a fully fledged PC. I may
upgrade them to X-Terms one day but at this point in time it's easier for me
to develop something for SQL-Ledger in my spare time.
I also have a client who has a string of these type of terminals on his shop
floor. I currently have him interested in setting up a Linux box with
SQL-Ledger in the future.
Hope that sheds some light on why I'm developing a "Terminal" frontend. :)
Regards
Craig Jansen (CeeJay Computer Services
PH: 64 21 144 1851 FAX: 64 6 323 2060
http://www.cjcs.yi.org <http://www.cjcs.yi.org/>

  _____

Original Message dated 1/27/01, 8:23:26 PM
Author: "Ing. Antonio A. Gallardo" <ag...@ma...>
Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:
  _____

Please explain why you are creating a terminal frontend to SQL-Ledger. I
think that Web based Applications is the new wave of office products. Let
see at MS .net project for example.

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Marco De L. <del...@mt...>]

Someone get me of this mailing list please!!!


Thank you,

Marco
del...@mt...

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Kim C.
Callis
Sent: Saturday, January 27, 2001 4:25 AM
To: sql...@li...
Subject: Re: [SQL-Ledger-users] evaluation of sql-ledger

"Ing. Antonio A. Gallardo" wrote:

>
>
> Hi Craig!
>
> Please explain why you are creating a terminal frontend to SQL-Ledger.
> I think that Web based Aplications is the new wave of office products.
> Let see at MS .net project for example.
>
> If you want, you can do anything with SQL-Ledger source. But the goal
> to archive is to create a account application Web-based.
>
> PHP is great, and maybe he will save us many problems about UI. Please
> Dieter explain us why you dont choose PHP in the develop of
> SQL-Ledger.
>
> I think that MySQL is a low-end DBMS. PostgreSQL is more powerfull and
> we will approach the powerful features of PostgreSQL. Dieter again,
> please answer us what you think about that.
>
> I will be glad to open a discussion about the Roadmap of SQL-Ledger to
> all the users.
>

I am curious about two of your above statements... First off, I think
that it is applaudable that Craig is attempting to create a curses
interface to SQL-Ledger. An application should be designed in such a way
that allows it to be modified to meet the needs of any end user. Take an
application like Quickbooks (since we are on an accounting path here!).
This is a nice application for some, but by no means does it really meet
the needs of all. Unfortunately, there is no real quick and easy way to
modify it to be useful. I think Craig gave a very valid explaination of
why he is doing such a modification.

Secondly, I was curious to hear about how you qualify your view of MySQL
being a "low -end" DBMS. The lacking feature of MySQL at one time was
handling transactions. Of course that was prior to 3.23, because that
requirement has been put in to production. From a benchmark perspective,
MySQL is in fact faster than PostgreSQL, by a significant margin. Of
course this was due to a transaction mechanism which easily made MySQL
faster. Nevertheless, although I am by no leaps and bounds a MySQL
evangelist, I will say that MySQL does a nice job of holding it's own.

RE: [SQL-Ledger-users] SQL-Ledger part payment handling

[Marco De L. <del...@mt...>]

Someone get me of this mailing list please!!!


Thank you,

Marco
del...@mt...

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Mark
Williamson
Sent: Saturday, January 27, 2001 4:23 AM
To: sql...@li...
Subject: [SQL-Ledger-users] SQL-Ledger part payment handling

Hi Everyone,

Been having a look at SQL-Ledger, I have managed to get it up and
running in a Debian Linux..

This is question is more in the use of SQL-ledger in it's current
form, that is what is the best way to handle part payments of an
invoice?  or is how are people managing this who are currently using
SQL-Ledger..

Cheers
Mark

[SQL-Ledger-users] dir templates moved from default location

[user <us...@co...>]

Hello there.
i just installed sql-ledger for the first time. everything seems to
work  well. but i need to move dir "templates" from
/var/www/html/sql-ledger to var/www/html/templates.

where exactly i should change path to it, so software will recognize new
directory as templates dir. must be glbal varieble for templates dir
somewhere.

please help me out. i really stucked there.

kindest regards.
Alexander Moloksher

us...@co...

[SQL-Ledger-users] Purchase Orders and back orders

[Mark W. <ma...@ma...>]

Hello,

Having a look at SQL-Ledger, is there going to be anyway to handle 
purchase orders, and to trace what's on back order, within the package, 
or is this planned for the future?

Cheers
Mark

Re: [SQL-Ledger-users] evaluation of sql-ledger

[Kim C. C. <kc...@c2...>]

"Ing. Antonio A. Gallardo" wrote:

>
>
> Hi Craig!
>
> Please explain why you are creating a terminal frontend to SQL-Ledger.
> I think that Web based Aplications is the new wave of office products.
> Let see at MS .net project for example.
>
> If you want, you can do anything with SQL-Ledger source. But the goal
> to archive is to create a account application Web-based.
>
> PHP is great, and maybe he will save us many problems about UI. Please
> Dieter explain us why you dont choose PHP in the develop of
> SQL-Ledger.
>
> I think that MySQL is a low-end DBMS. PostgreSQL is more powerfull and
> we will approach the powerful features of PostgreSQL. Dieter again,
> please answer us what you think about that.
>
> I will be glad to open a discussion about the Roadmap of SQL-Ledger to
> all the users.
>

I am curious about two of your above statements... First off, I think
that it is applaudable that Craig is attempting to create a curses
interface to SQL-Ledger. An application should be designed in such a way
that allows it to be modified to meet the needs of any end user. Take an
application like Quickbooks (since we are on an accounting path here!).
This is a nice application for some, but by no means does it really meet
the needs of all. Unfortunately, there is no real quick and easy way to
modify it to be useful. I think Craig gave a very valid explaination of
why he is doing such a modification.

Secondly, I was curious to hear about how you qualify your view of MySQL
being a "low -end" DBMS. The lacking feature of MySQL at one time was
handling transactions. Of course that was prior to 3.23, because that
requirement has been put in to production. From a benchmark perspective,
MySQL is in fact faster than PostgreSQL, by a significant margin. Of
course this was due to a transaction mechanism which easily made MySQL
faster. Nevertheless, although I am by no leaps and bounds a MySQL
evangelist, I will say that MySQL does a nice job of holding it's own.

[SQL-Ledger-users] SQL-Ledger part payment handling

[Mark W. <ma...@ma...>]

Hi Everyone,

Been having a look at SQL-Ledger, I have managed to get it up and 
running in a Debian Linux..    

This is question is more in the use of SQL-ledger in it's current 
form, that is what is the best way to handle part payments of an 
invoice?  or is how are people managing this who are currently using 
SQL-Ledger..

Cheers
Mark

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Craig J. <cr...@sm...>]

Hi Antonio,
It is true the GUI interface to applications is by far more inviting to =
a=20
lot of people. MS aside (I Don't Use Any MS Products) :) While 95% of th=
e=20
terminals in my office are running X-Windows and are capable of graphica=
l=20
web browsing I also have a number of "OLD" Wyse dumb terminals which are=
=20
currently being used for stock control & order entry. In the long term I=
=20
plan on getting SQL-Ledger to integrate with with my current stock=20
control software. The only role of these terminals is for employees who =

have no need for me to spend money on setting them up with a fully=20
fledged PC. I may upgrade them to X-Terms one day but at this point in=20
time it's easier for me to develop something for SQL-Ledger in my spare =
time.
I also have a client who has a string of these type of terminals on his =

shop floor. I currently have him interested in setting up a Linux box=20
with SQL-Ledger in the future.
Hope that sheds some light on why I'm developing a "Terminal" frontend. =

:)
Regards
  Craig Jansen (CeeJay Computer Services
  PH: 64 21 144 1851		FAX: 64 6 323 2060
  http://www.cjcs.yi.org


Original Message dated 1/27/01, 8:23:26 PM
Author: "Ing. Antonio A. Gallardo" <ag...@ma...>
Re: RE: [SQL-Ledger-users] evaluation of sql-ledger:

Please explain why you are creating a terminal frontend to SQL-Ledger. I=
=20
think that Web based Applications is the new wave of office products. Le=
t=20
see at MS .net project for example.

RE: [SQL-Ledger-users] Open Source Enterprise Software

[Ing. A. A. G. <ag...@ma...>]

Yesterday I was on the Net and see many other applications that will be
great if SQL-Ledger will be integrated. Example of another app is
PHPGroupWare!

Antonio Gallardo


-----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de Ron
Pero
Enviado el: Viernes, 26 de Enero de 2001 10:12 a.m.
Para: sql...@li...
Asunto: [SQL-Ledger-users] Open Source Enterprise Software


Here is something that will probably interest the people on this list.
Would sql-ledger fit in there?
Ron

>...the GNU Enterprise project (www.gnue.org) A GNU project
>which aims to develop a set of tools to build programs that together will
>form a complete system to provide functionality for most business needs.

RE: [SQL-Ledger-users] evaluation of sql-ledger

[Ing. A. A. G. <ag...@ma...>]

Hi Craig!

Please explain why you are creating a terminal frontend to SQL-Ledger. I
think that Web based Aplications is the new wave of office products. Let see
at MS .net project for example.

If you want, you can do anything with SQL-Ledger source. But the goal to
archive is to create a account application Web-based.

PHP is great, and maybe he will save us many problems about UI. Please
Dieter explain us why you dont choose PHP in the develop of SQL-Ledger.

I think that MySQL is a low-end DBMS. PostgreSQL is more powerfull and we
will approach the powerful features of PostgreSQL. Dieter again, please
answer us what you think about that.

I will be glad to open a discussion about the Roadmap of SQL-Ledger to all
the users.

Regards,

Antonio Gallardo.



-----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de Craig
Jansen
Enviado el: Viernes, 26 de Enero de 2001 04:41 a.m.
Para: sql...@li...; ma...@ro...
Asunto: Re: [SQL-Ledger-users] evaluation of sql-ledger


Hi Matthew

I am currently developing a seperate app to use on Wyse Terminal's as a 
frontend to SQL-Ledger. Ultimatley (The way I see it) SQL-Ledger is 
simply a frontend to the postgresSQL database.

So writing another type of Frontend should not really pose too much of a 
problem. The linux console scripts I am putting together for my own 
business simply write to the same database and tables. The only thing 
that's really different is the user interface.

So I don't see why you couldn't do it from another application. The tests 
I've come up with on my consoles appear to work and I havn't noticed any 
problems with SQL-Ledger itself after using the console app.

For those of you on this list interested in a Console application, I will 
be releasing it as soon as I feel comfortable with it's performance.

Hope that helps out a little.

Regards
  Craig Jansen (CeeJay Computer Services)
  PH: +64 21 144 1851    FAX: 64 6 323 2060
  http://www.cjcs.yi.org

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

> 2. Can anyone, maybe Dieter, comment on integrating sql-ledger with
> front-office software. We are writing a CRM app with PHP / mySQL (but may
> change to PostgreSQL) and I need to integrate with an accounting package.

> I haven't yet looked under the hood of sql-ledger as we don't have
> postgresSQL installed, but am I right in guessing that I'll be able to 
write
> a function to create invoices in sql-ledger from our CRM package ... ie 
from
> outside sql-ledger?

[SQL-Ledger-users] parse error

[dave w. <dw...@dl...>]

Has anyone come accross the problem

Content-type: text/html=20
Error!
No such file or directory: balance_sheet.html

when they try to generate a  balance sheet

Re: [SQL-Ledger-users] internal server errror

[dave w. <dw...@dl...>]

Hey Allan

Awesome thanks alot....gotter going now.  The sql-ledger username didnt
exist in the pg_hba.conf file.  Once again...THANKS

Happy as Hell
Dave Wolff

By the way Allan are you related to Tillman Hodgson???


----- Original Message -----
From: "Alan Hodgson" aho...@si...
To: <sql...@li...>
Sent: Friday, January 26, 2001 5:44 PM
Subject: Re: [SQL-Ledger-users] internal server errror

Re: [SQL-Ledger-users] internal server errror

[Alan H. <aho...@si...>]

On Fri, Jan 26, 2001 at 05:47:44PM -0600, dave wolff wrote:
> The script returns the right error messages if i use a bad user name or p=
asswd.  But when i enter the right user name and pass i get the internal se=
rver error.  I have the database set-up and i have the database drivers ins=
talled correctly as far as i know...
>=20

Check your Apache error_log.  The script error should be in there.  It's
probably just your database driver setup.

--=20
"The only new thing in this world is the history you do not know"=20
 -- President Harry S. Truman=20

[SQL-Ledger-users] internal server errror

[dave w. <dw...@dl...>]

Hi all.

I have downloaded and installed sql-ledger and have been trying to get =
it going for about a day now.  I can get the scripts to work but when i =
go to login i get an internal server error.  What i dont get is why does =
the setup.cgi script work properly as well as the login script.

The script returns the right error messages if i use a bad user name or =
passwd.  But when i enter the right user name and pass i get the =
internal server error.  I have the database set-up and i have the =
database drivers installed correctly as far as i know...

Any help would be greatly appreciated as i am starting a new business =
and would like to try and use this ledger system

Once again thanks
Dave Wolff