Site Talk forum: Plant List - Exporting to Excel/More Columns/Sorting by Column

Views: 237, Replies: 12 » Jump to the end
Name: Carol Sandt
Lancaster County, Pennsylvania (Zone 6b)
Peonies Butterflies Region: Mid-Atlantic Hibiscus Daylilies Xeriscape
Hostas Roses Celebrating Gardening: 2015
Image
csandt
Aug 15, 2017 7:29 AM CST
@Dave
Would it be feasible to extend the capabilities of the user's personal plant list to be able to (1) add more user-defined columns and sort by any chosen column and (2) display members of several categories, rather than just one category?

Example of use: I have ordered a lot of daylilies and would like to plan their placement in two new gardens, one for late-blooming and very late-blooming daylilies and one for a combination of dark-colored and yellow or gold daylilies. In my plant list, I have created a category called "Ordered" and am viewing only the genus Hemerocallis within that Category. I would like to create categories for different colors, different bloom times and different garden locations and group the plants I have ordered together according to the criteria for several categories, not just one. Once grouping is done, being able to see scape height and bloom color in user-defined coumns would be helpful within the selection. Then it would be greate to be able to sort by these columns.

Thank you for considering this request.

Carol Sandt
"Hope is the simple trust that God has not forgotten the recipe for manna.” - W. Paul Jones in "Trumpet at Full Moon"
[Last edited by csandt - Aug 15, 2017 2:12 PM (+)]
Give a thumbs up | Quote | Post #1528600 (1)
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level
Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier Million Pollinator Garden Challenge
Image
dave
Aug 15, 2017 8:13 AM CST

Garden.org Admin

User-defined columns in the plant list is something that is possible to be programmed, of course, but it would by no means be an easy undertaking, and my list of priorities is still fairly long. I don't want to set aside important projects in order to add this functionality.

But, exporting to spreadsheet is something that wouldn't take long to do, and with the export you could then bring it into Excel or Google Docs and then manipulate the data however you liked.

I'll get you the export feature this morning, if time allows.
Name: Carol Sandt
Lancaster County, Pennsylvania (Zone 6b)
Peonies Butterflies Region: Mid-Atlantic Hibiscus Daylilies Xeriscape
Hostas Roses Celebrating Gardening: 2015
Image
csandt
Aug 15, 2017 8:39 AM CST
@Dave,
Thank you!
Would adding the ability to select more than one category be feasible?
Carol Sandt
"Hope is the simple trust that God has not forgotten the recipe for manna.” - W. Paul Jones in "Trumpet at Full Moon"
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level
Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier Million Pollinator Garden Challenge
Image
dave
Aug 15, 2017 8:44 AM CST

Garden.org Admin

The ability to select more than one category is already there.

I have added the CSV export option. You'll see it next to the print icon in your list.

Note that the CSV will only export the plants that are visible on the page that you're looking at when you click the icon. So if you have multiple pages, then you'll need to change your site settings to increase the number of items to show per page until you can see them all; then click the CSV icon to download all the items on that page to a spreadsheet that you can then open in Excel.
Name: Carol Sandt
Lancaster County, Pennsylvania (Zone 6b)
Peonies Butterflies Region: Mid-Atlantic Hibiscus Daylilies Xeriscape
Hostas Roses Celebrating Gardening: 2015
Image
csandt
Aug 15, 2017 9:11 AM CST
Thank You!
Carol Sandt
"Hope is the simple trust that God has not forgotten the recipe for manna.” - W. Paul Jones in "Trumpet at Full Moon"
Name: K
Seattle, WA (Zone 7b)
kreemoweet
Aug 15, 2017 1:02 PM CST
I just attempted to use this new (and extremely welcome) "export to CSV" facility on my as yet rudimentary plant list. My observations on the
resulting .csv file:

There seem to be 7 fields in the data, but there is no header line defining them. Only the 3rd and 6th fields were populated with data, and
seem to correspond to the "Status" and "Notes" columns as displayed on the plant list web page.

All fields have those annoying and useless surrounding double quotes, as is typically found with Microsoft applications. I think it were
better to dispense with those unless actually needed per accepted CSV format specifications.

The file used Unix-style line endings (single LF character) at the end of each row. This does not bode well for folks using Windows software
to work with the file, as such apps frequently choke on those. Conversely, I've found that my Linux software has no problem with any of the
various line ending conventions.

On a somewhat unrelated topic: How does one get the entries in the plant list to appear "alphabetically"? Mine appear in time-of-entry
order, and I can not find a way to change that.

Perhaps @Dave will find time to look at these issues? Thanks.
Name: Carol Sandt
Lancaster County, Pennsylvania (Zone 6b)
Peonies Butterflies Region: Mid-Atlantic Hibiscus Daylilies Xeriscape
Hostas Roses Celebrating Gardening: 2015
Image
csandt
Aug 15, 2017 2:21 PM CST
When I did the CSV export and copied the resulting spreadsheet into Numbers on my iPad, the result looks good, ready for adding column headings and additional columns. Here is a screenshot immediately after pasting into Numbers:

Thumb of 2017-08-15/csandt/ce469a

Carol Sandt
"Hope is the simple trust that God has not forgotten the recipe for manna.” - W. Paul Jones in "Trumpet at Full Moon"
Name: Carol Sandt
Lancaster County, Pennsylvania (Zone 6b)
Peonies Butterflies Region: Mid-Atlantic Hibiscus Daylilies Xeriscape
Hostas Roses Celebrating Gardening: 2015
Image
csandt
Aug 15, 2017 2:53 PM CST
dave said:The ability to select more than one category is already there.

.


@Dave, Can you be more specific about how to display items belonging to two or more categories. For example, I would like to display Hemerocallis that belong both to the "Ordered" category and to the "Southwest Rhododendron Garden by Chinese Chestnut Tree." I assigned each plant to two categories, "Ordered" and the garden where it will be planted. At present, if I display "Ordered" Hemerocallis and then "Southwest Rhododendron Garden by Chinese Chestnut Tree", the entire latter category displaces the former category. I do not see a subset of "Ordered" cultivars that are also in the category "Southwest Rhododendron Garden by Chinese Chestnut Tree".

My category "Southwest Rhododendron Garden by Chinese Chestnut Tree" contains (1) plants that are already in that garden and (2) new plants I have ordered for that garden.

The category "Ordered" contains (1) plants destined for that garden and (2) plants destined for the "RareFind Rhododendron Garden Along River Road."
Carol Sandt
"Hope is the simple trust that God has not forgotten the recipe for manna.” - W. Paul Jones in "Trumpet at Full Moon"
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level
Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier Million Pollinator Garden Challenge
Image
dave
Aug 15, 2017 3:27 PM CST

Garden.org Admin

Oh, I thought you were asking about how to put a plant into more than one category.

Displaying numerous categories is something I'll have to give some thought to...
Name: Sandy B.
Ford River, Michigan UP (Zone 4b)
(Zone 4b-maybe 5a)
Charter ATP Member Celebrating Gardening: 2015 I was one of the first 300 contributors to the plant database! I helped beta test the first seed swap Garden Sages Million Pollinator Garden Challenge
Region: United States of America Region: Michigan Seed Starter Vegetable Grower Greenhouse Birds
Image
Weedwhacker
Aug 15, 2017 3:35 PM CST
I'm glad you asked that, Carol... I couldn't figure it out either (although it hasn't really occurred to me to want to do it before). Smiling

"Blessed is he who has learned to laugh at himself, for he shall never cease to be entertained."
- John Powell / Cubits.org - A Universe of Communities
/ Share your recipes: Favorite Recipes A-Z cubit
C/F temp conversion / NGA Member Map
Name: Carol Sandt
Lancaster County, Pennsylvania (Zone 6b)
Peonies Butterflies Region: Mid-Atlantic Hibiscus Daylilies Xeriscape
Hostas Roses Celebrating Gardening: 2015
Image
csandt
Aug 15, 2017 4:50 PM CST
dave said:Oh, I thought you were asking about how to put a plant into more than one category.

Displaying numerous categories is something I'll have to give some thought to...


I apologize for my lack of clarity. I can easily see how you understood it that way.
Carol Sandt
"Hope is the simple trust that God has not forgotten the recipe for manna.” - W. Paul Jones in "Trumpet at Full Moon"
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level
Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier Million Pollinator Garden Challenge
Image
dave
Aug 15, 2017 7:17 PM CST

Garden.org Admin

The error was mine. You were very clear, I just wasn't reading carefully enough. Smiling
Name: Terri
Lucketts, VA (Zone 7a)
Region: Mid-Atlantic Region: Virginia Dog Lover Lover of wildlife (Raccoon badge) Hellebores Irises
Ferns Foliage Fan Ponds Avid Green Pages Reviewer
Image
aspenhill
Aug 26, 2017 7:00 AM CST
Thanks for this new feature @Dave! I tried it this morning and it works great for importing in to Excel. I find that manipulating the data via the Excel spreadsheet is really useful Thumbs up

« Garden.org Homepage
« Back to the top
« Forums List
« Site Talk forum
You must first create a username and login before you can reply to this thread.

Member Login:

Username:

Password:

[ Join now ]

Today's site banner is by Fleur569 and is called "Working with Purple & White"