Pat Stanford

For the first question, there are a number of items in the Channel Parameter Record that we have no idea of HOW they are being used internally in the object. I think it is to save the data so when you switch from one type to another it is already populated correctly. And yes, it is just kind of trial and error to figure out which field has the data you need. I don't understand the last question. Can you post a small test file with a couple of objects with your different record formats and the spreadsheet that is not doing what you want and I can take a look.

Or create a single line Vectorscript: WSScript_SetResStr(Date(2,0)); In my case this was named Script-2 So I used a worksheet formula of: =RUNSCRIPT('Script-2') The parameters of the Date Function are for the Date and Time formats. For the first Parameter, 0=Full Date, 1=Abbreviated Date, 2=Short Date For the second Param 0=Date only, 1=Date & Time, 2=Time Only The date is formatted according to your operating system settings. I thought there was a way to enter a single line script like this directly into the RunScript function, but I can't make it work this morning.

='Channel - 3D'.'__size_1' ='Channel - 3D'.'__size_1' ='Channel - 3D'.'__series_1' The field names might be different if you switch to a different Series. Easiest way to find things like this is to make a dummy report in a worksheet and add all the fields in. Find the columns that have the data you are looking for and then look in the header row for the field name.

1. VW2022 is still completely compatible with everything that was available when it was shipped. 2. Blame Apple. They are the ones who have changed the OS in such a way as to break older software.

There only are if they have developed them themselves based on some need in their localized content. Anyone can extend Vectorscript by writing a VWLibrary extension. How you would do that beyond the fact that I believe it requires SDK programming is beyond me. There is a CWLibraryUniversal1.vwlibrary that is included in my version of VW. Probably due to the fact that the the Stair tool (and others) are actually CW code that has been licensed back to VW for inclusion in the base version of VW.

The length is stored in the Channel record. ='Channel - 3D'.'Length' The default Length, Width, Height worksheet functions will give you the orthogonal distances. Length is the X dimension, Width is Y and Height is Z. They will report on almost any object, but if the object is not aligned with the axis, it probably won't provide useful data.

I do not see those items in the stock VW2024. In the Miscellaneous category of the Script Editor window I do see a number of CW_ functions, but none related to matrices. I know the Computerworks (the German distributor) often prefixes their commands CW_ My guess is the CE_ is something similar and is not provided by Vectorworks directly but rather by the localizer or some other other source. CE_ may very well be Computer Express who I believe is the Swiss distributor. There is not a Miscellaneous category in the stock Function Reference documentation.

What function reference are you looking in? I can't find those functions in the version shipping with VW2024 nor in the on-line Developer version.

Maybe also look at ForEachObjectAtPoint which allows you to specify a radius rather than needing an absolute point. But I think you are correct about having to pass world coordinates not PIO coordinates.

Worksheets on their own can only report on objects that are not in the drawing. Being in the Resource manager is not enough. While it is possible to use a DatabaseByScript to create a database of Resources, unless you are comfortable with scripting it is not a good idea. All Sorting and Summing have to be done in the script. You can't use the usual database controls. Sorry.

I think the poly is "consumed" during the creation of the slab. If you need to use the poly after the slab creation I think you need to duplicate the poly first. I am not certain if the "copy" or the "original" will be the one retaining the UUID. I think when you make a copy in VW, the copy is the one that ends up selected and the original is unselected. Or maybe it is the other way around.

@MullinRJ Thanks for the help. I THINK I could have done this, but your explanation is so much clearer than mine would have been. And at the time, my brain would not tell me how to make the original vectors/points. Thanks for the refresher.

I don't think associations require Event Enabled. Unless you want something like delete tag on delete object.

Your file has no interiorcad objects, so I can't see if the database is selecting them properly or not. I need a file with a few samples (2-4) of objects to meet each of the two database criteria.

In the Debug List View Explorer, it shows that the PIO is included in Data Tag. But that may just be in the file and not how it is drawn. 😞