This functionality is only available for certain module packages. Info / Copyright

Parts Management: CSV Import and Export for Parts

Parts Management: Control Files for Importing and Exporting Data

The following tables list all fields taken into account for the Part group for CSV imports and exports and their respective designations.

Table "tblPart"

CSV field designation

Parts management field designation

Tab

class

"Part type" (no actual field)

Tree

producttopgroup

Generic product group

General

productgroup

Product group

General

productsubgroup

Product subgroup

General

craftelectro

Trade / Electrical engineering

General

craftfluid

Trade / Fluid power

General

craftmechanic

Trade / Mechanics

General

craftprocess

Trade / Process engineering

General

crafthydraulic

Trade / Hydraulics

General

craftpneumatic

Trade / Pneumatics

General

craftlubrication

Trade / Lubrication

General

craftcooling

Trade / Cooling

General

craftcoolinglubricant

Trade / Cooling lubricant

General

craftgastechnology

Trade / Gas engineering

General

craftfluidundefined

Trade / Fluid power (undefined)

General

partnr

Part number

General

discontinued

Discontinued part

General

erpnr

ERP number

General

typenr

Type number

General

uniqueid

(internal unique ID, used for the Data Portal)

General

description1

Designation 1

General

description2

Designation 2

General

description3

Designation 3

General

manufacturer

Manufacturer

General

supplier

Supplier

General

ordernr

Order number

General

note

Description

General

priceunit

Price unit

Prices / Other

quantityunit

Quantity unit

Prices / Other

packagingquantity

Quantity/packaging

Prices / Other

discount

Discount

Prices / Other

purchaseprice1

Purchase price/price unit Currency 1

Prices / Other

purchaseprice2

Purchase price/price unit Currency 2

Prices / Other

packagingprice1

Purchase price/packaging Currency 1

Prices / Other

packagingprice2

Purchase price/packaging Currency 2

Prices / Other

salesprice1

Sales price Currency 1

Prices / Other

salesprice2

Sales price Currency 2

Prices / Other

identcode

Barcode number

Prices / Other

identtype

Barcode type

Prices / Other

certificate

Certification / General

Prices / Other

certificate_UL

Certification / UL

Prices / Other

certificate_VDE

Certification / VDE

Prices / Other

certificate_CE

Certification / CE

Prices / Other

weight

Weight

Mounting data

width

Width

Mounting data

height

Height

Mounting data

depth

Depth

Mounting data

mountingspace

Space requirement

Mounting data

mountinglocation

Mounting surface

Mounting data

externalplacement

External placement

Mounting data

graphicmacro

Graphical macro

Mounting data

picturefile

Image file

Mounting data

snapheightmiddleoffset

Center mismatch

Mounting data

snapheight

Clip-on height

Mounting data

ecabinetmacro

Texture

Mounting data

widthspacingleft

Mounting clearance width / left

Mounting data

widthspacingright

Mounting clearance width / right

Mounting data

heightspacingabove

Mounting clearance height / above

Mounting data

heightspacingbelow

Mounting clearance height / below

Mounting data

depthspacingfront

Mounting clearance depth / front

Mounting data

depthspacingrear

Mounting clearance depth / rear

Mounting data

groupnumber

Group number

Technical data

piecetype

Part group

Technical data

functiongroup

Function group

Technical data

wear

Wearing part

Technical data

spare

Spare part

Technical data

maintenance

Lubrication / maintenance

Technical data

lifetime

Service time

Technical data

stress

Stress

Technical data

usage

Procurement

Technical data

groupsymbolmacro

Macro

Technical data

terminal

Connection point pattern

Technical data

reportid

Identifier for reports

Data for reports

externaldocument1 - externaldocument3

File / hyperlink 1 - 3

Documents

Note:

Please note that the safety-related values cannot be imported in CSV since there is no 1:1 relation to the parts data.

Table "tblMechanic"

CSV field designation

Parts management field designation

Tab

additionallength

Additional length

Connection points

Table "tblVariant"

CSV field designation

Parts management field designation

Tab

connectiondesignation

Connection point designations

Function templates

technicalcharacteristics

Technical characteristics

Function templates

assemblyspreaded

Distributed placement of assembly

Assembly

Table "tblFunctionTemplate"

Warning:

Please note that the "tblFunctionTemplate" table may only be imported or exported as a whole. Even if this table apparently contains several fields they are still treated as one field. If, for example, a field has been commented on during the import, any existing entry in the parts management is deleted!

CSV field designation

Parts management field designation

Tab

pos

Line

Function templates

functiondefid

Function definition

Function templates

connectionDesignation

Connection point designation

Function templates

characteristics

Characteristic

Function templates

nesteddevicetag

Plug designation

Function templates

description

Terminal description

Function templates

intrinsicsafety

Intrinsically safe

Function templates

variant

Variant

Function templates

terminalNr

Designation

Function templates

idx1

Index 1

Function templates

idx2

Index 2

Function templates

functiondefcategory

Function definition: Category

Function templates

functiondefgroup

Function definition: Group

Function templates

symbol

Symbol

Function templates

symbolmacro

Symbol macro

Function templates

safetyrelevant

Safety function

Function templates

connectiondescription

Connection point description

Function templates

Table "tblFreeProperty"

CSV field designation

Parts management field designation

Tab

description.n (where "n" is a number between 1 and 1,000)

Description 1 - 1,000

Free properties

val.n (where "n" is a number between 1 and 1,000)

Value 1 - 1,000

Free properties

unit.n (where "n" is a number between 1 and 1,000)

Unit 1 - 1,000

Free properties

Table "tblAttribute"

CSV field designation

Parts management field designation

Tab

val.n (where "n" is a number between 1 and 100)

Value 1 - 100

Attributes

Table "tblAccessoryPosition"

CSV field designation

Parts management field designation

Tab

necessary.1

Required

Accessory placement

partnr.1

Part number / name

Accessory placement

variant.1

Variant

Accessory placement

parttype.1

Record type

Accessory placement

necessary.2

Required

Accessory placement

partnr.2

Part number / name

Accessory placement

variant.2

Variant

Accessory placement

parttype.2

Record type

Accessory placement

Table "tblGrid"

CSV field designation

Parts management field designation

Tab

<Property number>.<Index> (although the index is optional; if it is not stated it is interpreted as "0"). The property numbers begin with "22235" and are incremented

File / hyperlink 4 - 20

Documents

<Property number>.<Index> (although the index is optional; if it is not stated it is interpreted as "0")

Symbol 1 - 20

Data for reports