Jump to content

Nico vd Schaaf

Member
  • Posts

    46
  • Joined

  • Last visited

Everything posted by Nico vd Schaaf

  1. Hi Marissa, Thanks for thinking along with me! I'm using the no. of occupants field ('Space'.'11_Number of Occu'). I guess you'll need to grab both the 'count' and the object ID from a particular row and combine them in order to add the correct count to the correct space object? It also would be nice to recalculate the WS that counts the symbols. I guess for this action a node is also needed? Regs, Nico
  2. Hi, I've found a node that can get a subrow value (of a database row). Now I'm looking for a node that can SET a subrow value. Does it exist? I've got a worksheet that counts symbols per space object. But I want the number to appear in a space label. Currently I use 2 WS to fix this: 1 WS that counts the symbols per space object and a second WS that just lists the space objects in which I manually type the symbol count (as shown in WS1) so it appears in the space label. I was hoping that Marionette could automate this process for me. Nico.
  3. Hi Takeshi, Looks very useful, but the Japanese language indeed is not very common to me :-)...I guess I'll need to wait for Nemetschek or someone else to drop some nodes... Nico
  4. I'm quite curious as well if there are any nodes available to handle materials (e.g. assign material to an object?). Did you get any response?
  5. After some more testing it seems that every time you open an drawing you have to resolve the objects that have the database connection by: - selecting them all - select ODBC in the info palet - find row by value (I used ID) - press ok Feels like a workaround but it works...
  6. I've got a connection between a drawing and a mysql database. Now when I close the drawing and reopen it and edit record information an error shows that the database can't be accessed? When I detach the record and re attach it again it works fine... This doesn't seem very useful. Anyone any idea?
  7. I've setup a database connection with an mysql database. I've created a record with a database connection. Next I've attached this record to a symbol in my resource browser. But when I add an instance of this symbol to my drawing nothing happens in my database. Only when I select ODBC in the info palet and choose to add a row the database the data is added to the mySQL database. Is it possible to make this automatically happen? Or do I always have to establish the object connection manually? Any feedback would be great. Thanks in advance!
  8. Well currently we've got people manually adding images to a list of furniture items. I've already setup a furniture library in VW and I'd like to expand it by adding an image to each item. So whenever an peace of furniture is placed on the drawing automatically the right image is shown in the list. In my opinion a spreadsheet cell would be enough. I'm not sure if the images are also included in de excel export function of VW21? Would be nice... What kind of workflow are you thinking of when speaking of a database?
  9. I'm eager to learn but there's no need to rush!
  10. Thanks! But how would I define the formula when I add that extra layer with the Image symbols on it? I couldn't get it to work with the name of the image symbol in a record field. I'm still curious how the plant tag is organized since that tool has the functionality in it that I'm looking for...as far as I can see it in online resources...
  11. Hi Pat, Thanks for thinking along with me. I guess something like the plant tag would help me the most but your second suggestion might do the job too...but I so far I can't get it to work. My setup: Symbol 1: a chair with a record ([RC] 82_furniture) attached to it with a text field (image) including the name of symbol 2 Symbol 2: an pgn image of the chair Now in the Worksheet I list the 'symbol 1' items. No big deal...but I can't manage to show the image of 'symbol' 2. What formula should I use? =IMAGE(S='[RC] 82_furniture'.'image') results in false =IMAGE('[RC] 82_furniture'.'image') results in just the text of the field... If I enter =IMAGE(S='82_Hay-AAC_IMG'), so the name of symbol 2, in an empty cell it does work but only when the symbol is in the drawing. Ideally I keep those symbols out of the drawing and call the image symbols from the resources... Please find my setup attached. chair.vwx
  12. I've posted this question also in the general discussion but maybe Marionette can help...not sure. Is it possible to link an image (png/jpg) to a symbol? I'd like to list symbols in a WS with a nice image next to it instead of an rasterized version of the symbol itself. I've seen an example of a plant tag which does the trick but I use architect and not landscape so I don't have access to that tag.
  13. Thanks Pat, I'm not sure if I can capture the results of that script in a worksheet? I've already created a workaround so I can use the standard criteria... It seems that custom scripts can be very helpful. Do you have tips on learning to write them? Nico
  14. I'm trying to filter not by IFC Entity but by a specific IFC Criteria of that IFC Entity type... a little background might clarify: I have lots of different types of floor finish slab styles (for carpets). Both the class of the slab and the slab component are the same. Otherwise I can't control the 2d appearance of the slab by class. All different carpet types would have the same color on the drawing. The only option is to change the color within the slab style itself...which I hate...I like to draw 'by class' as much as possible...So in the worksheet I can't use classes to filter. The easiest way for now is to name the components which I want to be grouped identically. E.a. 'carpet'. And add specific info on color etc. in the description field of the slab style. This way I could just use =DATABASE((COMP='carpet')) as formula and filter by =GETIFCPROPERTY('IfcSlab.Description')... But naming all the components 'floorfinish' isn't ideal...
  15. Is it possible to use an IFC property as a database criteria in a WS? I can use GET IFC Property as a function in a WS column but I want to use it as a filter in the database formula. When I enter =GETIFCPROPERTY('Pset_SlabCommon.Reference')='floorfinish' it shows true/false for each item but I want the false items to be removed from the list... any help would be appreciated!
  16. Is it possible to link an image (png/jpg) to a symbol? I'd like to list symbols in a WS with a nice image next to it instead of an rasterized version of the symbol itself. I've seen an example of a plant tag which does the trick but I use architect and not landscape so I don't have access to that tag. Perhaps Marionette can help?
  17. I'm confident too now... I'm not sure when the latest update was released (I guess more than 2weeks ago?) but in general I update immediately when a new SP is released...When I run into new bugs I'll get back here! Thanks!
  18. I lost the file and recreated it with a slightly different worksheet setup and guess what...now it works!? I really don't know why it didn't work previously. I'll extent my experiment to test if it's reliable...hopefully it is. It will save me a lots of time (and mistakes) counting...which I terribly hate... chair count.vwx
  19. Hi, I've been looking around for answers, but without the result I'm looking for... I try to create a worksheet that lists all the instances of a particular symbol and in which space it is placed. The closest I got was via: formula: =DATABASE(((S='74 WC 01') & (Sto='first'))) then 2 columns with: =s / =GetSpaceNumForObj I seems that the GetSpaceNumForObj looks for all the space objects below because it's also listing the space numbers of ground floor spaces. When I change 'first' into 'ground floor' it only lists the space numbers on the ground floor... when I add criteria to GetSpaceNumForObj (ea: (Sto='first')) it will prompt only true or false and no numbers.... Anyone any Idea how to fix this? Thanks in advance! Nico
  20. not sure if this is what you need but I created a room stamp (just the functionality...no layout) with room name, room area and apartment area...I also added the apartment nr. which is needed in the worksheet (named rooms) for 'summarizing' all the rooms of a certain apartment. In the worksheet you can just type in a value for the apartment area and it will be inserted in all the room stamps... Rooms only_NvdS.vwx
  21. can you provide a VW file with just the space objects?
  22. Hi, I don't fully understand the workflow. What do you mean by roomdatabase? Space object data can be captured by a worksheet directly...you don't need marionette for it. N.
  23. I'm setting up a worksheet retrieving values from space objects. First column contains a number, second column counts certain type of space objects and the third should multiply the value of the 1st and 2nd column...should... ...but it doesn't. I've put the formula =(VALUE(A1)*VALUE(B1) in C1 but it doesn't convert the number in B1 to an actual number (B1 has the formula =COUNT). The result in C3 is the value of A1... Surely I've done something wrong but I can't figure it out what so any help would be appreciated!
  24. I'm completely unfamiliar with Python so Marionette would be better I guess although Marionette has a great impact on the file size of VW document? So from that point of view Python might be better? In any case some help would be appreciated...😀!
  25. Thanks @Marissa Farrell... The command indeed works so for the moment there is a way...For the longer term a command as described would be really nice. Would that be a marionette script as well? Nico
×
×
  • Create New...