Import Infrastructure
- Cornelia Stärkel (Deactivated)
- Thomas Wais
- Christian FitzGerald Forberg
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 |
|---|---|---|---|
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 |