sql-ledger-users

[SL] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

Hello, this has probably come up before but I can't find the answer I'm 
looking for.
I have a mixed OS environment consisting of the following computers
(Linux server - Kubuntu server edition  - household lan )
Mac G3 - 10.3.9
Windows XP Home
Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this 
will be the GPS and POS machine
and finally another linux server that my websites are hosted on in 
another city where I do NOT have root access nor postgresql capability.

My thoughts are this.
I would like to be able to have a central place where my accounting 
takes place that is accessible from any of the other machines.
I'm thinking the laptop would be a good candidate for this as it will 
need to be used when we go to craft shows and such to sell our 
products.  I doubt we will have wireless capability because most are in 
farm country.
I need it to store the credit card processing information and sale 
history, print a receipt/invoice for the customer.
I use joomla as my CMS and Virtuemart as my ecommerce software. 
My ideal scenario is that sql-ledger would be able to import via csv or 
some other method my days activities ( virtuemart uses mysql ) and 
updates its accounting accordingly.  Lacking that we don't do so much 
business via the net that we couldn't enter them by hand for now.
but when we come home from shows, we need to be able to synchronize the 
data thats on the laptop with the server. ( if its not the main machine 
already ).  Similarly when we are in the office at home I want to be 
able to access the sql-ledger program from any of the desktop machines 
or laptop be it xp or mac or even the linux clients.

I don't know the best way to install/build sql-ledger to fit my needs, 
or if it really will.  I'm not very good at accounting and really am 
tired of looking.  I would really appreciate any and all help.
Thanks
Troy

Re: [SL] newbie question regarding laptop POS

[david <da...@ke...>]

On Wed, 2007-03-14 at 23:47 -0500, Hall Family wrote:
> Hello, this has probably come up before but I can't find the answer I'm 
> looking for.
> I have a mixed OS environment consisting of the following computers
> (Linux server - Kubuntu server edition  - household lan )
> Mac G3 - 10.3.9
> Windows XP Home
> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this 
> will be the GPS and POS machine
> and finally another linux server that my websites are hosted on in 
> another city where I do NOT have root access nor postgresql capability.
> 

First: All you have to worry about is your server.. .any machine can act
as client. I have a similar mixed bag.

If your server doesn't need to be online 24/7, the lapdog will do fine. 

As far as importing data, you need info from someone else.. I've never
needed to do it ;-)  It seems to me that the laptop being POS and server
makes things relatively easy. Then when you plug your laptop into your
lan you have access to everything you need.

I'm assuming that your joomla/ecommerce is off line when you are at
shows anyway, and that it's all installed on the laptop?? Or did i miss
something?

> My thoughts are this.
> I would like to be able to have a central place where my accounting 
> takes place that is accessible from any of the other machines.
> I'm thinking the laptop would be a good candidate for this as it will 
> need to be used when we go to craft shows and such to sell our 
> products.  I doubt we will have wireless capability because most are in 
> farm country.
> I need it to store the credit card processing information and sale 
> history, print a receipt/invoice for the customer.
> I use joomla as my CMS and Virtuemart as my ecommerce software. 
> My ideal scenario is that sql-ledger would be able to import via csv or 
> some other method my days activities ( virtuemart uses mysql ) and 
> updates its accounting accordingly.  Lacking that we don't do so much 
> business via the net that we couldn't enter them by hand for now.
> but when we come home from shows, we need to be able to synchronize the 
> data thats on the laptop with the server. ( if its not the main machine 
> already ).  Similarly when we are in the office at home I want to be 
> able to access the sql-ledger program from any of the desktop machines 
> or laptop be it xp or mac or even the linux clients.
> 
> I don't know the best way to install/build sql-ledger to fit my needs, 
> or if it really will.  I'm not very good at accounting and really am 
> tired of looking.  I would really appreciate any and all help.
> Thanks
> Troy
> 
> 
> 
> -------------------------------------------------------------------------
> 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] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

Thanks for responding David,

> First: All you have to worry about is your server.. .any machine can act
> as client. I have a similar mixed bag.
>
> If your server doesn't need to be online 24/7, the lapdog will do fine. 
>
> As far as importing data, you need info from someone else.. I've never
> needed to do it ;-)  It seems to me that the laptop being POS and server
> makes things relatively easy. Then when you plug your laptop into your
> lan you have access to everything you need.
>
> I'm assuming that your joomla/ecommerce is off line when you are at
> shows anyway, and that it's all installed on the laptop?? Or did i miss
> something?
>
>   

No, thats incorrect.  My websites are all run offsite in Cedar Falls at 
a Major Data Center.  The laptops only original purporse was GPS 
navigation and email while traveling.
It has since come up that it would be great to use it also as a POS 
system while at the shows.  Thats why I was thinking of having some part 
of SQL-Ledger on the laptop.  I can see your point about having it be 
the server completely.
Do you know if "Damn Small Linux" will handle sql-ledger?  I ask because 
the drive space on the laptop is very limited.
Its a lowly ADM-K6 381mhz system with 192mb of ram. and a 4G HD.  It 
Does have a dvd drive so I could I believe run a "live" variant of linux 
and store the data ONLY on the hd.  Another alternative I suppose would 
be to purchase a USB drive for it but I think that would be fairly 
expensive.
I don't know what the bare minimum I would need to make it function as a 
nix server and still retain at least windows 98 on it for the GPS.

Thanks
Troy
>   

Re: [SL] newbie question regarding laptop POS

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

PARTIALLY OFF TOPIC

Hey man!

No comfort here, except to say that you have asked what I've been putting
off wondering, since I run Joomla! with VirtueMart as well for my site-based
sales.

I have actually been looking around for alternatives, because I am tired of
fooling with odd SEO, flaky checkout and such on VirtueMart, wondering if
there is a simpler, clearer alternative out there.

For example, I have been very interested in Volusion, especially if it can
offer me just turnkey, guaranteed rock-solid checkout (that doesn't fail or
give errors at random times to my customers) and guaranteed best-in-class
SEO and marketing help. Sucks that it isn't FREE FREE FREE, but hey, I am
learning you can't trip over a dollar to save a dime.

I am tired of fooling around...I have lost so many sales due to flaky, too
long, error-prone checkout. SEO has actually not been too too terrible, but
it is still inconsistent and gives me the "grass is greener on the other
side of the fence" feeling that there is something that is a better VALUE
out there, see?

Anyhow, back on track, I would be very interested in what you are interested
in. Even a pan-solution solution, a generic import that could be reworked
from csv exports and such, would be sweet. I tried the generic SQL-Ledger
import thing and it didn't work for me. Kept failing out.

I wonder if we could pool some monetary resources and get this added to the
project on a faster-track basis.

Anyhow, just putting my vote in and saying HI to a fellow Joomla/VirtueMart
user!

Best,
Matt




On 3/15/07, Hall Family <hei...@io...> wrote:
>
> Hello, this has probably come up before but I can't find the answer I'm
> looking for.
> I have a mixed OS environment consisting of the following computers
> (Linux server - Kubuntu server edition  - household lan )
> Mac G3 - 10.3.9
> Windows XP Home
> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this
> will be the GPS and POS machine
> and finally another linux server that my websites are hosted on in
> another city where I do NOT have root access nor postgresql capability.
>
> My thoughts are this.
> I would like to be able to have a central place where my accounting
> takes place that is accessible from any of the other machines.
> I'm thinking the laptop would be a good candidate for this as it will
> need to be used when we go to craft shows and such to sell our
> products.  I doubt we will have wireless capability because most are in
> farm country.
> I need it to store the credit card processing information and sale
> history, print a receipt/invoice for the customer.
> I use joomla as my CMS and Virtuemart as my ecommerce software.
> My ideal scenario is that sql-ledger would be able to import via csv or
> some other method my days activities ( virtuemart uses mysql ) and
> updates its accounting accordingly.  Lacking that we don't do so much
> business via the net that we couldn't enter them by hand for now.
> but when we come home from shows, we need to be able to synchronize the
> data thats on the laptop with the server. ( if its not the main machine
> already ).  Similarly when we are in the office at home I want to be
> able to access the sql-ledger program from any of the desktop machines
> or laptop be it xp or mac or even the linux clients.
>
> I don't know the best way to install/build sql-ledger to fit my needs,
> or if it really will.  I'm not very good at accounting and really am
> tired of looking.  I would really appreciate any and all help.
> Thanks
> Troy
>
>
>
> -------------------------------------------------------------------------
> 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
>



-- 
Regards,
Matt

Re: [SL] newbie question regarding laptop POS

[Luc v. S. <lu...@co...>]

There is a solution upcoming here in the Netherlands where there will be 
a syncronisation script between joomla/virtuemart and sql-ledger as well 
as sugar-crm.
In a bout a month time they will show me a demo.
I am not sure if this company will keep this code opensource. However 
they said they intended to.

If things look promising I will reply again

Luc



Matt Jackson wrote:
> PARTIALLY OFF TOPIC
>
> Hey man!
>
> No comfort here, except to say that you have asked what I've been putting
> off wondering, since I run Joomla! with VirtueMart as well for my site-based
> sales.
>
> I have actually been looking around for alternatives, because I am tired of
> fooling with odd SEO, flaky checkout and such on VirtueMart, wondering if
> there is a simpler, clearer alternative out there.
>
> For example, I have been very interested in Volusion, especially if it can
> offer me just turnkey, guaranteed rock-solid checkout (that doesn't fail or
> give errors at random times to my customers) and guaranteed best-in-class
> SEO and marketing help. Sucks that it isn't FREE FREE FREE, but hey, I am
> learning you can't trip over a dollar to save a dime.
>
> I am tired of fooling around...I have lost so many sales due to flaky, too
> long, error-prone checkout. SEO has actually not been too too terrible, but
> it is still inconsistent and gives me the "grass is greener on the other
> side of the fence" feeling that there is something that is a better VALUE
> out there, see?
>
> Anyhow, back on track, I would be very interested in what you are interested
> in. Even a pan-solution solution, a generic import that could be reworked
> from csv exports and such, would be sweet. I tried the generic SQL-Ledger
> import thing and it didn't work for me. Kept failing out.
>
> I wonder if we could pool some monetary resources and get this added to the
> project on a faster-track basis.
>
> Anyhow, just putting my vote in and saying HI to a fellow Joomla/VirtueMart
> user!
>
> Best,
> Matt
>
>
>
>
> On 3/15/07, Hall Family <hei...@io...> wrote:
>   
>> Hello, this has probably come up before but I can't find the answer I'm
>> looking for.
>> I have a mixed OS environment consisting of the following computers
>> (Linux server - Kubuntu server edition  - household lan )
>> Mac G3 - 10.3.9
>> Windows XP Home
>> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this
>> will be the GPS and POS machine
>> and finally another linux server that my websites are hosted on in
>> another city where I do NOT have root access nor postgresql capability.
>>
>> My thoughts are this.
>> I would like to be able to have a central place where my accounting
>> takes place that is accessible from any of the other machines.
>> I'm thinking the laptop would be a good candidate for this as it will
>> need to be used when we go to craft shows and such to sell our
>> products.  I doubt we will have wireless capability because most are in
>> farm country.
>> I need it to store the credit card processing information and sale
>> history, print a receipt/invoice for the customer.
>> I use joomla as my CMS and Virtuemart as my ecommerce software.
>> My ideal scenario is that sql-ledger would be able to import via csv or
>> some other method my days activities ( virtuemart uses mysql ) and
>> updates its accounting accordingly.  Lacking that we don't do so much
>> business via the net that we couldn't enter them by hand for now.
>> but when we come home from shows, we need to be able to synchronize the
>> data thats on the laptop with the server. ( if its not the main machine
>> already ).  Similarly when we are in the office at home I want to be
>> able to access the sql-ledger program from any of the desktop machines
>> or laptop be it xp or mac or even the linux clients.
>>
>> I don't know the best way to install/build sql-ledger to fit my needs,
>> or if it really will.  I'm not very good at accounting and really am
>> tired of looking.  I would really appreciate any and all help.
>> Thanks
>> Troy
>>
>>
>>
>> -------------------------------------------------------------------------
>> 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] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

oh that would be soooo nice.  There is a guy who wrote an inventory 
program that unfortunately is on his site only, but it allows us to do 
all kinds of inventory stuff ( peninventory.com) and he's going to be 
working on a vm integration module for it.
So with that and sql-ledger and this syncro we'd be in great shape here 
as long as the stuff from the netherlands knows how to handle US style 
taxation properly.
Troy


Luc van Stappershoef wrote:
> There is a solution upcoming here in the Netherlands where there will be 
> a syncronisation script between joomla/virtuemart and sql-ledger as well 
> as sugar-crm.
> In a bout a month time they will show me a demo.
> I am not sure if this company will keep this code opensource. However 
> they said they intended to.
>
> If things look promising I will reply again
>
> Luc
>
>
>
> Matt Jackson wrote:
>   
>
> -------------------------------------------------------------------------
> 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] newbie question regarding laptop POS

[Hall F. <hei...@io...>]

Thanks Mat.  I know an excellent perl programmer and a sql programmer so 
perhaps your right.
Thanks for the encouragement.
Troy

Matt Jackson wrote:
> PARTIALLY OFF TOPIC
>
> Hey man!
>
> No comfort here, except to say that you have asked what I've been putting
> off wondering, since I run Joomla! with VirtueMart as well for my site-based
> sales.
>
> I have actually been looking around for alternatives, because I am tired of
> fooling with odd SEO, flaky checkout and such on VirtueMart, wondering if
> there is a simpler, clearer alternative out there.
>
> For example, I have been very interested in Volusion, especially if it can
> offer me just turnkey, guaranteed rock-solid checkout (that doesn't fail or
> give errors at random times to my customers) and guaranteed best-in-class
> SEO and marketing help. Sucks that it isn't FREE FREE FREE, but hey, I am
> learning you can't trip over a dollar to save a dime.
>
> I am tired of fooling around...I have lost so many sales due to flaky, too
> long, error-prone checkout. SEO has actually not been too too terrible, but
> it is still inconsistent and gives me the "grass is greener on the other
> side of the fence" feeling that there is something that is a better VALUE
> out there, see?
>
> Anyhow, back on track, I would be very interested in what you are interested
> in. Even a pan-solution solution, a generic import that could be reworked
> from csv exports and such, would be sweet. I tried the generic SQL-Ledger
> import thing and it didn't work for me. Kept failing out.
>
> I wonder if we could pool some monetary resources and get this added to the
> project on a faster-track basis.
>
> Anyhow, just putting my vote in and saying HI to a fellow Joomla/VirtueMart
> user!
>
> Best,
> Matt
>
>
>
>
> On 3/15/07, Hall Family <hei...@io...> wrote:
>   
>> Hello, this has probably come up before but I can't find the answer I'm
>> looking for.
>> I have a mixed OS environment consisting of the following computers
>> (Linux server - Kubuntu server edition  - household lan )
>> Mac G3 - 10.3.9
>> Windows XP Home
>> Compaq Presario 1685 Laptop ( non-wireless but does have ethernet ) this
>> will be the GPS and POS machine
>> and finally another linux server that my websites are hosted on in
>> another city where I do NOT have root access nor postgresql capability.
>>
>> My thoughts are this.
>> I would like to be able to have a central place where my accounting
>> takes place that is accessible from any of the other machines.
>> I'm thinking the laptop would be a good candidate for this as it will
>> need to be used when we go to craft shows and such to sell our
>> products.  I doubt we will have wireless capability because most are in
>> farm country.
>> I need it to store the credit card processing information and sale
>> history, print a receipt/invoice for the customer.
>> I use joomla as my CMS and Virtuemart as my ecommerce software.
>> My ideal scenario is that sql-ledger would be able to import via csv or
>> some other method my days activities ( virtuemart uses mysql ) and
>> updates its accounting accordingly.  Lacking that we don't do so much
>> business via the net that we couldn't enter them by hand for now.
>> but when we come home from shows, we need to be able to synchronize the
>> data thats on the laptop with the server. ( if its not the main machine
>> already ).  Similarly when we are in the office at home I want to be
>> able to access the sql-ledger program from any of the desktop machines
>> or laptop be it xp or mac or even the linux clients.
>>
>> I don't know the best way to install/build sql-ledger to fit my needs,
>> or if it really will.  I'm not very good at accounting and really am
>> tired of looking.  I would really appreciate any and all help.
>> Thanks
>> Troy
>>
>>
>>
>> -------------------------------------------------------------------------
>> 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] newbie question regarding laptop POS

[Kirti <ki...@UN...>]

<There is a solution upcoming here in the Netherlands where there will be 
<a syncronisation script between joomla/virtuemart and sql-ledger as well 
<as sugar-crm.
<In a bout a month time they will show me a demo.
<I am not sure if this company will keep this code opensource. However 
<they said they intended to.

<If things look promising I will reply again

<Luc

This would be very welcome. For some time I have been searching for a Postgresql backend for Virtuemart instead of the MySQL one that comes with the package. Any solutions anyone?
At least it would be easier to synchronize VMart and SL that way.

The advantage with Joomla/VMart is that it has a very Customer Friendly Web Frontend with Product and Price display etc. I find the Product Group and Subgroup and CSV-upload features very handy . However this app lacks the transaction solidity that SL provides.

However if SL could incorporate features similar to Joomla, this might be best - that way DB integrity would be assured.

Ken