Post a reply

Image
Aug 15, 2017 7:29 AM CST
Thread OP
Name: Carol H. Sandt
Lancaster County, Pennsylvania (Zone 6b)
Annuals Roses Peonies Region: Pennsylvania Region: Mid-Atlantic Hostas
Growing under artificial light Foliage Fan Daylilies Butterflies Bookworm Aroids
@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.
Last edited by csandt Aug 15, 2017 2:12 PM Icon for preview
Image
Aug 15, 2017 8:13 AM CST
Garden.org Admin
Name: Dave Whitinger
Southlake, Texas (Zone 8a)
Region: Texas Seed Starter Vegetable Grower Tomato Heads Vermiculture Garden Research Contributor
Million Pollinator Garden Challenge Charter ATP Member I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level Region: Ukraine Garden Sages
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.
Image
Aug 15, 2017 8:39 AM CST
Thread OP
Name: Carol H. Sandt
Lancaster County, Pennsylvania (Zone 6b)
Annuals Roses Peonies Region: Pennsylvania Region: Mid-Atlantic Hostas
Growing under artificial light Foliage Fan Daylilies Butterflies Bookworm Aroids
@Dave,
Thank you!
Would adding the ability to select more than one category be feasible?
Image
Aug 15, 2017 8:44 AM CST
Garden.org Admin
Name: Dave Whitinger
Southlake, Texas (Zone 8a)
Region: Texas Seed Starter Vegetable Grower Tomato Heads Vermiculture Garden Research Contributor
Million Pollinator Garden Challenge Charter ATP Member I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level Region: Ukraine Garden Sages
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.
Image
Aug 15, 2017 9:11 AM CST
Thread OP
Name: Carol H. Sandt
Lancaster County, Pennsylvania (Zone 6b)
Annuals Roses Peonies Region: Pennsylvania Region: Mid-Atlantic Hostas
Growing under artificial light Foliage Fan Daylilies Butterflies Bookworm Aroids
Thank You!
Avatar for kreemoweet
Aug 15, 2017 1:02 PM CST
Name: K
Seattle, WA (Zone 9a)
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.
Image
Aug 15, 2017 2:21 PM CST
Thread OP
Name: Carol H. Sandt
Lancaster County, Pennsylvania (Zone 6b)
Annuals Roses Peonies Region: Pennsylvania Region: Mid-Atlantic Hostas
Growing under artificial light Foliage Fan Daylilies Butterflies Bookworm Aroids
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
Image
Aug 15, 2017 2:53 PM CST
Thread OP
Name: Carol H. Sandt
Lancaster County, Pennsylvania (Zone 6b)
Annuals Roses Peonies Region: Pennsylvania Region: Mid-Atlantic Hostas
Growing under artificial light Foliage Fan Daylilies Butterflies Bookworm Aroids
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."
Image
Aug 15, 2017 3:27 PM CST
Garden.org Admin
Name: Dave Whitinger
Southlake, Texas (Zone 8a)
Region: Texas Seed Starter Vegetable Grower Tomato Heads Vermiculture Garden Research Contributor
Million Pollinator Garden Challenge Charter ATP Member I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level Region: Ukraine Garden Sages
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...
Image
Aug 15, 2017 3:35 PM CST
Name: Sandy B.
Ford River Twp, Michigan UP (Zone 4b)
(Zone 4b-maybe 5a)
Charter ATP Member Bee Lover Butterflies Birds I was one of the first 300 contributors to the plant database! Million Pollinator Garden Challenge
Seed Starter Vegetable Grower Greenhouse Region: United States of America Region: Michigan Enjoys or suffers cold winters
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
“Think occasionally of the suffering of which you spare yourself the sight." ~ Albert Schweitzer
C/F temp conversion
Image
Aug 15, 2017 4:50 PM CST
Thread OP
Name: Carol H. Sandt
Lancaster County, Pennsylvania (Zone 6b)
Annuals Roses Peonies Region: Pennsylvania Region: Mid-Atlantic Hostas
Growing under artificial light Foliage Fan Daylilies Butterflies Bookworm Aroids
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.
Image
Aug 15, 2017 7:17 PM CST
Garden.org Admin
Name: Dave Whitinger
Southlake, Texas (Zone 8a)
Region: Texas Seed Starter Vegetable Grower Tomato Heads Vermiculture Garden Research Contributor
Million Pollinator Garden Challenge Charter ATP Member I was one of the first 300 contributors to the plant database! Garden Ideas: Master Level Region: Ukraine Garden Sages
The error was mine. You were very clear, I just wasn't reading carefully enough. Smiling
Image
Aug 26, 2017 7:00 AM CST
Name: Terri
Lucketts, VA (Zone 7a)
Region: Mid-Atlantic Region: Virginia Dog Lover Lover of wildlife (Raccoon badge) Deer Ponds
Foliage Fan Ferns Hellebores Irises Peonies Amaryllis
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
Image
Jun 26, 2022 5:51 AM CST
Name: Vickie
southern Indiana (Zone 6b)
Bee Lover Garden Photography Celebrating Gardening: 2015 Daylilies Plant Lover: Loves 'em all! Region: United States of America
Region: Indiana Garden Art Annuals Clematis Cottage Gardener Garden Ideas: Level 2
Just found out that I can export my plant list to Excel! How awesome! My "Have" list showed that I had more than I really did, so I needed to compare this list to the one on my computer. Exporting the list to a format that I could work with made it so quick and easy.

@dave, belated thanks for adding that wonderful feature!

Thumb of 2022-06-26/blue23rose/436f1a
May all your weeds be wildflowers. ~Author Unknown
You must first create a username and login before you can reply to this thread.
  • Started by: csandt
  • Replies: 13, views: 809
Member Login:

( No account? Join now! )

Today's site banner is by frostweed and is called "Flame Acanthus, Wildflowers"

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.