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