PDMS管理员：导出MTO文件 配置步骤（MTO report）

helloshigy

PDMS导出MTO管件数量的方式是：点击菜单栏的“utilities-standard reporting-reports”，run或者modify一个模版（推荐modify，直接run无法运行system command命令。）

pdms导出MTO管件数量

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:}