Document toolboxDocument toolbox

Import Network Cables

This pages describes how to import cables in Pathfinder.

Select the import network cables option from the import and export section.

You can import network cables into your Pathfinder network to manage and create network paths.

 


 

Select Scheme

 

The ability to import cables allows you to quickly and easily create a large amount of network cables for use 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 files and the corresponding excel cable import files. You can use this template as the base for your network.

 

Import Installation Cable Schema File:

 

Import Installation Cable Excel File:

 

Import Patch Cable Schema File:

 

Import Patch Cable Excel File:

 


 

Overview of fields for importing cables

The constants are unique names in the system and refers to an importable field. Identifying constants are used for clear distinction between entries.

 

Identifying constant

Mandatory fields

Data type

Description

Identifying constant

Mandatory fields

Data type

Description

SourceCampusName

X

Text

Name of the source location

SourceBuildingName

X

Text

Name of the source building

SourceFloorName

(X)

Text

Name of the source floor

SourceFloorNumber

(X)

Text

Number of the source floor

SourceRoomName

(X)

Text

Name of the source room

SourceRoomNumber

(X)

Text

Number of the source room

SourceComponentName

X

Text

Name of the source component

SourcePortName

(X)

Text

Name of the source port

SourcePortNumber

(X)

Text

Number of the source port

TargetCampusName

X

Text

Name of the target location

TargetBuildingName

X

Text

Name of the target building

TargetFloorName

(X)

Text

Name of the target floor

TargetFloorNumber

(X)

Text

Number of the target floor

TargetRoomName

(X)

Text

Name of the target room

TargetRoomNumber

(X)

Text

Number of the target room

TargetComponentName

X

Text

Name of the target component

TargetPortName

(X)

Text

Name of the target port

TargetPortNumber

(X)

Text

Name of the target port

ConnectionTypeName

X

Text

Connection type ("InstallationCable" or "I" and "PatchCable" or "P")

CableDefName

X

Text

Name of the cable definition (must be identical with the name in the catalog)

LineDefName

X

Text

Name of the line type (must be identical with the name in the catalog)

CableName

 

Text

Cable Name

CableDescription

 

Text

Cable Description

CableNumber

 

Text

Cable Number

CableLength

 

Integer

Cable Length

CableInstallationDate

 

Date

Cable Installation Date

CablePurchaseDate

 

Date

Cable Purchase Date

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