[PLUG] Membership tracking software?
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?
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?
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?
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?
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?
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?
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