"Component Designation" Column value as Custom or Parametric are not working on customize valve.

[hyrro_velasquez]

Hi Sir/Ma'am,

Good day,

I've been on this issue for a long time now, and still I really cant find any solutions to this.

I've already tried to export and import an excel file via "Full spec data export" so I can change the "Component Designation" column value as "Custom" or "Parametric", hoping that it will solve my problem for the part geometry not showing under the part property of my custom component created via python script, when placed on the plant 3D workspace. But unfortunately it still does not show on part property.

I also tried to change the "Component Designation" column value via Edit parts window on Part List tab, setting it's value to Custom, but unfortunately when placed on Plant 3D workspace, still the part geometry/Dimensions under Part Properties still does not show, and still there is no way for me to edit it's dimensions once its placed on the workspace. I'm really on a dead end here, is there any one encountered this issue?, please if you could give me some information regards to this issue I'll appreciate it sooooo muuuuuuuuuccchhhhh.

Also this is my python script, may be there is something that I'm doing wrong or I'm missing something, that cause the dimensions not to show on my parts geometry that others might know about, please correct me. thank you so much in advance.

from aqa.math import *
from varmain.primitiv import *
from varmain.custom import *
@Anonymous(Group="Valve", TooltipShort="BALLVALVE999", TooltipLong="BALLVALVE999", LengthUnit="mm", Ports=2)
@group("MainDimensions")
@param(PIPE_OD=LENGTH, TooltipLong="Outside diameter of the flange")
@param(PIPESIZE=LENGTH, TooltipLong="Outside diameter of the flange")
@param(L=LENGTH, TooltipLong="Graphics flange Diameter")
@param(H=LENGTH, TooltipLong="Graphics flange Diameter")
@param(D=LENGTH, TooltipLong="Graphics flange thickness")
@param(H1=LENGTH, TooltipLong="Graphics flange thickness")
def BALLVALVE999(s, PIPE_OD = 60.3, PIPESIZE = 50, L = 178, H = 143, D = 230,H1 = 165,ID = 'BALLVALVE999',**kw):
#VALVE
  B = CYLINDER(s, R=PIPE_OD/2,H=L,O=0).rotateX(0).rotateX(270).translate((0,0,0))
  B1 = CYLINDER(s, R=PIPE_OD/2+H1/10,H=L,O=0).rotateX(0).rotateX(270).translate((0,0,0))
  B2 = CYLINDER(s, R=H1/2,H=L/9,O=0).rotateX(0).rotateX(270).translate((0,0,0))
  B3 = CYLINDER(s, R=H1/2,H=L/9,O=0).rotateX(0).rotateX(270).translate((0,L/2,0))
  B4 = CYLINDER(s, R=H1/2,H=L/9,O=0).rotateX(0).rotateX(270).translate((0,L/2 + L/9 + 1,0))
  B5 = CYLINDER(s, R=H1/2,H=L/9,O=0).rotateX(0).rotateX(270).translate((0,L - L/9,0))
  B6 = CYLINDER(s, R=H1/2.5,H=L/2 - L/9,O=0).rotateX(0).rotateX(90).translate((0,L/2 + L/9,0))
  B7 = CYLINDER(s, R=L/6,H=(H+H/2.5)-(H/7)*2,O=0).rotateX(0).rotateX(0).translate((0,L/2-(L/6)/2,-H/2.5))
  B8 = CYLINDER(s, R=L/3,H=(H/7),O=0).rotateX(0).rotateX(0).translate((0,L/2-(L/6)/2,((H)-(H/7)*2)))
  B9 = CYLINDER(s, R=L/7.5,H=(H/7),O=0).rotateX(0).rotateX(0).translate((0,L/2-(L/6)/2,((H)-(H/7))))
#NUTS 
  B10 = CYLINDER(s, R=(H/6)/2,H=(L/9)/1.5,O=0).rotateX(0).rotateX(270).translate((0,L/2 + L/9*2 + 1,H1/3))
  B11 = CYLINDER(s, R=(H/6)/2,H=(L/9)/1.5,O=0).rotateX(0).rotateX(270).translate((0,L/2 + L/9*2 + 1,-H1/3))
  B12 = CYLINDER(s, R=(H/6)/2,H=(L/9)/1.5,O=0).rotateX(0).rotateX(270).translate((H1/3,L/2 + L/9*2 + 1,0))
  B13 = CYLINDER(s, R=(H/6)/2,H=(L/9)/1.5,O=0).rotateX(0).rotateX(270).translate((-H1/3,L/2 + L/9*2 + 1,0))
#HANDLE 
  B14 = BOX(s, L=D, W=H1/12, H=H1/10).rotateX(0).rotateX(0).translate((0,D/2 + (L/2-(L/6)/2),-(H1/12)/2+H)) 
#port points
  s.setPoint((0, 0, 0),(0, -1, 0))
  s.setPoint((0, L, 0),(0, 1, 0))
  #s.setLinearDimension('Par_L',(0.0, 0.0, 0.0),(0.0, Par_L, 0.0))
  return

[李榕华|Ronghua.LI]

Yes, I have the same problem.

[hyrro_velasquez]

We are two unfortunate people I guess😣

[h_eger · Accepted solution]

Dear @hyrro_velasquez ,

@李榕华|Ronghua.LI ,

[李榕华|Ronghua.LI]

Look at @h_eger  reply. 

It's a little cumbersome to operate, but it's really useful.

[李榕华|Ronghua.LI]

Thank you for your reply, which solved the problem that has puzzled me for a long time.

[李榕华|Ronghua.LI]

I have two more questions. Please help me to answer them when you are free.

1、Does the “ComponentDesignation” attribute have other values besides Custom and Placeholder?

2、How should I query the PnPID of a valve so that I can quickly find it in Piping.dcf.

[hyrro_velasquez]

Dear Sir @h_eger 

Sir thank you so much for your feedback,regards SQL for Plant 3D objects, I was able to convert my project SQLite to SQL Server using "PnPProjectMaintenance.exe". But I'm new to this part of Plant3D, that's why I just wanna ask about, how can I reflect/apply the changes I made from "dbo.EngineeringItems" table specifically on my custom valves Component Designation column, to my project model or spec?. Again thank you so much for your help on this forum. I'm forever grateful.🙏

[hyrro_velasquez]

Dear Sir @李榕华|Ronghua.LI 

regards to your question no. 1, hope this helps.

[李榕华|Ronghua.LI]

Changes in SQL server are reflected in the project model.

[hyrro_velasquez]

Sir @李榕华|Ronghua.LI 

Does the project model automatically update after you made changes to SQL server?

in my case, it still does not make my parts geometry appear in my valve properties after I update the "ComponentDesignation" column. Even if I placed a new valve model in the plant 3D workspace still does not do any changes in the property. hope you can help me in this one, can you give me some simple procedure, like what to do next after I updated the value?. thank you so much.

[hyrro_velasquez]

Sir @李榕华|Ronghua.LI  Sir @h_eger 

I just wanna ask also, before converting from SQLite to SQLserver, I copied my project folder from my local drive to our server e.g.  "asa10099\plant3d" then I convert, then all the database are created on the SQL server after convertion. Do I need also to copy my python files from "C:\AutoCAD Plant 3D 2021 Content\CPak Common\CustomScripts", on the server? does this will make any difference? sorry for so many question, I just cant seem to find the answers I'm looking for. but then again thank you very much for you feedbacks.

[李榕华|Ronghua.LI]

What you have changed will be updated in time, but what you put later needs to be changed.

[h_eger · Accepted solution]

Dear @hyrro_velasquez ,

It makes sense to copy the content folder on the server as well, since all Plant 3D project employees can then access the same content.

[Ray_K]

I created a python custom valve with Component Designation set to "Custom" in both Catalog and Spec. It also shown on Piping.dcf(EngineeringItems) as "Custom"

I am not sure why the valve parameters not shown on the Properties tab. I tried also Component Designation set to "Parametric". Where did I do wrong?

[h_eger]

Dear @Ray_K ,

This post should provide information about your problem

https://in-the-pipes.typepad.com/in_the_pipes/2017/12/sunnyside-up-secrets-in-plant-3d-201811.html?u... 

[Ray_K]

@h_eger 

Yes, I followed the approach mentioned on that article. I tried "Custom" and "Parametric" but the parameters of my custom valve that I created using python is not working.

I specified "Custom" both on Catalog and Spec. I even check the Piping.dcl(EngineeringItems) sqllite database. I used the same manner on my Custom Pipe Supports and it works as expected.

Is the "component designation" applicable to all catalog components?

Thank you.

[h_eger]

Dear @Ray_K ,

I can only test parametric valves and they work with "Custom" and "Parametric"

[Pranav_KapoorERAJN]

Hello, for "Supports" in the plant3D supports catalog, is there a way to fix the dimensions so users cannot change them?

[h_eger]

@Pranav_KapoorERAJN ,

No, this is not possible because it was introduced in Plant 3D 2016 at the request of the users.