Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by matteoluigi

  1. 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
  2. Hi, is there any possibility to color worksheet cells dependent on their content? like in data visualization?
  3. 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
  4. did you get a solution in the meantime?
  5. 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?
  6. 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 😉
  7. 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!
  8. 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)
  9. @Pat Stanford thanks for your advice! I will have to send the wish to ComputerWorks
  10. @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. ;-)
  11. 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)
  12. 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...
  13. 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 🙂
  14. 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!
  15. the Vectorworks Beam Tool has been a good approach, however it's quite unfinished... My main issue are object styles, when will they be supported?
  16. Hi, working on VW 2022 - Mac OS Big Sur, the sequence of data sets is not changeable in VW 2022... The sequence of data sets in the 2022 Datamanager doesn't change, when I move them. In the first video, you see what I am expecting (like in VW 2021 SP5). When I move a dataset the number is changing. In VW 2022 unfortunately i can't change the order of data sets any more (video nr 2). Looks like the data set °15 still remains nr 15, also I move it above °10, where it should switch to °10 itself. 😞 VW 2021-sp5.mov VW 2022 SP2.mov
  17. Try to move the line „crit = vs.GetName("TAB_WE_H*")“ above the foreach-command. that should do it imho
  18. Hi, I don't understand, why the GetLname-Function in the following code doesn't work, the GetClass-Function instead does work. Both functions work with a Handle (HNDL) and return a String value. def CalledProc(HNDL): # LNR=vs.GetClass(HNDL) LNR=vs.GetLName(HNDL) vs.SetRField(HNDL,'l-test','layer',LNR) vs.ForEachObject(CalledProc,"(T=RECT)") vs.AlrtDialog('done') I attached a small vwx 2022 file with a few rectangles and a python script with the posted code which (as you can read) reads out the class name or the layer name and writes it into the record format field "layer" from the record format "l-test". any idea why GetClass works and GetLName instead doesn't? I tried the function in other scripts, of course, too, without any differences... GetLName.zip
  19. It works 😄 why shouldn't it work, wrapping worksheet-code in a string which is written via python into a worksheet, why shouldn't it work. vs.SetWSCellFormulaN(worksheet,3,3,3,3,"=XLOOKUP(B3; '___'; 'Zimmeranzahl':A1..A11; 'Zimmeranzahl':B1..B11)") -> (XTABELLENSUCHE is the german translation for XLookup. I will never understand entirely why programming functions are translated into german 😉 )
  20. Yes, it’s option 2 which I want to achieve. i want to scan space objects for their type to assign them longer text parts which I “store” in another worksheet. one project I have is for example a list of all rooms with one worksheet for every room which of course grows with the building. I already have an idea. Setting a string like vs.SetWSCellFormulaN(worksheet, 2, 3, 2, 3,’=xlookup(A3,…)’ in a worksheet sounds promising (and a little bit naive, too ;-)) i will have a try asap.
  21. Just a quick idea, afaik both functions only exist in worksheets and the 2022 Datamanager. Why not enable VLookup and XLookup functions also in Vectorscript/Python? Could be great... I already could have a use case for that...
  22. 😞 that didn't help I just want to prevent, that the worksheet already exists before I create a new one 😉 for a in range (4): # vs.CreateWS('WS_TEST'+a+',2,2') worksheet = vs.GetObject(vs.Concat('WS_TEST',a)) if worksheet not in [None, 0]: vs.CreateWS((vs.Concat('WS_TEST',a)),2,2) vs.SetWSColumnWidth((vs.Concat('WS_TEST',a)),1,1,50) vs.SetWSColumnWidth((vs.Concat('WS_TEST',a)),1,1,20) vs.SetWSRowHeight((vs.Concat('WS_TEST',a)),1,1,20,0,0) vs.SetWSRowHeight((vs.Concat('WS_TEST',a)),2,2,20,0,0) vs.SetWSCellFormulaN((vs.Concat('WS_TEST',a)),1,1,1,1,a) create-ws.zip
  23. did you find any conclusion? actually I tried the following code, understanding that it won't work. However, I want to check wether the worksheet already exists before I create it. if worksheet = nil: however doesn't work with a handle, obviously (and "NIL" doesn't exist in Python) What can I do? switch back to Vectorscript? 😞 worksheet = vs.GetObject('WS_TEST') if worksheet = nil: vs.CreateWS(('WS_TEST'),2,2)
  • Create New...