Jump to content

WORKSHEET CREATION


Recommended Posts

Hello there, 

 

Awesome explanations, @Pat Stanford, thank you for that. 
 

My VW is set in French and

  =(Door.Width)

doesn't seem to work. I use a PIO which is called Porte. In the OIP there is a field called "Largeur de la porte" 

 

 =(Porte.'Largeur de la porte')

doesn't work neither. 
 

Questions : 

Does your trick work for each PIO ? 
How do you get the name of a PIO ? Is it the one written at the top of the OIP ? Is there an official English name hidden somewhere ? 

Link to comment

Make a script from the script in this post.  Place a single instance of the Porte PIO on the design layer (not in a wall) and leave it selected. Run the script. It will product a worksheet showing exactly the Record and Field names that you need to use.

 

 

If not, post a file with a single instance of a Porte and I will take a look.

 

HTH

  • Like 1
Link to comment

Thank you very much for this, @Pat Stanford. I will share here the conclusions for other VW CH_FR users (Potentially 2.2 mio users 🙂)

 

1) My door is a 'Door CW' not a 'Porte'

2) The fields in the OIP are actually translated from German. So you need to call them in German. 

3) The IFC fields are always in English. 

4) If you click on the little arrow in a cell and select "Database" and the PIO you want ("Door" or "Window" or whatever) you will find a list of all parameters you can use. 

 

So what I was looking for was : 

='Door CW'.'BaseQuantities_Height'/10 (/10 because BaseQuantities are in mm but I work in cm)

='Door CW'.'BaseQuantities_Width'/10

='Door CW'.'Türhöhe' 

='Door CW'.'Türbreite' 

='Window CW'.'BaseQuantities_Height'/10

='Window CW'.'BaseQuantities_Width'/10 

='Window CW'.'Fensterhöhe'

='Window CW'.'Fensterbreite'

 

 

 

 

 

Edited by Stéphane
  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...