Dieter @ DWorks Posted February 11, 2009 Share Posted February 11, 2009 Hi, how can I have the space finishes into a worksheet? It seems that only the fields that appear in the oip can be extracted to a worksheet. I really need the room finishes to show up in my worksheet. thx in advance, Dieter Quote Link to comment
Jeffrey W Ouellette Posted February 11, 2009 Share Posted February 11, 2009 Dieter, If you look at the "VA Create Schedule..." command, you will see that there is a Room Finish Schedule. The fields you are probably looking for are: Space.Floor Key Space.Base Key Space.North Key Space.East Key Space.South Key Space.West Key Space.Ceiling Key Quote Link to comment
Dieter @ DWorks Posted February 11, 2009 Author Share Posted February 11, 2009 Thx for that The 'VA Create Schedule...' command is not translated like many others in our version. I always try to get all fields with a custom script I made, but with some pio's like the space tool, I can't seem to get them with scripting. Quote Link to comment
Pat Stanford Posted February 11, 2009 Share Posted February 11, 2009 The script in this thread: http://techboard.vectorworks.net/ubbthreads/ubbthreads.php?ubb=showthreaded&Number=108487#Post108487 Should get you all of the possible fields of a PIO Quote Link to comment
panta rhei Posted February 11, 2009 Share Posted February 11, 2009 Space.North Key Space.East Key Space.South Key Space.West Key What a country of squares! Quote Link to comment
Dieter @ DWorks Posted February 11, 2009 Author Share Posted February 11, 2009 The script in this thread: http://techboard.vectorworks.net/ubbthreads/ubbthreads.php?ubb=showthreaded&Number=108487#Post108487 Should get you all of the possible fields of a PIO Well, I have such a script to use when I don't know all fields. But it's not working on some pio's like spaces and walls. Quote Link to comment
Pat Stanford Posted February 11, 2009 Share Posted February 11, 2009 Well, the one I pointed to does work for Spaces. Walls are not PIOs, so it won't work for them as there is no parameter record to get the field from. Quote Link to comment
starling75 Posted September 27, 2010 Share Posted September 27, 2010 How can I extract room finishes descriptions? Now I am able to get r.f. codes entering variables like Space.Floor Key etc into database row.. Make room finishes legend command works, but it creates only dumb worksheet. I would like to have codes and their descriptions linked into one live spreadsheet ... Does somewhere exist complete list of spreadsheet database variables like Space.Floor Key, 'Space'.'Number' ...etc ? Quote Link to comment
Pat Stanford Posted September 27, 2010 Share Posted September 27, 2010 Check out this thread: http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=108487#Post108487 It has a script that will give you all of the PIO fields of a selected object and the formulas you need to use to show that data in a worksheet. Floor Finish 'Space'.'Floor Finish' Base Material 'Space'.'Base Material' North Wall Finish 'Space'.'North Wall Finish' East Wall Finish 'Space'.'East Wall Finish' South Wall Finish 'Space'.'South Wall Finish' West Wall Finish 'Space'.'West Wall Finish' Ceiling Material 'Space'.'Ceiling Material' Remarks 'Space'.'Remarks' Quote Link to comment
starling75 Posted September 27, 2010 Share Posted September 27, 2010 Check out this thread: http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=108487#Post108487 It has a script that will give you all of the PIO fields of a selected object and the formulas you need to use to show that data in a worksheet. Floor Finish 'Space'.'Floor Finish' Base Material 'Space'.'Base Material' North Wall Finish 'Space'.'North Wall Finish' East Wall Finish 'Space'.'East Wall Finish' South Wall Finish 'Space'.'South Wall Finish' West Wall Finish 'Space'.'West Wall Finish' Ceiling Material 'Space'.'Ceiling Material' Remarks 'Space'.'Remarks' Thanks Pat, works great - :cool: Quote Link to comment
starling75 Posted September 29, 2010 Share Posted September 29, 2010 Check out this thread: http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=108487#Post108487 It has a script that will give you all of the PIO fields of a selected object and the formulas you need to use to show that data in a worksheet. Pat, the script above works good for many PIOs in VW 2009 except for spaces. It works fine in VW 2008. Quote Link to comment
starling75 Posted September 29, 2010 Share Posted September 29, 2010 How can I make spreadsheet with a list of wall components in VW2009? pic Quote Link to comment
Jeffrey W Ouellette Posted September 29, 2010 Share Posted September 29, 2010 Bohdan, Sorry, in 2009 you can't, but in 2011 you can. Prior to 2011, the wall components didn't have there own unique data structure, they were just graphic components embedded in the Wall. In 2011, they are now embedded unique data structures that have their own 3D geometry and rendering characteristics, as well as database entries (functions) that are exposed to the user (=COMPONENTAREA, =COMPONENTNAME, =COMPONENTVOLUME). Quote Link to comment
starling75 Posted September 29, 2010 Share Posted September 29, 2010 Bohdan, Sorry, in 2009 you can't, but in 2011 you can. Prior to 2011, the wall components didn't have there own unique data structure, they were just graphic components embedded in the Wall. In 2011, they are now embedded unique data structures that have their own 3D geometry and rendering characteristics, as well as database entries (functions) that are exposed to the user (=COMPONENTAREA, =COMPONENTNAME, =COMPONENTVOLUME). Jeffrey, I can see wall components names in object criteria database settings, it should be somehow doable/scriptable .. pic Maybe using this?? .............?? Quote Link to comment
Pat Stanford Posted September 29, 2010 Share Posted September 29, 2010 Pat, the script above works good for many PIOs in VW 2009 except for spaces. It works fine in VW 2008. Unfortunately, NV changed the Space Object from a Vectorscript PIO to an SDK PIO between 2008 and 2009 and did not expose most of the parameter fields. Nothing I can do by script to work around that. In VW2011, all the fields seem to be accessible. Quote Link to comment
starling75 Posted September 30, 2010 Share Posted September 30, 2010 What is the syntax of a formula I should enter into database row, If I want to list for example north keys and east keys in one column? ='Space'.'East Key' & 'Nort key' (doesn't work..) Quote Link to comment
Pat Stanford Posted September 30, 2010 Share Posted September 30, 2010 I don't think you can put them together in VW2009. A Concat function was added to the worksheet in VW2010 (if I remember correctly). The following works in VW2011. =CONCAT(space.'East Key', ' - ', space.'North Key') Notice that the quotes are not required around the space record name since it does not have a "space character" (or any other special character) in the name. If you want to put the quotes in for consistency you can. Quote Link to comment
starling75 Posted October 1, 2010 Share Posted October 1, 2010 I don't think you can put them together in VW2009. A Concat function was added to the worksheet in VW2010 (if I remember correctly). The following works in VW2011. =CONCAT(space.'East Key', ' - ', space.'North Key') Notice that the quotes are not required around the space record name since it does not have a "space character" (or any other special character) in the name. If you want to put the quotes in for consistency you can. CONCAT function is in 2009 I tried your example formula in 2009 and 2011_eval, and this is the result.. 01 02 Quote Link to comment
Pat Stanford Posted October 1, 2010 Share Posted October 1, 2010 What criteria are you using for the database? I was using Type is Space. VW2011 Quote Link to comment
starling75 Posted October 1, 2010 Share Posted October 1, 2010 (edited) What criteria are you using for the database? I was using Type is Space. VW2011 Same criteria .. tab - concat Edited October 1, 2010 by starling75 Quote Link to comment
Dieter @ DWorks Posted October 1, 2010 Author Share Posted October 1, 2010 What criteria are you using for the database? I was using Type is Space. VW2011 Same criteria .. tab - concat Look closely at the capitals! Quote Link to comment
Pat Stanford Posted October 1, 2010 Share Posted October 1, 2010 DWorks is right. You need to use Space, not space in the formulas. Quote Link to comment
starling75 Posted October 1, 2010 Share Posted October 1, 2010 DWorks is right. You need to use Space, not space in the formulas. Thanks Pat and DWorks, but formulas are insensitive to whether they are written uppercase or minuscule.. But I finally found the "root of evil" ... my OS is set to use commas for separation of decimal places. I had to replace them with semicolons... Quote Link to comment
rb-arch Posted November 4, 2010 Share Posted November 4, 2010 I can't get the Remarks section to show up on my finish schedule. When I use the Space.Remarks it looks correct, but won't display what I enter in the Space properties dialogue, or in the work sheet itself. Any ideas? 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.