Jump to content

David Dauphin

Member
  • Content Count

    19
  • Joined

  • Last visited

Everything posted by David Dauphin

  1. David Dauphin

    Total truss lenght in worksheet

    Hello, In my truss worksheet (with spotlight truss tool), I want to display total weight of the system, and total length. No problem for total weight, but the same formula can't calculate total length. The results are always the number of truss that have truss length record in database. And systematically, each row length field is followed by "mm". Perhaps, it is why sum can't be calculate? If i build with symbols trusses instead of truss tool, there is no problem to calculate total length of system. Worksheet with tool truss and error calculate total length : Worksheet with symbol truss and total length good result :
  2. David Dauphin

    Light Info Record fields

    Hello, After 2 hours of searching how to sum my projectors weight and wattage in a worksheet, I finally find that it wasn't possible with those original databases 'Light Info Record' and 'Light Info Record M' ! The issue is that weight and wattage are text fields ! So I change them to number fields and then I'm able to sum weight and wattage in a worksheet ! But then, there is another problem : when you change fields from "text" to "number" you have to put a default value, and then, all youy projectors loose their weight and wattage ! Then you had to manually update every projector's weight and wattage! It will be convenient to fix those kinds of fields in "number" instead of "text" no? I know that users could do mistake by filling fields with multiple units (kg, lb, g, t, ...W, kW, ....) but it could be mentioned weight in kg and wattage in W by exemple. For exemple, lenght in 'truss record' are always in mm, and when you know that, there is no problem. Fields that I change to be able to sum weight in my worksheets :
  3. David Dauphin

    Connected corners inversion down-up

    Hello, I've got an issue with inserting truss corners X30D : When I'm connecting a down corner to down trusses, this corner inverses vertical position !
  4. David Dauphin

    Light Info Record fields

    @Rob Books thanks Rob. Effectively, if I set numbers to 'dimensions', worksheet display the lenght unit of the file (cm, mm, m, inch...). So I had to set it to 'general' as you said, and add suffix 'kg' and 'W'. But there still remain a problem : if I put another projector and I erase 'Light Info Record' when importing this new projector, so this database has agin 'weight' and 'wattage' in text fields. Is there a chance to corrige that in future upgrade?
  5. David Dauphin

    Connected corners inversion down-up

    @Rob Books For example, this is my file. I can't create the truss properly, and bracework can't calculate it. truss1.vwx I'm an old VWX user (since 1998) but a new Spotlight user for 2 weeks... maybe I don't manipulate correctly Spotlight tools?
  6. David Dauphin

    Total truss lenght in worksheet

    @Robert Janiak Thanks Robert, yes this method is OK. But usually, I don't show unit mark in my drawings. That's why I would like to have function like 'UnitFile' in my worksheets.
  7. David Dauphin

    Spotlight trussing and BraceWorks

    Hi, I'm a 20 years Vectorworks users, and work with my own truss librairies and data record since beginning. Now I want to use fabulous Bracework so I have to learn to work with spotlight trusses. It will be easier if I was a new beginner ūüėČ I've got same problem than you. For hinges, and also with rounded truss, and mostly with ground support calculations ! I hope those lacks of functions will be soon available ! I've seen your video too @SCParker . For hinge, I've got 1/2 bookend symbols. Do you think I can integrate them into braceworks? This is a typical truss that I would like to calculate with Braceworks :
  8. David Dauphin

    Total truss lenght in worksheet

    Another things : Do you know how I can display my unit file after formula "=SOMME(G3)" It's not good to add "suffix" because if unit changes then "suffix" you added don't change automatically. It may be a field like FileUnit or something like that ? That's what I mean with "suffix" in a french version :
  9. David Dauphin

    Total truss lenght in worksheet

    @Robert Janiak @Sam Jones thank you guys ! Yes Robert it solves my problem with 'trussitem' THANKS !!! Me too I would like to know difference beetween TrussItem and Truss Record.
  10. David Dauphin

    Total truss lenght in worksheet

    @Sam Jones Hi Sam, Have you test my file? may I have yours to compare it whith mine? Thanks.
  11. Hello, A question to Vectorworks Spotlight developers : Could it be possible to have more fields in truss record database? It may be useful to have connections forks needed for the system, and total volume of system. I used to work with truss symbol instead of spotlight truss, and all my trusses have connections forks quantities (2 for ladder truss, 3 for triangle truss, 4 for square truss, 1x2 or 1x3 or 1x4 for 2D corner, 2x2 or 2x3 or 2x4 for 3D and 4D corners, ...). And then, order picker in stock have exact quantity of each truss and total connections forks needed. Volume may be useful too, to approximatly know what trucks size needed (20m3, 30m3, 40m3, ...100m3) Yes I know that I could duplicate spotlight truss libraries and customize them using "User fields 1", 2, 3, ... But it may be useful for everyone to have those fields, no? Many thanks to ear this request. Here an example of old system build with truss symbol (and no spotlight truss tool). Connections forks are "Goupilles & sécu en sus", and volume is "Cubage colisé" in my french worksheet :
  12. David Dauphin

    More fields in "Truss record" Database

    Sorry, my english is not so good, and Google can't traduct "the generic cheeseborough object" in french. Can you explain me or show me a screenshot please ?
  13. David Dauphin

    More fields in "Truss record" Database

    Thanks Tom. OK I will do like that too.
  14. David Dauphin

    Total truss lenght in worksheet

    Hi Sam, here is my file. I'm working with metric length and VWX 2019 french version :Trusses-worksheet.vwx
  15. David Dauphin

    More fields in "Truss record" Database

    Thanks Rob, Keep this request in mind ūüėČ
  16. David Dauphin

    More fields in "Truss record" Database

    Thanks Rob, I understand your contraints. No problem. Other questions : to do that on my own, is it the correct way : - I had to duplicate a truss library in /Applications/Vectorworks 2019 FR-FR/Bibliothèque/Objects - Ent Truss/...., - edit this duplicate files with my personnal user fileds data to have my worksheet with the data I need And after I can use this duplicate files in Spotlight AND Braceworks too? The disavantage is I had to edit duplicate files each time that there's an update on original libraries?
  17. Hello, I've got troubleshooting with Videoscreen tool, or I make a mistake? I can't see "Show Coverage zone" and "Show Zoom Range" even if boxes are checked. I've got Landru plug-in and videoscreen created with this plug-in can display those coverage zone and zoom range. Thanks for your support. With VWX2019 tool and 2 boxes checked : With Landru tool and 2 boxes checked :
  18. Hello, I need to have informations on my hoists presentation layer (n¬į,X,Y,...) and I need IMAGE in worksheet display the object with those informations. It's not readable on the final worksheet. I know that if I put simple hoists without information and stack them in the foreground, IMAGE are OK but I can't do that, my totals will be false with those extra hoists. Maybe is it possible to notify in formula to don't show informations on the IMAGE? Like a "NoLabel" argument? For example, one of my formulas is : =IMAGE(('HoistVW'.'Type'='1/4 Ton') AND ('HoistVW'.'Function'='Audio')) (sorry for bad english, i'm a french user) Thanks everyone for your support. Worksheet not readable with hoist labels : Worksheet OK and readable without hoist labels : My hoists must be like that on my final layer, with labels
  19. David Dauphin

    Hoist Symbols in worksheet flipped

    Hello, I've got similar issue. I need to have informations on my hoists presentation (n¬į,X,Y,...) and IMAGE in worksheet display the object with those informations. It's not readable on the final worksheet. Yes, if I put simple hoists without information and stack them in the foreground, IMAGE are OK but I can't do that, my totals will be false. Maybe is it possible to notify in formula to don't show informations on the IMAGE? My formula is : =IMAGE(('HoistVW'.'Type'='1/4 Ton') AND ('HoistVW'.'Function'='Audio')) (sorry for bad english, i'm a french user) Thanks for your help

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

√ó