Jump to content

matteoluigi

Member
  • Posts

    460
  • Joined

  • Last visited

Posts 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...)

     

    779482036_Bildschirmfoto2022-05-19um16_23_07.png.3f1d44deaa6d8489d5738aec2cc0bb0c.png

     

     

    IF OR.zip

  2. 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

  3. 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?

  4. 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 😉

    • Like 1
  5. 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)

  6. 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)

  7. 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...

  8. 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!

    • Like 1
  9. 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.

     

     😞 

     

     

     

     

  10. 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

  11. 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 😉

     

    Bildschirmfoto 2022-02-22 um 10.18.13.png

    • Like 1
  12. 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.

×
×
  • Create New...