Jump to content
Sign in to follow this  
Roger Webster

Sort plants by category

Recommended Posts

How do I sort plants on a schedule into trees, shrubs, groundcovers etc? Should I place them on separate layers and create separate worksheets for each category using the "edit criteria" command? Or set up seperate classes for each?

Share this post


Link to post

Roger you can use the Plant Category Record as a criteria filter. You need to be diligent though and ensure that all of your plants are categorised correctly and that the spelling is 100% correct in every instance.

Share this post


Link to post
Roger you can use the Plant Category Record as a criteria filter. You need to be diligent though and ensure that all of your plants are categorised correctly and that the spelling is 100% correct in every instance.

OK I have gone through all my plant records making sure the category of each is correct. If I create a worksheet and include all categories, it's fine. If I then start to filter by category, the data disappears from all but the first category, ie, in subsequent categories all rows appear blank even though the "edit criteria" window tells me the items (plants) are being correctly sorted and counted . The "select data item" command also identifies each one, but no text appears in any of the row columns. Any help gratefully received.

Share this post


Link to post

Roger it is a Vw 2009 file which is what your signature says you have. Thus I don't understand why you can't open it. A PDF will not be much use to you because you won't have any way of examining the Worksheet.

A typical criteria filter is shown in the attached image.

Share this post


Link to post

I don't understand why either, but anyway ... as above, it's fine if I just have one section, eg trees, OR shrubs etc, but if I then add further database rows for shrubs, perennials, climbers etc and enter new edit the criteria for these all of these appear as blank rows. They do have data in them, I know this because if I add new plants, new rows appear and I can identify them using the "select data item" command, but all text in the worksheet rows is invisible/absent except for the first section. I also notice that the formula "summarise items with the same name" does not work in the subsequent sections, only in the first one. The only way I can find round this is to produce separate worksheet lists, one for each plant category. The Getting Started with Landmark 2011 pdf download shows the sort of plant list worksheet I need (though I'd want to edit the columns), but does not explain how it was created. I have also been trawling through the 2008 Design Series and Fundamentals manuals to get this far, but now I'm stuck!

Share this post


Link to post

A question Roger. After you have made your changes are you invoking the Recalculate command?

Share this post


Link to post

OK here is (hopefully) a small file to illustrate the problem with some random plants. The plant list has captured all the data, but only the trees show up. Many thanks for the help. And yes I have been hitting the recalculate button, and any changes are indeed incorporated.

Edited by Roger Webster

Share this post


Link to post

You only have a formula for the acer. as for the other verieties add the formula in the database header.

I made the modification on you sample drawing and all works fine.

Remember after each sort (ie. shrubs, perennials, etc.) add the formula in the header.

Give it a whirl and let us know if you have any other questions.

Share this post


Link to post

Also make sure your plant data (Category) matches your sort or plants will be eliminated from the total.

Share this post


Link to post

Roger, for the other categories you are missing formulae in each of the Database header rows.

Share this post


Link to post

Yes, just figured it out at last, from the file you sent earlier which I have now managed to open - I needed to copy and paste formulae into each database header. Thank you very much - a great leap forward for me

Share this post


Link to post

OK I'm finally there - with much help from Mike m and Bryan G - gratefully acknowledged. But I can't help thinking this should have been a great deal easier! The ability to produce a plant list from a plan, and to keep it updated, is a fantastically helpful tool for anyone in the landscape business and a good reason for using Vectorworks - but why make it so clunky to use?. The fields to be included will vary in different countries and according to the use the information will be put to - client presentation, costing, ordering etc, but surely sorting the list alphabetically and by plant category are pretty basic requirements for all of us. Why then do none of the standard sample worksheets do this, and why is information on such a basic task so very hard to come by? Does the process of customising a worksheet need to be so arcane? Sorry to gripe, but judging by some other postings on the subject of worksheets I'm not alone in finding this confusing, and as an Apple user I am accustomed to programmes being much more attuned to the needs of the end user.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×