Jump to content

Nico vd Schaaf

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Nico vd Schaaf

  • Rank

Personal Information

  • Homepage
  • Location

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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...
  2. 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?
  3. 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!
  4. 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?
  5. I'm eager to learn but there's no need to rush!
  6. 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...
  7. 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
  8. 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.
  9. 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
  10. 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...
  11. 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!
  12. 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?
  13. 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!
  14. 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
  15. 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


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.

  • Create New...