Marietta Posted March 22, 2005 Share Posted March 22, 2005 I added a new category to my plant list for perennials and for annuals. The plant list shows every instance of these plants instead of adding them up and listing them once. Also, they are not sorted alphabetically. I highlighted the database header and selected the sum and sort buttons on top. I get a message that it cannot sort or sum beyond a certain column number. This message didn't come up again and the plants are not sorted or summed. What can I do? Quote Link to comment
Vectorworks, Inc Employee Robert Anderson Posted March 22, 2005 Vectorworks, Inc Employee Share Posted March 22, 2005 Marietta, what platform are you on? Mac or Windows? Quote Link to comment
Marietta Posted March 22, 2005 Author Share Posted March 22, 2005 I am working on Mac OS 10.3.7 on a G4 with 400MHz and 704MB SDRAM. Quote Link to comment
Vectorworks, Inc Employee Robert Anderson Posted March 22, 2005 Vectorworks, Inc Employee Share Posted March 22, 2005 Marietta, I've looked into this a little more and I have the question: how did you add the category? This is a "hard-coded" item (it shows up as a popup item in the Plant Reference Data command). So, how did you add the category? Quote Link to comment
Marietta Posted March 22, 2005 Author Share Posted March 22, 2005 Robert I started off with the simple plant list (columns for code, quantity, botanical and common names, schedule, remarks). I then categorized the plants in the rows according to their designation in the plant resource data (trees, shrubs, perennials, annuals-biennials, etc.). I would edit the criteria in the data base headers so that only the trees would show up in the first section of rows, shrubs in the next, etc. The plants in each section would come in alphabetical order within that section. My plant list would have one row which I labelled 'TREES'. The next row would be the edited database header so that only the trees would show up. The next row would be labelled 'SHRUBS', then the database header for shrubs, etc. This has worked fine until I tried to add more sections for perennials and for annuals-biennials. Quote Link to comment
Aqueous Posted March 25, 2005 Share Posted March 25, 2005 Marietta I have just completed a fairly extensive scheme for a park and found that it proved useful to assign seperate classes for each group of plants. I also subdivided the worksheet for each class (or categfory). In this way I am able to call out reports for each group and assign ID refs that would assist VS in sorting the list. I hope this is useful. Quote Link to comment
Marietta Posted March 30, 2005 Author Share Posted March 30, 2005 Aqueous Do you mean that you would assign classes such as trees, shrubs, perennials, etc. to the plants and that they would show up in that order in your plant list? Do you use the simple plant list and add more choices to the database header and add that class? Mohit I modified the simple plant list. Click on 'database headers' in the arrow pull down tab. Add an extra row above the first calculated rows (you can see these by the diamond infront of the row number). Type in 'Trees' or whatever your plant category is in this row. Then highlight the next row with the diamond shape, and right click on the row number, select 'edit criteria'. You will see row with 'record', 'plant record' is 'present' Click on more choices button and select 'field value' 'plant category' '=' 'trees' or whatever your category is. Now only the trees would be shown in the rows below. Add 2 rows below for the next category. Copy the database header info and change the category to the next category. I had problems with this way when I added more categories (3&4 categories), so I don't know if this is a limit - that was my original question. Maybe Aqueous's way works better with classes. Quote Link to comment
mohit Posted March 31, 2005 Share Posted March 31, 2005 1. how do i sort the plants in the work sheet to have all the plants of the same category listed at the same place? 2. how do i create the report to show the same plant specie with 2 or 3 different sizes and spacing to show up in different rows on the work sheet? Quote Link to comment
artemis Posted June 29, 2005 Share Posted June 29, 2005 We have developed a plant list that sorts plants into their categories. Unfortunately it commonly misplaces plants (a tree listed as a perennial, etc). not sure why this happens because each time i go and double check the setting in the plant database it is properly categorized. If I 'ok' my way out (essentially recreating the plant definition) this usually fixes the issue. Quote Link to comment
Marietta Posted June 29, 2005 Author Share Posted June 29, 2005 Artemis How did you develope the plant list? I have gotten that problem before that the tree is listed as a Zinnia (it seems the plant data base likes zinnias). This happens when I edit a plant through the 'Edit Plant Catalogue' instead of the plant reference. I have to edit the plant again to get it right. It is best to edit the reference data itself then use it in your drawings. Hope this helps. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.