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

Page 67

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

Contents MA4000 Expense Management NEC Infrontia Corporation Liability DisclaimerContents Setting Up Infrastructures Figures Page How This Guide is Organized IntroductionExploring 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 ApplicationWindow Sizing Using the search functionSearch Function Copy Button Quick Set/Quick Insert ButtonsView Most Recently Added Items Copy CapabilitiesTo Clipboard Button Using the Copy functionUsing the copy to Excel To Excel ButtonAbout the Circuit Trace Tool Accessing the Circuit Trace ToolTo access the Circuit Trace Tool Circuit Trace ToolCopy to Clipboard Show/Hide Table or DiagramViewing Circuit Information Invert TableChanging the Trace Point Arranging the DiagramViewing a Components Detail Viewing a components Details View informationUser Defined Fields Creating customized fields Custom FieldsViewing the Security Log Security LogGeneral Settings Page About Cable Managements Wizards Cable Management WizardsUsing an infrastructure setup wizard Infrastructure Setup WizardsSome examples are listed below Documentation WizardsCan still rename any port individually Port Naming WizardAbout the Infrastructure Setting up the Geographical InfrastructureSetting Up Infrastructure within a Company Campuses Setting Up CompaniesTo set up a Company Adding a Building BuildingsAdding a Campus Remove a CampusRemoving 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 FaceplateAdding 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 AssetHorizontal Links FinancialsHorizontal 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 HardwareAdding Splices Connecting a Horizontal Link to a Grounding ConductorSplices Editing the Key SheetBackbones Connecting a Backbone Cable to a SpliceBackbone Cables Deleting a Backbone type Setting up a backbone typeAdding a Backbone Defining a BackboneBackbone Source Setting up the backbone destinationSetting up the backbone source Backbone SourceIdentifying Backbone Pathways Used Backbone Pair/Strand DetailsChanging the status of a port Backbone Cross-ConnectsAdding Busbars Connecting a Backbone to a Grounding ConductorGrounding Adding pathways usedAdding a Conductor Adding firestops in your infrastructure FirestopsConductor Pathways Used Adding a FirestopAdding a Pathway Connecting a Firestop to a PathwayConnecting a Pathway to a Firestop PathwaysAdding a contact Connecting the PathwaysConnecting to another pathway ContactsDeleting a contact type Connecting a User to Horizontal LinksDefining a Contact Define a contact typeGenerating a report from the Report Creator How to Run a ReportReports Creating Cable Management Specific UsersSorting, Filtering, and Grouping Reports Available Reports Print Details ButtonAbout the Spreadsheet Tool Spreadsheet ToolLaunching the Spreadsheet Tool Spreadsheet Tool Import from ExcelAdding data to the Import Tool Using the Import Tool to Transfer Data to Cable ManagementChecking 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

Related manuals

Manual 280 pages 30.63 Kb