Manuals / NEC / Computer Equipment / Computer Accessories

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

Models: MA4000

1 74

Download 74 pages 16.82 Kb

Page 66

Spreadsheet Tool

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

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

Contents

User Guide NEC NEC Infrontia CorporationMA4000 Expense Management Cable ManagementLiability Disclaimer 2009 NEC Infrontia CorporationCable Management Tools ContentsIntroduction Cable Management WizardsSetting Up Infrastructures Product FunctionalityAppendix-1 Page FiguresTitle Figureiv Figures Setting Up Infrastructures IntroductionHow This Guide is Organized ChapterExploring Cable Management Exploring the Cable Management EnvironmentThe Cable Management Main Page Cable Management menu Cable Management Main MenuSETUP menu REPORTS menuThe Cable Management Environment Navigator TreeHierarchy Descriptions Location Info List View Button DescriptionDetail View 1-8IntroductionAttachments Adding an AttachmentViewing an Attachment Deleting an Attachment Adding NotesDeleting Notes Revision Log1-12Introduction Cable Management Tools Multi-View Multi-TaskCapabilityUsing 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 fieldsOR -  Security Log Viewing the Security LogTOOLS menu General Settings 2-12Cable Management Tools Cable Management Wizards About Cable Managements WizardsInfrastructure Setup Wizards Using an infrastructure setup wizardthese recommendations Documentation Wizards Some examples are listed belowPort Naming Wizard Setting Up Infrastructures Setting up the Geographical InfrastructureAbout the Infrastructure To set up a Company Setting Up CompaniesSetting Up Infrastructure within a Company CampusesRemove 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 Setting Up Asset Types Connecting to a Horizontal LinkConnecting to a Grounding Conductor AssetsAdding a Backbone Asset Backbone AssetsWorkstation Assets Adding a Workstation Asset4-14Setting Up Infrastructures FinancialsHorizontal Links SpaceHorizontal Link HL Info Defining Horizontal LinksConnecting Contacts to a Horizontal Link Identifying Horizontal Link Pathways Used Adding Splices SplicesEditing the Key Sheet Adding splices to the closureSplice Types User Defined Connecting a Backbone Cable to a SpliceBackbones Adding user-definedsplices to the closureDefining a Backbone Setting up a backbone typeAdding a Backbone Deleting a Backbone typeBackbone Source Setting up the backbone destinationBackbone Source Backbone DestinationBackbone 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 Firestops Conductor Pathways UsedAdding a Firestop Pathways Connecting a Firestop to a PathwayConnecting a Pathway to a Firestop Adding a PathwayConnecting the Pathways ContactsAdding a contact Define 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 CreatorGrouping Data on a Report Sorting, Filtering, and Grouping ReportsSelecting Data for a Report Sorting a ReportFor example The Print Details ButtonAvailable Reports Step 2 Print the report from the browserSpreadsheet Tool Import from Excel Spreadsheet ToolLaunching the Spreadsheet Tool About the Spreadsheet ToolAdding data to the Import Tool Checking Data Step 4 When done, click OKImporting Data Setting Up Infrastructures4-35 4-36Setting Up Infrastructures Cross-Connects Product FunctionalityTermination Hardware FirestopsPathways GroundingSplices Filtering Logic-NavigatorTreecontact your NEC Infrontia representative NDA-31010,Issue NEC NEC Infrontia Corporation