NEC MA4000 manual Launching the Spreadsheet Tool, Spreadsheet Tool Import from Excel

Page 66

4-32 Setting Up Infrastructures

Spreadsheet Tool

Spreadsheet Tool (Import from Excel)

One of Cable Management's most useful tools is its ability to bulk-load large amounts of existing data into the Cable Management database.

With this tool, any kind of data that can be converted or imported into a Microsoft Excel spreadsheet can be transferred with a few clicks to your Cable Management database. This is particularly valuable when you are transferring your existing network documentation from other databases or spreadsheets to Cable Management.

About the Spreadsheet Tool

The Spreadsheet Tool consists of a multi-worksheet spreadsheet with macros that simplify and speed up the process of adding network infrastructure data to a Cable Management database. Here's an overview of how it works:

Step 1 Each worksheet's columns correspond to the Cable Management data fields for that network component category. Using any import or copy- and-paste option available, you add your existing data to the worksheet.

Step 2 Next, you use the tool's Check Data macro to verify the data's integrity and identify data that cannot be authenticated.

Step 3 When you activate the Import Data macro, all authenticated data on the worksheet is uploaded to the specified Cable Management database.

Launching the Spreadsheet Tool

The Spreadsheet Tool is shipped on the Cable Management installation CD and is a standalone Excel file that you can copy to the Cable Management server or to any client PC that has access to the Microsoft SQL database server. You can open the tool from either the Cable Management Install menu, or directly from Excel.

Step 1 Make sure your Excel configuration is set to allow macros. (Set macro security to Medium or Low.)

Step 2 From the Cable Management Install screen, click on Accessories and then Spreadsheet Tool on the submenu page.

Step 3 If a Security Message dialog box appears, click the Enable Macros button.

MA4000 Expense Management Cable Management User Guide - Issue 1

Image 66

Contents MA4000 Expense Management Liability Disclaimer NEC Infrontia CorporationContents Setting Up Infrastructures Figures Page Introduction How This Guide is OrganizedExploring Cable Management Exploring the Cable Management EnvironmentCable Management Main Cable Management Main Menu Cable Management Environment Navigator TreeHierarchy Descriptions Location Info List View Button Detail View Attachments Adding an AttachmentViewing an Attachment Deleting an Attachment Adding NotesAdding additional Notes to the Port or Strand Level Deleting Notes Revision LogPage Cable Management Tools Available Within the Application Multi-View Multi-Task CapabilityUsing the search function Window SizingSearch Function Copy Capabilities Quick Set/Quick Insert ButtonsView Most Recently Added Items Copy ButtonTo Excel Button Using the Copy functionUsing the copy to Excel To Clipboard ButtonCircuit Trace Tool Accessing the Circuit Trace ToolTo access the Circuit Trace Tool About the Circuit Trace ToolInvert Table Show/Hide Table or DiagramViewing Circuit Information Copy to ClipboardViewing a components Details View information Arranging the DiagramViewing a Components Detail Changing the Trace PointUser Defined Fields Custom Fields Creating customized fieldsSecurity Log Viewing the Security LogGeneral Settings Page Cable Management Wizards About Cable Managements WizardsInfrastructure Setup Wizards Using an infrastructure setup wizardDocumentation Wizards Some examples are listed belowPort Naming Wizard Can still rename any port individuallySetting up the Geographical Infrastructure About the InfrastructureSetting Up Companies Setting Up Infrastructure within a Company CampusesTo set up a Company Remove a Campus BuildingsAdding a Campus Adding a BuildingFloors Removing a BuildingAdding a Floor Indoor Spaces Removing a FloorAdding an Indoor Space Telecommunication Spaces Removing an Indoor SpaceAdding a Telecommunication Space Outdoor Spaces Removing a Telecommunication SpaceAdding an Outdoor Space Adding a Faceplate FaceplatesRemoving an Outdoor Space Removing a FaceplatePorts Adding a PortRemoving a Port Setting Up the Cabling Infrastructure Termination HardwareAdding Termination Hardware Defining Termination Hardware Start and End Port/PositionEditing Port/Position Status Assets Adding a Backbone Asset Backbone AssetsWorkstation Assets Adding a Workstation AssetFinancials Horizontal LinksSetting up a horizontal link Horizontal Link HL InfoDefining Horizontal Links Connecting Contacts to a Horizontal Link Connecting Workstation Assets to a Horizontal LinkConnecting a Data Horizontal Link to a Backbone Asset Connecting a Horizontal Link to Termination Hardware Connecting a Data Horizontal Link to a Mainframe AssetConnecting a Voice Horizontal Link to a Backbone Asset Identifying Horizontal Link Pathways UsedEditing the Key Sheet Connecting a Horizontal Link to a Grounding ConductorSplices Adding SplicesConnecting a Backbone Cable to a Splice BackbonesBackbone Cables Defining a Backbone Setting up a backbone typeAdding a Backbone Deleting a Backbone typeBackbone Source Setting up the backbone destinationSetting up the backbone source Backbone SourceBackbone Cross-Connects Backbone Pair/Strand DetailsChanging the status of a port Identifying Backbone Pathways UsedAdding pathways used Connecting a Backbone to a Grounding ConductorGrounding Adding BusbarsAdding a Conductor Adding a Firestop FirestopsConductor Pathways Used Adding firestops in your infrastructurePathways Connecting a Firestop to a PathwayConnecting a Pathway to a Firestop Adding a PathwayContacts Connecting the PathwaysConnecting to another pathway Adding a contactDefine a contact type Connecting a User to Horizontal LinksDefining a Contact Deleting a contact typeCreating Cable Management Specific Users How to Run a ReportReports Generating a report from the Report CreatorSorting, Filtering, and Grouping Reports Print Details Button Available ReportsSpreadsheet Tool Import from Excel Spreadsheet ToolLaunching the Spreadsheet Tool About the Spreadsheet ToolUsing the Import Tool to Transfer Data to Cable Management Adding data to the Import ToolChecking Data Importing Data Page Termination Hardware Cross-ConnectsFirestops Pathways GroundingSplices Ability to see backbone pair/strand details/statusPage MA4000 Expense Management Cable Management User Guide

Related manuals

Manual 280 pages 30.63 Kb