This hands-on course teaches students how to transform existing spreadsheets into structured netTerrain data models using the platform's Excel Import capabilities. Attendees will learn how to build and validate import sheets for common network documentation objects including sites, buildings, floors, rooms, racks, devices, patch panels, ports, fiber infrastructure, and outside plant assets. The training covers parent-child relationships, hierarchy creation, object types, catalog mapping, custom attributes, geographic coordinates, and connectivity modeling, enabling organizations to rapidly populate a new netTerrain environment from existing inventory and operational data rather than creating assets manually. Real-world examples demonstrate how to import network inventories, facility information, GIS data, and connectivity records using proven import templates and best practices.
The course also explores advanced import techniques designed to improve data quality and accelerate deployment. Students will learn how to update existing records, import connectivity relationships, validate imported information, troubleshoot import errors, and analyze import logs to resolve issues efficiently. Additional topics include preparing source data, configuring catalog types, handling custom fields, and resolving common challenges such as missing parent objects, invalid coordinates, and attribute conflicts. Organizations using the latest AI-powered capabilities can also learn how AI-assisted Excel Import can analyze spreadsheets, generate import-ready structures, recommend hierarchy creation, and streamline data mapping prior to importing into netTerrain, significantly reducing the effort required to onboard large datasets.
