sql-ledger-users — SQL-Ledger users

Re: Adding new customer or vendor...

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

The customertax and vendortax tables are used to lookup tax links.

customer -> customertax
vendor -> vendortax


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, 28 Dec 2001, Philip Reetz wrote:

> 
> 
> Hello everyone,
> I'm trying to build a bridge between the groupware solution we are using 
> and sql-ledger.
> Both are using postgresql, so I was thinking I use a single database for 
> both programs and write a trigger that updates the customer and vendor 
> relation for sql-ledger every time I add or edit a contact in my groupware. 
> The groupware has fields which make it possible to distinguish between 
> vendor and customer.
> So far everything seems pretty straightforward. My question is: When I add 
> a customer or vendor through the webinterface, are only the customer or 
> vendor relation affected or is there more to do?
> 
> Any help would be highly appreciated.
> 
> Bye,
> 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...
> 
> 
> 

Duplicate customer records, anyone?

[alta <al...@al...>]

Is anyone else seeing duplicate customer records whenever they create 
a new customer?

I get 2 identical records per customer with Version 1.8 and 
PostgreSQL 7.2.  If I put a put a UNIQUE constraint on the id field, 
I get a duplicate record error, which prevents the customer from 
being entered.

If you have not tested this, I would appreciate someone else running 
a test.  Anyone?

Thanks ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: Duplicity?

[alta <al...@al...>]

Roger...

If you are concerned that the possibility of creating two invoices 
with the same number is an integrity issue (or a potential for 
confusion), consider trying a UNIQUE constraint on the invoice number 
field.

However, I tried something similar to prevent duplicate customer 
records, and got an error.  If I understand Dieter's explanation, 
this is because the record is created with a null in the id field.  
So, my sggestion may not work for other tables, either.

... Reed

On Friday 28 December 2001 12:40, you wrote:
> Invoices are distinguished by an internal ID, not the invoice
> number or a combination of invoice number and name.
>
> So, yes, you can enter the same information again, however, the
> invoices are different.
>
>
> 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, 28 Dec 2001, Roger Samour wrote:
> > Hi, I was entering a Vendor invoice, and just to test it I
> > entered another invoice with the same Invoice number and under
> > the same vendor and it allowed me to do that. Am I doing
> > something wrong? or does it allow duplicate invoice numbers under
> > the same vendor?
> >
> > Roger J. Samour

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: Duplicity?

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

Invoices are distinguished by an internal ID, not the invoice number or 
a combination of invoice number and name.

So, yes, you can enter the same information again, however, the invoices
are different.


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, 28 Dec 2001, Roger Samour wrote:

> Hi, I was entering a Vendor invoice, and just to test it I entered
> another invoice with the same Invoice number and under the same vendor
> and it allowed me to do that. Am I doing something wrong? or does it
> allow duplicate invoice numbers under the same vendor?
> 
> Roger J. Samour
> 
> 
> 

Re: Adding new customer or vendor...

[alta <al...@al...>]

Philip ...

I have loaded the customer table externally, and it seems to be the 
only table needed for customer info.  Note that for each record, you 
have to provide an integer id that does not conflict with another 
identical number in another record.  If you do not take care, you may 
end up with double records with the same id, as the id field is not 
UNIQUE in the customer table.  Otherwise, the process is 
straight-forward.

... Reed

On Friday 28 December 2001 08:53, you wrote:
> Hello everyone,
> I'm trying to build a bridge between the groupware solution we are
> using and sql-ledger.
> Both are using postgresql, so I was thinking I use a single
> database for both programs and write a trigger that updates the
> customer and vendor relation for sql-ledger every time I add or
> edit a contact in my groupware. The groupware has fields which make
> it possible to distinguish between vendor and customer.
> So far everything seems pretty straightforward. My question is:
> When I add a customer or vendor through the webinterface, are only
> the customer or vendor relation affected or is there more to do?
>
> Any help would be highly appreciated.
>
> Bye,
> Philip

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Duplicity?

[Roger S. <rs...@ma...>]

Hi, I was entering a Vendor invoice, and just to test it I entered another invoice with the same Invoice number and under the same vendor and it allowed me to do that. Am I doing something wrong? or does it allow duplicate invoice numbers under the same vendor?

Roger J. Samour

Re: Adding new customer or vendor...

[Chris F. <ch...@fe...>]

On Fri, 28 Dec 2001 17:53:39 +0100  Philip Reetz wrote:
 +------------------
 | 
 | 
 | Hello everyone,
 | I'm trying to build a bridge between the groupware solution we are using 
 | and sql-ledger.
 | Both are using postgresql, so I was thinking I use a single database for 
 | both programs and write a trigger that updates the customer and vendor 
 | relation for sql-ledger every time I add or edit a contact in my groupware. 
 | The groupware has fields which make it possible to distinguish between 
 | vendor and customer.
 | So far everything seems pretty straightforward. My question is: When I add 
 | a customer or vendor through the webinterface, are only the customer or 
 | vendor relation affected or is there more to do?
 | 
 | Any help would be highly appreciated.
 | 
 | Bye,
 | 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...
 | 
 | 
 +------------------

--
    Chris Fedde
    303 773 9134

Adding new customer or vendor...

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

Hello everyone,
I'm trying to build a bridge between the groupware solution we are using 
and sql-ledger.
Both are using postgresql, so I was thinking I use a single database for 
both programs and write a trigger that updates the customer and vendor 
relation for sql-ledger every time I add or edit a contact in my groupware. 
The groupware has fields which make it possible to distinguish between 
vendor and customer.
So far everything seems pretty straightforward. My question is: When I add 
a customer or vendor through the webinterface, are only the customer or 
vendor relation affected or is there more to do?

Any help would be highly appreciated.

Bye,
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: Upgrade from 1.6.8 to 1.8.0 issues

[Michael B. <mi...@di...>]

Hi Dieter:

Thanks for quick reply.  Yes I noticed the templates after going back
through the docs and playing with the update.

I noticed that you changed the invoice entry format again.  Just courious.
Why do you have the Qty first instead of the Number since you have to do a
lookup first on the number?  Just wanting to know the thinking/logic
behind the change.

Thanks again for the very quick fix on the AR Aging!  Your GREAT with a
GREAT product!

Regards,

Mike Bush

-- 

Digital Minds International
E-Mail:	Mi...@Di...
Web:	http://www.DigitalMinds.net
Tel:	(615) 661-7900
Fax:	(615) 661-7949

On Sun, 23 Dec 2001, Dieter Simader wrote:

> The upgrade instructions specifically instruct you to copy the new
> templates (Default-sales_order.html, etc.) to the template directories.
> Since every user can have their own templates in a directory below the
> templates directory you'll have to repeat the step for each template
> directory.
>
> templates are organized in sub directories
>
>    templates/joe/invoice.html
>                  purchase_order.html
>                  ...........
>    templates/sue/invoice.html
>                  purchase_order.html
>                  ...........
>
>
> Wether these are foreign language or default templates depends which one
> you chose when you created a new template directory.
>
> You can create a new directory by simply editing the user's preferences
> and specifying a new directory in the field 'New Templates' and choosing a
> set of templates from the selection menu 'Setup Templates'
>
>
> As for the aging report. fix is online at
> http://www.sql-ledger.org/source/
>
>
> 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, 23 Dec 2001, Michael Bush wrote:
>
> > David:
> >
> > There appears to be a problem with users setup code too.  None of the
> > templates are being copied to or referenced properly.  You can test the
> > issue by going into the Setup mode (click on the Setup in the lower right
> > hand corner).  Once in the Setup mode, click on all of the templates.  I
> > am getting errors messages on everything when you create a new user from
> > scratch.  I am going to manually copy the html template to the folder it
> > is referenceing to see if that solve the issue.
> >
> > Be back shortly with an answer.
> >
> > Regards,
> >
> > Mike Bush
> >
> >
>
>
>

I am starting off...

[Roger S. <rs...@ma...>]

Which version should I use?
1.6.x or 1.8?

Thanx

Roger

Re: Upgrade from 1.6.8 to 1.8.0 issues

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

The upgrade instructions specifically instruct you to copy the new
templates (Default-sales_order.html, etc.) to the template directories.
Since every user can have their own templates in a directory below the
templates directory you'll have to repeat the step for each template
directory.

templates are organized in sub directories

   templates/joe/invoice.html
                 purchase_order.html
                 ...........
   templates/sue/invoice.html
                 purchase_order.html
                 ...........


Wether these are foreign language or default templates depends which one
you chose when you created a new template directory.

You can create a new directory by simply editing the user's preferences
and specifying a new directory in the field 'New Templates' and choosing a
set of templates from the selection menu 'Setup Templates'


As for the aging report. fix is online at
http://www.sql-ledger.org/source/


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, 23 Dec 2001, Michael Bush wrote:

> David:
> 
> There appears to be a problem with users setup code too.  None of the
> templates are being copied to or referenced properly.  You can test the
> issue by going into the Setup mode (click on the Setup in the lower right
> hand corner).  Once in the Setup mode, click on all of the templates.  I
> am getting errors messages on everything when you create a new user from
> scratch.  I am going to manually copy the html template to the folder it
> is referenceing to see if that solve the issue.
> 
> Be back shortly with an answer.
> 
> Regards,
> 
> Mike Bush
> 
> 

Re: Upgrade from 1.6.8 to 1.8.0 issues

[Michael B. <mi...@di...>]

David:

There appears to be a problem with users setup code too.  None of the
templates are being copied to or referenced properly.  You can test the
issue by going into the Setup mode (click on the Setup in the lower right
hand corner).  Once in the Setup mode, click on all of the templates.  I
am getting errors messages on everything when you create a new user from
scratch.  I am going to manually copy the html template to the folder it
is referenceing to see if that solve the issue.

Be back shortly with an answer.

Regards,

Mike Bush

-- 

Digital Minds International
E-Mail:	Mi...@Di...
Web:	http://www.DigitalMinds.net
Tel:	(615) 661-7900
Fax:	(615) 661-7949

On Sun, 23 Dec 2001, David A. Bandel wrote:

> On Sun, 23 Dec 2001 15:20:05 -0600 (CST)
> Michael Bush <mi...@di...> spewed into the bitstream:
>
> > Hi David:
> >
> > Glad to know that I am not the only one.  Hopefully, Dieter is already
> > aware of the issue ;0
> >
> > Are you posting any records yet on 1.8.0?
>
> Not yet, just looking it over.
>
> I should also mention that when I look at the frame source for the Error
> page, I see another error about users/.conf no such file or directory.
> Wonder what that's all about?
>
> Ciao,
>
> David A. Bandel
>

Re: Upgrade from 1.6.8 to 1.8.0 issues

[Michael B. <mi...@di...>]

Hi David:

Glad to know that I am not the only one.  Hopefully, Dieter is already
aware of the issue ;0

Are you posting any records yet on 1.8.0?

Regards,

Mike Bush

-- 

Digital Minds International
E-Mail:	Mi...@Di...
Web:	http://www.DigitalMinds.net
Tel:	(615) 661-7900
Fax:	(615) 661-7949

On Sun, 23 Dec 2001, David A. Bandel wrote:

> On Sun, 23 Dec 2001 15:05:58 -0600 (CST)
> Michael Bush <mi...@di...> spewed into the bitstream:
>
> > Hi Everyone:
> >
> > I upgraded from version 1.6.8 to 1.8.0 and now I am getting the error
> > below when trying to do an AR Aging report.  Yes, I did run the upgrade
> > script.
> >
> >
> >
> > Error!
> >
> >
> > ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target
> > list
> >
> >
> >
> > I was able to fix the invoice printing issues by deleting my account and
> > reentering it.
> >
> >
> > Any ideas on the AR Aging report error?
> >
> > Merry Christmas,
> >
> > Mike Bush
> > --
> >
> > Digital Minds International
> > E-Mail:	Mi...@Di...
> > Web:	http://www.DigitalMinds.net
> > Tel:	(615) 661-7900
> > Fax:	(615) 661-7949
> >
>
> I get exactly the same thing; it also shows up in AP aging as well as AR
> aging.
>
> Ciao,
>
> David A. Bandel
>

Upgrade from 1.6.8 to 1.8.0 issues

[Michael B. <mi...@di...>]

Hi Everyone:

I upgraded from version 1.6.8 to 1.8.0 and now I am getting the error
below when trying to do an AR Aging report.  Yes, I did run the upgrade
script.



Error!


ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target
list



I was able to fix the invoice printing issues by deleting my account and
reentering it.


Any ideas on the AR Aging report error?

Merry Christmas,

Mike Bush
-- 

Digital Minds International
E-Mail:	Mi...@Di...
Web:	http://www.DigitalMinds.net
Tel:	(615) 661-7900
Fax:	(615) 661-7949





Date: Sun, 23 Dec 2001 14:41:15 -0600 (CST)
From: Michael Bush <mi...@di...>
To: Dieter Simader <dsi...@sq...>
Subject: Re: SQL-Ledger Version 1.8.0

Hey Dieter:

Upgraded from Version 1.6.8 to 1.8.0 and now when trying to do an AR Aging
report I get the following error message:

----------------------

Error!


ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target
list


----------------------

When printing invoices I get:

Content-Type: text/html
Error!

No such file or directory: invoice.html


------------------------


I ran the upgrade UPGRADE-1.6-1.8 sql script with no errors.

Any ideas?

Merry Christmas,

Mike Bush

--

Digital Minds International
E-Mail: Mi...@Di...
Web:    http://www.DigitalMinds.net
Tel:    (615) 661-7900
Fax:    (615) 661-7949

Sql-ledger running for the first time.

[Arun <am_...@ya...>]

Hi,

    I installed sql-ledger on a debian machine (following the
    instruction in faq). When i points to the 
    admin.pl it is requesting password. I found the users/members 
    file and found a line 'password='. I tried to add a password there
    and then login from the admin page. What ever i try its prompting 
    for password again. Not even password invalid message.


Thanks,
Arun.

Admin user passwd won't work?

[Roger S. <rs...@ma...>]

Hey, after changing the Admin passwd once, then next time I go in and supply NO passwd... it lets me in! So my question is: what am I doing wrong? I am running a RH 7.1 and have successfully added two users to the system. Any help is welcomed and appreciated...

Roger J. Samour

ROP in parts table

[Ho-Sheng H. <qa...@ne...>]

I came across a term I'm not familiar with. What is "ROP"? 

And by any chance, does anyone know how the make-model thing works (in
the practical sense) in SL?

Thanks for any info.

-Qaexl-

Re: New User

[Brian C. <bt...@ch...>]

Thomas Good wrote:
>=20
> On Wed, 19 Dec 2001, Brian Cawthon wrote:
>=20
> > [Wed Dec 19 13:00:38 2001] [error] [client 206.2.228.130] Premature e=
nd
> > of script headers: /usr/local/share/apache/htdocs/sql-ledger/admin.pl
> > Can't locate DBI.pm in @INC (@INC contains:
>=20
> Hi.
>=20
> You will need DBI, a perl module, and DBD-Pg a perl "driver".
> Go to your unix distribution cd and install the perl modules that
> complement your postgres installation or check out www.cpan.org
>=20
> You can get DBI from:
> http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/D=
BI/
>=20
> and DBD from:
> http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/D=
BD/
>=20
> You need to install DBI *first*.
> Also you will need to set two environment variables to successfully
> build DBD:  POSTGRES_INCLUDE and POSTGRES_LIB
> You will find references to this process in the archives for this list.
>=20
> Good luck!
>=20
> --------------------------------------------------------------------
>               Saint Vincent Catholic Medical Centers
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-818-5528
> Behavioral Health Services                      Fax:    718-818-5056
> Residential Services                            Mobile: 917-282-7359
> --------------------------------------------------------------------
> /*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
> --------------------------------------------------------------------


TO ALL FreeBSD USERS:
SQL-LEGDER does work using FreeBSD.

There is one item I should bring to your attention when loading Perl.
1. su root
2. cd /usr/ports/databases/p5-DBI
2a. make
2b. make install
2c. make clean
3. cd /usr/ports/databases/p5-DBD-Pg
4. cp Makefile Makefile.org
5. Using an editor (i.e. vi) comment out these line:

#CONFIGURE_ENV+=3DPOSTGRES_INCLUDE=3D${PREFIX}/include/pgsql \
#               POSTGRES_LIB=3D${PREFIX}/lib
#

next
Add these line:
CONFIGURE_ENV+=3DPOSTGRES_INCLUDE=3D/usr/local/pgsql/include \
POSTGRES_LIB=3D/usr/local/pgsql/lib

save as Makefile
6. type make
7. type make install
8. type make clean
9. Your now done.  Test to see if sql-ledger works.

Notice: The path of the original Makefile maybe incorrect.

Below is the header information from the Makefile.

# New ports collection makefile for: p5-DBD-Pg
# Date created:                         June 17th 1997
# Whom:                                 James FitzGibbon
<jf...@Fr...>

Perlmagick

[Marvin D. <pe...@be...>]

Also, take a look at PerlMagick, the Perl interface to ImageMagick.


Best

Marvin Dickens

ImageMagik and SQL-ledger

[Marvin D. <pe...@be...>]

Here is a list of the ImageMagik commands and what they do... Perhaps some 
food for thought:

1.) Montage: creates a composite image by combining several separate images. 
The images are tiled on the composite image with the name of the image
optionally appearing just below the individual tile. 

2.) Convert: converts an input file using one image format to an output file 
with a differing image format. Great for file format manipulation

3.) Mogrify: transforms an image or a sequence of images. These transforms 
include image scaling, image rotation, color reduction, and others. The
transmogrified image overwrites the original image

4.) Identify: describes the format and characteristics of one or more image 
files. It will also report if an image is incomplete or corrupt. The 
information displayed includes the scene number, the file name, the width and 
height of the image, whether the image is colormapped or not, the number of 
colors in the image, the number of bytes in the image, the format of the 
image (JPEG, PNM, etc.), and finally the number of seconds it took to read 
and process the imag

5.) Combine: combines images to create new images. You can get some pretty 
artistic and sometimes weird results with this command...

6.) Xtp: is a utility for retrieving, listing, or printing files from a 
remote network site, or sending files to a remote network site. Xtp performs 
most of the same functions as the ftp program, but does not require any 
interactive commands. You simply specify the file transfer task on the 
command line and xtp performs the task automatically. This utility should 
totally fascinate some of you network centric people out there...

7.) Display: is a machine architecture independent image processing and 
display program. It can display an image on any workstation display running 
an X server. The image can be displayed as background image of any window. 
Display first determines the hardware capabilities of your workstation.

8.) Import: reads an image from any visible window on an X server and outputs 
it as an image file. You can capture a single window, the entire screen, or
any rectangular portion of the screen.

9.) Animate: Animate displays a sequence of images on any workstation display 
running an X server. Animate first determines the hardware capabilities
of the workstation. This command is hard-core from a graphics programmers 
stand point....


Best

Marvin Dickens

Re: PDF output

[Marvin D. <pe...@be...>]

On Thursday 20 December 2001 16:09, you wrote:
> This might help: http://www.easysw.com/htmldoc/
>
> It's a GNU program with source code to convert HTML to PDF (among other
> things)
>
> It isn't in Perl but it can be run from a command line

Having coded document format conversion utilities for other applications, it 
seems to me the obvious choice would be to use ImageMagik to do the 
conversions. The convert utility, that ships with ImageMagik, among other 
things, will convert HTML to PDF files (As long as you have the ps2pdf 
utility that ships with ghostscript installed) with little effort. In 
addition to being able to produce PDF output, you also will have the ability 
to produce output in other formats:

AVS, BIE, BMP, CGM, CYMK, DCX, DIB, DICOM, EPDF, EPI. EPS, FAX+ GIF,
GREY, JPEG, MIFF, MPEG, PCD, PCL, PGM, PNG, PS2+, RGB, TIFF, TXT

Just to name a few...

I would be willing to spend some time creating a module for SQL-Ledger to 
produce this type of output. Any other takers...?... Just so you know, my perl
skill are probably not as strong as others on the list, but I do have pretty 
good amount of programming experience regarding document conversion and 
ImageMagik.


Best

Marvin Dickens

RE: admin user passwd?

[Roger S. <rs...@ma...>]

>> Why is it that if I don't type a passwd for the admin.pl script 
>> that it allows me to go in? is there something I'm doing wrong? 
>> Also why do I have to include the postgres user and passwd when 
>> I add a new user? Just wondering...Any help is welcomed and 
>> appreciated... 
>> 
>> Roger Samour 

>Did you change the admin password yet? 

>The reason that you would specify another user is so that you >can differentiate 
>databases and usernames for different companies and or >branches or security. 

Well, yes I did change the passwd the first time, but the second time I do it, without a passwd, it lets me in, no questions asked... so I still don't know why it does that... thanks

Roger Samour

Windows & MySQL port

[Ilkka ... <gon...@ho...>]

Hi again,

Actually something else came up and I'm now dropping off this porting thing.

What I have done this far works anyway somehow, so if you want to test it, 
please send me mail (no need to send it to the mailing list) and I will send 
you a copy.

Ilkka

> > And BTW, I'm still on my way porting Sql-ledger to Windows & MySQL, it's
> > almost ready now. I don't know if you remember me talking about this 
>earlier
> > but I needed to get it working on Windows & MySQL. Maybe that's part of 
>the
> > reason to my problem :-)
> >
> > There are some other functionality too that I have added - like 
>Javascript
> > things and something else. When it's ready I hope that it can be 
>backported
> > to original version (hopefully not by me :), but anyway if there are 
>people
> > interested, I can give them a copy (of course, with disclaimers - for
> > example the installation procedure is not very smooth).
>
>How "not very smooth" is it?  I started to try to get postgresql and
>sql-ledger working on NT 4.0, but I realized I didn't have the
>experience to make that quick and easy, and I wasn't even sure it would
>work.  I might be interested in what you're doing, though.
>
>Bill
>--
>Bill Harris                                  3217 102nd Place SE
>Facilitated Systems                          Everett, WA 98208 USA
>http://facilitatedsystems.com/               phone: +1 425 337-5541
>




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

RE: PDF output

[Brian J. <bjo...@je...>]

This might help: http://www.easysw.com/htmldoc/

It's a GNU program with source code to convert HTML to PDF (among other
things)

It isn't in Perl but it can be run from a command line




-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Philip
Reetz
Sent: Thursday, December 20, 2001 3:35 PM
To: Dieter Simader
Cc: sql...@li...
Subject: PDF output


Hello Dieter,
I have two questions:
1.) I got an eMail today from someone who has modules for sales order
offers etc, which he thinks could be integrated into sql-ledger. How far
away is release 1.8 I'm asking, because if it is to long away we will start
working on it ourselves.

2.) How is the PDF output coming? I know it is on the todo list. We would
like to start working on it right away and don't start from scratch if
someone has already invested some thought and time into this project. We
would like to join forces with people who work on it.
If nobody has started working on it, maybe you can give us a few hints how
you would like to see it implemented so we go into the right direction.

Thank you very much.

Bye,
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: admin user passwd?

[<sql...@fi...>]

You wrote:

> From: "Roger Samour" <rs...@ma...>
> To: "sql-ledger users mailing list"  <sql...@li...>
> Date: Wed, 19 Dec 2001 18:27:34 -0600
> Subject: admin user passwd? 
> 
> 
> Why is it that if I don't type a passwd for the admin.pl script
> that it allows me to go in? is there something I'm doing wrong?
> Also why do I have to include the postgres user and passwd when
> I add a new user? Just wondering...Any help is welcomed and
> appreciated...
> 
> Roger Samour

Did you change the admin password yet?

The reason that you would specify another user is so that you can differentiate
databases and usernames for different companies and or branches or security.