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.

[ 1 Select Scheme ] [ 2 Select File ] [ 3 Fields for Importing Infrastructure ]

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

Import Component Definitions From File

Import Network Cables