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 |
---|---|---|---|
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 |