Aveva. PML. Read data from excel(.xls)

Sometimes its need to read data from excel file not just .csv file, import data from some external source. With such little macro you can do it.

 

Advertisements

PML for Basic Level

In this section you can find intermediate level information about PML/PML2.

Such concepts like variable, arrays, forms, collection, loop and etc. Just start reading…

GoogleDisk(Manual)
GoogleDisk(Exercises)

By Romeldhagz

PML for Starters and Beginners Level

This manual is for those who are using
Aveva PDMS in their day-by-day work and wants to know the system deeper and automate work to make system do whatever they wants.

This is for the starters, who don’t know about programming at all and for beginners, who can already do some simple tasks.

Let’s get started!

GoogleDisk

By Pdmsmagic

Paragon. Weight creation (PWEI)

 There are two possible ways to insert Weight into paragon.

Pipe Component Preview

While creating Pipe elements, we may face with situation when we need to preview category elements, that’s in current specification.

Export specific attributes to .ATT (Navisworks)

Usually admins don’t have problems with export to .ATT of a small models or
if they have not demanding customer.

Clash Report in CSV format

To find clashed elements in CSV format in customizeable way you can you such request. This example search thought pipes under /STABILIZER.

1;# HH CLASH; NOZZLE 2 of EQUIPMENT 1 of ZONE 1 of SITE /AFG-CX01.HVAC; NOZZLE 2 of EQUIPMENT 1 of ZONE 3 of SITE /AFG-CX01.HVAC; at E11299 N1299 U1501;user
2; # HH TOU; NOZZLE 2 of EQUIPMENT 1 of ZONE 1 of SITE /AFG-CX01.HVAC; BOX 1 of EQUIPMENT 1 of ZONE 3 of SITE /AFG-CX01.HVAC; at E11300 N1125 U1500;user

Cate Viewer – Simple form (Updated)

This form can preview multiple categories simultaneously.

Find SCTN end clashed with Panel

This macro may be used to find out, what END is closer to PANE (or all other types) that is intersects SCTN.

We use clash tool, to find out at what point we have collision and than check which end is closer to it.

 

3D Letters with Panels & Plates & Equi

Usually we need text in 3D model for explanation of structural blocks.