GM data exporting

[alexgleason]

Allow Garden Managers to easily export data stored to their garden in a .csv file. Relevant data includes:

• Garden roster
• Gleaning stats and order records
• Garden plot stats
• Reported volunteer hours

Estimated time: 1.5hrs

[alexgleason]

I hoped to do this simple one first, but it seems to rely on #163 with "Reported volunteer hours" being saved.

@marykatefain in the meantime, can you elaborate on what each of these 4 data points actually are? For example, I don't know what "garden roster" means, and "garden plot stats" is too vague.

[marykatefain]

Garden roster The list of people affiliated with a garden and their roles. For example:

First Name       Last Name     Role                            Plot #             Email            Phone
Jen                   Gold               Garden Manager         10                jgold@...        123-890-9876
Sam                 Harris              Gardener                     17               sharris@...     123-890-9879

Gleaning stats and order records Gleaning stats are the crop weights that pickers report at the end of their trip to each garden. For example:

Date               Crop           Weight         Picker
6/17/18          Lettuce        6 lbs            Joe Smith
6/17/18          Tomato        10 lbs          Joe Smith
6/17/18          Cucumber    5 lbs           Joe Smith
6/19/18          Basil            .5 lbs           Sally Doe

Order Records are the records of each "order" that is placed:

Gardener          Order Type     Start Date        End Date         Crops                        Notes           Status
Jane Smith       Pick                 6/1/18              6/7/18              Lettuce, Tomato...     --                 Closed
Kim Kardian     Pick                 10/16/18          10/24/18          All                              blabla....      Open

You would also want to be able to export pick data relevant to each order, which should be able to be cross-referenced by ID numbers

Order ID          Pick ID          Crops Picked            Picker           Notes
1234                8765             Lettuce, Tomato...    Joe Smith      There was no basil ready

Garden plot stats Basic garden info. How many plots you have, how many users you have, total weight reported per season so far and in garden history, number of open plots, etc

Reported volunteer hours

Name                   Date              Hours Reported           Task
Jane Goody         10/14/18        2                                   Weed the common beds
Sam Smith           10/15/18       1.5                                 Build a birdhouse

[marykatefain]

Wow sorry, those tables aligned when I wrote them....... You get the gist

[marykatefain]

Also obviously those tables are not comprehensive - just to give you an idea. ID#s for example would be necessary for each data instance