This functionality is only available for certain module packages. Info

Connecting to an EPLAN Platform Master Data SQL Database: Mapping of Parts Properties

Parts can be created in both EPLAN Harness proD Library and in the EPLAN Platform parts management, and they are displayed in real time in both libraries. If, however, you want the parts to be synchronized in both libraries, they must be created in EPLAN Harness proD Library. In this case they will be mapped to the following Generic product group > Product group > Product subgroup entries in the EPLAN Platform parts management: Mechanics > Undefined > Undefined, Electrical engineering > Undefined > Undefined, and Undefined > Undefined > Undefined. If a connector, connectable object (PLC / motor), or terminal does not exist in EPLAN Harness proD Library, but is created in the EPLAN platform master data, it will be represented by a cuboid in the EPLAN Harness proD Library-specific 3D window. This way, there is at least a basic 3D model with pins. The dimensions of the cuboid are taken from the EPLAN platform-specific Weight, Width and Height properties (Mounting data tab). If the cuboid is deleted in EPLAN Harness proD Library, it is not recreated. If the components of above are first created in EPLAN Harness proD Library, no cuboid is created.

EPLAN Harness proD

Global properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Part name

General > Part number

Description

General > Description

Created

Properties > Creation date

Creator

Properties > Creator

Last modified by

Properties > Last editor

Last change

Properties > Modification date

ERP number

General > ERP number

Part status > Obsolete

General > Discontinued part (check box is activated)

If the Discontinued part check box is turned off in the master data, the previous state is reset in EPLAN Harness proD Library. The previous state is the state which was set prior to the Obsolete setting in EPLAN Harness proD Library or before activating the Discontinued part setting in the master data.

Manufacturer company

General > Manufacturer

Quantity/packaging

Prices / Other > Quantity/packaging

Cost/item

Prices / Other > Purchase price/price unit (currency 1)

Cost/unit

EPLAN Harness proD

Weight, user-defined properties, and tags mapping

EPLAN Platform master data properties

Parts management tab and field name

Cable weight

Properties > Weight / length

Wire weight

Properties > Weight / length

Weight/item

Mounting data > Weight

User-defined properties

Free properties

Tags

Attributes

EPLAN Harness proD

Wire properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Min. bending radius

Properties > Min. bending radius

Cross-section

Function templates > Connection: Cross-section / diameter

Rules for wire cross-sections are the same as for cable wire cross-sections.

Outside diameter

Properties > External diameter

Max. voltage

Properties > Voltage

Color

Function templates > Connection color / number

Stripe color

For colors and stripe colors, the following abbreviations are supported:

BK = black

BN = brown

RD = red

OG = orange

YE = yellow

GN = green

BU = blue

VT = violet

GY = gray

WH = white

PK = pink

GD = gold

TQ = turquoise

SR = silver

For other colors the hexadecimal code is used, e.g. "#00bfff". If the wire has a stripe color, both color abbreviations are used under Function templates > Connection color / number, e.g. "GNYE". If such a wire is created in the master data, color and stripe color are automatically set in EPLAN Harness proD Library. In the above example, the wire color is green, and the stripe color is yellow.

The following function templates are supported for wires:

General > General special functions > Connection > Connection definition > Conductor / wire

General > General special functions > Connection > Connection definition > Connection, general

Note:

In EPLAN Harness proD, the minimal bending radius is a dimensionless factor that, when multiplied with the cable's or wire's outside diameter, returns the actual value of the minimal bending radius in terms of a unit of length; the EPLAN Platform does, however, already store the minimal bending radius with the unit of length. It is therefore important to remember that:

EPLAN Harness proD minimal bending radius = EPLAN Platform minimal bending radius / outside diameter of the cable or wire in question.

EPLAN Harness proD

Cable properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Wire name

Function templates > Connection color / number

Wire product color

Min. bending radius

Properties > Min. bending radius

Outside diameter

Properties > External diameter

Cable wire cross-section

Function templates > Connection: Cross-section / diameter

Max. voltage

Properties > Voltage

No. of wires

Function templates > Conductor / wire (one row for each one)

The following function definitions are supported for cable wires:

General > General special functions > Connection > Connection definition > Conductor / wire

General > General special functions > Connection > Connection definition > Connection, general

The following function definitions are supported for cable shields:

General > General special functions > Connection > Connection definition > Conductor / wire

General > General special functions > Connection > Connection definition > Connection, general

As long as a name of the supported function definition is entered in the Shielded by entry for cable shields of the master data, they become a shield in EPLAN Harness proD Library.

If the shield is created in EPLAN Harness proD Library, it has the Cable definition function definition in the master data with an additional Conductor / wire function definition of Potential type "SH" to represent the shield.

If the Function templates > Connection: Cross-section / diameter entry contains no value at all, the shield in EPLAN Harness proD Library is non-conductive, and therefore the Conductive check box is not activated.

For cables created in the EPLAN platform master data, all associated wires in EPLAN Harness proD Library have the Insulation property activated.

EPLAN Harness proD

Ribbon cable properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Wire name

Function templates > Connection color / number

Wire product color

Min. bending radius

Properties > Min. bending radius

Outside diameter

Properties > External diameter

Cable wire cross-section

Function templates > Connection: Cross-section / diameter

Max. voltage

Properties > Voltage

No. of wires

Function templates > Conductor / wire (one row for each cable wire)

The following function definitions are supported for ribbon cable wires:

General > General special functions > Connection > Connection definition > Conductor / wire

General > General special functions > Connection > Connection definition > Connection, general

Electrical engineering > Cable / Antenna > Shield > Shield > Shield, Cable definition

For ribbon cables created in the EPLAN platform master data, all ribbon cable wires in EPLAN Harness proD Library have the Insulation property activated.

Rules for cross-sections of cables and ribbon cable wires

The cable wire's outside diameter is calculated on the basis of the cable wire cross-section.

If the Function templates > Connection: Cross-section / diameter entry contains a value with units which are currently not set in EPLAN Harness proD Library, the value is converted (recalculated) to the units determined in the EPLAN Harness proD Library settings for units.

If the Function templates > Connection: Cross-section / diameter entry contains a value with area units, this value is used as the cable wire's cross-section in EPLAN Harness proD Library.

If the Function templates > Connection: Cross-section / diameter entry contains a value with length units, the value is used as the cable wire's outside diameter, and the cross-section is calculated on the basis of this value.

If the Function templates > Connection: Cross-section / diameter entry contains a value without any units, the units determined in the Properties > Unit for connection cross-section / diameter field are used. If the entry there is set to "As in project", the units determined in the EPLAN Harness proD Library settings for units are used.

If the Function templates > Connection: Cross-section / diameter entry contains no value at all and the value in the Properties > Connection: Cross-section / diameter field does not contain any units, this value is used as the cable wire's cross-section.

EPLAN Harness proD

Connector properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Gender > Not set

Function templates > Electrical engineering > Terminals and plugs > Plug definition > Plug definition > Plug definition for male and female pins

Gender > Female

Function templates > Electrical engineering > Terminals and plugs > Plug definition > Plug definition > Plug definition for female pins

Gender > Male

Function templates > Electrical engineering > Terminals and plugs > Plug definition > Plug definition > Plug definition for male pins

Pin designation

Function templates > Terminal / Pin designation

Connection point designations

Function templates > Connection point designations

There is the possibility to have multiple pins in EPLAN Harness proD Library and still retain connection point designations like "A¶B¶C" in the master data function definition. In order to do so, for each pin enter the same value into the Pin designation field in EPLAN Harness proD Library. Then, still in EPLAN Harness proD Library, enter "A" into the Connection pin designations field of the first pin, "B" into the Connection pin designations field of the second pin, and "C" into the Connection pin designations field of the third pin.

The following function definitions are supported for connectors:

Electrical engineering > Terminals and plugs > Plug definition > Plug definition > (...)

Electrical engineering > Terminals and plugs > Pin > Pin, 2 connection points > (...)

In EPLAN Harness proD, the Full pin name property of the connector has the following format: Pin designation:Connection point designations.

Although by default pins are created in EPLAN Harness proD Library, grouped pins can also be used.

EPLAN Harness proD

Splice properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Connection point designations

Function templates > Connection point designations

The following function definitions are supported for splices:

Electrical engineering > Connection splicer / line connector > Connection splicer / line connector > Connection splicer, 3 connection points > Connection splicer, 3 connection points

Electrical engineering > Connection splicer / line connector > Connection splicer / line connector > Connection splicer, 4 connection points > Connection splicer, 4 connection points

Electrical engineering > Connection splicer / line connector > Connection splicer / line connector > Connection splicer, variable > Connection splicer, variable

Electrical engineering > Connection splicer / line connector > Connection splicer / line connector > Line connector, 2 connection points > Line connector

In EPLAN Harness proD, the Full pin name property of the splice has the following format: Connection point designations.

EPLAN Harness proD

Terminal properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Terminal designation

Function templates > Terminal / Pin designation

Connection point designations

Function templates > Connection point designations

Level

Level

There is the possibility to have multiple pins in EPLAN Harness proD Library and still retain connection point designations like "A¶B¶C" in the master data function definition. In order to do so, enter the same value into both or either of the Terminal designation and Level fields. Optionally you can leave either of these properties empty. Then, still in EPLAN Harness proD Library, enter "A" into the Connection pin designations field of the first pin, "B" into the Connection pin designations field of the second pin, and "C" into the Connection pin designations field of the third pin.

The following function definitions are supported for terminals:

Electrical engineering > Terminals and plugs > Terminal > Terminal, variable > (...)

Electrical engineering > Terminals and plugs > Terminal > Terminals with saddle jumper, (...) connection points > (...)

Electrical engineering > Terminals and plugs > Terminal > Terminals, (...) connection points > (...)

In EPLAN Harness proD, the Full pin name property of the terminal has the following format: Terminal designation:Connection point designations – Level #, with # being the designation of the level. "- Level" is added automatically if the level is used.

EPLAN Harness proD

Connectable object properties mapping

EPLAN Platform master data properties

Parts management tab and field name

Motor and PLC

Connectable object

Electrical engineering > Terminals and plugs > Pin > Pin, 2 connection points > Pin, general

Electrical engineering > Special functions in electrical engineering > Device connection point > Device connection point

Electrical engineering > Special functions in electrical engineering > Device connection point > Device connection point, general

Electrical engineering > Special functions in electrical engineering > Device connection point > N-device connection point

Electrical engineering > Special functions in electrical engineering > Device connection point > PE device connection point

Electrical engineering > Special functions in electrical engineering > Device connection point > SH device connection point

Electrical engineering > Special functions in electrical engineering > Device comection point, 2 connection points > Device connection point, 2 connection points

Electrical engineering > Special functions in electrical engineering > Device comection point, 2 connection points > N-device connection point, 2 connection points

Electrical engineering > Special functions in electrical engineering > Device comection point, 2 connection points > PE device connection point, 2 connection points

Electrical engineering > Special functions in electrical engineering > Device comection point, 2 connection points > SH device connection point, 2 connection points

Electrical engineering > Special functions in electrical engineering > Device comection point, variable > Device connection point, variable

Plug designation (in platform master data for PLC only)

PLC > Function templates > Plug designation

Connection point designations

Function templates > Connection point designations

There is the possibility to have multiple pins in EPLAN Harness proD Library and still retain connection point designations like "A¶B¶C" in the master data function definition. In order to do so, enter the same value into Plug designation fields. Optionally you can leave this properties empty. Never mind that motors do not have a Plug designation entry in the master data. Then, still in EPLAN Harness proD Library, enter "A" into the Connection pin designations field of the first pin, "B" into the Connection pin designations field of the second pin, and "C" into the Connection pin designations field of the third pin.

The following function definitions are supported for motors:

Electrical engineering > Power consumers (motor, heating, light) > Motor > Motor with PE, 3 connection points > (...)

Electrical engineering > Power consumers (motor, heating, light) > Motor > Motor with PE, 4 connection points > (...)

Electrical engineering > Power consumers (motor, heating, light) > Motor > Motor without PE and winding, 2 connection points > (...)

Electrical engineering > Power consumers (motor, heating, light) > Motor > Motor without PE, 4 connection points > Stepper motor

Electrical engineering > Power consumers (motor, heating, light) > Motor > Motor, variable > (...)

The following function definitions are supported for PLC:

Electrical engineering > PLC / bus > PLC box > PLC box > (...)

Electrical engineering > PLC / bus > PLC connection point > PLC connection point, I / O, 1 connection point > (...)

Electrical engineering > PLC / bus > PLC connection point > PLC connection point, card power supply, 1 connection point > (...)

Electrical engineering > PLC / bus > PLC connection point > PLC connection point, network / bus cable, 1 connection point > (...)

Electrical engineering > PLC / bus > PLC connection point > PLC connection point, power supply, 1 connection point > (...)

Electrical engineering > PLC / bus > PLC connection point > PLC connection point, variable > (...)

The following function definitions are supported for Sensor, switch, and pusbutton:

Electrical engineering > Sensor, switch, and pusbutton > Analog sensor > (...)

Electrical engineering > Sensor, switch, and pusbutton > Digital sensor, general > (...)

Electrical engineering > Sensor, switch, and pusbutton > Level detector > (...)

Electrical engineering > Sensor, switch, and pusbutton > Light barrier > (...)

Electrical engineering > Sensor, switch, and pusbutton > Limit switch, mechanical > (...)

Electrical engineering > Sensor, switch, and pusbutton > Proximity switch > (...)

Electrical engineering > Sensor, switch, and pusbutton > Switch, pusbutton > (...)

In EPLAN Harness proD, the Full pin name property of the terminal has the following format: Pin designation:Connection point designations.

Although by default pins are created in EPLAN Harness proD Library, grouped pins can also be used.