sql-ledger-users — SQL-Ledger users

[SL] Printer Output Default/Media

[Florian R. <fl...@mu...>]

Hi,

i looked a bit in the documentation, and some minutes in the source.

How can the printer media enforced, e.g. only create pdf, no html, no
postscript. And or how could be PDF marked as default?


thanks in advance..

-- 
Dipl.-Inf. Univ. Florian Reitmeir                     http://net.multi24.com/

Josef-Schweinester-Str.1                              Tel: +43 526 266166 
6412 St. Georgen / Austria                            Fax: +43 526 266166 -10

Re: [SL] Howto recover a deleted invoice

[Dr E. L. <el...@li...>]

Doesn't SL do this with an transaction ID, so that you can have two
invoices with the same invoice number if you want? In other words, would
it not overwrite the new one?

Never mind, if this happens to you, it does teach you, to conentrate :-)-O

el

on 3/10/07 1:52 PM Craig Isdahl said the following:
> We'll I'm no SL expert but if they did a "post as new" it created a
> new invoice w/ a new invoice number.  Assuming they are able to go
> "back" in the browser to the original unmodified invoice they could
> repost it, re-creating the original and leaving the new one.  Is my
> logic flawed?
>

Re: [SL] Howto recover a deleted invoice

[Craig I. <cr...@da...>]

We'll I'm no SL expert but if they did a "post as new" it created a new
invoice w/ a new invoice number.  Assuming they are able to go "back" in the
browser to the original unmodified invoice they could repost it, re-creating
the original and leaving the new one.  Is my logic flawed?


> -----Original Message-----
> From: sql...@li... [mailto:sql-ledger-
> use...@li...] On Behalf Of Dr Eberhard Lisse
> Sent: Saturday, March 10, 2007 1:07 AM
> To: sql...@li...
> Subject: Re: [SL] Howto recover a deleted invoice
> 
> Will that not overwrite the newly posted invoice?
> 
> el
> 
> on 3/10/07 12:32 AM Craig Isdahl said the following:
> > If you haven't already shutdown your computer or browser, just hit the
> back
> > button until you get to the correct version of the invoice then post it.
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Best Linux OS for SL?

[Vladimir B. <vl...@bo...>]

> Normally I use SME/Mitel/E-smith for my SL installes, however I have
> a site that wants SL, already has a SME doing way to many other
> tasks.. what would the"list" recomend for simple Linux OS to install
> SL as a stand alone server??
>  
> Thanks,
>  
> PS, sorry if this is a duplicate.. I did not see my post arrive last
> time....

Hello, as a standalone server consider FreeBSD. Get rid of the X and
desktop management configuration, just install the applications you need
for SL (apache, sql, ...) Also the security management will be easier.
If you decide for linux try Debian or Redhat server. No SUSe after M$
aliance.

Cheers, -vlado

Re: [SL] sql-ledger-users Digest (any issue)

[Peter H. <pe...@ho...>]

I've been quietly watching this list for a while, just to get a sense 
for SL as I'm planning to use it for a number of companies (I'm not an 
accountant, just the guy who's been lumbered with finding 'something' :-).

In general terms, a couple of observations on the list.  All IMHO, of 
course:

(1) Personal observations (the 'idiot' series) do not have a place, 
otherwise the list should be turned into moderated status and messages 
subjected to edit.  The volume is low enough, and you could flag only 
specific members for edit (yes, it's a form of censorship).  Been there, 
seen it and even done it.  But there are two sides to this: cause and 
effect.

(2) If you have knowledge, it may be a good idea to display it by 
educating rather than state that "it's simple".  The difference is in 
documenting your efforts. Stating that you can do something and then 
speak disparaging of others who ask you for details (i.e. prove it) is 
actually a social engineering method used by fraudsters.  I don't think 
that's the case here <g>, but by just saying "it's easy" without any 
documentary evidence creates IMHO exactly the kind of frustration that 
lead to the name calling.  A question is asked because a solution is 
desired.  If you have something positive to contribute, speaketh.  If 
not, "don't waste my bandwidth" was an advice that existed in days 
before the Net (BBS).  It's still valid.

So, that's the personal stuff dealt with (proverbial asbestos underwear 
donned :-).

Next: the newbie view.

(1) Printed output.  I'm amazed to see someone mention output doesn't 
identify the company.  That should be a default header/footer macro.  
I'm also slightly apprehensive seeing the use of LaTEX for output 
formatting - never used it so that's something else I'm going to have to 
pick up (although I probably mastered worse things :-).  Was that choice 
because HTML doesn't have decent page control?  I know there will 
probably be a 'print' button somewhere but I know from experience that 
most users will just do a Ctrl-P in their web browser and expect it to 
work (I noticed a neat trick at JoomlaShack where a printout will 
actually -automatically- use a different layout which is more optimised 
for prints - interesting idea).

(2) Test perspective.  I have existing Charts of Accounts that I'd like 
to use to test the system.  I have, however, no way of assessing if the 
system will work for what I have in mind as the magic secret of getting 
those charts in is contained in a 'to-buy' manual.  I have no problem 
with spending money on the manual (I always sponsor a project that gives 
me benefits for moral reasons) as such but I would have preferred a 
donation route instead of being forced into manual labour :-).

(3) Time Cards.  From personal experience I know the day format will 
give the most accurate result - it's also the most hated one.  A 
"Weekly" would be better, and I can see that being of use to 
recruiters/consultancies as well (I vaguely recall I had a query for 
that at some stage).  However, from a security background I'd be 
hesitant to let outsiders near my core accounting system so I think I 
may have a word with some people to see if we can't cook up some 
interfaces to a webpage.  I'm thinking about a system where someone logs 
in, enters their a/c (have SL look up if it's valid) then progress to a 
week chart with some codes that associate with the relevant a/c, and 
sense/range check the inputs before it gets fed to SL or to some system 
that allows a multi-stage approval cycle.  It would go a long way to 
automated billing and remove manual entry and the inaccuracies that can 
result from that.  It's an idea, but probably not in scope for SL.

(4) For the rest, well, I'm not an accountant but I may have to be one 
for a while. I thus found it interesting to find some good help on the 
'contributors' page - this should be more prominent IMHO.  And thanks to 
whoever put up this link 
<http://www.dwmbeancounter.com/tutorial/Tutorial.html> because it's good 
stuff :-).

(5) Overall security.  For those who don't do this for a living, if you 
install SL for corporate use I would strongly suggest not to expose the 
interface to the outside world until you have secured the system.  Under 
Unix/Linux this means removing services you don't use, latest patches 
(as always), tight firewall and if you can possibly manage use a VPN or 
at least SSL (together is harder :-).  Even Hamachi (hamachi.cc) is 
better than raw on the Net.  Where possible use SE Linux to contain 
processes, and run a daily crack on the passwords (after agreeing this 
with users and management) to pick up people that have made their life 
too easy - it's still the easiest route into a system (I'm veering 
strongly towards two-factor logons for the accounts myself). 
Under Windows, well, I may cause a storm here but I personally think 
you're starting with the wrong fundamentals, and I'm saying that as 
someone who's been using it since Worries for Workgroups.  Best stick it 
behind a non-Windows based firewall (cheap & cheerful: IPcop.org) and 
ensure you manually apply patches with a decent rollback mechanism.  
It's perfectly possible to build a secure Windows environment, it's just 
too much work and expense to my liking :-).  For the best help there, go 
to the NSA.org pages and download the advice, then gradually switch on 
until you have a system that just does the job and nothing more.  Be 
warned: the NSA advice will initially give you a system that practically 
doesn't work until you throttle back a bit so document what you're doing.

That's me.  I'll shut up now :-).

-- 

Regards,   /// Peter ///

Peter Houppermans MBCS CITP etc etc

E:	pe...@ho...
E:	pet...@me...

"A positive attitude will not solve all your problems, but
it will annoy enough people to make it worth the effort."
 -- Herm Albright

Authorised Thawte Web of Trust Notary

Re: [SL] Best Linux OS for SL?

[Gene C. <gc...@so...>]

Hi,

I'd suggest Using Centos as you are already familiar with it.  SME 7 is 
based on Centos.  Use the single-server CD.

This may be of help, but if you find any errors, please let me know.  YMMV

http://www.sonoracomm.com/index.php?option=com_content&task=view&id=80&Itemid=32

G

ATM Logic wrote:
> Normally I use SME/Mitel/E-smith for my SL installes, however I have a site
> that wants SL, already has a SME doing way to many other tasks.. what would
> the"list" recomend for simple Linux OS to install SL as a stand alone
> server??
>  
> Thanks,
>  
> PS, sorry if this is a duplicate.. I did not see my post arrive last
> time....
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-- 

=============================
Gene Cooper
Sonora Communications, Inc.
5531 N. Oracle Road
Tucson, AZ  85704

(520) 293-8461 x101
(520) 888-4060 fax

gc...@so...

Re: [SL] Howto recover a deleted invoice

[Dr E. L. <el...@li...>]

Will that not overwrite the newly posted invoice?

el

on 3/10/07 12:32 AM Craig Isdahl said the following:
> If you haven't already shutdown your computer or browser, just hit the
back
> button until you get to the correct version of the invoice then post it.

Re: [SL] Best Linux OS for SL?

[George O. <geo...@ya...>]

On Saturday 10 March 2007 16:30, ATM Logic wrote:
> Normally I use SME/Mitel/E-smith for my SL installes, however I have a site
> that wants SL, already has a SME doing way to many other tasks.. what would
> the"list" recomend for simple Linux OS to install SL as a stand alone
> server??
>
> Thanks,
>

I don't think there is a difference. Whatever distro you're comfortable with 
just install it and run SL. I tried RedHat, Debian and SuSe and as far as SL 
goes I did not see any diference.

George

[SL] Best Linux OS for SL?

[ATM L. <atm...@km...>]

Normally I use SME/Mitel/E-smith for my SL installes, however I have a site
that wants SL, already has a SME doing way to many other tasks.. what would
the"list" recomend for simple Linux OS to install SL as a stand alone
server??
 
Thanks,
 
PS, sorry if this is a duplicate.. I did not see my post arrive last
time....

[SL] /sql-ledger/login.pl: symbol lookup error

[Joseph <sy...@in...>]

After upgrading several perl script, when I try to log-in to sql-ledger
I get:
/usr/local/sql-ledger/login.pl: symbol lookup error: /usr/lib/perl5/vendor_perl/5.8.8/i686-linux/auto/DBD/Pg/Pg.so: undefined symbol: PQserverVersion
[client 127.0.0.1] Premature end of script headers: login.pl

Can anybody point me in the right direction?
-- 
Joseph

Re: [SL] Howto recover a deleted invoice

[Craig I. <cr...@da...>]

If you haven't already shutdown your computer or browser, just hit the back
button until you get to the correct version of the invoice then post it.

> -----Original Message-----
> From: sql...@li... [mailto:sql-ledger-
> use...@li...] On Behalf Of Adrien Laurent
> Sent: Friday, March 09, 2007 12:37 PM
> To: sql...@li...
> Subject: [SL] Howto recover a deleted invoice
> 
> Hi Everyone,
> 
> I've overwrote an invoice using POST instead of POST AS NEW, is there
> an easy way to bring back the old invoice ?
> 
> Thanks a lot,
> 
> Adrien
> 
> --
> Adrien Laurent
> Chief Information Officer
> (514) 284-2020 x 202
> ad...@mo...
> www.modulis.ca
> 
> Technical questions? su...@mo...
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Config

[Jigme D. <jig...@gm...>]

On 3/9/07, Sergio Ruiz <ru...@sb...> wrote:

> The error message is the following:
> Error!
> could not connect to server: Connection refused
>  Is the server running on host "192.168.1.24" and accepting
>  TCP/IP connections on port 5432?

The error message looks like the SQL server is either not running, or
if it is running it is not accepting connections on the 192.168.1.24
interface.  If this is the localhost that is running the server, you
can simply leave the host blank and it should work. It works for me
that way.

Jigme Datse

Re: [SL] Config

[Ted O. <te...@on...>]

Check to make sure the PostgreSQL database server is running.

Is your database running on a remote machine?  If so, the database server may 
not be set up to allow TCP connections.

Ted

Sergio Ruiz wrote:
> Hi folks,
>   This might be a stupid question, but I'm already don't know where to look. I'm trying to install sql-ledger, and I'm having problems. 
> 
>   I enter in http://myservername/sql-ledger/admin.pl. Then I click on 'Pg  Database Administration' to create the dataset. In host I type in the ip address of the computer hosting the software. As user sql-ledger, and connect to template1. I don't know the password for sql-ledger. I have tried leaving it blank, or use the password 'password', but nothing seems to work.
> 
> The error message is the following:
> Error!          
> could not connect to server: Connection refused
>  Is the server running on host "192.168.1.24" and accepting
>  TCP/IP connections on port 5432?
> 
> 
> I have the feeling that I'm missing something. I have no idea what. Can anyone help me, please?
> 
> Thank you,
> 
> Sergio J Ruiz
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

[SL] Howto recover a deleted invoice

[Adrien L. <adr...@gm...>]

Hi Everyone,

I've overwrote an invoice using POST instead of POST AS NEW, is there
an easy way to bring back the old invoice ?

Thanks a lot,

Adrien

-- 
Adrien Laurent
Chief Information Officer
(514) 284-2020 x 202
ad...@mo...
www.modulis.ca

Technical questions? su...@mo...

Re: [SL] Poll - What do you want to see?

[Jeff R. <je...@jr...>]

Hi All

I'd like to be able to assign more than one group of items to a 
customer. My items are classified by areas of repair (telephone, cash 
register, computer) I have many customers that repair more than one 
category and it would be nice if the pricelist for them could include 
both categories (without having to print two separate sets out). It's 
not a big deal, I'll look into it myself when I get some time if it 
doesn't appear in an upcoming revision.

Jeff Roberts

[SL] Config

[Sergio R. <ru...@sb...>]

Hi folks,
  This might be a stupid question, but I'm already don't know where to look. I'm trying to install sql-ledger, and I'm having problems. 

  I enter in http://myservername/sql-ledger/admin.pl. Then I click on 'Pg  Database Administration' to create the dataset. In host I type in the ip address of the computer hosting the software. As user sql-ledger, and connect to template1. I don't know the password for sql-ledger. I have tried leaving it blank, or use the password 'password', but nothing seems to work.

The error message is the following:
Error!          
could not connect to server: Connection refused
 Is the server running on host "192.168.1.24" and accepting
 TCP/IP connections on port 5432?


I have the feeling that I'm missing something. I have no idea what. Can anyone help me, please?

Thank you,

Sergio J Ruiz

Re: [SL] Poll - What do you want to see?

[Ronald K. <rj...@ya...>]

A management menu that will generate reports and help you to:=0A=0ASet ROP =
based on sales=0ACreate parent child relationships for categories=0AUpdate =
vendor cost as percent of list price=0ACreate PO based on sales=0ABest Sell=
ers....Dollars / Margin=0A=0Aand..=0A=0Aallocate freight on Vendor invoice=
=0A=0A=0A----- Original Message ----=0AFrom: C. Duncan Hudson <Duncan@Dunc-=
IT.com>=0ATo: sql...@li...=0ASent: Friday, March =
2, 2007 9:49:47 AM=0ASubject: [SL] Poll - What do you want to see?=0A=0A=0A=
After my last post I got to thinking...  It seems (to me) that the same =0A=
items come up over and over on the list.  There is continued development =
=0Aof the application (and that's wonderful), but is it providing what =0Ap=
eople are really looking for, wanting, needing?  What are the two =0Abigges=
t things everyone wants fixed or added to SQL-Ledger?=0A=0AMy two biggest w=
ants, needs are:  Sales tax flexibility - I need to be =0Aable to make a ta=
xed customer tax free (on occasion) and vice versa.  My =0Anext wish would =
just make my life easier - I wish you could search (on =0APOs, Sales Orders=
 and Invoices) by Shipto.=0A=0AAnybody else?=0A=0A=0ADunc=0A=0A=0A=0A------=
-------------------------------------------------------------------=0ATake =
Surveys. Earn Cash. Influence the Future of IT=0AJoin SourceForge.net's Tec=
hsay panel and you'll get the chance to share your=0Aopinions on IT & busin=
ess topics through brief surveys-and earn cash=0Ahttp://www.techsay.com/def=
ault.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV=0A___________________=
____________________________=0Asql-ledger-users mailing list=0Asql-ledger-u=
se...@li...=0Ahttps://lists.sourceforge.net/lists/listinfo/s=
ql-ledger-users=0A=0A=0A =0A_______________________________________________=
_____________________________________=0ASucker-punch spam with award-winnin=
g protection. =0ATry the free Yahoo! Mail Beta.=0Ahttp://advision.webevents=
.yahoo.com/mailbeta/features_spam.html

Re: [SL] Poll - What do you want to see?

[Dr E. L. <el...@li...>]

on 3/8/07 6:37 PM Michael Hasse said the following:
> #1
> A "clean" way of handling overpayments and prepayments:

I'd also like to have an easier way to do this.


> #2
> Fix the summary reporting of taxes!!!!!!!!!!!!!!!!

Yours truly, the pompous ass and idiot, has a little perl script that,
collects all AR and AP transactions and generates a list of them in a
LaTeX box, deducts one subtotal from the other into another box. And
fills in the Namibian VAT form.

Anyone wanting to to have a look at really horrid programming style, can
email me.


> 	This cost us quite a few man-hours and several hundred dollars in  
> fines recently.  :(

You just made my week!

el

Re: [SL] Poll - What do you want to see?

[Michael H. <mh...@it...>]

#1
A "clean" way of handling overpayments and prepayments:
	- uninvoiced funds are associated with the customer
	- these amounts appear at the bottom of any new invoice as a payment 
(s) with the original date/memo etc
	- like a regular payment item though these can be edited in case the  
customer prefers a different application of funds
	- the current available balance shows up everywhere the current  
available credit does
	- the current remaining balance is shown on the invoice
	- prepayment amounts can be made taxable (or not) on a systemwide  
basis to handle countries where taxes are levied on receipt of funds
	- summary reporting of taxes is fixed(!) so that these amounts, and  
any adjustments due to nontaxable items being purchased, are rolled  
up properly

#2
Fix the summary reporting of taxes!!!!!!!!!!!!!!!!
	This cost us quite a few man-hours and several hundred dollars in  
fines recently.  :(

Re: [SL] Output reports to csv

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

Hi Russell
Another simple way to output to CSV is to install and use
latest Webmin.
>From Webmin, open the postgresql table, and click-clack at
the "Export as CSV" button. Seems real easy.
Cheers again
David J
PS.  I think this is a recent addition to Webmin.  
YMMV with older version/s.

> 
> Could you please detail the steps to enable this?
> 
> This would be very useful.
> 
> TIA
> 
> Russell
> 
>

Re: [SL] Output reports to csv

[Michael H. <mh...@it...>]

Yes, please, stop replying to him!  (The only time I have to see his  
crap is when somebody replies and I read the thread.  :)
    On a more serious note, while it is easy enough to filter people  
like that, first impressions do count.  New members of the list  
seeing his sort of unprofessional trash talk (even to someone else)  
may not stick around long enough to find out how many genuinely nice  
and helpful people there actually are on the list.
    I hate to think how much business he has cost Dieter...


On Mar 5, 2007, at 10:34 PM, Christopher A. Bailey wrote:

> Wray,
> I agree with you. It's just that I've read so many posts where "el"  
> trashes people for asking perfectly good questions or, worse yet,  
> making suggestions that I feel like he really is just being an  
> asshole. Let's call a spade a spade. Ideas are a vital part of  
> discussion groups like this one. From reading this list, I'm not  
> the first one to complain about him, but I will try to refrain from  
> sinking to his level again. Thanks for keeping us on topic.
>
> -Chris
> ----- Original Message -----
> From: "Wray Cason" <wr...@au...>
> To: sql...@li...
> Sent: Saturday, March 3, 2007 2:15:43 PM (GMT-0800) America/ 
> Los_Angeles
> Subject: Re: [SL] Output reports to csv
>
> For what it is worth, I find this mailing list useful when it contains
> technical discussion of SQL ledger.  I don't find it useful when it
> contains flaming and sniping.
>
>> I didn't ask you to advise anyone, I asked you not to try and be one.
>>
>> el
>>
>> on 3/3/07 12:46 AM Christopher A. Bailey said the following:
>>> I wouldn't advise anyone on this list to try to be an idiot. The  
>>> good
>>> doctor has already filled that position.
>>>
>>> -Chris
>>>
>>> ----- Original Message -----
>>> From: "Dr Eberhard Lisse" <el...@li...>
>>> To: da...@ke...
>>> Cc: sql...@li...
>>> Sent: Friday, March 2, 2007 7:45:08 AM (GMT-0800) America/ 
>>> Los_Angeles
>>> Subject: Re: [SL] Output reports to csv
>>>
>>> Please don't try to be an idiot.
>>>
>>> el
>>>
>>> on 3/2/07 12:40 PM david said the following:
>>>> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>>>>> It is almost trivial, to put this statement of mine into a perl
>>>>> script,
>>>>> and using the appropriate CPAN module, to generate Excell or
>>>>> OpenOffice
>>>>> spreadsheets.
>>>>>
>>>>
>>>> It's NOT trivial. I'm sure I could manage it, and I'm sure you,  
>>>> being
>>>> the ultimate renaissance man, could manage it too.. but I have  
>>>> to say
>>>> that CSV export is a very sensible addition to the wish list.
>>>>
>>>> By your reasoning, there shouldn't be an invoice function in SL  
>>>> because
>>>> anyone could do their own. Please try not to be a pompous ass.
>>>
>>> -------------------------------------------------------------------- 
>>> -----
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>>> share
>>> your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php? 
>>> page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>> -------------------------------------------------------------------- 
>>> -----
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>>> share
>>> your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php? 
>>> page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>> --
>> Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
>> el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
>> PO Box 8421             \     /   Please do NOT email to this address
>> Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way
>>
>> --------------------------------------------------------------------- 
>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share
>> your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>
>
> Wray Cason "Wrayman"
> Auxilium Computing
> www.auxiliumcomputing.com
> wr...@au...
> main: 206-595-2080
> fax:  425-895-9825
> msn: wr...@pi...
> aim: AuxiliumWrayman
> yahoo: wraycason
> skype: wrayman
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] CSV Export / Payroll Module interest?

[Les R <ope...@gm...>]

Hi All,

Ok, I'll write a script for this. What was the original outline for the
SQL?


Is there any interest in a payroll module? I've been maintaining a payroll
system for a regional college here is Sask for the last 20 years or so and
have had an "intimate relationship" with the CCRA deduction formulae for a
long time... (grin)


Les Richardson
Open Admin for Schools

[SL] Off-Topic: Online stores

[Matt J. <sir...@gm...>]

Since I assume at least a few of you are online business owners, I am
curious to know what your "solutions" have been for the following:

- Search engine optimization
- Marketing help
- Knowing at what point in the process of a sale you are losing customers
- Site hosting and building (are you doing DIY and open source, or
using a hosted, optimized, pro service, etc.?)

I ask because I am currently using Joomla! with a VirtueMart shopping
cart for my store, but I am considering switching to the (expensive)
Fortune3 platform, just on the fact that I have seen direct evidence
that they are what they say they are, the real deal.

Any experience for me?

Best,
Matt J.

Re: [SL] Output reports to csv

[<ma...@hu...>]

> It is almost trivial, to put this statement of mine into a perl script,
> and using the appropriate CPAN module, to generate Excell or OpenOffice
> spreadsheets.
>

Nice.

m

Re: [SL] Output reports to csv

[Christopher A. B. <cb...@ge...>]

Wray,
I agree with you. It's just that I've read so many posts where "el" trashes people for asking perfectly good questions or, worse yet, making suggestions that I feel like he really is just being an asshole. Let's call a spade a spade. Ideas are a vital part of discussion groups like this one. From reading this list, I'm not the first one to complain about him, but I will try to refrain from sinking to his level again. Thanks for keeping us on topic.

-Chris
----- Original Message -----
From: "Wray Cason" <wr...@au...>
To: sql...@li...
Sent: Saturday, March 3, 2007 2:15:43 PM (GMT-0800) America/Los_Angeles
Subject: Re: [SL] Output reports to csv

For what it is worth, I find this mailing list useful when it contains
technical discussion of SQL ledger.  I don't find it useful when it
contains flaming and sniping.

> I didn't ask you to advise anyone, I asked you not to try and be one.
>
> el
>
> on 3/3/07 12:46 AM Christopher A. Bailey said the following:
>> I wouldn't advise anyone on this list to try to be an idiot. The good
>> doctor has already filled that position.
>>
>> -Chris
>>
>> ----- Original Message -----
>> From: "Dr Eberhard Lisse" <el...@li...>
>> To: da...@ke...
>> Cc: sql...@li...
>> Sent: Friday, March 2, 2007 7:45:08 AM (GMT-0800) America/Los_Angeles
>> Subject: Re: [SL] Output reports to csv
>>
>> Please don't try to be an idiot.
>>
>> el
>>
>> on 3/2/07 12:40 PM david said the following:
>>> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>>>> It is almost trivial, to put this statement of mine into a perl
>>>> script,
>>>> and using the appropriate CPAN module, to generate Excell or
>>>> OpenOffice
>>>> spreadsheets.
>>>>
>>>
>>> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
>>> the ultimate renaissance man, could manage it too.. but I have to say
>>> that CSV export is a very sensible addition to the wish list.
>>>
>>> By your reasoning, there shouldn't be an invoice function in SL because
>>> anyone could do their own. Please try not to be a pompous ass.
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> --
> Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
> el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
> PO Box 8421             \     /   Please do NOT email to this address
> Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>


Wray Cason "Wrayman"
Auxilium Computing
www.auxiliumcomputing.com
wr...@au...
main: 206-595-2080
fax:  425-895-9825
msn: wr...@pi...
aim: AuxiliumWrayman
yahoo: wraycason
skype: wrayman

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users