Sky Posted February 22, 2019 Share Posted February 22, 2019 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? Quote Link to comment
Pat Stanford Posted February 22, 2019 Share Posted February 22, 2019 =GETIFCPROPERTY(CONCAT(IFC_ENTITY, '.NAME')) Should work for Styled Walls with IFC information. Quote Link to comment
Sky Posted February 22, 2019 Author Share Posted February 22, 2019 @Pat Stanford This is just killing me.... Quote Link to comment
Pat Stanford Posted February 22, 2019 Share Posted February 22, 2019 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 Quote Link to comment
Sky Posted February 22, 2019 Author Share Posted February 22, 2019 @Pat Stanford I really appreciate your help. I have no idea why this worksheet is doing this. Quote Link to comment
Pat Stanford Posted February 22, 2019 Share Posted February 22, 2019 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. Quote Link to comment
Sky Posted February 22, 2019 Author Share Posted February 22, 2019 @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. Quote Link to comment
Pat Stanford Posted February 22, 2019 Share Posted February 22, 2019 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. Quote Link to comment
Sky Posted February 24, 2019 Author Share Posted February 24, 2019 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 Quote Link to comment
Markvl Posted February 27, 2019 Share Posted February 27, 2019 (edited) 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 Edited February 27, 2019 by Markvl Quote Link to comment
Sky Posted February 27, 2019 Author Share Posted February 27, 2019 @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). Quote Link to comment
M5d Posted February 28, 2019 Share Posted February 28, 2019 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! Quote Link to comment
Sky Posted March 5, 2019 Author Share Posted March 5, 2019 Why is this sooooo difficult? Quote Link to comment
Sky Posted March 7, 2019 Author Share Posted March 7, 2019 @Pat Stanford Did you see the file? Can you figure out what's wrong? Quote Link to comment
Pat Stanford Posted March 10, 2019 Share Posted March 10, 2019 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. Quote Link to comment
Sky Posted March 10, 2019 Author Share Posted March 10, 2019 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. Quote Link to comment
Markvl Posted March 13, 2019 Share Posted March 13, 2019 @Skystill having issues? Send along the file to me if you can and I'll have a look. Quote Link to comment
Sky Posted March 13, 2019 Author Share Posted March 13, 2019 @Markvl Thanks! I just sent a Dropbox link in a private message. I get an error message when trying to upload it here. Quote Link to comment
Markvl Posted March 13, 2019 Share Posted March 13, 2019 (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. 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 March 13, 2019 by Markvl Quote Link to comment
Markvl Posted March 13, 2019 Share Posted March 13, 2019 Now is there a particular way you want the info to show up? Quote Link to comment
Markvl Posted March 13, 2019 Share Posted March 13, 2019 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? Quote Link to comment
Sky Posted March 13, 2019 Author Share Posted March 13, 2019 I don't see the same thing for 01. 04, 07 and 05 descriptions in you screen shot don't match up either. Quote Link to comment
Markvl Posted March 13, 2019 Share Posted March 13, 2019 (edited) @Sky Sorry something goofy went on there. See this pic. Hmmm... something else I noticed is that some walls are showing a description and others not. Edited March 13, 2019 by Markvl Quote Link to comment
Sky Posted March 13, 2019 Author Share Posted March 13, 2019 @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. Quote Link to comment
Sky Posted March 13, 2019 Author Share Posted March 13, 2019 Looking at it again 14, is correct, but 20 and 13 are not. So weird! 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.