sql-ledger-users — SQL-Ledger users

Re: [SL] Qty Precision

[<la...@cl...>]

Oops...never mind that I used the old version of pg_dumpall to export the
data and now using the 8.3 version to do the export all seems fine
now...tim
>
> On another question, I am also testing the upgrade of Postgres from 7.2 to
> 8.3, and any idea on what the 8.3 database locale should be? The default
> 8.3 database locale is LATIN9 and the pg_dumpall of SL from 7.2 is
> SQL_ASCII. You think I should init the 8.3 db using SQL_ASCII instead of
> the default LATIN9? Using LATIN9 and I did the import the yearend report
> are all messed up?
>
> Regards,
>
> Tim
>
>
>
>> On Wed, May 21, 2008 at 11:04 PM,  <la...@cl...> wrote:
>>> Looked further into the issue, it seems during the database upgrade the
>>> qty type had went from real to double precision. It seems weired that
>>> the
>>> value had went from 10.83 to 10.8299999237061 and not 10.8300000000000
>>
>> Following query should sort out the issue for the past data. New data
>> will always be correctedly recorded. (Take backup before running it)
>>
>> UPDATE invoice SET qty = ROUND(qty,2);
>>
>> Regards
>> --
>> http://wiki.ledger123.com/
>>
>> * Purpose-built SQL-Ledger Hosting. Free trial.
>> * SQL-Ledger VMware Appliance. Free download.
>>
>> --
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Microsoft
>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Qty Precision

[<la...@cl...>]

Thank you for the reply! I thought about doing something like that but as
the yearends for 05, 06, and 07 all checkout so I am gonna leave it alone
in the db as it is for now. I am sure that there is an explanation on how
real and double precision numbers are stored in the db and hence the
difference.

On another question, I am also testing the upgrade of Postgres from 7.2 to
8.3, and any idea on what the 8.3 database locale should be? The default
8.3 database locale is LATIN9 and the pg_dumpall of SL from 7.2 is
SQL_ASCII. You think I should init the 8.3 db using SQL_ASCII instead of
the default LATIN9? Using LATIN9 and I did the import the yearend report
are all messed up?

Regards,

Tim



> On Wed, May 21, 2008 at 11:04 PM,  <la...@cl...> wrote:
>> Looked further into the issue, it seems during the database upgrade the
>> qty type had went from real to double precision. It seems weired that
>> the
>> value had went from 10.83 to 10.8299999237061 and not 10.8300000000000
>
> Following query should sort out the issue for the past data. New data
> will always be correctedly recorded. (Take backup before running it)
>
> UPDATE invoice SET qty = ROUND(qty,2);
>
> Regards
> --
> http://wiki.ledger123.com/
>
> * Purpose-built SQL-Ledger Hosting. Free trial.
> * SQL-Ledger VMware Appliance. Free download.
>
> --
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Qty Precision

[Armaghan S. <sa...@le...>]

On Wed, May 21, 2008 at 11:04 PM,  <la...@cl...> wrote:
> Looked further into the issue, it seems during the database upgrade the
> qty type had went from real to double precision. It seems weired that the
> value had went from 10.83 to 10.8299999237061 and not 10.8300000000000

Following query should sort out the issue for the past data. New data
will always be correctedly recorded. (Take backup before running it)

UPDATE invoice SET qty = ROUND(qty,2);

Regards
-- 
http://wiki.ledger123.com/

* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger VMware Appliance. Free download.

--

Re: [SL] Qty Precision

[<la...@cl...>]

No response as of yet on this one...

Looked further into the issue, it seems during the database upgrade the
qty type had went from real to double precision. It seems weired that the
value had went from 10.83 to 10.8299999237061 and not 10.8300000000000
(probably during some alter table modify column command) as the original
value was entered as 10.83. I can probably use some more time to look into
this, but for now I have updated the io.pl to format qty like sellprice.

$form->format_amount(\%myconfig, $form->{"qty_$i"}, $decimalplaces, $zero)

This issue impact only existing invoice (I hope) and I can now get old
invoices to print only the two decimal place. Any input on if this is
gonna break anything would be great. For now, I can only rerun the yearend
reports using the old and new systems an hoping that their bottom lines
match. It would be annoying for them to be off by $0.01.

Thanks ahead for any comments!

Tim



> hello...we are testing our upgrade from 2.4.11 to 2.8.14 and the default
> precison is set to 2. Everything seems fine but the qty. for an example
> invoice went from 10.83 to 10.8299999237061. My guess is that the
> precision doesn't apply to qty. anyone knows how i can fix this? This line
> item was shipping so for most of the time it isn't an integer. Sending a
> customer an invoice with this many decimal place seems confusing...thanks
> ahead for your help...regards, tim
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Major problems after perl upgrade

[Mark J. S. <ms...@ea...>]

Hi everybody,

I'm running SQL Ledger on a Debian testing/lenny box.  One of the updates that 
happened recently was an upgrade from perl 5.8 to 5.10

I'm not sure if it is related, but since that update, Sql Ledger has been 
acting quite badly.

When I try to post a new invoice, i get:

DBD::Pg::db do failed: ERROR: syntax error at or near ")"
LINE 4: '21/05/2008', NULL, )
 ^ at SL/IS.pm line 1077.
Error!
INSERT INTO acc_trans (trans_id, chart_id, amount,
 transdate, project_id, id)
 VALUES (20297, 10035, 1.77,
 '21/05/2008', NULL, )
ERROR: syntax error at or near ")"
LINE 4: '21/05/2008', NULL, )
 ^


Which looks like the invoice id isn't getting processed properly.

When I try to print, I get

Error!
Bizarre copy of ARRAY in aassign at SL/Form.pm line 425.

Which means absolutely nothing to me.

I'm running 2.8.14, though I just upgraded today from 2.6.27 to try to fix 
this problem.

Under 2.6.27, I got a similar error message on posting, and something about an 
unreferenced hash on printing.

I see in the mailing list archives that Roy Pennington had a similar problem.  
Did you resolve it?

Mark

[SL] Qty Precision

[<la...@cl...>]

hello...we are testing our upgrade from 2.4.11 to 2.8.14 and the default
precison is set to 2. Everything seems fine but the qty. for an example
invoice went from 10.83 to 10.8299999237061. My guess is that the
precision doesn't apply to qty. anyone knows how i can fix this? This line
item was shipping so for most of the time it isn't an integer. Sending a
customer an invoice with this many decimal place seems confusing...thanks
ahead for your help...regards, tim

Re: [SL] incorrect sql-ledger-httpd.conf file?

[James M. <ja...@ja...>]

ja...@in... wrote:
>  James
>  I thinks you're confusing SQL-Ledger with another product.
>  ledgersmb perhaps ?
>  On Thu 15/05/08  6:36 AM , James McDonald ja...@ja...
> sent:
>   Alias / / 
>   
Woops sorry. s/ledgersmb/sql-ledger/g

Re: [SL] incorrect sql-ledger-httpd.conf file?

[Armaghan S. <sa...@le...>]

On Wed, May 14, 2008 at 11:21 PM, Myk Robinson <myk...@gm...> wrote:
> Just restored a backup file to the database, but now i am unable to restart
> apache after a clean install of sql-ledger. I get an error about the
> sql-ledger-httpd.conf file..  Here's the contents of the file:
>
> Alias / /
> <Directory>
>  AllowOverride All
>  AddHandler cgi-script .pl
>  Options ExecCGI Includes FollowSymlinks
>  Order Allow,Deny
>  Allow from All
> </Directory>
>
> <Directory /users>
>  Order Deny,Allow
>  Deny from All
> </Directory>

Contents of sql-ledger-httpd.conf seem incorrect due to some reason.

Following lines:
Alias / /
<Directory>

should be:
  Alias /sql-ledger /usr/local/sql-ledger/
  <Directory /usr/local/sql-ledger>

Regards

Re: [SL] incorrect sql-ledger-httpd.conf file?

[<ja...@in...>]

 James
 I thinks you're confusing SQL-Ledger with another product.
 ledgersmb perhaps ?
 On Thu 15/05/08  6:36 AM , James McDonald ja...@ja...
sent:
  Alias / / 

Re: [SL] incorrect sql-ledger-httpd.conf file?

[Myk R. <myk...@gm...>]

Thanks to all. I installed using the perl script, just downloaded today. I 
have installed this numerous times, and this has never happened..

On Wednesday 14 May 2008 04:06:13 pm James McDonald wrote:
> Myk Robinson wrote:
> > Just restored a backup file to the database, but now i am unable to
> > restart apache after a clean install of sql-ledger. I get an error about
> > the sql-ledger-httpd.conf file..  Here's the contents of the file:
> >
> >
> >
> >
> > Alias / /
> > <Directory>
> >   AllowOverride All
> >   AddHandler cgi-script .pl
> >   Options ExecCGI Includes FollowSymlinks
> >   Order Allow,Deny
> >   Allow from All
> > </Directory>
> >
> > <Directory /users>
> >   Order Deny,Allow
> >   Deny from All
> > </Directory>
>
> Alias / / <== here you are trying to alias the physical root dir to the
> webroot? which is incorrect Alias /lsmb /path/to/your/ledgersmbdir <= it
> should look like this <Directory /path/to/your/ledgersmbdir> <= directory
> needs a directory argument AllowOverride All
>   AddHandler cgi-script .pl
>   Options ExecCGI Includes FollowSymlinks
>   Order Allow,Deny
>   Allow from All
> </Directory>
>
> <Directory /users>
>   Order Deny,Allow
>   Deny from All
> </Directory>
>
> > And here is what I get when i try to restart apache:
> >
> > robinson@robinson-desktop:~$ sudo /etc/init.d/apache2 restart
> >  * Restarting web server apache2
> > * We failed to correctly shutdown apache, so we're now killing all
> > running apache processes. This is almost certainly suboptimal, so please
> > make sure your system is working as you'd expect now!
> > Syntax error on line 3 of /etc/apache2/sql-ledger-httpd.conf:
> > <Directory> directive requires additional arguments
> >
> > [fail]
> > robinson@robinson-desktop:~$
> >
> >
> >
> > What am i doing wrong? I copied the text word for word, so i assume
> > something is not correct with the text in the .conf file..
> >
> > Thanks,
> > -myk
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] incorrect sql-ledger-httpd.conf file?

[James M. <ja...@ja...>]

Myk Robinson wrote:
> Just restored a backup file to the database, but now i am unable to restart 
> apache after a clean install of sql-ledger. I get an error about the 
> sql-ledger-httpd.conf file..  Here's the contents of the file:
>
>
>
>
> Alias / /
> <Directory>
>   AllowOverride All
>   AddHandler cgi-script .pl
>   Options ExecCGI Includes FollowSymlinks
>   Order Allow,Deny
>   Allow from All
> </Directory>
>
> <Directory /users>
>   Order Deny,Allow
>   Deny from All
> </Directory>
>
>   

Alias / / <== here you are trying to alias the physical root dir to the webroot? which is incorrect
Alias /lsmb /path/to/your/ledgersmbdir <= it should look like this
<Directory /path/to/your/ledgersmbdir> <= directory needs a directory argument
  AllowOverride All
  AddHandler cgi-script .pl
  Options ExecCGI Includes FollowSymlinks
  Order Allow,Deny
  Allow from All
</Directory>

<Directory /users>
  Order Deny,Allow
  Deny from All
</Directory>

> And here is what I get when i try to restart apache:
>
> robinson@robinson-desktop:~$ sudo /etc/init.d/apache2 restart
>  * Restarting web server apache2                                                 
> * We failed to correctly shutdown apache, so we're now killing all running 
> apache processes. This is almost certainly suboptimal, so please make sure 
> your system is working as you'd expect now!
> Syntax error on line 3 of /etc/apache2/sql-ledger-httpd.conf:
> <Directory> directive requires additional arguments
>                                                                          
> [fail]
> robinson@robinson-desktop:~$
>
>
>
> What am i doing wrong? I copied the text word for word, so i assume something 
> is not correct with the text in the .conf file..
>
> Thanks,
> -myk
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft 
> Defy all challenges. Microsoft(R) Visual Studio 2008. 
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

[SL] Multiple currency question

[Dirk E. S. <ds...@ca...>]

We need to quote and calculate some of our services in USD, but invoices
have to be in local currency, based on a given exchange rate. Example:

Invoice:

1 item USD 100, exchange rate of today 1,791.00, total USD 100 = COP
1,791,000

Is there a way to calculate line items on both currencies and include the
exchange rate?

(I guess some users made experiences during the change to Euro some years
ago ...)

Thanks for any idea

Enrique

Cartagena - Colombia
http://www.sipcolombia.com

Re: [SL] incorrect sql-ledger-httpd.conf file?

[Paul T. <pt...@wa...>]

What you are doing wrong?  You are not reading the install docs, not reading
the faq's, did I miss something?
Apart from that, I suspect you probably did not make cgi executable, nor did
you configure apache correctly.

Either put the dir bit in the special sql-config for apache, OR put it in
the main apache config.
Putting config files half here and half there is an accident waiting to
happen (in plain English:  bound to get unwanted results)

BTW,. did you alias /path_to/sql-ledger/

2008/5/14 Myk Robinson <myk...@gm...>:

> Just restored a backup file to the database, but now i am unable to restart
> apache after a clean install of sql-ledger. I get an error about the
> sql-ledger-httpd.conf file..  Here's the contents of the file:
>
>
>
>
> Alias / /
> <Directory>
>  AllowOverride All
>  AddHandler cgi-script .pl
>  Options ExecCGI Includes FollowSymlinks
>  Order Allow,Deny
>  Allow from All
> </Directory>
>
> <Directory /users>
>  Order Deny,Allow
>  Deny from All
> </Directory>
>
>
> And here is what I get when i try to restart apache:
>
> robinson@robinson-desktop:~$ sudo /etc/init.d/apache2 restart
>  * Restarting web server apache2
> * We failed to correctly shutdown apache, so we're now killing all running
> apache processes. This is almost certainly suboptimal, so please make sure
> your system is working as you'd expect now!
> Syntax error on line 3 of /etc/apache2/sql-ledger-httpd.conf:
> <Directory> directive requires additional arguments
>
> [fail]
> robinson@robinson-desktop:~$
>
>
>
> What am i doing wrong? I copied the text word for word, so i assume
> something
> is not correct with the text in the .conf file..
>
> Thanks,
> -myk
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] incorrect sql-ledger-httpd.conf file?

[Rolf S. <in...@to...>]

In my installation, it's

Alias /sql-ledger /usr/local/sql-ledger

Do you try to install SL manually? Use setup.pl for this, or you'll have 
many more problems.

Rolf

Myk Robinson schrieb:
> Just restored a backup file to the database, but now i am unable to restart 
> apache after a clean install of sql-ledger. I get an error about the 
> sql-ledger-httpd.conf file..  Here's the contents of the file:
> 
> 
> 
> 
> Alias / /
> <Directory>
>   AllowOverride All
>   AddHandler cgi-script .pl
>   Options ExecCGI Includes FollowSymlinks
>   Order Allow,Deny
>   Allow from All
> </Directory>
> 
> <Directory /users>
>   Order Deny,Allow
>   Deny from All
> </Directory>
> 
> 
> And here is what I get when i try to restart apache:
> 
> robinson@robinson-desktop:~$ sudo /etc/init.d/apache2 restart
>  * Restarting web server apache2                                                 
> * We failed to correctly shutdown apache, so we're now killing all running 
> apache processes. This is almost certainly suboptimal, so please make sure 
> your system is working as you'd expect now!
> Syntax error on line 3 of /etc/apache2/sql-ledger-httpd.conf:
> <Directory> directive requires additional arguments
>                                                                          
> [fail]
> robinson@robinson-desktop:~$
> 
> 
> 
> What am i doing wrong? I copied the text word for word, so i assume something 
> is not correct with the text in the .conf file..
> 
> Thanks,
> -myk
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft 
> Defy all challenges. Microsoft(R) Visual Studio 2008. 
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] incorrect sql-ledger-httpd.conf file?

[Myk R. <myk...@gm...>]

Just restored a backup file to the database, but now i am unable to restart 
apache after a clean install of sql-ledger. I get an error about the 
sql-ledger-httpd.conf file..  Here's the contents of the file:




Alias / /
<Directory>
  AllowOverride All
  AddHandler cgi-script .pl
  Options ExecCGI Includes FollowSymlinks
  Order Allow,Deny
  Allow from All
</Directory>

<Directory /users>
  Order Deny,Allow
  Deny from All
</Directory>


And here is what I get when i try to restart apache:

robinson@robinson-desktop:~$ sudo /etc/init.d/apache2 restart
 * Restarting web server apache2                                                 
* We failed to correctly shutdown apache, so we're now killing all running 
apache processes. This is almost certainly suboptimal, so please make sure 
your system is working as you'd expect now!
Syntax error on line 3 of /etc/apache2/sql-ledger-httpd.conf:
<Directory> directive requires additional arguments
                                                                         
[fail]
robinson@robinson-desktop:~$



What am i doing wrong? I copied the text word for word, so i assume something 
is not correct with the text in the .conf file..

Thanks,
-myk

Re: [SL] need help with restoring data

[Rolf S. <in...@to...>]

Read the Howto on Armaghan's homepage:
http://wiki.ledger123.com/index.php?n=Local.DataRestore

Rolf

Myk Robinson schrieb:
> Hey-
> 
> One of my hard drives crashed in my sql-ledger system. I was able to retrieve 
> all my data, however a lot of email was lost. I had an archive of mails to 
> this list. How do i restore my backup file?
> 
> Thanks,
> -myk
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft 
> Defy all challenges. Microsoft(R) Visual Studio 2008. 
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] need help with restoring data

[Myk R. <myk...@gm...>]

Hey-

One of my hard drives crashed in my sql-ledger system. I was able to retrieve 
all my data, however a lot of email was lost. I had an archive of mails to 
this list. How do i restore my backup file?

Thanks,
-myk

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Andrew @ A. L. <atm...@km...>]

> 
> What I meant wasn't "PDF Screen", but "PDF dell". Neither me 
> nor my customers change to postscript when printing to the 
> network printer.
> 
>  > Only
>  > Issue is it's a little tight to the top and bottom of the page.
> 
> PDF and PS are not always 100 % the same, because the first 
> is created by pdflatex and the second by tex and dvips.
> 
> Rolf

Yes, tried PDF dell, and I get about 30 pages of jibberish from the printer.
I just made a copy of the original logo, saved my logo as logo.eps and its
working.  Not sure why PDF 'dell' does not work, but...  At this point not
to worried about it.  What do you suggest I do/change to make the "print"
look exactly like the PDF?  The PDF is perfect, and for the number of
invoices we do its fine to use the 2 step print (3-5 a day is all we would
normally invoice)

Also the PDF fits perfect on 8x11 the print is too tight to the top and
bottom. 

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Rolf S. <in...@to...>]

Andrew @ ATM Logic schrieb:
> PDF Screen is flawless

What I meant wasn't "PDF Screen", but "PDF dell". Neither me nor my 
customers change to postscript when printing to the network printer.

 > Only
 > Issue is it's a little tight to the top and bottom of the page.

PDF and PS are not always 100 % the same, because the first is created 
by pdflatex and the second by tex and dvips.

Rolf

Re: [SL] MOVE SERVER WHIT DIFFERENT VERSION OF POSTGRESQL

[Paul T. <pt...@wa...>]

Make sure to save all templates, users and other directories to say a usb
stick as well, just in case.
Those are NOT included in the sql_dump iirc.

2008/5/9 Armaghan Saqib <sa...@le...>:

> On Fri, May 9, 2008 at 12:29 PM, Ricardo Granados Tiznado
> <ri...@so...> wrote:
> > I am working now in local server with the version 2.8.14 and
> > PostgreSQl 7.4.19 and want to do a backup  and restore it in a vps
> > when i have PostgreSQL 8.1 or 8.3 I am not very sure still and the
> > same SQL-Ledger's version. I think to do a support with pg_dump
> > (pg_dump-Fc) in the local server and one pg_restore in the new server,
> > what problem exists with the change of PostgreSQL's versions that
> > could fall ill in SQL-Ledger ?
>
> 1. There should not be any problem restoring 2.8.14 backup into a
> newer postgresql versions.
>
> 2. psql is enough to restore sql-ledger backup (after uncompressing
> your backup if it is compressed)
>
> Regards
> Armaghan
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Andrew @ A. L. <atm...@km...>]

> Andrew McGeachy schrieb:
> > OK... So that is working great now I can print, however I 
> guess I am 
> > back to editing something... My PDF invoices and Statements 
> look great 
> > (our logo, everything is sthe right size)  However when I 
> print Postcript...
> 
> Postscript uses "logo.eps" instead of "logo.png". You have to 
> scale it to the correct size if you use postscript format.
> ==> Did you try to print PDF from SL to your Dell printer?
> 
> Rolf

PDF Screen is flawless, (so I can print the PDF to the 'dell' fine)
I just edited one of our logos down to about 1/4 the size of the 
Logo.eps and overwrote it, and now its working fairly good.  Only
Issue is it's a little tight to the top and bottom of the page.
"Thank you for your valued business" Is cut a bit at the bottom.

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Rolf S. <in...@to...>]

Andrew McGeachy schrieb:
> OK... So that is working great now I can print, however I guess I am back to
> editing something... My PDF invoices and Statements look great (our logo,
> everything is sthe right size)  However when I print Postcript...

Postscript uses "logo.eps" instead of "logo.png". You have to scale it 
to the correct size if you use postscript format.
==> Did you try to print PDF from SL to your Dell printer?

Rolf

Re: [SL] SL working fine, imported users, and restored from backup. All is well other than no PDF ?

[Andrew M. <atm...@km...>]

OK... So that is working great now I can print, however I guess I am back to
editing something... My PDF invoices and Statements look great (our logo,
everything is sthe right size)  However when I print Postcript invoice to
'dell' (what I setup for a printer) invoice prints out without any "error"
however the SQL Ledger logo is printed in HUGE size (about 5" x 9" and off
the page to the Right) and the rest of the invoice prints as it should but
just about off the page, some items would be off the page.

Any thoughts about what I would be missing with that.  You can point me to a
how to, and I should be able to remember how I did out invoices a number of
years ago, thanks.

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Armaghan Saqib
> Sent: Thursday, May 08, 2008 7:38 AM
> To: sql...@li...
> Subject: Re: [SL] SL working fine, imported users,and 
> restored from backup. All is well other than no PDF ?
> 
> On Thu, May 8, 2008 at 9:52 AM, Andrew @ ATM Logic 
> <atm...@km...> wrote:
> >  One other little thing you may be able to help me with is printing.
> >  I have just gotten into the habit of printing the PDF and 
> then after  
> > Opening the PDF I send that to the printer as I have not had the  
> > Postscript printer option work for a number of years...  We only  
> > Invoice maybe 3-6 times a day so its not a big deal...
> >  I am guessing I have some work to do with Cups.. Or something,  
> > However am I missing something simple?  Do I need to plug 
> the  Printer 
> > directly into the SL system?  (I normally print to Network  
> Lasers, in 
> > this case it would be a Dell Color Laser, however I have  Some old 
> > school laser I could plug in as well)
> 
> 1. Configure a CUPS printer on your SL server.
> 2. Add the name to sql-ledger.conf
> 3. Select it before printing invoice.
> 
> I have an HP network printer configured as CUPS printer on 
> Fedora 7 server and named it (conveniently) 'printer'. My 
> relevant sql-ledger.conf is:
> 
> %printer = ( Laser      => 'lpr -Plaser',
>              Epson      => 'lpr -PEpson',
>              printer    => 'lpr -Pprinter'
> );
> 
> You can remove the unwanted printers (Laser, Epson) from this 
> variable.
> 
> --
> * Purpose-built SQL-Ledger Hosting
> * SQL-Ledger VMware Appliance
> http://www.ledger123.com/
> 
> Free trial available.
> --
> 
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by the 2008 JavaOne(SM) 
> Conference Don't miss this year's exciting event. There's 
> still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java
> .sun.com/javaone
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] MOVE SERVER WHIT DIFFERENT VERSION OF POSTGRESQL

[Armaghan S. <sa...@le...>]

On Fri, May 9, 2008 at 12:29 PM, Ricardo Granados Tiznado
<ri...@so...> wrote:
> I am working now in local server with the version 2.8.14 and
> PostgreSQl 7.4.19 and want to do a backup  and restore it in a vps
> when i have PostgreSQL 8.1 or 8.3 I am not very sure still and the
> same SQL-Ledger's version. I think to do a support with pg_dump
> (pg_dump-Fc) in the local server and one pg_restore in the new server,
> what problem exists with the change of PostgreSQL's versions that
> could fall ill in SQL-Ledger ?

1. There should not be any problem restoring 2.8.14 backup into a
newer postgresql versions.

2. psql is enough to restore sql-ledger backup (after uncompressing
your backup if it is compressed)

Regards
Armaghan

[SL] MOVE SERVER WHIT DIFFERENT VERSION OF POSTGRESQL

[Ricardo G. T. <ri...@so...>]

I am working now in local server with the version 2.8.14 and
PostgreSQl 7.4.19 and want to do a backup  and restore it in a vps
when i have PostgreSQL 8.1 or 8.3 I am not very sure still and the
same SQL-Ledger's version. I think to do a support with pg_dump
(pg_dump-Fc) in the local server and one pg_restore in the new server,
what problem exists with the change of PostgreSQL's versions that
could fall ill in SQL-Ledger ?

Regards.

Ricardo Granados