Document toolboxDocument toolbox

Import Infrastructure

This pages describes how to import infrastructure and components in Pathfinder.

Select the import infrastructure option from the import and export section.

You can import locations, nested infrastructures and nested components into your Pathfinder network to manage.

 


 

Select Scheme

 

The ability to import infrastructure allows you to quickly and easily create a large amount of infrastructure and components in a nested hierarchy in Pathfinder.

Select the type of scheme you want and click Next.

You can also load schemes and save as templates here.

Please make sure to set your column headers with the same title as the current scheme. The fields are case sensitive.


 

Select File

 

Click on load from file to import the file from your local system. The function supports Excel file types for import.

Click on in Pathfinder Next to execute the file import.

 

Here is an example schema file and the corresponding excel infrastructure import file. You can use this template as the base for your network.

 

Import Infrastructure Schema File:

 

Import Infrastructure Excel File:

 


 

Fields for Importing Infrastructure

The constants are unique names in the system and refers to an importable field. Identifying constants are used for clear distinction between entries. For floors and rooms the identifying constant can either be its name or its number.

 

Identifying constant

Mandatory fields

Data type

Description

Identifying constant

Mandatory fields

Data type

Description

CampusLatitude

 

Double

Latitudinal position of the location

CampusLongitude

 

Double

Longitudinal position of the location

CampusName

X

Text

Location name

CampusShortName

 

Text

Location short name

CampusStreet

 

Text

Location street

CampusZip

 

Text

Location ZIP

CampusCity

 

Text

Location city

CampusCountry

 

Text

Location country

CampusDescription

 

Text

Location description

BuildingLatitude

 

Double

Latitudinal position of the building

BuildingLongitude

 

Double

Longitudinal position of the building

BuildingName

X

Text

Building name

BuildingShortName

 

Text

Building short name

FloorName

 

Text

Floor name

FloorNumber

(X)

Text

Floor number

FloorShortName

(X)

Text

Floor short name

FloorFilePath

 

Text

Path to a file attached to a floor

FloorFileMode

 

Text

Valid values: Link, DB, LinkAsBg, DBAsBg

Link = as a link to the file

DB = file is saved in database

LinkAsBg = as a link to the file and used as background

DBAsBg = file is saved in database and used as background

default value: DB

RoomName

(X)

Text

Room name

RoomShortName

 

Text

Room short name

RoomNumber

(X)

Text

Room number

RoomDescription

 

Text

Room description

RoomHeight

 

Text

Room height (optional)

RoomWidth

 

Text

Room width (optional)

RoomLength

 

Floating-point number

Room length (optional)

RoomArea

 

Floating-point number

Room area (optional)

ComponentDefName

X

Text

Component definition name (must match catalog)

ComponentName

X

Text

Component name (must be unique in its room)

ComponentNameNew

 

Text

Use this to update a component name

ComponentDescription

 

Text

Component description (optional)

ComponentComment

 

Text

Component comment (optional)

ComponentSlotPosition

 

Text

Slot position in parent component (only required for built-in components)

ParentSlotNumber

 

Integer

Slot number in parent component for the module

ComponentImportAsModule

 

Boolean

Define whether the component is a module or not

ComponentBayPosition

 

Text

Bay position in parent component (only required for built-in components)

ComponentLayerNumber

 

Integer

Layer in a cabinet, default=1 (optional)

ComponentLeftOffsetMM

 

Integer

Component left offset in a cabinet (optional)

ComponentBurdenCentre

 

Text

Burden center (optional)

ComponentInventoryNumber

 

Text

Inventory number (optional)

ComponentSerialNumber

 

Text

Serial number (optional)

ComponentServiceNumber

 

Text

Service number (optional)

ComponentGuarantee

 

Text

Guarantee (optional)

ComponentLastMaintenance

 

Date

Last Maintenance (optional)

ComponentMaintenanceCycle

 

Text

Maintenance Cycle (optional)

ComponentEAN

 

Text

European article number (optional)

ComponentPurchaseDate

 

Date

Purchase Date (optional)

ComponentInstallationDate

 

Date

Installation Date (optional)

ComponentWarrantyContract

 

Text

Warranty Contract (optional)

ComponentWarrantyEnds

 

Date

End of Warranty (optional)

ComponentKnownIssues

 

Text

Known Issues (optional)

ComponentMacAddress

 

Text

Mac address (optional)

ComponentReverseMounting

 

Integer

Reverse mounting (0=no, 1=yes) (otional)

ComponentValue

 

Floating-point number

Component value (optional)

ComponentDepreciationDate

 

Date

Depreciation date (optional)

ComponentFQDN

 

Text

Fully qualified domain name (optional)

ComponentOS

 

Text

Operating system (optional)

ComponentConfiguration

 

Text

Configuration (optional)

ComponentResponsibleContact

 

Text

Responsible Contact (optional)

ComponentURL

 

Text

URL (optional)

ComponentExternalRef

 

Tex

External Reference (optional)

ParentComponentName

X

Text

Parent component name (must be unique in its room, can be left empty)

SlotName

X

Text

Slot name

PortName

 

Text

Port name

PortNumber

X

Integer

Port number

PortNumberNew

 

Integer

New value for port number

PortDescription

 

Text

Port Description

InletDefName

X

Text

Inlet's component definition name (must match catalog)

InletName

X

Text

Inlet name

CustomString1 (to 8)

 

Text

Custom Text fields

CustomInteger1 (and 2)

 

Integer

Custom Integer Fields

CustomDate1 (and 2)

 

Date

Custom Date Fields

CustomFloat1 (and 2)

 

Floating-point number

Custom Floating-point number Fields