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 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 infrastrcture from file.sch
Import Infrastructure Excel File:
Import infrastrcture from file.xlsx
Fields for Importing Infrastructure
The following fields can be used during the import process. Fields marked as identifying will be used to match the data to other objects. Therefore it is necessary for them to be unique in the given context. If for example a server is meant to be imported into a rack, the rack name must be unique within the room.
Some objects like floors and rooms can be identified by their name or number.
Field name | Identifying | 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 | |
CampusUID | Text | Location UID | |
CampusExternalRef | Text | Location external reference | |
BuildingLatitude | Double | Latitudinal position of the building | |
BuildingLongitude | Double | Longitudinal position of the building | |
BuildingName | x | Text | Building name |
BuildingShortName | Text | Building short name | |
BuildingUID | Text | Building UID | |
BuildingStreet | Text | Building street | |
BuildingZip | Text | Building ZIP | |
BuildingCity | Text | Building city | |
BuildingDescription | Text | Building description | |
BuildingExternalRef | Text | Building external reference | |
FloorName | (x) | Text | Floor name |
FloorNumber | (x) | Text | Floor number |
FloorShortName | 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 | |
FloorUID | Text | Floor UID | |
FloorExternalRef | Text | Floor external reference | |
RoomName | (x) | Text | Room name |
RoomShortName | Text | Room short name | |
RoomNumber | (x) | Text | Room number |
RoomDescription | Text | Room description | |
RoomArea | Floating-point number | Room area (optional) | |
RoomUID | Text | Room UID | |
RoomType | Text | Room type Valid values: enmNone, enmStorage, enmWiringCloset, enmDataCenter, enmOffice, enmTrainingRoom, enmEducationRoom, enmComputerRoom, enmAdministration, enmSportsRoom, enmWorkshop, enmKitchen, enmToilet, enmLocker, enmMeetingRoom, enmLectureHall, enmAuditorium, enmLivingRoom, enmCommonRoom, enmRestRoom, enmWaitingRoom, enmDiningRoom, enmDetentionArea, enmConstructionSpace, enmCounterRoom, enmSupervisoryRoom, enmShed, enmTechLab, enmPhysicalLab, enmChemicalLab, enmAnimalHusbandry, enmCultivation, enmArchive, enmColdStore, enmExhibition, enmClassroom, enmLibrary, enmStage, enmSurgeryRoom, enmDiagnosticRadiology, enmRadiotherapy, enmPhysiotherapy, enmMedicalSupplies, enmRetirementRoom, enmWardrobe, enmStoreRoom, enmShelter, enmWaterSpace, enmElectricRoom, enmDayNursery, enmSpace, enmCorridor, enmStaircase, enmBoilerRoom, enmEquipmentRoom, enmControlRoom, enmEditingRoom, enmStudio, enmConferenceRoom, enmFunctionalSpace | |
RoomAdministrationUnit | Text | Room administration unit | |
RoomExternalRef | Text | Room external reference | |
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) | |
ComponentUID | Text | Component UID | |
ParentSlotNumber | x | 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 | Text | External Reference (optional) | |
ComponentOrderNumber | Text | Order number | |
ComponentDeliveryDate | Date | Delivery date | |
ComponentSupplier | Text | Supplier | |
ComponentMaintenanceContract | Text | Maintenance contract | |
ComponentMaintenanceStart | Date | Maintenance start | |
ComponentMaintenanceEnd | Date | Maintenance end | |
ComponentState | Text | State of the component Valid values: csNone, csInUse, csInMaintenance, csDefective, csPlanned, csOrdered, csDelivered, csInStock, csConfigured, csOutOfOperation, csDecommissioned, csToBeDisposed, csDisposed | |
ParentComponentName | x | Text | Parent component name (must be unique in its room, can be left empty) |
ParentComponentUID | Text | Parent component UID | |
ParentSlotName | x | Text | Slot name |
PortName | Text | Port name | |
PortNumber | x | Integer | Port number |
PortNumberNew | Integer | New value for port number | |
PortDescription | Text | Port description | |
PortUID | Text | Port UID | |
PortFront | Boolean | Port position true = front, false = rear | |
InletDefName | Text | Inlet's component definition name (must match catalog) | |
InletName | Text | Inlet name | |
ComponentCustomString1 (to 8) | Text | Custom text fields for components | |
ComponentCustomInteger1 (and 2) | Integer | Custom integer fields for components | |
ComponentCustomDate1 (and 2) | Date | Custom date fields for components | |
ComponentCustomFloat1 (and 2) | Floating-point number | Custom floating-point number fields for components | |
RoomCustomString1 (to 8) | Text | Custom text fields for rooms | |
RoomCustomInteger1 (and 2) | Integer | Custom integer fields for rooms | |
RoomCustomDate1 (and 2) | Date | Custom date fields for rooms | |
RoomCustomFloat1 (and 2) | Floating-point number | Custom floating-point number fields for rooms | |
FloorCustomString1 (to 8) | Text | Custom text fields for floors | |
FloorCustomInteger1 (and 2) | Integer | Custom integer fields for floors | |
FloorCustomDate1 (and 2) | Date | Custom date fields for floors | |
FloorCustomFloat1 (and 2) | Floating-point number | Custom floating-point number fields for floors | |
BuildingCustomString1 (to 8) | Text | Custom text fields for buildings | |
BuildingCustomInteger1 (and 2) | Integer | Custom integer fields for buildings | |
BuildingCustomDate1 (and 2) | Date | Custom date fields for buildings | |
BuildingCustomFloat1 (and 2) | Floating-point number | Custom floating-point number fields for buildings | |
LocationCustomString1 (to 8) | Text | Custom text fields for locations | |
LocationCustomInteger1 (and 2) | Integer | Custom integer fields for locations | |
LocationCustomDate1 (and 2) | Date | Custom date fields for locations | |
LocationCustomFloat1 (and 2) | Floating-point number | Custom floating-point number fields for locations |