[PLUG] Membership tracking software?

2015-01-14 Thread Roderick Anderson
Recommendations?

I just took on the Treasurer position for a local non-profit which 
includes tracking membership and dues.

Currently the club (Kootenai Amateur Radio Society) is using Quick Books 
for accounting and Excel spreadsheets for membership rosters.  So here I 
am trying to get a Windows system up for QB and using a spreadsheet for 
something better done with a data base.

Did some research (Google searches) but probably picked poor search 
terms.  Didn't get good results.
I seem to remember some mention on the list of others working with 
membership handling.  Therefore the request for recommendations.

Dream solution:

First: it is FOSS.

Second: runs on Linux or Windows.

Third: not web based right now as I don't know the full story on the 
clubs hosting situation but could put up my own server if that is the 
better solution.

Forth: If it is OSS, coded in Perl or ... PHP so I can feel fairly 
comfortable if hacking is needed.  C, Fortran, Basic and Python can be 
dealt with.

As usual all thoughts, ideas, or clue-sticks are appreciated.


\\||/
Rod
-- 
___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug


Re: [PLUG] Membership tracking software?

2015-01-14 Thread Roderick Anderson
On 01/14/2015 09:10 AM, Nat Taylor wrote:
 I've used Civicrm it's robust and needs hosting.  I found this online never
 used but seems like what u want?  If not try CRM in your searches, or I
 used linux donation tracking to find this:
 http://linux.softpedia.com/get/Office/Finance/Grace-Donation-Manager-11849.shtml

Thanks Nat.  Looks like far more than is needed but I will try CRM in 
the searches and look at Civicrm.


Rod
-- 

 On Wednesday, January 14, 2015, Roderick Anderson raander...@gmail.com
 wrote:

 Recommendations?

 I just took on the Treasurer position for a local non-profit which
 includes tracking membership and dues.

 Currently the club (Kootenai Amateur Radio Society) is using Quick Books
 for accounting and Excel spreadsheets for membership rosters.  So here I
 am trying to get a Windows system up for QB and using a spreadsheet for
 something better done with a data base.

 Did some research (Google searches) but probably picked poor search
 terms.  Didn't get good results.
  I seem to remember some mention on the list of others working with
 membership handling.  Therefore the request for recommendations.

 Dream solution:

  First: it is FOSS.

  Second: runs on Linux or Windows.

  Third: not web based right now as I don't know the full story on the
 clubs hosting situation but could put up my own server if that is the
 better solution.

  Forth: If it is OSS, coded in Perl or ... PHP so I can feel fairly
 comfortable if hacking is needed.  C, Fortran, Basic and Python can be
 dealt with.

 As usual all thoughts, ideas, or clue-sticks are appreciated.


 \\||/
 Rod
 --
 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org javascript:;
 http://lists.pdxlinux.org/mailman/listinfo/plug

 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org
 http://lists.pdxlinux.org/mailman/listinfo/plug

___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug


Re: [PLUG] Membership tracking software?

2015-01-14 Thread Roderick Anderson
Thanks Rich.

On 01/14/2015 09:12 AM, Rich Shepard wrote:
 On Wed, 14 Jan 2015, Roderick Anderson wrote:

 Recommendations?

 Rod,

 Yeah. LibreOffice's Base. At least for membership tracking. Possibly for
 the money side if that's simple enough.

 Or, for the money part I'd look closely at jGnash
 http://www.sourceforge.net/projects/jgnash/. Written in java (not my
 favorite language) so it runs on everything. I use it for personal finance,
 but the mail list indicates that some use it for small business accounting,
 too. Might work for you.

This might be the solution for the accounting. The position is only for 
two years and despite all the work that local LUG does to convert the 
HAMS being able to go Windows would be ideal.


 If that's not sufficient, take a look at Ledger123
 http://www.ledger123.com/; that's what I've been using for business for 15
 years now. Uses a browser as the UI, but you can set up the postgres back
 end on the OS of your choice, and the middleware code is written in perl.

Yeah, Ledger123, LedgerSMB and SQL-ledger.  A bit too much for KARS.


Again thanks,
Rod
-- 

 HTH,

 Rich


 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org
 http://lists.pdxlinux.org/mailman/listinfo/plug

___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug


Re: [PLUG] Membership tracking software?

2015-01-14 Thread Rich Shepard
On Wed, 14 Jan 2015, Roderick Anderson wrote:

 Recommendations?

Rod,

   Yeah. LibreOffice's Base. At least for membership tracking. Possibly for
the money side if that's simple enough.

Or, for the money part I'd look closely at jGnash
http://www.sourceforge.net/projects/jgnash/. Written in java (not my
favorite language) so it runs on everything. I use it for personal finance,
but the mail list indicates that some use it for small business accounting,
too. Might work for you.

If that's not sufficient, take a look at Ledger123
http://www.ledger123.com/; that's what I've been using for business for 15
years now. Uses a browser as the UI, but you can set up the postgres back
end on the OS of your choice, and the middleware code is written in perl.

HTH,

Rich


___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug


Re: [PLUG] Membership tracking software?

2015-01-14 Thread Nat Taylor
I've used Civicrm it's robust and needs hosting.  I found this online never
used but seems like what u want?  If not try CRM in your searches, or I
used linux donation tracking to find this:
http://linux.softpedia.com/get/Office/Finance/Grace-Donation-Manager-11849.shtml

On Wednesday, January 14, 2015, Roderick Anderson raander...@gmail.com
wrote:

 Recommendations?

 I just took on the Treasurer position for a local non-profit which
 includes tracking membership and dues.

 Currently the club (Kootenai Amateur Radio Society) is using Quick Books
 for accounting and Excel spreadsheets for membership rosters.  So here I
 am trying to get a Windows system up for QB and using a spreadsheet for
 something better done with a data base.

 Did some research (Google searches) but probably picked poor search
 terms.  Didn't get good results.
 I seem to remember some mention on the list of others working with
 membership handling.  Therefore the request for recommendations.

 Dream solution:

 First: it is FOSS.

 Second: runs on Linux or Windows.

 Third: not web based right now as I don't know the full story on the
 clubs hosting situation but could put up my own server if that is the
 better solution.

 Forth: If it is OSS, coded in Perl or ... PHP so I can feel fairly
 comfortable if hacking is needed.  C, Fortran, Basic and Python can be
 dealt with.

 As usual all thoughts, ideas, or clue-sticks are appreciated.


 \\||/
 Rod
 --
 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org javascript:;
 http://lists.pdxlinux.org/mailman/listinfo/plug

___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug


Re: [PLUG] Membership tracking software?

2015-01-14 Thread Larry Brigman
I know you want to move stuff to FOSS but here is some info to help
convince others.

Be aware that QB can become ransomware.  A friend that does Taxes and
bookkeeping ran into this.  Something about 15K limit on one records like
invoices.  Once you hit the limit you cannot get into the data without
upgrading to QB pro.

On Wed, Jan 14, 2015 at 8:40 AM, Roderick Anderson raander...@gmail.com
wrote:

 Recommendations?

 I just took on the Treasurer position for a local non-profit which
 includes tracking membership and dues.

 Currently the club (Kootenai Amateur Radio Society) is using Quick Books
 for accounting and Excel spreadsheets for membership rosters.  So here I
 am trying to get a Windows system up for QB and using a spreadsheet for
 something better done with a data base.

 Did some research (Google searches) but probably picked poor search
 terms.  Didn't get good results.
 I seem to remember some mention on the list of others working with
 membership handling.  Therefore the request for recommendations.

 Dream solution:

 First: it is FOSS.

 Second: runs on Linux or Windows.

 Third: not web based right now as I don't know the full story on the
 clubs hosting situation but could put up my own server if that is the
 better solution.

 Forth: If it is OSS, coded in Perl or ... PHP so I can feel fairly
 comfortable if hacking is needed.  C, Fortran, Basic and Python can be
 dealt with.

 As usual all thoughts, ideas, or clue-sticks are appreciated.


 \\||/
 Rod
 --
 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org
 http://lists.pdxlinux.org/mailman/listinfo/plug

___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug


Re: [PLUG] Membership tracking software?

2015-01-14 Thread Roderick Anderson
Thanks Larry,

On 01/14/2015 09:28 AM, Larry Brigman wrote:
 I know you want to move stuff to FOSS but here is some info to help
 convince others.

 Be aware that QB can become ransomware.  A friend that does Taxes and
 bookkeeping ran into this.  Something about 15K limit on one records like
 invoices.  Once you hit the limit you cannot get into the data without
 upgrading to QB pro.

I have considered moving to their web based system so in two years all I 
have to do is pass along the user id and password.  Haven't looked into 
costs yet so Rich's suggestion of jgnash may be the way.


Rod
-- 


 On Wed, Jan 14, 2015 at 8:40 AM, Roderick Anderson raander...@gmail.com
 wrote:

 Recommendations?

 I just took on the Treasurer position for a local non-profit which
 includes tracking membership and dues.

 Currently the club (Kootenai Amateur Radio Society) is using Quick Books
 for accounting and Excel spreadsheets for membership rosters.  So here I
 am trying to get a Windows system up for QB and using a spreadsheet for
 something better done with a data base.

 Did some research (Google searches) but probably picked poor search
 terms.  Didn't get good results.
  I seem to remember some mention on the list of others working with
 membership handling.  Therefore the request for recommendations.

 Dream solution:

  First: it is FOSS.

  Second: runs on Linux or Windows.

  Third: not web based right now as I don't know the full story on the
 clubs hosting situation but could put up my own server if that is the
 better solution.

  Forth: If it is OSS, coded in Perl or ... PHP so I can feel fairly
 comfortable if hacking is needed.  C, Fortran, Basic and Python can be
 dealt with.

 As usual all thoughts, ideas, or clue-sticks are appreciated.


 \\||/
 Rod
 --
 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org
 http://lists.pdxlinux.org/mailman/listinfo/plug

 ___
 PLUG mailing list
 PLUG@lists.pdxlinux.org
 http://lists.pdxlinux.org/mailman/listinfo/plug

___
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug