Hi Mary Beth
We use FileMaker. It isn't terribly expensive and you can often buy a
license that is a version or two old at a greatly discounted price. A
version 9 or 10 would work nearly as well as the current Version 11.
Furthermore, I would be happy to send you a blank copy of the file we
deployed, if it is an approximate fit to your garden organization, or if it
can be easily modified to fit your program. Access could be used for a
similar result but I'm terribly fond of FileMaker. Apparently Microsoft came
out with a new, free database product this year but I haven't seen it yet.
I am not sure if this will make sense to you, but we use the following
tables. It will make sense to someone who develops databases. Each table is
equivalent to one spreadsheet in Excel. You may not need some of these
tables, as it reflects our style of organization using teams to raise
specific crop varieties.
HOUSEHOLDS - this unit pays dues each year, includes household name,
address, phones
MEMBERS - the individual people who belong to the households, includes
individual names, emails.
DUES - records of annual payments, e.g. amount paid, date, balance due,
check no, deposit date, etc.
TEAMS - this unit works specific crops, includes a team number "4", name
"Tomatoes", and year "2011"
TEAM ASSIGNMENTS - this links 5 to 8 members to one team
ROWS - the specific, fixed plots in our garden, which we call rows
CROPS - the crops we raise, includes crop name, variety, and seed source
TEAM-ROW-CROP - connects one team to two to four rows and one to six crops
in a given season
EMAILS - this is a log of all emails sent, some of which we reuse in later
years
Our database cuts administration time at least in half. It makes for rapid
communication, a quick deposit sheet, and an accumulation of valuable data
we use to communicate our project to others each year.
Best wishes for a successful data management effort!
Jama Crawford
Shared Harvest Community Garden
Durango CO
----- Original Message -----
From: "Mary Beth Pudup" <pu...@ucsc.edu>
To: <community_garden@list.communitygarden.org>
Sent: Tuesday, November 29, 2011 10:06 PM
Subject: [Community_garden] garden membership software
Hi-- I am wondering if anyone has experience/can recommend a software
program useful for managing membership in a community garden (other than
excel, that is).
Thank you.
Mary Beth Pudup
SF, CA
--
Mary Beth Pudup, Associate Professor
Department of Community Studies
210 Oakes College
University of California, Santa Cruz
Santa Cruz, CA 95064
831 459 2003 (office)
831 459 4979 (fax)
_______________________________________________
The American Community Gardening Association listserve is only one of
ACGA's services to community gardeners. To learn more about the ACGA and
to find out how to join, please go to http://www.communitygarden.org
To post an e-mail to the list: community_garden@list.communitygarden.org
To subscribe, unsubscribe or change your subscription:
http://list.communitygarden.org/mailman/listinfo/community_garden_list.communitygarden.org
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 6672 (20111130) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
_______________________________________________
The American Community Gardening Association listserve is only one of ACGA's
services to community gardeners. To learn more about the ACGA and to find out
how to join, please go to http://www.communitygarden.org
To post an e-mail to the list: community_garden@list.communitygarden.org
To subscribe, unsubscribe or change your subscription:
http://list.communitygarden.org/mailman/listinfo/community_garden_list.communitygarden.org
