PDMS管理員：導出MTO文件 配置步驟（MTO report）

helloshigy

PDMS導出MTO管件數量的方式是：點擊菜單欄的“utilities-standard reporting-reports”，run或者modify一個模版（推薦modify，直接run無法運行system command命令。）


MTOC MTOH MTOT Setting：屬性說明及圖示

---

Attribute	Object	Value
MTOC	Piping components (include ELBO, FLAN, ATTA, INST, VALV, etc.; exclude TUBI)	ON or unset	component shows in drawing normally and material list/MTO; e.g., set right flange MTOC=ON:
		OFF	component shows in drawing normally, but not in material list/MTO; e.g., set right flange MTOC=OFF:
		DOTD	component shows in drawing in dotted lines, but not in material list/MTO; e.g., set right flange MTOC= DOTD:
		DOTU	component shows in drawing in dotted lines, but not in material list/MTO, and dimension line will not show; e.g., set right flange MTOC= DOTU:
MTOH	TUBI directly connected to the head of branch	ON or unset	TUBI shows in material list/MTO
		OFF	TUBI not shows in material list/MTO
		DOTU	TUBI not shows in drawing in dotted lines, but not in material list/MTO, and dimension line will not show;
		DOTD	TUBI not shows in material list/MTO
MTOT	TUBI not directly connected to the head of branch	ON or unset	TUBI shows in material list/MTO
		OFF	TUBI not shows in material list/MTO
		DOTU	TUBI not shows in drawing in dotted lines, but not in material list/MTO, and dimension line will not show;
		DOTD	TUBI not shows in material list/MTO

Note: the recommended way is to use command to set the attribute, e.g., ‘MTOC OFF’

MTO導出with規則：

---

1. TYPE NE 'BEND' ((TYPE NE 'TUBI' and (MTOC EQ 'ON' or MTOC EQ '' or MTOC EQ 'UNSET' )) or (TYPE EQ 'TUBI' and ((MTOT EQ 'ON' or MTOT EQ '' or MTOT EQ 'UNSET' ) or (MTOH EQ 'ON' or MTOH EQ '' or MTOH EQ 'UNSET' ))))

復制代碼

這才是正確的代碼。

如果導出提示代碼太多，是因為HIERARCHY里你add了太多東西造成的，用group處理，建立一個groupset，把所有pipe的zone都放到里面，然后HIERARCHY里只add這個groupset。

關于mto生成后自動打開excel：

---

system command里填寫代碼：

1. '"C:\Program files\Microsoft Office\Office14\excel.exe" D:\PDMS_MTO\PIPE.csv'

復制代碼

注意：C:\Program files\Microsoft Office\Office14\excel.exe要和你電腦上的excel位置一致。

簡單點，可以直接打開mto文件夾：

1. 'start D:\PDMS_MTO'

復制代碼

掃碼訪問本帖：

lin005

好厲害，頂一個！！！！

wzfxihou

好厲害 實用 實用！

yifang

總結的不錯  學習

buster1022

{:4_92:}{:4_92:}{:4_92:}{:4_92:}{:4_92:}{:4_92:}{:4_92:}

ab403999562

講解的很詳細啊

processor

很不錯，前排支持一下

趙瑞祥_X77T5

高手啊，膜拜一下

18816760517

這是高手{:4_110:}{:4_110:}{:4_110:}{:4_110:}{:4_110:}

18816760517

{:4_98:}{:4_98:}{:4_98:}{:4_98:}