matteoluigi

great, that works!

Actually I try to write an IF query in a worksheet. Sth like: =IF(((B2<>'')|(B2<>'*A*')|(B2<>'*B*'));'YES';'NO') It's mainly about filtering weather string (it will be a substring later on...) does contain a special word/code or it doesn't. For the beginning I try to filter, wether cell B2 does contain the letter A or B or it doesn't. However B2.1 and B2.2 do contain an '*A*' and '*B*' however the result is still YES. No clue, why... (it will be a main part of my code...) IF OR.zip

Hi, is there any possibility to color worksheet cells dependent on their content? like in data visualization?

As you can see in the worksheet in the attached file I tried to extract the substring from a classname in a worksheet. The result isn't the substring but a number. The code in the first column of a database-row is "=SUBSTRING(C; '-'; 1)" and doesn't work. The only way to get the class-substring works with two columns, one with a simple "=C" and the second with =SUBSTRING(B2; '-'; 1) (B2 = the Cell-Name in which I am looking for the class name by "=C") Looks like a bug to me, isn't it? (so also the more complicated code "=CONCAT((SUBSTRING(B2; '-'; 1)); ' -|- '; (SUBSTRING(B2; '-'; 2)); ' -|- '; (SUBSTRING(B2; '-'; 3)); ' -|- '; (SUBSTRING(B2; '-'; 4)))" works ^^) ps. =IF((C='*A*'); 'A'; (IF((C='.*E*'); 'E'; IF((C='*H*'); 'H'; 'Y')))) doesn't work either, i have to use =IF((B2='*A*'); 'A'; (IF((B2='.*E*'); 'E'; IF((B2='*H*'); 'H'; 'Y')))) instead 😞 ) Substring from Class.zip

did you get a solution in the meantime?

just to avoid having double posts about the same topic: What can be possible reasons, that the Vectorworks-login doesn't find our License Server? Instead I have to fill in the server-IP manually. Actually we have macOS operating systems from 10.12 to 12 in our office. Our server runs on 10.12 (and is to be updated of course, i guess to 11 (Big Sur)) I imagine, that Vectorworks must send some kind of broadcast to find the license server which isn't answered. Must be some security policy on the server, I guess. Like port 5053 which could be closed to broadcasts or sth like that. What do you know about that?

Hi, I am curios, wether anyone at Reprise or VW did ever consider a possibility of monitoring how many licenses were, are in use. Like creating a diagram over the last few months, since the reprise license server has been set up,..., in order to see, how many licenses have been in use by which person, where, ... and how many licenses where in process at all. Actually I am writing this in an excel spreadsheet, every day manually... But, could be a simple automated job, as well 😉

yeah, the Data Manager is a great tool to assign IFC-Data to objects in Vectorworks. There you can manage really much things, assign new data, change data, assign record-format/database data to original PSets and also manage custom PSets... It's a really powerful tool!

The command "IFC AttachPset" exists, but, does there exist also vs.IFC DetachPset? (or any type of command or code which could detach by Name defined psets from Objects) (Reason: somehow my mappings in the datamanager get overwritten somehow/don't work, until I detach all attached psets by hand... So I want to write a script to automate that work actually I work with activation scripts..., pls, preferably help me with my code question, not with the datamanager-issue)

@Pat Stanford thanks for your advice! I will have to send the wish to ComputerWorks

@Pat Stanford that‘s a bug imho. It works fine on older operating systems with older Vectorworks Versions. Got to (re)try VW2021, 2020 on Big Sur tomorrow morning. Or would you say it’s a regression? I don’t think so. ;-)

tried to - reset the user folder: no success - tried with another user: no success, too. every time i want to edit the filename text inside the save-dialog..., no cmd keyboard shortcuts work inside the save dialogue text-input field. Got it already confirmed by some users on the german Vectorworks-Board. I'm not the only one. (in fact every user, who answered my post experienced the same issue, their using Big Sur and Monterey as operating systems)

Hi, did/does anybody else experience, that the command key doesn't work specially in Vectorworks (tried it in work,... - everything fine), just in VW it doesn't work, so i can't press cmd+a for example, to mark up the whole file name, cmd+x, cmd+c, cmd+v doesn't work either... (in VW 2020, 2021 and 2022) Any ideas why? I already asked in the german board. Seems to my like an issue from Vectorworks on macOS Big Sur...

Hi, in Vectorworks it's possible to select Worksheets and Scripts through the Window-Menu. It would be great (and, in fact i wonder, why it hasn't been already implemented), to sort worksheets and scripts by their folder, too. Please, implement it asap 🙂

ever thought about a migration assistent for the datamanager, to migrate Data-Manager Sets between IFC-Versions? (ifc 2x3 -> IFC 4 -> IFC 5...) It now happened to me, that we did develop and design our own studio-specific datamanager-sets. Now, transforming them to higher ifc standards turns out in a big copy and paste orgy... An option to migrate a set from one ifc-standard to another would be a great timesaver!