sql-ledger-users — SQL-Ledger users

Re: OFFTOPIC: upgrading distro without rebooting

[James T. <ja...@ci...>]

For those of you who don't want to ruin your fabulous uptimes, I recall a
collegue of mine cheating once. He did the full upgrade, and used touch on
one or more files as su. The date he used being the date that the original
uptime started. If pressed I could ask him exactly what he did.

Sure it's cheating but if you don't tell I won't.

Regards

James

Re: SQL Ledger on Red Hat anyone?

[Steve D. <sd...@sw...>]

Hi Lee.

I believe your /users/members.default file failed to open or generate the new
members file.

Is the permission on it as follows?

-rw-r--r--    1 nobody nobody      57 Jan 24 20:04 members.default

And the users directory?

drwx------    2 nobody nobody   1024 Jan 19 10:53 users

That's an sql-ledger error message, so you can execute scripts (at least
admin.pl - your in as far as Apache goes).

Look at the above file and directory.

Good luck,
Steve

Lee Kimber wrote:

> Wow! You folks are amazing! I'm on the Linux Router Project mailing list
> and even that doesn't produce so many responses so quickly.
>
> OK, I've got to fess up to one of those doh moments here. I forgot to put
> the forward slash before "usr" in one of the httpd.conf lines...
>
> However, now that I have done that, hitting
> http://127.0.0.1/sql-ledger/admin.pl returns me a red "Error!" followed by
> a line of black text saying:
>
> "Permission denied: users/members"
>
> Mmmm, I've run "chown nobody:nobody users templates" and I can see that a
> user and group called 1000 own most of these files, including admin.pl.
>
> If I've understood this correctly, this is the script I need to run to set
> up users and members so I'm a bit stuck here.
>
> Thanks for any ideas.
>
> Lee
>
> At 02:36 PM 2/12/2002 -0800, Joe MacDonald wrote:
> >I got it running with out any problems.
> >
> >As long as your permissions are correct and apache is setup to run perl
> >scripts then you should be okay.
> >
> >I found that putting an index.html file in your /sql-ledger directory
> >helps with resolving any path and permission problems. Then just have a
> >link in the index.html file that points to login.pl
> >
> >Good Luck
> >
> >Joe MacDonald

Re: OFFTOPIC: upgrading distro without rebooting

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

On Wed, 13 Feb 2002, Jake Skinner wrote:

> I'm curious too
>
> > You can't upgrade a distro with out rebooting.
> >
> >
> > On Tue, 2002-02-12 at 16:27, Jonas Smedegaard wrote:
> > > On Tue, 12 Feb 2002, John Berninger wrote:
> > >
> > > > Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my
> > > > 130 day uptime - I want to beat a friend's 280-some-odd day uptime. :)
> > >
> > > For the sake of ego: Switch to Debian - then you can upgrade without
> > > rebooting ;-)

Ok ok - it is not a secret: Have a search on Google for "Debian upgrade
without reboot" and read the first two entries (and it isn't bleeding edge
either - that second hit is from may 2000!).

I have succesfully upgraded a machine in Denmark, Europe from San
Francisco, US using ssh. It really just needed 2 commands and then
accepting the defaults a bunch of times (no, not a special script - the
core packaging system of Debian, APT)!

Sure, if you want to run a newer _kernel_ a reboot is needed, but that is
separate from upgrading the distro.

I'd be happy to discuss this further, but let's move it away from the
mailinglist. Drop a mail to de...@jo..., that one is stored on web as
well if someone feels like joining later on :-)

And sorry, Dieter, I'll try and stick to the topic. I really appreciate
the clean (and non-distro-specific) design of SQL-Ledger. Keep up the
great work!

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: SQL Ledger on Red Hat anyone?

[Lee K. <lee...@ki...>]

Wow! You folks are amazing! I'm on the Linux Router Project mailing list 
and even that doesn't produce so many responses so quickly.

OK, I've got to fess up to one of those doh moments here. I forgot to put 
the forward slash before "usr" in one of the httpd.conf lines...

However, now that I have done that, hitting 
http://127.0.0.1/sql-ledger/admin.pl returns me a red "Error!" followed by 
a line of black text saying:

"Permission denied: users/members"

Mmmm, I've run "chown nobody:nobody users templates" and I can see that a 
user and group called 1000 own most of these files, including admin.pl.

If I've understood this correctly, this is the script I need to run to set 
up users and members so I'm a bit stuck here.

Thanks for any ideas.

Lee

At 02:36 PM 2/12/2002 -0800, Joe MacDonald wrote:
>I got it running with out any problems.
>
>As long as your permissions are correct and apache is setup to run perl
>scripts then you should be okay.
>
>I found that putting an index.html file in your /sql-ledger directory
>helps with resolving any path and permission problems. Then just have a
>link in the index.html file that points to login.pl
>
>Good Luck
>
>Joe MacDonald

Re: OFFTOPIC: upgrading distro without rebooting

[Bryan J. S. <b.j...@ie...>]

Jake Skinner wrote:
> I'm curious too

Er, I've upgraded distros without rebooting before.
Use RPM to do a "live" upgrade, including GLibC.
The only kicker is the kernel, but that's it.

I also wouldn't try upgrading "live" when you're changing the X in
X.Y RedHat releases (e.g., 6.2 to 7.0), but the Y in X.Y (e.g., 7.0
to 7.2) has been fine.  In fact, I've done this with RedHat 5.x, 6.x
and 7.x with fairly good results.

-- Bryan

-- 
Bryan J. Smith, Engineer        mailto:b.j...@ie...   
AbsoluteValue Systems, Inc.     http://www.linux-wlan.org
SmithConcepts, Inc.          http://www.SmithConcepts.com
---------------------------------------------------------
1999 IRS Data:  The richer half of all US income
                earners pay 99% of all US taxes

Re: SQL Ledger on Red Hat anyone?

[Matthew P. <mj...@ie...>]

On 12 Feb 2002, Joe MacDonald wrote:

> You can't upgrade a distro with out rebooting. 

Bull.  It's difficult to upgrade a kernel without rebooting, but it's quite
simple to upgrade the version of distro you're using without rebooting.

> > (sorry, this is off-topic, I just had to do it...)

Ditto.


-- 
-----------------------------------------------------------------------
#include <disclaimer.h>
Matthew Palmer
mj...@ie...

OFFTOPIC: upgrading distro without rebooting

[Jake S. <js...@gr...>]

I'm curious too

> You can't upgrade a distro with out rebooting.
>
>
> On Tue, 2002-02-12 at 16:27, Jonas Smedegaard wrote:
> > On Tue, 12 Feb 2002, John Berninger wrote:
> >
> > > Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like
my
> > > 130 day uptime - I want to beat a friend's 280-some-odd day uptime.
:)
> >
> > For the sake of ego: Switch to Debian - then you can upgrade without
> > rebooting ;-)
> >
> > (sorry, this is off-topic, I just had to do it...)
> >
> > - Jonas
> >
> > --
> > Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
> > Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
> > Debian GNU/Linux developer               http://people.debian.org/~js/
> >
> >
> >
> --
> Joe MacDonald
> jam...@hw...
> Focus Computer Consulting
> 250-861-3798



Attention:
The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies.

Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of The Gribbles Group.

Thank You.

Whilst every effort has been made to ensure that this e-mail message and any attachments are free from viruses, you should scan this message and any attachments.
Under no circumstances do we accept liability for any loss or damage which may result from your receipt of this message or any attachment.

Re: SQL Ledger on Red Hat anyone?

[Joe M. <jam...@hw...>]

You can't upgrade a distro with out rebooting. 


On Tue, 2002-02-12 at 16:27, Jonas Smedegaard wrote:
> On Tue, 12 Feb 2002, John Berninger wrote:
> 
> > Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my
> > 130 day uptime - I want to beat a friend's 280-some-odd day uptime.  :)
> 
> For the sake of ego: Switch to Debian - then you can upgrade without
> rebooting ;-)
> 
> (sorry, this is off-topic, I just had to do it...)
> 
>  - Jonas
> 
> -- 
> Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
> Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
> Debian GNU/Linux developer               http://people.debian.org/~js/
> 
> 
> 
-- 
Joe MacDonald
jam...@hw...
Focus Computer Consulting
250-861-3798

Re: SQL Ledger on Red Hat anyone?

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

On Tue, 12 Feb 2002, John Berninger wrote:

> Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my
> 130 day uptime - I want to beat a friend's 280-some-odd day uptime.  :)

For the sake of ego: Switch to Debian - then you can upgrade without
rebooting ;-)

(sorry, this is off-topic, I just had to do it...)

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: SQL Ledger on Red Hat anyone?

[D.Kreft <bi...@kr...>]

On Tue, 12 Feb 2002, Lee Kimber wrote:

> The first sign of trouble is that when I hit
> http://localhost/sql-ledger/admin.pl I get "file not found". In fact the
> file is there.

Make sure that the path to perl in your scripts is the same as that listed
in the first line of your scripts (on the 'she-bang' line). If you don't
have perl in the right place, the shell will say "file not found."

-dan

RE: SQL Ledger on Red Hat anyone?

[Dan I. <da...@ja...>]

We use it on redhat 7.1. However, i did not follow the install instructions
exactly.

Our web root is a standard rh7.1 (/var/www/html). I put the sql ledger files
in here, and it works fine.

<snip>

[root@somewhere sql-ledger]# pwd
/var/www/html/sql-ledger
[root@somewhere sql-ledger]#

</snip>

To access it, simply go to http://somewhere/sql-ledger/.

I honestly cannot remember if i had to do anything else unusual, but i
recall it took all of about 5 minutes to set up.

Dan.

--
Dan Irwin - Systems Administrator
Jackie's Wholesale Nurseries Pty Ltd
Email: da...@ja...
Phone: 07 3888 2481
Fax: 07 3888 2530
Postal: 10 Gleeson Road Burpengary Queensland 4505
Email: in...@ja...
Web: http://www.jackies.com.au


-----Original Message-----
From: Lee Kimber [mailto:le...@ki...]
Sent: Wednesday, 13 February 2002 7:15 AM
To: sql...@li...
Subject: SQL Ledger on Red Hat anyone?


Hi there,

Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?

I've followed the default install instructions and chagned httpd.conf to 
reflect the SQL Ledger-preferred document root of /usr/local/www but no
luck.

The first sign of trouble is that when I hit 
http://localhost/sql-ledger/admin.pl I get "file not found". In fact the 
file is there.

What would help me a lot would be a guide to troubleshooting SQL-Ledger's 
perl scripts. Something with some diagnostic tests and an analysis of their 
results.

I saw that somebody in the mailing list had planned to write a SQL-Ledger 
FAQ but couldn't find the actual document.

Anybody gone down this SQL-Ledger on Red Hat path before and emerged 
scathed but knowledgeable?

Thanks

Lee

Re: SQL Ledger on Red Hat anyone?

[Ed W. <ew...@rh...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

We run SQL Ledger on Redhat 7.2 internally and administer SQL LEdger at 
multiple client locations running various flavors/versions of Linux.  Best I 
can recall, it worked without errors for us once the correct perl modules 
were installed (we actually used Redhats included RPMS and didn't download 
sources).  Redhat 7.2 was one of the easiest installs we have performed 
sql-ledger.  Not sure what your problem might be, but make sure your web 
server and database are running, i.e. ps -aux  Make sure you don't have a 
firewall blocking the request, use tcpdump on the server to actually monitor 
the request and then try to access the server from another machine using the 
servers ip address.

This is in our httpd.conf

Alias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
    Options ExecCGI Includes FollowSymlinks
</Directory>

Hope this information will get you started.  Wish I could offer more 
suggestions but don't have enough information to help further.
- -- 
Ed Wiget
Owner/Senior Network Security Consultant
RHP Studios
"Keeping Your Data Safe!"
http://www.rhpstudios.com
email: ew...@rh...
email2: sec...@rh...
Office: 606-564-0046
Toll Free: 866-G02-RHPS (866-402-7477)
Fax: 606-564-0076


On Tuesday 12 February 2002 04:15 pm, you wrote:
> Hi there,
>
> Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?
>
> I've followed the default install instructions and chagned httpd.conf to
> reflect the SQL Ledger-preferred document root of /usr/local/www but no
> luck.
>
> The first sign of trouble is that when I hit
> http://localhost/sql-ledger/admin.pl I get "file not found". In fact the
> file is there.
>
> What would help me a lot would be a guide to troubleshooting SQL-Ledger's
> perl scripts. Something with some diagnostic tests and an analysis of their
> results.
>
> I saw that somebody in the mailing list had planned to write a SQL-Ledger
> FAQ but couldn't find the actual document.
>
> Anybody gone down this SQL-Ledger on Red Hat path before and emerged
> scathed but knowledgeable?
>
> Thanks
>
> Lee


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8aZ80+EoLKxIs7PwRAg+mAJ4wju30bPdV8KmCP1wGPuLtjR51cwCeLbP9
eadDhLhmWQfGHSAtNbBmNaA=
=m0Ry
-----END PGP SIGNATURE-----

Re: SQL Ledger on Red Hat anyone?

[John B. <Jo...@be...>]

I'm currently running SQL Ledger v1.6.9 on Red Hat Linux 7.1, and had
very few problems getting started.  There are really very few
differences between 7.1 and 7.2, so it /should/ Just Work(tm).

I'm assuming that admin.pl is located in the physical path
/usr/local/www/sql-ledger/admin.pl, so I'll avoid any path issues.  :)

The first thing to check would be the Apache error log
(/var/log/httpd/error_log) and see what the server is telling you when
you see "file not found".

Aside: the only reason I haven't upgraded to RHL 7.2 is ego - I like my
130 day uptime - I want to beat a friend's 280-some-odd day uptime.  :)
Upgrading would involve a reboot, which would start my uptime back at 0
days.  :(

On Tue, 12 Feb 2002, Lee Kimber wrote:

> Hi there,
> 
> Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?
> 
> I've followed the default install instructions and chagned httpd.conf to 
> reflect the SQL Ledger-preferred document root of /usr/local/www but no luck.
> 
> The first sign of trouble is that when I hit 
> http://localhost/sql-ledger/admin.pl I get "file not found". In fact the 
> file is there.
> 
> What would help me a lot would be a guide to troubleshooting SQL-Ledger's 
> perl scripts. Something with some diagnostic tests and an analysis of their 
> results.
> 
> I saw that somebody in the mailing list had planned to write a SQL-Ledger 
> FAQ but couldn't find the actual document.
> 
> Anybody gone down this SQL-Ledger on Red Hat path before and emerged 
> scathed but knowledgeable?
> 
> Thanks
> 
> Lee

-- 
John Berninger

GPG Key ID: A8C1D45C
        Fingerprint: B1BB 90CB 5314 3113 CF22  66AE 822D 42A8 A8C1 D45C

It is a known fact that developers cannot document.  That's why we have 
documentation specialists.  If developers could document, they'd all be
system administrators!
--

Re: SQL Ledger on Red Hat anyone?

[Joe M. <jam...@hw...>]

I got it running with out any problems.

As long as your permissions are correct and apache is setup to run perl
scripts then you should be okay.

I found that putting an index.html file in your /sql-ledger directory
helps with resolving any path and permission problems. Then just have a
link in the index.html file that points to login.pl

Good Luck

Joe MacDonald



On Tue, 2002-02-12 at 13:15, Lee Kimber wrote:
> Hi there,
> 
> Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?
> 
> I've followed the default install instructions and chagned httpd.conf to 
> reflect the SQL Ledger-preferred document root of /usr/local/www but no luck.
> 
> The first sign of trouble is that when I hit 
> http://localhost/sql-ledger/admin.pl I get "file not found". In fact the 
> file is there.
> 
> What would help me a lot would be a guide to troubleshooting SQL-Ledger's 
> perl scripts. Something with some diagnostic tests and an analysis of their 
> results.
> 
> I saw that somebody in the mailing list had planned to write a SQL-Ledger 
> FAQ but couldn't find the actual document.
> 
> Anybody gone down this SQL-Ledger on Red Hat path before and emerged 
> scathed but knowledgeable?
> 
> Thanks
> 
> Lee
> 
> 
-- 
Joe MacDonald
jam...@hw...
Focus Computer Consulting
250-861-3798

SQL Ledger on Red Hat anyone?

[Lee K. <le...@ki...>]

Hi there,

Has anybody successfully got SQL Ledger working on Red Hat Linux 7.2?

I've followed the default install instructions and chagned httpd.conf to 
reflect the SQL Ledger-preferred document root of /usr/local/www but no luck.

The first sign of trouble is that when I hit 
http://localhost/sql-ledger/admin.pl I get "file not found". In fact the 
file is there.

What would help me a lot would be a guide to troubleshooting SQL-Ledger's 
perl scripts. Something with some diagnostic tests and an analysis of their 
results.

I saw that somebody in the mailing list had planned to write a SQL-Ledger 
FAQ but couldn't find the actual document.

Anybody gone down this SQL-Ledger on Red Hat path before and emerged 
scathed but knowledgeable?

Thanks

Lee

Re: PDF output

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

To use a different backend function you should put the replacement
function into the same custom_ frontend script. If you need the same code
in more than one module create another file and included the file in both
custom_ scripts with a require.

$form->parse_template() would then become &parse_template()

This way you do not need to patch Form.pm.


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 Tue, 12 Feb 2002, Philip Reetz wrote:

> 
> 
> Hello list members,
> as promised here is the patch to produce postscript output from within 
> sql-ledger. Everything needed schould be included in the tar file. You will 
> also find a text document describing installation procedures and handling 
> and an invoice template.
> If there are any questions feel free to discuss this with us and the list.
> I hope this will be of some help for anybody.
> 
> Ciao,
> Philip
> --
> LINET Services
> Linux im Intra- und InterNet
> 
> Rebenring 33                                    Tel.:   0531-280 191 71
> 38106 Braunschweig                              Fax:    0531-280 191 72
> 
> http://www.linet-services.de
> mailto:in...@li...

Re: PDF output

[Philip R. <p....@li...>]

Hello list members,
as promised here is the patch to produce postscript output from within 
sql-ledger. Everything needed schould be included in the tar file. You will 
also find a text document describing installation procedures and handling 
and an invoice template.
If there are any questions feel free to discuss this with us and the list.
I hope this will be of some help for anybody.

Ciao,
Philip
--
LINET Services
Linux im Intra- und InterNet

Rebenring 33                                    Tel.:   0531-280 191 71
38106 Braunschweig                              Fax:    0531-280 191 72

http://www.linet-services.de
mailto:in...@li...

Re: PDF invoices, Account Reconciliation, GUI

[Sergio A. K. <ser...@ho...>]

----- Original Message ----- 
From: "David Lane" <dl...@eg...>

[...]

> Application interface - terminal based:
> 
> The other major issue concerning us is application speed and efficiency
> - the web interface is very useful (and vital) for distributed
> businesses (as many in New Zealand are) and there appears to be no other
> fully functional client-server accounting system with a realistic price
> tag.  Despite that, however, for grinding through invoices as some of
> our clients do, you have to have a very responsive, 100% keyboard driven
> interface.  Has anyone considered a terminal based interface (sorry I
> haven't found a way to search the Sql-ledger mailing list archives...)?

david, despite common belief, web standards are developed
with accesibility in mind, there is a *lot* of effort in this
field...
having a 100% keyboard driven interface on the web, is not
only possible, but a *requirement* for today web standards...
see:
http://www.cs.tut.fi/~jkorpela/forms/accesskey.html
http://www.w3.org/TR/REC-html40/interact/forms.html#adef-accesskey
http://www.webaim.org/

/sergio

Re: PDF invoices, Account Reconciliation, GUI

[Guido B. <gd...@le...>]

> Summary:
> 3.  Depending on how much work has been done on a perl/TK interface, we
> respectfully suggest considering a terminal based UI like curses (i.e.
> keyboard driven and lightweight) and/or or another crossplatform GUI
> system like Qt (perl or pyQt) or wxWindows (wxPerl or wxPython)
> interface as we believe they result in much more polished and visually
> appealing apps.
>
My experience on GUI interface for business is different to Sql-ledger HTML.

To have very responsive effects we have use Javascript to control data
download in XML format for all data from and to SQL Server.
But instability of new browsers don't guarantees good quality (some crashes
appears every week).
Sql-ledger is less command's responsive but very stable!

PerlTK is very stable environment and with Perl is not difficult to
developer library to download forms and data directly from HTTP server to
maintain client-server design.
The goal is to developer


My experience on perlQt and wxPerl is negative because are less stable and
less portable respect to PerlTK.
For business (character oriented) application PerlTK is complete GUI.
Obviusly the SQL-Ledger programmers knows Perl and PerlTK is nice for their.

best regards
Guido Brugnara

>...............................................
> --
> ** David Lane, Director - Egressive Limited * dl...@eg... ** **
> PO Box 24162, Christchurch, NZ * www.egressive.com * 025 229 8147 **
> ** Open Source: software for the discerning palate * www.openz.org **


-- 
ing. Guido Brugnara tel.+39(461)390804 fax.396028
Leader.IT S.r.l.  (Leader Information Technology)
Strada della Pozzata, 41        www.leader.it/srl
38050 Villazzano TRENTO (ITALY)    in...@le...

Re: PDF output

[Philip R. <p....@tu...>]

Hello,
I just read the posting from David Lane about pdf output.
As Dieter knows we are working on a similar project.
With minor changes to the parse template sub in SL we have written an 
addition that produces postsript output from a latex template.
The latex template uses the same variables as the html templates. (You 
can still use both html and latex templates as you like).

A very useful feature (at least to us) is that in latex templates we can 
calculate page subtotals and print them on the buttom of the page for 
invoices or orders that span several pages.

The output right now is pure postscript but it is very easy with linux 
means to produce pdf files if wanted.

We have been testing this for the last two weeks and for us it works 
very well. We were going to post the changes to the list but lots of 
works prevented this so far. But now that this topic has landed on the 
top priority I will make everything ready for shipment :) ASAP. 
(Hopefully tomorrow)

I hope it will be a help for others, too.

Ciao,
Philip

PS: What does account reconcilation mean? I have not found a translation 
that makes any sense to me in this context.
--
LINET Services
Germany

PDF invoices, Account Reconciliation, GUI

[David L. <dl...@eg...>]

Summary: 
1.  We are developing an Latex -> PDF invoice capability and an XML ->
PDF one as well.
2.  We are very interested in the proposed Account Reconciliation
functionality.
3.  Depending on how much work has been done on a perl/TK interface, we
respectfully suggest considering a terminal based UI like curses (i.e.
keyboard driven and lightweight) and/or or another crossplatform GUI
system like Qt (perl or pyQt) or wxWindows (wxPerl or wxPython)
interface as we believe they result in much more polished and visually
appealing apps.

PDF generation:

In response to the last message (quoted below), we are working on
generating PDF invoices from Late and will contribute those changes back
to the Sql-ledger project as soon as possible (i.e. as soon as it works
:o).

Due to our interest in shifting our company documentation into XML, we
have also decided to have a play with an XML to PDF conversion using XSL
and FOP to produce PDF.  We're also looking at ways to produce PS
output.  At this stage it works best to use a Java servlet engine (e.g.
Tomcat from the Jakarta project) for speed. We will also contribute
those changes back to the Sql-ledger project if anyone is interested.

If anyone else is working on either of these mechanisms actively, please
let us know so that we can avoid reinventing the wheel!  

Account Reconciliation:

Speaking of "what's ahead", we are very interested in the Account
Reconciliation functionality - has anyone made any progress on that?  If
so, please do tell!  We consider that to be on of two aspects of
Sql-ledger that is keeping us from wholeheartedly promoting it to our
clients.

Application interface - terminal based:

The other major issue concerning us is application speed and efficiency
- the web interface is very useful (and vital) for distributed
businesses (as many in New Zealand are) and there appears to be no other
fully functional client-server accounting system with a realistic price
tag.  Despite that, however, for grinding through invoices as some of
our clients do, you have to have a very responsive, 100% keyboard driven
interface.  Has anyone considered a terminal based interface (sorry I
haven't found a way to search the Sql-ledger mailing list archives...)? 
There are perl-curses bindings
(http://www.perl.com/doc/FAQs/FAQ/oldfaq-html/Q3.8.html).  Such an
interface could be used effectively from a Linux server on Win32 clients
on a LAN.  

Most of our clients are currently using a locally (New Zealand) produced
app that recently switched from a DOS (terminal style) interface to a
Win32 interface, and despite the latter looking much snazzier, given a
few days of working with it, most prefer the speed and efficiency of the
earlier DOS version...

Application interface - X/Win32 based:

If the planned GUI interface is like the standard X TK GUI, then we'd be
much more enthusiastic about a perlQt (http://www.surf.org.uk/vperlqt/)
or pyQt (http://www.thekompany.com/projects/pykde/) interface to
Sql-ledger (from my experience, Qt - www.trolltech.com - is an extremely
complete and efficient open source C++ GUI library with perl and python
bindings that runs natively on Win32, Unix, MacOS, and embedded systems
that produces *very* polished interfaces)...  We're looking at that
ourselves.  Although we'll have to carefully examine the licensing
implications, we have a commercial development license for Qt (Unix and
Win32) and would be (barring licensing issues) willing in principle to
build Win32 binaries if no one else has that capability.  

Another viable option for an interface would be wxPerl
(wxperl.sourceforge.net) or even wxPython (www.wxpython.org) which have
sprung from the impressive wxWindows (C++) open source cross-platform
development project....   Note, both Qt
(www.thekompany.com/projects/pykde/tools.php3) and wxWindows
(wwww.roebling.de) have GUI builder applications.

We think that Sql-ledger is an inspiring project, and hope that we can
contribute to its development so that the open source community has a
real contender for the small business accounting market!  Great work to
everyone who has contributed.

Regards,

Dave Lane 

On Tue, 2002-02-12 at 03:09, M R wrote:
> On http://sql-ledger.org/misc/ahead.html it mentions:
> 
> Native GUI interface  (perl/TK)
> PDF / Latex for generation of reports
> 
> Is there anyone actually working on these?
> 
> (my 1st code efforts will be to generate history reports of invoices.  I think  
> I can use some of the command-line web tools to import billing/export 
> HTML that I can then fax/print/save to disk)
> 
> 
-- 
** David Lane, Director - Egressive Limited * dl...@eg... **
** PO Box 24162, Christchurch, NZ * www.egressive.com * 025 229 8147 ** 
** Open Source: software for the discerning palate * www.openz.org **

Questions about http://sql-ledger.org/misc/ahead.html

[M R <mtr...@du...>]

On http://sql-ledger.org/misc/ahead.html it mentions:

Native GUI interface  (perl/TK)
PDF / Latex for generation of reports

Is there anyone actually working on these?

(my 1st code efforts will be to generate history reports of invoices.  I think  
I can use some of the command-line web tools to import billing/export 
HTML that I can then fax/print/save to disk)

Re: Bug Report

[Guido B. <gd...@le...>]

> Hello everyone,
>
> I found two things I think are bugs:
>
> I'm using SL 1.8.2 and Mozilla
>
> 1) AP module -> Add transaction
> when entering a new transaction the fraction amount of the invoice is
> cut  off after saving the entry.
> e.g. 80.60 becomes 80.00
>
> 2) AP module -> Payments
> when entering a payment SL does not use the local fraction divider but
> the  us default.
> e.g. in Germany we use a comma instead of a dot
> when entering 80,60 it becomes 80.600,00
>
> Does anybody have the same problems?

We was resolve problem to force number value passed to sub format_amount in
SL/Form.pm function

We dont know, but in some situation the format_amout receive $amount
parameter with comma "," and not dot "."; obviusly the next code dont
elaborate value correctly.

Probably it is wrong programming of LC_LOCALE !???

SL/Form.pm___________________________________
.................
sub format_amount {
  my ($self, $myconfig, $amount, $dash, $vg) = @_;

  # GDO change ',' to '.' (LC_LOCALE problems!?!)        ## insert
  $amount =~ s/,/./;                                     ## insert
  # GDO END                                              ## insert

  # compensate for perl bug
  $amount = ($vg) ? $amount : sprintf("%.2f", $amount);
  my $negative = ($amount < 0);
.................
_____________________________________________

bye
Guido Brugnara

>
> Any help is appreciated.
>
> Ciao,
> Philip
>
>
> --
> LINET Services
> Linux im Intra- und InterNet
>
> Rebenring 33                                    Tel.:   0531-280 191 71
> 38106 Braunschweig                              Fax:    0531-280 191 72
>
> http://www.linet-services.de
> mailto:in...@li...


-- 
ing. Guido Brugnara tel.+39(461)390804 fax.396028
Leader.IT S.r.l.  (Leader Information Technology)
Strada della Pozzata, 41        www.leader.it/srl
38050 Villazzano TRENTO (ITALY)    in...@le...

problem copying & pasting in excel

[Sergio A. K. <ser...@ho...>]

I get a "Accounts Receivables Aging Report", 
(or whatever report)
then I "select all", copy & paste into excel.

now, noone of the numeric columns show up as
numeric (no matter what format has the cells)...

why ? because all the html cells have a " "
(non breaking space)
<td align=right>&nbsp;489.00</td>

(the source code of this is in rp.pl)

I suppose this nbsp was added to workaround the
ugly effect of a blank cell in mozilla.

AFAICS, mozilla 0.9.8 doesn't have this bug,
so the nbsp can be taken out.

another solution would be to put some "if"s in the code,
if the quantity is non blank echo the quantity,
otherwise echo a nbsp.
(yes, it would uglify the code)

and while we are at it, can you change the line
<table border=1>
by
<table class=table-report>
?

thanks,
/sergio
ps: maybe the templates directory should be separated by
    country code, the same as locale...

Vendor Invoice

[Maritza M. <ma...@ho...>]

HI,

   I'M NEW WITH SQL-LEDGER AND I WAS LOOKING AT THE VENDOR INVOICE. I 
NOTICED THAT IT ONLY DISPLAYS TWO DECIMAL PLACES AND SOME OF THE ITEMS IN 
SOME INVOICES HAVE UP TO 4 DECIMAL PLACES. I MANAGED TO DISPLAY FOUR DECIMAL 
PLACES BY CHANGING SOME SPRINTF LINES IN DIFFERENT PLACES IN SOME SCRIPT. 
NOW, I HAVE A PROBLEM. I NEED TO DISPLAY ONLY TWO IN THE TOTAL OF THE 
INVOICE. I HAVE TRIED MANY METHODS TO DO SO, BUT WHEN I SUBMIT THE INVOICE, 
THE TOTAL IS ALTERED AND ADDED SOME CENTS. IT LOOKS THAT WHAT I HAVE DONE IS 
THE SAME AS HAVING ONLY TWO DECIMAL PLACES.

   I WAS WONDERING IF ANYONE WAS WORKING ON THIS AND, IF SO, MAYBE HE OR SHE 
COULD GIVE ME A HAND ON THIS.


THANKS,

MARITZA


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com