sql-ledger-users — SQL-Ledger users

Re: sql-ledger and MySQL

[kevin b. <kev...@bi...>]

hi klavs,

i know its not the answer you want - but databases have a habit of 
growing - and 4 or 5 years down the line when you are responsible for 
possibly dozens of companies accounts you will be glad you chose an ACID 
compliant DB such as postgres,

kev


Sergio A. Kessler wrote:
> ----- Original Message ----- 
> From: "klavs klavsen" <kl...@vs...>
> 
>>Hi everybody,
>>
>>I'm new to sql-ledger - I got pointed to it by my local LUG
>>(www.sslug.dk).
>>
>>I can see it only supports postgres, which is very unfortunate for me,
>>as my only server only has 64mb's of ram, and I'm running mysql (which I
>>use for my PHP) and a lot of other stuff on it already. This is my
>>reasoning for not wanting to embark on postgres ( please no flames :-).
>>
> 
> I'm running postgres on a 32mb machine, and it run well.
> 
> 
>>I found some links describing that it was "only" a specific type of SQl
>>statements that didn't work in MySQL and that it also had something to
>>do with MySQL's lack of transaction support.
>>
> 
> it's not only transaction support, is a lot of things...
> (UNIONs, subselects, JOIN, foreign keys, VIEWs, etc)
> 
> 
>>With the links I found, I could ofcourse just exchange the sql
>>statements as described and my version would probably be up and
>>running.. but I would very much like for whatever change, to be in the
>>main code, so that I wouldn't have to do the whole thing over again when
>>1.8.3 emerges, and so on.
>>
> 
> look, we are talking about money here, you don't want to run
> it in a database that is not ACID compliant, trust me, you don't
> *really* want...
> running a storyboard with mysql is fine, running a system that
> manage money is another thing altogheter...
> 
> hey, what's the problem of learning postgresql ?
> (for me pgsql was easier to learn than mysql, 
> and I aproached pgsql after mysql)
> 
> this book is good for begginers:
> http://www.postgresql.org/docs/aw_pgsql_book/index.html
> 
> /sergio
> 
> 
> 
> 

Re: sql-ledger and MySQL

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

----- Original Message ----- 
From: "klavs klavsen" <kl...@vs...>

> Hi everybody,
> 
> I'm new to sql-ledger - I got pointed to it by my local LUG
> (www.sslug.dk).
> 
> I can see it only supports postgres, which is very unfortunate for me,
> as my only server only has 64mb's of ram, and I'm running mysql (which I
> use for my PHP) and a lot of other stuff on it already. This is my
> reasoning for not wanting to embark on postgres ( please no flames :-).

I'm running postgres on a 32mb machine, and it run well.

> I found some links describing that it was "only" a specific type of SQl
> statements that didn't work in MySQL and that it also had something to
> do with MySQL's lack of transaction support.

it's not only transaction support, is a lot of things...
(UNIONs, subselects, JOIN, foreign keys, VIEWs, etc)

> With the links I found, I could ofcourse just exchange the sql
> statements as described and my version would probably be up and
> running.. but I would very much like for whatever change, to be in the
> main code, so that I wouldn't have to do the whole thing over again when
> 1.8.3 emerges, and so on.

look, we are talking about money here, you don't want to run
it in a database that is not ACID compliant, trust me, you don't
*really* want...
running a storyboard with mysql is fine, running a system that
manage money is another thing altogheter...

hey, what's the problem of learning postgresql ?
(for me pgsql was easier to learn than mysql, 
and I aproached pgsql after mysql)

this book is good for begginers:
http://www.postgresql.org/docs/aw_pgsql_book/index.html

/sergio

database constraints

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

Hi,

I'm new to sql-ledger and new to postgresql but I can't seem to find where the constraint and index 
definitions are stored in the install scripts.  If anyone can point me in the right direction I 
would sure appreciate it.  If this a rtfm question I apologize in advance.

Thanks,
Damon

Ranksix Solutions Inc.
da...@ra...
250.514.6616

Re: PostgreSQL 7.2 and SLQ-Ledger 6.x

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

On Thu, 7 Mar 2002, Keld Jørn Simonsen wrote:

> > A simple search and replace did the trick:
> >
> > s/'current_date'/CURRENT_DATE/
>
> I get a lot of errors
> invalid command \N
> invalid command \.
>
> And after doing your recommended change I get:
>
> ERROR:  Bad date external representation 'CURRENT_DATE'

My guess is you did this:

s/'current_date'/'CURRENT_DATE'/

instead of this:

s/'current_date'/CURRENT_DATE/

Notice the difference? Remove the quotes as well. :-)

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

sql-ledger and MySQL

[klavs k. <kl...@vs...>]

Hi everybody,

I'm new to sql-ledger - I got pointed to it by my local LUG
(www.sslug.dk).

I can see it only supports postgres, which is very unfortunate for me,
as my only server only has 64mb's of ram, and I'm running mysql (which I
use for my PHP) and a lot of other stuff on it already. This is my
reasoning for not wanting to embark on postgres ( please no flames :-).

I found some links describing that it was "only" a specific type of SQl
statements that didn't work in MySQL and that it also had something to
do with MySQL's lack of transaction support.

With the links I found, I could ofcourse just exchange the sql
statements as described and my version would probably be up and
running.. but I would very much like for whatever change, to be in the
main code, so that I wouldn't have to do the whole thing over again when
1.8.3 emerges, and so on.

Do you have any plans for example, for making SQL-ledger workable with
both databases.. seeing as how MySQL's Innodb gives it transactions
support, there shouldn't be an immediate problem, or?

well anyways, I'm very interested in your work with the sql-ledger and
hope to be able to use it, one way or the other.

Thank you in advance.

--=20
Regards,
Klavs Klavsen

-------------| This mail has been sent to you by: |------------
              Klavs Klavsen - Open Source Consultant=20
                 kl...@vs... - http://www.vsen.dk

    Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments.            -- Rosabeth Moss Kanter

Re: PostgreSQL 7.2 and SLQ-Ledger 6.x

[Keld S. <ke...@dk...>]

On Thu, Mar 07, 2002 at 04:20:38PM +0100, Jonas Smedegaard wrote:
> Hi all,
> 
> I just upgraded to PostgreSQL 7.2 and ran into trouble.
> 
> I believe I solved the problem and want to share it with you (sorry if it
> is already covered somewhere):
> 
> The sql dumps had lines like the following
> 
>   "transdate" date DEFAULT 'current_date'
> 
> which PostgreSQL 7.2 dislikes.
> 
> A simple search and replace did the trick:
> 
> s/'current_date'/CURRENT_DATE/

I get a lot of errors 
invalid command \N
invalid command \.

And after doing your recommended change I get:

ERROR:  Bad date external representation 'CURRENT_DATE'

I really would like some advise on this.
I had no problems with upgrading to postres 7.1.3
but going to 7.2 has not worked for me yet.

Keld

PostgreSQL 7.2 and SLQ-Ledger 6.x

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

Hi all,

I just upgraded to PostgreSQL 7.2 and ran into trouble.

I believe I solved the problem and want to share it with you (sorry if it
is already covered somewhere):

The sql dumps had lines like the following

  "transdate" date DEFAULT 'current_date'

which PostgreSQL 7.2 dislikes.

A simple search and replace did the trick:

s/'current_date'/CURRENT_DATE/


 - 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: session management

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

Sergio,

you can easily add http authentication. In fact I make a reference to this
in the FAQ, under section Security.

However, session control has nothing to do with http authentication.


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 Mon, 4 Mar 2002, Sergio A. Kessler wrote:

> dieter, sometimes things are not that simple...
> 
> for example, rigth now, in my company (not a big one)
> one of boys in charge of accounting is in vacations,
> and other female employee took his place (using another
> username of course) using *the same* computer of the boy...
> (we are not using sql-ledger, by the way)
> 
> in my previous work (at a university) allmost all
> computers were shared betwen users, in fact, in that
> place there were employees using the computer at the
> morning, and others users using the same computer
> past midday...
> 
> all this using win98, a monouser system...
> 
> I understand you don't want to add http auth because
> dnhttpd doesn't support it, and I respect your desicion...
> (also I understand this is not a big priority)
> 
> /sergio

Re: session management

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

dieter, sometimes things are not that simple...

for example, rigth now, in my company (not a big one)
one of boys in charge of accounting is in vacations,
and other female employee took his place (using another
username of course) using *the same* computer of the boy...
(we are not using sql-ledger, by the way)

in my previous work (at a university) allmost all
computers were shared betwen users, in fact, in that
place there were employees using the computer at the
morning, and others users using the same computer
past midday...

all this using win98, a monouser system...

I understand you don't want to add http auth because
dnhttpd doesn't support it, and I respect your desicion...
(also I understand this is not a big priority)

/sergio

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>


> This apparent *security risk* is not a security risk at all.
>
> If you are concerned about other people accessing your terminal then you
> log off, or activate your screen saver, simple enough!
>
>
> 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 Mon, 4 Mar 2002, kevin bailey wrote:
>
> > hi there
> >
> > first thing - i am not an HTML/PERL expert - but...
> >
> > is there no way that perl can effecitvely wipe any password when the
> > page loads -  and then it is only the button/submit event which requests
> > the login.
> >
> > again - not my area of expertise etc. but surely we should find a way to
> > sort out this potential security risk,
> >
> > kev bailey
>
>
>

Re: VAT calculation rounding error

[Steven D'A. <st...@cy...>]

On Mon, Mar 04, 2002 at 05:47:18PM +0000, kevin bailey wrote:
> hi roy,
> 
> i could be right off the mark but...
> 
> my calculator gives me an answer of 16.625 - which in normal maths gets 
> rounded to 16.63
> 
> but in financial maths is it not the case that sometimes numbers ending 
> in '5' are rounded down and other times are rounded up.
> 
> something to do with a number being odd/even or something...
> 
> i think this is done because if '5' is always rounded up then totoals 
> tend to drift upwards with huge amounts,

If you are concerned about vast numbers of rounded fives, the conventional
method to deal with this problem is the "even-odd rule".

This rule says that:

 - if the five is the last significant digit and the round-off digit (the 
   one to the left of the 5) is odd, round up;

 - if the five is the last significant digit and the round-off digit is
   even, don’t round up

For example, 0.45 would round to 0.4, but 0.55 would round to 0.6.

However, the even-odd rule does NOT apply if there are additional digits
after the five. For example, 0.45001 is closer to 0.5 than it is to 0.4,
so you should round it to 0.5.


-- 
Steven D'Aprano
Cybersource Pty Ltd, ACN 053 904 082
Level 9, 140 Queen St, Melbourne VIC 3000 
Tel: +61 3 9642 5997  Fax: +61 3 96425998 
Web: http://www.cyber.com.au 

Re: demo toronto

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

I made this change for Opera in 1.8.3 already.

changes are listed on the *What's Ahead* page.

minor upgrades are usually nothing more than unpacking the code over top.


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 Mon, 4 Mar 2002, Franky Van Liedekerke wrote:

> ok, tx for the info. Is there a way to see the progress on this release? Or better: to download and try it out? I'm tempted on using sql-ledger, but I don't know if a version upgrade would be easy/difficult ...
> 
> Franky
> 
> btw: maybe the next version can support opera clients natively? Changing
> 
> 	if ($ENV{HTTP_USER_AGENT} =~ /(mozilla|links)/i) {
> to
> 	if ($ENV{HTTP_USER_AGENT} =~ /(mozilla|links|opera)/i) {
> 
> in the files admin.pl and login.pl should do the trick.
> 

Re: demo toronto

[Franky V. L. <lie...@pa...>]

ok, tx for the info. Is there a way to see the progress on this release? Or better: to download and try it out? I'm tempted on using sql-ledger, but I don't know if a version upgrade would be easy/difficult ...

Franky

btw: maybe the next version can support opera clients natively? Changing

	if ($ENV{HTTP_USER_AGENT} =~ /(mozilla|links)/i) {
to
	if ($ENV{HTTP_USER_AGENT} =~ /(mozilla|links|opera)/i) {

in the files admin.pl and login.pl should do the trick.



On Mon, 4 Mar 2002 11:12:34 -0700 (MST)
Dieter Simader <dsi...@sq...> wrote:

> 1.8.3 is still under development.
> 
> You can see the additional features on the what's ahead page. The
> *Toronto* demo is a snapshot of the latest development version.
> 
> 
> 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, 3 Mar 2002, Franky Van Liedekerke wrote:
> 
> > Hi all,
> > 
> > I see that the demo in Toronto is version 1.8.3, while the download
> > section only shows version 1.8.2. Is this version still under
> > development?
> > 
> > Franky
> > 
> > 
> 
> 
> 

Re: demo toronto

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

1.8.3 is still under development.

You can see the additional features on the what's ahead page. The
*Toronto* demo is a snapshot of the latest development version.


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, 3 Mar 2002, Franky Van Liedekerke wrote:

> Hi all,
> 
> I see that the demo in Toronto is version 1.8.3, while the download
> section only shows version 1.8.2. Is this version still under
> development?
> 
> Franky
> 
> 

Printing assembly components in invoice

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

Hello Dieter, hello list,

I have a question or a feature request ;)
My company sometimes sells computer hardware as a system (not really 
unusual). On the invoice I would like to have the system with the price and 
then all the components listed underneath. e. g.
qty     number  description             price
1       2334            workstationXP           1.234,00
1       122             Pentium IV
2       443             SDRAM 256 MB
1       44              HDD Maxtor 40 GB

I think you know what I mean. This is very important because my customers 
want to know what is in their system and almost every system is unique I 
would like to know the components by just looking at the invoice.

Right now I'm using this workaround a part system with price and all the 
components with a price of 0,00.
I think the use of assemblies would be a lot easier and less error prone.

Any comments. Looking forward to hear from the rest of the list.

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: session management

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

This apparent *security risk* is not a security risk at all.

If you are concerned about other people accessing your terminal then you
log off, or activate your screen saver, simple enough!


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 Mon, 4 Mar 2002, kevin bailey wrote:

> hi there
> 
> first thing - i am not an HTML/PERL expert - but...
> 
> is there no way that perl can effecitvely wipe any password when the 
> page loads -  and then it is only the button/submit event which requests 
> the login.
> 
> again - not my area of expertise etc. but surely we should find a way to 
> sort out this potential security risk,
> 
> kev bailey

Re: Backup and restore

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

The columns are not in the right order.

You could re-arrange the ar and parts tables or save the schema and
re-create your new database from the existing. This way they will match.

Or reorder the columns in the sql/Pg-tables.sql file to match yours and
create a new dataset.


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, 3 Mar 2002, David A. Bandel wrote:

> Hey folks,
> 
> Got a question about the backup and restore.
> 
> I have one system I've upgraded from like version 1.2 all the way to
> current (1.8.2).  Previously I did backups (OK, still do) from a command
> line and they worked fine.  Thought I'd give Dieter's backup a try.
> 
> So I installed another box, set up the database (empty), and tried to
> restore from the backup file (after all, that's what I'd do if the hard
> drive crashed).
> 
> However, some tables are giving me fits.  Here are the error messages from
> the restore (I used a command line \i <filename.db> to restore):
> psql:pananix.db:347: ERROR:  copy: line 1, Bad date external
> representation '10071' psql:pananix.db:347: PQendcopy: resetting
> connection and:
> psql:pananix.db:671: ERROR:  copy: line 1, Bad float8 input format
> '06-02-2002' psql:pananix.db:671: PQendcopy: resetting connection
> 
> I suspect for some reason the columns are being input in the wrong order. 
> The specific tables are: DELETE FROM ar;
> COPY ar FROM stdin;
> 10091   1001    21-11-2000      10071   0       502.5   500     502.5  
> 07-12-2000      20-12-2000      1       FOB David       30      \N      \N
>      \N
> 
> and:
> DELETE FROM parts;
> COPY parts FROM stdin;
> 10264   LS-Desktop      Complete Linux System Installed & Configured    ea
>      550     795     \N      06-02-2002      3.5     -1      \N      0    
>   0       0       0       10058   10063   10046   \N      0
> 
> When I created the original database, it only had the default table, so
> that's what I set up via the admin screen with 1.8.2 (Default dataset). I
> figured it'd be closest to the original from 1.2 (with all the updates). 
> 
> Thoughts, ideas, ???
> 
> Thanx,
> 
> David A. Bandel
> 

Re: VAT calculation rounding error

[kevin b. <kev...@bi...>]

hi roy,

i could be right off the mark but...

my calculator gives me an answer of 16.625 - which in normal maths gets 
rounded to 16.63

but in financial maths is it not the case that sometimes numbers ending 
in '5' are rounded down and other times are rounded up.

something to do with a number being odd/even or something...

i think this is done because if '5' is always rounded up then totoals 
tend to drift upwards with huge amounts,

HTH,

kev bailey

Roy Smith wrote:
> Hi folks
> 
>  
> 
> Please could anybody help with this one...
> 
>  
> 
> I have a Purchase invoice for £95.00 plus £16.63 of VAT at 17.5%.
> 
> When SQL-Ledger calculates the VAT it comes to £16.62.
> 
>  
> 
> What is the best way to force the correct VAT amount into the Purchase 
> Invoice ?
> 
>  
> 
> best regards
> 
> Roy
> 
>  
> 

Re: session management

[kevin b. <kev...@bi...>]

hi there

first thing - i am not an HTML/PERL expert - but...

is there no way that perl can effecitvely wipe any password when the 
page loads -  and then it is only the button/submit event which requests 
the login.

again - not my area of expertise etc. but surely we should find a way to 
sort out this potential security risk,

kev bailey



 >>/me knocks my embarrased head...
 >>
 >>ok, anyway, while we are at it: whoever come to my computer
 >>can log in my name, as the url (with the encrypted passwd)
 >>stay in the browser cache...
 >>(thanks to url completion features in IE, mozilla et al)
 >>
 >>I just type "aba" in my browser and he show me many
 >>urls to access sql-ledger bypassing the login dialog,
 >>for example, this:
 >>http://abacus.sql-ledger.org/sql-ledger/menu.pl?path=bin/mozilla&action=
 >>acc_
 >>menu&login=sergio&password=
 >>
 >>note the passwd IS there (it's just blank), so skipping the login dialog
 >>is just too easy, even it happened me accidently...
 >>
 >>and that can be a big security problem in bussiness...
 >>
 >>/sergio
 >>

Re: VAT calculation rounding error

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

This rounding error is compliments of perl and will disappear with the
next release. I have added a proper rounding function which rounds up on
.5 instead of down.

However for any tax discrepencies you can add a VAT adjustment by adding
a service item linked to the tax to your invoice.


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

On Sun, 3 Mar 2002, Roy Smith wrote:

> Hi folks
>=20
> Please could anybody help with this one...
>=20
> I have a Purchase invoice for =A395.00 plus =A316.63 of VAT at 17.5%.
> When SQL-Ledger calculates the VAT it comes to =A316.62.
>=20
> What is the best way to force the correct VAT amount into the Purchase
> Invoice ?
>=20
> best regards
> Roy
>=20
>=20

demo toronto

[Franky V. L. <lie...@pa...>]

Hi all,

I see that the demo in Toronto is version 1.8.3, while the download section only shows version 1.8.2. Is this version still under development?

Franky

Re: session management

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

I think you don't understand a single bit of what I said,
please re-read my mail...

1) I'm not blaming dieter.
2) it's not about microsoft security bugs.
   ("it's not a bug, it's a feature, stupid")
3) it's not about windows.
4) it's not about IE

1a) I'm not blaming anyone, I just point to what *I* believe
    it's a security problem.
2a) I'm not pointing bugs in microsoft software,
    the url completion is a *normal* feature (in many browsers now).
3a) it happens on linux too.
4a) it happens on mozilla too.

please, keep your anti-microsoft propaganda to yourself
and try to be constructive instead of bashing left & rigth.

/sergio
pd: if you want to continue the flaming, instead of trying
to help, mail me privately, no need to bother other people.


----- Original Message ----- 
From: "Dr Default" <drd...@ho...>


> Whoever comes to the Whitehouse Computer keyboard can very possibly
> press the button for
> Full Global Nuclear War. That's why they only let chosen (elected) fools
> do that..
> Besides, somehow it seems unfair to me to blame Dieter for Microsoft's
> well spread security bugs.
> Workaround one: disable the 'remember my password' bit in IE and you are
> halfway there..
> Workaround two: disable windows and install linux
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> Sergio A. Kessler
> Sent: zondag 3 maart 2002 1:58
> To: Dieter Simader
> Cc: Kenneth Gonsalves; sql...@li...
> Subject: Re: session management
> 
> 
> /me knocks my embarrased head...
> 
> ok, anyway, while we are at it: whoever come to my computer
> can log in my name, as the url (with the encrypted passwd)
> stay in the browser cache...
> (thanks to url completion features in IE, mozilla et al)
> 
> I just type "aba" in my browser and he show me many
> urls to access sql-ledger bypassing the login dialog,
> for example, this:
> http://abacus.sql-ledger.org/sql-ledger/menu.pl?path=bin/mozilla&action=
> acc_
> menu&login=sergio&password=
> 
> note the passwd IS there (it's just blank), so skipping the login dialog
> is just too easy, even it happened me accidently...
> 
> and that can be a big security problem in bussiness...
> 
> /sergio
> 
> ----- Original Message -----
> From: "Dieter Simader" <dsi...@sq...>
> 
> 
> > There is no session management in SQL-Ledger.
> >
> > If you have session management than you are not using the official
> > version of SQL-Ledger.
> >
> > I suggest you complain to whoever added session managment.
> >
> >
> > 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, 2 Mar 2002, Sergio A. Kessler wrote:
> >
> > > a solution would be to use http auth
> > > (wich is a lot more simple than sessions),
> > > but dieter is against it  :(
> > >
> > > /sergio
> > >
> > > ----- Original Message -----
> > > From: "Kenneth Gonsalves" <la...@th...>
> > >
> > >
> > > > hi
> > > > problem:
> > > > user starts a session on a web based app. connection gets cut. he
> > > > re-establishes connection and tries to login. message - 'already
> logged in
> > > > get lost'. he has to wait anything upto 30 minutes for his
> > > > previous
> > > session
> > > > to expire before being able to do his work. any solution for this?
> 
> > > > kg

templates issue

[Franky V. L. <lie...@pa...>]

Hi all,

I'm just learning how to use sql-ledger, and was looking at the templates. Now I find something strange there:

at the top of Default-invoice.html, there's:

<head>
  <title>Invoice</title>
</head>

<body bgcolor=ffffff>


and Default-email_invoice.html invoice contains:

<HTML>
<HEAD>
  <TITLE>Invoice <%invnumber%></TITLE>
</HEAD>
<BODY BGCOLOR=ffffff>

According to me (and my browser), this results in html code with two <head><body> definitions, which is not what's desired.
My suggestions: put the <HTML>-tag in the Default-invoice.html file, and remove the <HEAD><BODY> code from the Default-email_invoice.html template, this would result in much better html-generated code.

With friendly regards,

Franky

Backup and restore

[David A. B. <da...@pa...>]

Hey folks,

Got a question about the backup and restore.

I have one system I've upgraded from like version 1.2 all the way to
current (1.8.2).  Previously I did backups (OK, still do) from a command
line and they worked fine.  Thought I'd give Dieter's backup a try.

So I installed another box, set up the database (empty), and tried to
restore from the backup file (after all, that's what I'd do if the hard
drive crashed).

However, some tables are giving me fits.  Here are the error messages from
the restore (I used a command line \i <filename.db> to restore):
psql:pananix.db:347: ERROR:  copy: line 1, Bad date external
representation '10071' psql:pananix.db:347: PQendcopy: resetting
connection and:
psql:pananix.db:671: ERROR:  copy: line 1, Bad float8 input format
'06-02-2002' psql:pananix.db:671: PQendcopy: resetting connection

I suspect for some reason the columns are being input in the wrong order. 
The specific tables are: DELETE FROM ar;
COPY ar FROM stdin;
10091   1001    21-11-2000      10071   0       502.5   500     502.5  
07-12-2000      20-12-2000      1       FOB David       30      \N      \N
     \N

and:
DELETE FROM parts;
COPY parts FROM stdin;
10264   LS-Desktop      Complete Linux System Installed & Configured    ea
     550     795     \N      06-02-2002      3.5     -1      \N      0    
  0       0       0       10058   10063   10046   \N      0

When I created the original database, it only had the default table, so
that's what I set up via the admin screen with 1.8.2 (Default dataset). I
figured it'd be closest to the original from 1.2 (with all the updates). 

Thoughts, ideas, ???

Thanx,

David A. Bandel
-- 
Focus on the dream, not the competition.
		-- Nemesis Racing Team motto
Internet (H323) phone: 206.28.187.30

VAT calculation rounding error

[Roy S. <xy...@bt...>]

Hi folks

Please could anybody help with this one...

I have a Purchase invoice for £95.00 plus £16.63 of VAT at 17.5%.
When SQL-Ledger calculates the VAT it comes to £16.62.

What is the best way to force the correct VAT amount into the Purchase
Invoice ?

best regards
Roy

Re: session management

[Kenneth G. <la...@th...>]

sorry about this - this question was not meant for this list, my finger 
slipped in the address book
kg
On Sunday 03 March 2002 02:15, Dieter Simader wrote:
> There is no session management in SQL-Ledger.
>
> If you have session management than you are not using the official version
> of SQL-Ledger.
>
> I suggest you complain to whoever added session managment.
>
>
> 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, 2 Mar 2002, Sergio A. Kessler wrote:
> > a solution would be to use http auth
> > (wich is a lot more simple than sessions),
> > but dieter is against it  :(
> >
> > /sergio
> >
> > ----- Original Message -----
> > From: "Kenneth Gonsalves" <la...@th...>
> >
> > > hi
> > > problem:
> > > user starts a session on a web based app. connection gets cut. he
> > > re-establishes connection and tries to login. message - 'already logged
> > > in get lost'. he has to wait anything upto 30 minutes for his previous
> >
> > session
> >
> > > to expire before being able to do his work. any solution for this?
> > > kg