Jump to content
Sky

Help with Wall Schedule!

Recommended Posts

I am using a worksheet for the first time for a wall schedule, and I can't figure out what to put in the database header to get the wall description. Really, really need help. Does anyone know?

Screen Shot 2019-02-14 at 3.15.12 PM.png

Share this post


Link to post

Either I was working too fast last night or just not paying attention. The single cell version is not working for me either, but a 3 cell version does.

 

In three columns enter the following formulas. I have assumed that these will be in columns D,E,F.

D3  =IFC_Entity

E3  =Concat(D3,'.Name')

F3  =GetIFCPropery(E3)

 

You can then set the column widths on D and E to zero so you don't see them.

 

HTH

 

Share this post


Link to post

Part of it it my fault.

 

First, what is the row number for the database header row? If it is not 3, then you need to change the formula to reference the correct row. Also what Column is the Description in? We want to make sure we are referencing the correct columns.

 

Second, the column F formula had a typo.  It should be =GetIFCProperty(E3)  My typo that you copied and pasted.

 

So cell "E3" should end up with a value of ifcWallStandardCase.Name

 

And "F3" should end up pulling the Name from the IFC record into the cell.

 

Try entering a formula of =GetIFCProperty('ifcWallStandardCase.Name')  into a header row and see what happens. The other two are just there to handle walls that are not standard case.

 

 

Share this post


Link to post

@Pat Stanford I put them in the columns you asked me to. 

 

Does E3  =Concat(D3,'.Name') have a typo too? When I corrected F3, it changes from showing the formula to the number 0, which is something I expect it to do.

 

I made a new column G and put =GetIFCProperty('ifcWallStandardCase.Name') in the database header, but it doesn't have anything in the column. 

Screen Shot 2019-02-22 at 11.36.46 AM.png

Share this post


Link to post

No, the E3 formula is correct.

 

Can you post a simplified sample file with a couple of walls and the worksheet and I can take a look?

 

Or send it to me in a direct message?

 

I have both versions working in a test file here.

Share this post


Link to post

Hi Pat!

 

I appreciate all the help you've offered me on this. I deleted a bunch of stuff from the file to get it under 200mb, but I keep getting an error message when trying to post it or send it to you directly. Grr...

 

Sky

Share this post


Link to post

Hi @Sky,

Pat is the best at this.  Might I add...use this to get your description...=IF(GETIFCPROPERTY('IfcWallStandardCase.Description')<>'', GETIFCPROPERTY('IfcWallStandardCase.Description'), GETIFCPROPERTY('IfcCurtainWall.Description'))  This is what I get when choosing TOOLS - REPORTS - CHOOSE SCHEDULE - WALL STYLE REPORT W/IMAGES

ScreenHunter_40 Feb. 27 08.28.jpg

Edited by Markvl

Share this post


Link to post

@Markvl 

8 hours ago, Markvl said:

=IF(GETIFCPROPERTY('IfcWallStandardCase.Description')<>'', GETIFCPROPERTY('IfcWallStandardCase.Description'), GETIFCPROPERTY('IfcCurtainWall.Description'))

 

So I guess the other question I had, because I have tried using this formula before, is that I don't know where that description is or how to edit it. It certainly isn't the Description input in the Edit Wall Style dialog (see attachment from my initial posting).

Share this post


Link to post

Something else to check, is that the cells are not formatted as text cells. If they are, or even if they were when the formula was entered, you need to use clear contents first before reentering the formulas, or they don't respond.

 

I think it's a bug and cells that are formatted as text, probably shouldn't have the record field drop-down showing, it's confusing!  

 

 

 

Share this post


Link to post

Why is this sooooo difficult?

Share this post


Link to post

Hi Sky,  Sorry for the delay, but I have been slammed at work.

 

I have uploaded an edited version of your test file back to my dropbox and sent you a link via DM.

 

I don't know why you were having trouble, but I did see it when I opened the file. After I edited it back to what I thought you had, it then worked based on my suggestions above.

Share this post


Link to post

A valiant effort, but alas, this is not the description. If you or someone else could tell me where this description is coming from, I don't mind editing that text as a solution either.

Screen Shot 2019-03-10 at 16.14.55.png

Screen Shot 2019-03-10 at 16.14.29.png

Share this post


Link to post

@Skystill having issues?  Send along the file to me if you can and I'll have a look.

Share this post


Link to post

@Markvl Thanks! I just sent a Dropbox link in a private message. I get an error message when trying to upload it here.

Share this post


Link to post
Posted (edited)

@Sky I've just downloaded and opened it up.  Having a look.  One thing I've done right of the top is Create a new wall schedule w/image.  See pic attached.

ScreenHunter_45 Mar. 13 16.19.jpg

I checked the Style info for your 12 conc.  shown last in the pic and all the info lines up with what is shown in the worksheet.

Edited by Markvl

Share this post


Link to post

Now is there a particular way you want the info to show up?

Share this post


Link to post

Odd.  I simply started a new worksheet and the data cells are all the same accept your original worksheet just doesn't seem generate the "answers".  Have you tried just putting in a new worksheet?

 

Share this post


Link to post

I don't see the same thing for 01. 04, 07 and 05 descriptions in you screen shot don't match up either.

Screen Shot 2019-03-13 at 12.42.07.png

Share this post


Link to post
Posted (edited)

@Sky  Sorry something goofy went on there.  See this pic.

ScreenHunter_47 Mar. 13 16.50.jpg

 

Hmmm... something else I noticed is that some walls are showing a description and others not.

Edited by Markvl

Share this post


Link to post

@Markvl This is what I mean - I don't know where those descriptions are coming from. They aren't from the data box from the Edit Wall Style window. See actual descriptions below. 

Screen Shot 2019-03-13 at 12.54.09.png

Screen Shot 2019-03-13 at 12.54.21.png

Screen Shot 2019-03-13 at 12.53.56.png

Share this post


Link to post

Looking at it again 14, is correct, but 20 and 13 are not. So weird!

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
Reply to this topic...

×   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...