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

helloshigy

PDMS導出MTO管件數(shù)量的方式是：點擊菜單欄的“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規(guī)則：

---

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' ))))

復(fù)制代碼

這才是正確的代碼。

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

關(guān)于mto生成后自動打開excel：

---

system command里填寫代碼：

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

復(fù)制代碼

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

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

1. 'start D:\PDMS_MTO'

復(fù)制代碼

掃碼訪問本帖：

912106130

好東西，學習一下

helloshigy

幾年后又看到這個貼子  總結(jié)的挺好的

動力火車

謝謝樓主的分享

zlweijian

很不錯，前排支持一下

mmandpanda

這么好的資料，感謝分享，好好學習一下

zfshao

這個不錯值得學習

meibao04107

不錯，學習了。

humphy

學習了，非常不錯的東西

a381807943

大贊，感謝分享