Adding data to the Import Tool | NEC MA4000 specification

Setting Up Infrastructures

4-33

Step 4 The tool will open as a spreadsheet with the following tabbed

		worksheets, and a Help tab:
		—Assets
		—Termination Hardware
		—Backbone Cables
		—Horizontal Links
		—Users
		Each component's worksheet functions independently of the others. The data
		categories are specific to that component, and the Check Data and Import Data

		macros work only with the data on the currently open worksheet. This ensures the
IMPORTANT		accurate, successful transfer of data.

Using the Import Tool to Transfer Data to Cable Management

The procedure for using the Cable Management Spreadsheet Tool is fast and simple, requiring only three overall steps:

•Adding data to the Import Tool

•Checking the data against the existing database contents

•Importing the data

Adding data to the Import Tool

Step 1 After opening the Spreadsheet Tool spreadsheet, click the worksheet tab for the type of data you want to import (Assets, Termination Hardware, Backbone Cables, Horizontal Links, or Users).

Step 2 Use Excel's import function to add data from other files, or copy-and- paste data from other Excel spreadsheets, or directly key data into the tool's worksheet. (Note that all required fields are marked with an * asterisk.) 



Recommendations: Before adding your data to the Import Tool, it's a good idea to sort the original file to match the order of the data in the Import Tool's spreadsheets. It's also a good practice to make sure that the data to be imported adheres to the Cable Management fields' requirements for length and data format.

MA4000 Expense Management Cable Management User Guide - Issue 1

Image 67

NEC MA4000 manual Using the Import Tool to Transfer Data to Cable Management, Adding data to the Import Tool

Contents

MA4000 Expense Management NEC Infrontia Corporation Liability Disclaimer Contents Setting Up Infrastructures Figures Page How This Guide is Organized Introduction Exploring the Cable Management Environment Exploring Cable ManagementCable Management Main Cable Management Main Menu Navigator Tree Cable Management EnvironmentHierarchy Descriptions Location Info List View Button Detail View Adding an Attachment AttachmentsViewing an Attachment Adding Notes Deleting an AttachmentAdding additional Notes to the Port or Strand Level Revision Log Deleting NotesPage Multi-View Multi-Task Capability Cable Management Tools Available Within the Application Window Sizing Using the search functionSearch Function Copy Button Quick Set/Quick Insert ButtonsView Most Recently Added Items Copy Capabilities To Clipboard Button Using the Copy functionUsing the copy to Excel To Excel Button About the Circuit Trace Tool Accessing the Circuit Trace ToolTo access the Circuit Trace Tool Circuit Trace Tool Copy to Clipboard Show/Hide Table or DiagramViewing Circuit Information Invert Table Changing the Trace Point Arranging the DiagramViewing a Components Detail Viewing a components Details View information User Defined Fields Creating customized fields Custom Fields Viewing the Security Log Security Log General Settings Page About Cable Managements Wizards Cable Management Wizards Using an infrastructure setup wizard Infrastructure Setup Wizards Some examples are listed below Documentation Wizards Can still rename any port individually Port Naming Wizard About the Infrastructure Setting up the Geographical Infrastructure Setting Up Infrastructure within a Company Campuses Setting Up CompaniesTo set up a Company Adding a Building BuildingsAdding a Campus Remove a Campus Removing a Building FloorsAdding a Floor Removing a Floor Indoor SpacesAdding an Indoor Space Removing an Indoor Space Telecommunication SpacesAdding a Telecommunication Space Removing a Telecommunication Space Outdoor SpacesAdding an Outdoor Space Removing a Faceplate FaceplatesRemoving an Outdoor Space Adding a Faceplate Adding a Port PortsRemoving a Port Termination Hardware Setting Up the Cabling InfrastructureAdding Termination Hardware Start and End Port/Position Defining Termination HardwareEditing Port/Position Status Assets Adding a Workstation Asset Backbone AssetsWorkstation Assets Adding a Backbone Asset Horizontal Links Financials Horizontal Link HL Info Setting up a horizontal linkDefining Horizontal Links Connecting Workstation Assets to a Horizontal Link Connecting Contacts to a Horizontal LinkConnecting a Data Horizontal Link to a Backbone Asset Identifying Horizontal Link Pathways Used Connecting a Data Horizontal Link to a Mainframe AssetConnecting a Voice Horizontal Link to a Backbone Asset Connecting a Horizontal Link to Termination Hardware Adding Splices Connecting a Horizontal Link to a Grounding ConductorSplices Editing the Key Sheet Backbones Connecting a Backbone Cable to a SpliceBackbone Cables Deleting a Backbone type Setting up a backbone typeAdding a Backbone Defining a Backbone Backbone Source Setting up the backbone destinationSetting up the backbone source Backbone Source Identifying Backbone Pathways Used Backbone Pair/Strand DetailsChanging the status of a port Backbone Cross-Connects Adding Busbars Connecting a Backbone to a Grounding ConductorGrounding Adding pathways used Adding a Conductor Adding firestops in your infrastructure FirestopsConductor Pathways Used Adding a Firestop Adding a Pathway Connecting a Firestop to a PathwayConnecting a Pathway to a Firestop Pathways Adding a contact Connecting the PathwaysConnecting to another pathway Contacts Deleting a contact type Connecting a User to Horizontal LinksDefining a Contact Define a contact type Generating a report from the Report Creator How to Run a ReportReports Creating Cable Management Specific Users Sorting, Filtering, and Grouping Reports Available Reports Print Details Button About the Spreadsheet Tool Spreadsheet ToolLaunching the Spreadsheet Tool Spreadsheet Tool Import from Excel Adding data to the Import Tool Using the Import Tool to Transfer Data to Cable Management Checking Data Importing Data Page Cross-Connects Termination HardwareFirestops Ability to see backbone pair/strand details/status GroundingSplices PathwaysPage MA4000 Expense Management Cable Management User Guide