Jump to content

Sebastiaan

Member
  • Posts

    335
  • Joined

  • Last visited

Posts posted by Sebastiaan

  1. Hi all,

     

    I am trying to make a database row based on Lighting devices and I want to set a criteria on the Channel field. In the lighting device record this is a text field.

     

    I want to set a filter to show only the lighting devices with a channel number between 1 and 100. But since it is a text field, the criteria field value '<=' and '>=' do not work. I tried to use a value function in the database formula but this does not work when I try it. Is it possible? Or am I doing it wrong? 

     

    This is how I tried to use the value function in the formula:

    =DATABASE((NOTINDLVP & NOTINREFDLVP & (PON='Lighting Device') & (VALUE('Lighting Device'.'Channel')>='1') & (VALUE('Lighting Device'.'Channel')<='100')))

     

    This way gives the desired result, but is a very long formula to edit:

    =DATABASE((NOTINREFDLVP & NOTINDLVP & (PON='Lighting Device') & (R IN ['Lighting Device']) & (('Lighting Device'.'Channel'='1') | ('Lighting Device'.'Channel'='2') | ('Lighting Device'.'Channel'='3') | ('Lighting Device'.'Channel'='4') | ('Lighting Device'.'Channel'='5') | ('Lighting Device'.'Channel'='6') | ('Lighting Device'.'Channel'='7') | ('Lighting Device'.'Channel'='8') | ('Lighting Device'.'Channel'='9') | ('Lighting Device'.'Channel'='10') | ('Lighting Device'.'Channel'='11') | ('Lighting Device'.'Channel'='12') | ('Lighting Device'.'Channel'='13') | ('Lighting Device'.'Channel'='14') | ('Lighting Device'.'Channel'='15') | ('Lighting Device'.'Channel'='16') | ('Lighting Device'.'Channel'='17') | ('Lighting Device'.'Channel'='18') | ('Lighting Device'.'Channel'='19') | ('Lighting Device'.'Channel'='20') | ('Lighting Device'.'Channel'='21') | ('Lighting Device'.'Channel'='22') | ('Lighting Device'.'Channel'='23') | ('Lighting Device'.'Channel'='24') | ('Lighting Device'.'Channel'='25') | ('Lighting Device'.'Channel'='26') | ('Lighting Device'.'Channel'='27') | ('Lighting Device'.'Channel'='28') | ('Lighting Device'.'Channel'='29') | ('Lighting Device'.'Channel'='30') | ('Lighting Device'.'Channel'='31') | ('Lighting Device'.'Channel'='32') | ('Lighting Device'.'Channel'='33') | ('Lighting Device'.'Channel'='34') | ('Lighting Device'.'Channel'='35') | ('Lighting Device'.'Channel'='36') | ('Lighting Device'.'Channel'='37') | ('Lighting Device'.'Channel'='38') | ('Lighting Device'.'Channel'='39') | ('Lighting Device'.'Channel'='40') | ('Lighting Device'.'Channel'='41') | ('Lighting Device'.'Channel'='42') | ('Lighting Device'.'Channel'='43') | ('Lighting Device'.'Channel'='44') | ('Lighting Device'.'Channel'='45') | ('Lighting Device'.'Channel'='46') | ('Lighting Device'.'Channel'='47') | ('Lighting Device'.'Channel'='48') | ('Lighting Device'.'Channel'='49') | ('Lighting Device'.'Channel'='50') | ('Lighting Device'.'Channel'='51') | ('Lighting Device'.'Channel'='52') | ('Lighting Device'.'Channel'='53') | ('Lighting Device'.'Channel'='54') | ('Lighting Device'.'Channel'='55') | ('Lighting Device'.'Channel'='56') | ('Lighting Device'.'Channel'='57') | ('Lighting Device'.'Channel'='58') | ('Lighting Device'.'Channel'='59') | ('Lighting Device'.'Channel'='60') | ('Lighting Device'.'Channel'='61') | ('Lighting Device'.'Channel'='62') | ('Lighting Device'.'Channel'='63') | ('Lighting Device'.'Channel'='64') | ('Lighting Device'.'Channel'='65') | ('Lighting Device'.'Channel'='66') | ('Lighting Device'.'Channel'='67') | ('Lighting Device'.'Channel'='68') | ('Lighting Device'.'Channel'='69') | ('Lighting Device'.'Channel'='70') | ('Lighting Device'.'Channel'='71') | ('Lighting Device'.'Channel'='72') | ('Lighting Device'.'Channel'='73') | ('Lighting Device'.'Channel'='74') | ('Lighting Device'.'Channel'='75') | ('Lighting Device'.'Channel'='76') | ('Lighting Device'.'Channel'='77') | ('Lighting Device'.'Channel'='78') | ('Lighting Device'.'Channel'='79') | ('Lighting Device'.'Channel'='80') | ('Lighting Device'.'Channel'='81') | ('Lighting Device'.'Channel'='82') | ('Lighting Device'.'Channel'='83') | ('Lighting Device'.'Channel'='84') | ('Lighting Device'.'Channel'='85') | ('Lighting Device'.'Channel'='86') | ('Lighting Device'.'Channel'='87') | ('Lighting Device'.'Channel'='88') | ('Lighting Device'.'Channel'='89') | ('Lighting Device'.'Channel'='90') | ('Lighting Device'.'Channel'='91') | ('Lighting Device'.'Channel'='92') | ('Lighting Device'.'Channel'='93') | ('Lighting Device'.'Channel'='94') | ('Lighting Device'.'Channel'='95') | ('Lighting Device'.'Channel'='96') | ('Lighting Device'.'Channel'='97') | ('Lighting Device'.'Channel'='98') | ('Lighting Device'.'Channel'='99') | ('Lighting Device'.'Channel'='100'))))

     

    Any thoughts?

  2. 50 minutes ago, Pat Stanford said:

    That is part of what makes this forum great. You have access to a number of nerds who have spent far too long digging into the depths of the documentation (and code) to figure some of this stuff out.

     

    I am looking at @MullinRJ, @Sam Jones, @JBenghiat. I apologize to all the rest of you who have helped me out over the years and am am drawing a blanks on right now.

     

    I think the programming community here for Vectorworks is probably the most helpful (and polite) group I have ever experienced.

     

    I am very happy that all of you are here!

     

    All of you have inspired me to follow an online Python course, and now I am trying to use that basic knowledge to make my own magic and it's going quite well!

     

    But I would never be able to, without all the helpful users,  information and example code in this forum!

     

     

  3. On 9/29/2020 at 5:54 PM, Pat Stanford said:

    Python:

    def  vs.AddWSColumnOperator(worksheet, databaseRow, column, operatorType):

       return None

     

    With an operatorType of 2.

     

     

    The inverse function is vs.HasWSColumnOperator.

     

    I have no idea why these are named this way instead of using the standard Get and Set names.

     

    Sorry for the late reply, but thank you! This works well.

     

    No wonder I could not find it, not only is the naming convention different than the other functions, but also the sum values operatortype 2 is not explained in the developer page?

     

    https://developer.vectorworks.net/index.php/VS:AddWSColumnOperator

  4. Hi all,

     

    I'm taking my first steps in to Python scripting in Vectorworks. My first project is a worksheet script to create some database rows in a worksheet.

     

    What i could not find in the function reference is how to set the 'sum values' option for a column in a database row. Is there a script function for that?

     

    I found 'SetSprdSortSumColumns' to set summarize and sort, but could not see how to set 'sum values'.

     

    Thank you,

     

    Sebastiaan

  5. 16 hours ago, MartinBlomberg said:

    Now I've found a lot of icons, thanks to the info given, cheers! But still, I lack a lot of tool icons and stuff, are they located some other place? 
    Cheers!

     

    Some Icons are also hidden in individual plugin files in the plugin folder within the application folder.

     

    for instance many spotlight tool icons are hidden in spotlight.vwlibrary (richt mouse click 'show package contents' on a mac). Any .vwlibrary file could have some images in it, many don't but some do. A lot of work to check them all I know 😉

     

    Also there are a couple of icons that I couldn't find anywhere that where hidden somewhere deeper. In that case I made a screenshot of those.

  6. 12 minutes ago, MartinBlomberg said:

    Wow, awsome!! Thank you so much!

     

    May I ask, is there a way to get these icons from you, or can I extract them from the SD somehow? 

     

    Thanks!

     

     

    You’re welcome.
     

    Individual tool icons can be found in the VW installation. Jim Wilson explained in this topic were they  can be found. I have not extracted the new 2020/2021 tool icons yet. So you would have to get them yourself. 
     

    Also in the topic below  you can learn how to get the toolset icons from a workspace file. 
     

    hope that helps you! 
     

     

    • Like 1
  7. BTW for maintenance of old files I could imagine the need to edit you could try to edit the field in The recourse manager.
     

    If you right click the lighting device in the recourse manager and click ‘attach record’, look up the Light info record, and then edit values. There you can edit the field. 

    • Like 1
  8. It is a field containing a string value that acts as a filter for VW to find a fixture mode. Simply said it contains the fixture name 
     

    it used to be visible in the OIP, but was placed in the background in vw2020. 
     

    there is no need to edit it, it does it’s work in the background. 
     

    The name fixture ID is often mistaken as channel number or fixture numnber as these terms are often used in the field. But that is not what it is in VW. 

  9. 11 hours ago, SamIWas said:

     

    This is what I do currently.  And it works, but is error prone if I forget to run the script.

     

     

    This is something I need to look into.  Maybe that would;d be a decent short-term solution.


    by the way. In Label legends I do place the circuit name and circuit number next to each other. It works fine the only downside is that you can not center the two fields as one. 
     

    also did you know that in the label layout you can group all fields together? This wil make your label behave as one object. 

  10. I agree this should be possible. Especially when you use multiple fields next to each other then the alignment in the legend becomes much better. 
     

    There are two things you can do at this moment. 
     

    use a data tag. In data tags there are dynamic text fields where you can combine mutliple fields into one. Which you can then center align for instance. 
     

    also you could use a script to concatenate the desired fields into one. In the AutoplotVW Plug-ins there is a menu command called copy field to field which will do exactly what you want. 
     

    but this will require you to run it each time you make updates  to your plot. 
     

    what we really want is dynamic text fields in label legends! 

  11. 2 hours ago, Adam M said:

    Is this possible to get the link again? 
    every time I try it says the link has expired??

    would be great to get a plugin! Vectorworks? 
     

    also just ordered a Spacemouse! Wow they look so damn cool! 🙂

     

    Hi, I just tried the link and it still works. Maybe try it from a different browser?

     

    Did you upvote the request? (little black arrow at the left upper corner of the topic, will turn green when you click it)

  12. 13 minutes ago, Company Call said:

    @Sebastiaan Did you received any feedback on this?

    I'm having the same issues with it... 

     

     

     

    Thanks!

    Hi, I recieved the following answers from tech support. The issues did not make it to SP4, my workaround is to not use schematic views until they work as desired ;-):

     

    That is correct, currently it unpacks the schematic at the origin, piling elements on top of one another. If not using hanging positions It’s best to select individual pieces of truss 1 by 1 and create schematics of each separately and then arrange them. This workflow is being worked on and will be improved shortly.

     

    My apologies, completely forgot to answer the other questions.

    I think the orientation of the schematic is hopefully going to be adresed in SP4

    the other issues…

    A lot of movements of devices in the schematic views leed to out of date schematic view geometry?

    This is correct you can use the select similar tool to select all of the schematics and click update on the Object Info Pallatte.

    And also it is not possible to move a device in the schematic view from one truss to another?

    This is also correct, fixtures should be moved on the truss not the schematic. However if you insert a new lighting device into a schematic it will spawn that fixture on the truss. I think this should be on the feature request list.

  13. You need to apply a texture. This is done in the object info palette. 
     

    I would advise you to check out one of the free courses in the online vectorworks University. 
     

    There are some basic rendering courses there that will help you on your way. 

  14. Hi All,

     

    I've been testing my workflows on the schematic views. I ran into some issues, I am working on 2020 SP3. I did not convert to hanging position. The file is a new 2020 blank metric file.

     

    I have 4 sticks of truss each truss has 1 fixture attached to it. If I make a schematic view from those, the placement, rotation and order of the fixture gets messed. This happens both in top and front view the first image below is the actual truss and fixture geometry, the second and third is the schematic view made from it. 

    47604353_ScreenShot2020-06-08at10_12_22.thumb.png.d217d355b98f29ccbc2294514568f5a2.png

    158337490_ScreenShot2020-06-08at10_16_44.thumb.png.aeab1f786006fe0bd2a90d03c716c25a.png

     

    317528820_ScreenShot2020-06-08at10_16_50.thumb.png.179733a4c341afe7c4ad31ae8430bc15.png

     

    If I put all 4 lighting devices on one piece of truss then the order and placement is correct, but the rotation is wrong. The first image below is the actual truss and fixture geometry, the second is the schematic view made from it:

    1699934148_ScreenShot2020-06-08at10_12_26.thumb.png.13a5069e743b64e793c444b480880665.png

    1872295611_ScreenShot2020-06-08at10_16_56.thumb.png.2af99cf0ec0cc0d6bf8c24421eae01b9.png

     

    A lot of movements of devices in the schematic views leed to out of date schematic view geometry. And also it is not possible to move a device in the schematic view from one truss to another. Again the first image below is the actual truss and fixture geometry, the second is the schematic view made from it:

     

    109612989_ScreenShot2020-06-08at10_41_04.thumb.png.15f2651bb312a13ae99e1cdd673af614.png1897835401_ScreenShot2020-06-08at10_40_57.thumb.png.c3bb2bd1647bc71e36e7281e8e021e48.png

     

    Is there a workaround to avoid these issues? I did try to use a hanging position but that led to a very long conversion time and this schematic view also had issues. I did not continue testing those as I understood the truss system workflow is the way the program is headed now.

     

    The VWX is attached.Schematic test.vwx

     

     

     

  15. On 12/18/2019 at 5:13 PM, Sebastiaan said:


    hi Yordan,

     

    we are aware of the “restart at function”. 
     

    the request is that for instance the Circuit name can Increment at the moment of restart at of the Circuit Number. So we don’t have to manually enter the next circuit name. 
     

    this could be useful in other fields that have a close relation just as Circuit number and circuit name. 


    in 2020 this functionality was added to Universe and DMX address. This is great already! The universe can increment upon the restart of the DMX address. 
     

    I would love to see it extended to at least the circuit number and Circuit name. They are related to each other just like universe and DMX address. 

  16. Hi All,

     

    I hav been experiencing an issue with the rendering of lighting devices.

     

    The light from the lighting devices does not render unless I perform a 'refresh instruments' or turn them off and on again. 

     

    If I open the file then they do not render, If I refresh and then save again and reopen the file then the lights still do not render untill refreshed or toggled off and on.

     

    This also means that cloud renderings return without the lighting rendered as the refresh is not performed in that case. 

     

    Is this an issue or do I have a setting that I have missed?

     

    It only happens to spotlight lighting devices, I tested it with a light from the light tool and then then the lights render without issues upon file open. 

     

    Attached is a file, created from a blank metric file, where it happens

     

    Thank you and regards,

     

    Sebastiaan

     

    LIT FOG TEST.vwx

  17. I have a razor naga trinity with 12 macro button under my thumb I have:

     

    duplicate array

    Move by points

    select similar 

    Normal perspective view
    orthogonal view

    paste in place

    OpenGl

    Wireframe

    Custom renderworks

    set lighting options. 

    Spotlight numbering 

    Find an Modify


    after some practice I can find those buttons without thinking now. 
     

    it has left, down and right scrollwheel click and I put spaces and Expose under that. So it can do everything the Magic Mouse can do. 
     

    Spacemouse and streamdeck on the other side. 
     

    3CD38F1E-3B4D-4BEC-9764-EAF34584E3FD.thumb.png.56cb99f25b619a267e22b93217d1bf30.png

     

     

     

     

    • Like 2
  18. 3 hours ago, ChrisK said:

    I also wanted a flatter file structure so I didn't have to drill down so much to access our symbols in RM.  We've set up our template so we don't use more than 2-3 of the tool boxes.  Too much clicking!   My solution was to create a separate blank .vwx file for each "category" and save it in a Libraries folder within a Workgroup folder on our network.  In User Folder tab of User Preferences, I added the path to the Workgroup folder.  To see the files (and everytime after a VW Library Update), I have to restart vw2020, open any file and refresh the Workgroup library.  THEN the Workgroup files show up.  Yes, VW will populate the Workgroup folder with all the empty folders, jic you want to use those files for a particular tool or keep to their file organization structure.  They don't show up unless there's a file in them.

     

    I would be apprehensive to change the user folder to the same location as the workgroup folder. The user folder also holds the licensing information files etc. I's rather have that hidden somewhere in the application folder. 

     

    My workaround was to place an 'alias' quicklink from my personal workgroup library folder and I put that quicklink in one of the VW specified folders. That way I can now always acces my own folder structure in the Resource Selector (with one extra click). But I believe that difference between the RM and the RS should not exist. 

×
×
  • Create New...