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 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.

Show P-Points in Design

Sometimes you need to see which p-point is located towards pipeline  or maybe you need to figure out which connection type or diameter is located at the leaving part of the element.

This tool may help you, just navigate to pipe element, open form and press button show Ppoints.

 

Small PML Macro Library

Here you can find few PML macros, just for studying.

Software Customization Reference Manual referenced to it.

Its was originally published at http://support.aveva.com but it is hidden now, by some reason.

Link to download achieve.

Search in SPEC from Design

Sometime we need to find out, what we got in our specs,
while we are in Design module.

We can use standard tool ‘search utility’ or small forms like this. Also its possible to extend functionality using PML callbacks from such user forms.

Download link

Preview isometric in PDF using UserControl in Aveva Pdms

After updating Aveva Pdms to version 12.1 we got problem, that we can’t preview PLT files if we use TTF.

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.

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.