Jump to content
  • 0
drelARCH

WORKSHEET - Database list of all materials present in wall/slab/roof styles components

Question

Anyone having difficulty to list in database worksheet materials that are part of wall or roof style components?

I am able to generate list of <any> is present materia just those that are part of slab styles....?

Any idea?

 

Thanks.

 

 

Snímka obrazovky 2020-11-06 o 15.26.30.png

Edited by drelARCH

Share this post


Link to post

12 answers to this question

Recommended Posts

  • 0

I don't think you want to use Material as part of the criteria. Set the criteria to be Object Type is Slab. Then use a column formula to list the materials.

Share this post


Link to post
  • 0

Thanks Pat,

 

I should have put it differently: what is the easiest way to list all materials present on one specific layer (in my case materials present in wall/slab/roof components)?

 

Here is layer with wall/slab/roof styles:

 

198167625_Snmkaobrazovky2020-11-09o23_32_10.thumb.png.d58f8c51af3319a059cc5b1212891694.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I might be missing something but with criteria like this one:

1087314169_Snmkaobrazovky2020-11-10o8_23_50.thumb.png.73f24c9ddc9009169986e56ee66b796b.png

 

 

 

 

 

 

 

 

 

 

 

and report like this:

404149989_Snmkaobrazovky2020-11-09o23_32_36.thumb.png.76d874e244f6bdbeccd21808230ae0e6.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I get list of materials but only from components of slab objects.  NO wall components listed. Why only slabs components....?

Here resulted worksheet:

1815013158_Snmkaobrazovky2020-11-09o23_35_56.thumb.png.edbd01ea859e81ad4bbdbe50d3ae5b64.png

 

 

 

 

 

 

 

 

 

 

 

 

 

Whenever I change criteria to the one you suggested with same report:

1083778554_Snmkaobrazovky2020-11-10o9_36_23.thumb.png.965d9dd790bc57690d0a039bca075951.png

 

 

 

 

 

 

 

 

 

I get nothing.

-----

I was hoping that it is very straightforward process to present all materials present in file on specific layer, kind of simplest task without need to go into component 1, component 2, component 3 structure...

 

I have tested this with materials applied to extrudes and it does work as expected.

 

I dont know maybe my report is not set correctly...?

 

I want to simply provide client a list with all materials and their characteristics present in designed building.

Any idea how to achieve it?

 

Thanks a lot in advance.

 

Edited by drelARCH

Share this post


Link to post
  • 0

Anyone with solution how to simply list (database worksheet) all present materials in wall/slab/roof style components?

Share this post


Link to post
  • 0

Kind of.

 

=ComponentName(1) will return the name of the first component

=ComponentMaterial(1) will return the name of the material of the first component.

 

What I have not found is a function that will return the number of components so you could use and IF statement to not display more components than exist in the object.

 

The criteria for the database I used had to be entered manually. The criteria is Component='*'. This is the equivalent of what you get when you enter Material Any is Present, but it only gets you subrows for components, not the other objects that might be contained inside the Wall/Slab/Roof. Just choose any component name from the Criteria Dialog box and then manually edit the formula to replace that Component name with the *.

 

Ask again if you need more help.

Share this post


Link to post
  • 0

I am not sure I understand completely what you are suggesting...

Is it like this?

Criteria

1859460259_Snmkaobrazovky2020-11-13o15_17_12.thumb.png.2541544cba9a6c89f561ff8a99d19387.png

 

 

 

 

 

 

 

 

 

 

 

Report

100236898_Snmkaobrazovky2020-11-13o15_17_40.thumb.png.bc2a246d520bbfe35ff389fb40ab4e8b.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If I understand correctly it is not possible to combine all components in one list?

If I substitute ComponentMaterial(1) with ComponentMaterial(*) I get zero list items...?

 

Pat thanks a lot for your effort to help.

 

Edited by drelARCH

Share this post


Link to post
  • 0

The way it is designed now, you have to specify the component (the 1 in my example above, but it could be any component number) to get the ComponentName or ComponentMaterial to display.

 

It is really designed to have different components display in different columns.

 

It would be possible to use a Concat statement to display the data for different components in a single column.

 

Let's take a step back. Please post a mockup of what you are actually trying to accomplish and then we will see how close we can get.

Share this post


Link to post
  • 0
4 hours ago, Pat Stanford said:

It would be possible to use a Concat statement to display the data for different components in a single column.

This is it. I need to display material data for different components in single column so I can easily summarise them and sort them.

First column: material name

next columns: properties of specific material from first column (see report print-screen in my earlier posts)

 

I am not familiar with concat function, how it can be utilise in this scenario?

 

Hope it is clear for you now.

Thanks a lot.

 

Share this post


Link to post
  • 0

Hi Pat,

 

Would appreciate your elaboration on concat function suggestion.

Sorry for pressing you into solving this issue.

 

 

Share this post


Link to post
  • 0

Based on a more detailed reading of what you are trying to do, I am not certain it will help you in this instance.


Concat takes a number of different strings and combines them together into one long string.

 

=Concat(ComponentMaterial(1), ' – ', ComponentMaterial(2))

 

Will return a string consisting of the Material of the first component , a space, a long dash, a space, and the Material of the second component. You can extrapolate  this for as many components as you want.

Share this post


Link to post
  • 0

I am not sure that I understand what you want, but take a look at this file.

 

The database in Row 8 seems close to what you want. Columns A/B/C were just there while I was testing.

 

Column D is the Material Name of the first Material.  Column E is the name of the component that uses that material.

 

I hope this helps you get where you are trying to go.

Material of components.vwx

Share this post


Link to post
  • 0

Since wall, slab or roof components are not objects, you can NOT list them in a database row. Not based on components and not by any other criteria.

The only solution to show a database row of components in a layer is by using a database row script.

Share this post


Link to post
  • 0

Hi,

 

Thanks Pat again ...hm not really what I want to achieve.

Peter I was afraid to hear your message. I strongly wonder why what appear to me as a basic task has to be done through script...?

 

I should have included example file with worksheet in it. Here it is.

You can see that in column B there are listed all components materials from slabs (thats how it works with material present any, dont why)  but not components from walls.

I know we have already discussed that in earlier posts but I wanted to send you file with initial state of things.

 

To make sure that I am clear enough with the task:  I want to simply collect materials (material names) from all components within slab/roof/wall styles into one database column = column B.

 

If it is not definitely possible as Peter is writing I start to think what would be the best way to approach it and get desired result...I have zero knowledge of scripting.

I have been thinking to create marionette that will generate extrudes (lets say cubes 1m x 1m x 1m) on one layer (maybe laid out on evenl spaced grid) and assign all materials in given file from resource manager. Then I can easily generate database list of all materials from extrudes and I get benefit of image preview (3D thumbnail) in database which is not possible with components...

Do you think this is feasible with marionetee?

 

 

materials from components.vwx

Edited by drelARCH

Share this post


Link to post

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.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

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.

×
×
  • Create New...