Checking Data | NEC MA4000 specs

4-34 Setting Up Infrastructures

Checking Data

Step 1 With the active worksheet containing the data you wish to import, click the Check Data button.

Step 2 If this is your first time using this function after launching the Spreadsheet Tool, an SQL Server Login window will open so you can access the database. In the top half of window, select the correct Server, and enter your Login ID and Password as needed.

If you are loading data into more than one database, you must close the tool and reopen it to switch to a different database.

NOTE

Step 3 Click the Options>> button to open the bottom half of the window where you can select the correct Database from the drop-down list.

Step 4 When done, click OK.

The Check Data macro will authenticate the data in that particular worksheet against the data in the database you've selected. When the Check Data function is finished, the data in your spreadsheet will be displayed in one of three colors (which are also documented on the Help worksheet tab in the tool itself): 



Black if the data checked out all right. Data rows that return in black will be imported. 



Red if the row of data is considered invalid. Data in red will not be imported. A data row may be marked red/invalid for a variety of reasons:

•The data in one or more fields doesn't match the correct format - a numerically formatted field contains text, a date is invalid or uses the wrong date format, the data does not match a option (e.g., a Horizontal Link type may only be Data, Voice, or Unused; if that field in the spreadsheet contains another value, or if the information doesn't use the same capitalization as the format, the row is marked invalid).

•A required field has been left blank.

•A unique data item already exists in the database.

•A unique data item appears more than once on the spreadsheet.

Purple if that data will create a new infrastructure item when it is imported. Purple is applied to individual cells, rather than complete rows. For example, if an asset being imported is located in a building already documented in the database, but on a floor that has not yet been documented, the import process will create the new floor first and then associate the asset with it.

MA4000 Expense Management Cable Management User Guide - Issue 1

Image 68

NEC MA4000 manual Checking Data

Contents

MA4000 Expense Management Liability Disclaimer NEC Infrontia Corporation Contents Setting Up Infrastructures Figures Page Introduction How This Guide is Organized Cable Management Main Exploring Cable ManagementExploring the Cable Management Environment Cable Management Main Menu Hierarchy Descriptions Cable Management EnvironmentNavigator Tree Location Info List View Button Detail View Viewing an Attachment AttachmentsAdding an Attachment Adding additional Notes to the Port or Strand Level Deleting an AttachmentAdding Notes Deleting Notes Revision LogPage Cable Management Tools Available Within the Application Multi-View Multi-Task Capability Search Function Using the search functionWindow Sizing Quick Set/Quick Insert Buttons View Most Recently Added ItemsCopy Capabilities Copy Button Using the Copy function Using the copy to ExcelTo Excel Button To Clipboard Button Accessing the Circuit Trace Tool To access the Circuit Trace ToolCircuit Trace Tool About the Circuit Trace Tool Show/Hide Table or Diagram Viewing Circuit InformationInvert Table Copy to Clipboard Arranging the Diagram Viewing a Components DetailViewing a components Details View information Changing the Trace Point User Defined Fields Custom Fields Creating customized fields Security Log Viewing the Security Log General Settings Page Cable Management Wizards About Cable Managements Wizards Infrastructure Setup Wizards Using an infrastructure setup wizard Documentation Wizards Some examples are listed below Port Naming Wizard Can still rename any port individually Setting up the Geographical Infrastructure About the Infrastructure To set up a Company Setting Up CompaniesSetting Up Infrastructure within a Company Campuses Buildings Adding a CampusRemove a Campus Adding a Building Adding a Floor FloorsRemoving a Building Adding an Indoor Space Indoor SpacesRemoving a Floor Adding a Telecommunication Space Telecommunication SpacesRemoving an Indoor Space Adding an Outdoor Space Outdoor SpacesRemoving a Telecommunication Space Faceplates Removing an Outdoor SpaceAdding a Faceplate Removing a Faceplate Removing a Port PortsAdding a Port Adding Termination Hardware Setting Up the Cabling InfrastructureTermination Hardware Editing Port/Position Status Defining Termination HardwareStart and End Port/Position Assets Backbone Assets Workstation AssetsAdding a Backbone Asset Adding a Workstation Asset Financials Horizontal Links Defining Horizontal Links Setting up a horizontal linkHorizontal Link HL Info Connecting a Data Horizontal Link to a Backbone Asset Connecting Contacts to a Horizontal LinkConnecting Workstation Assets to a Horizontal Link Connecting a Data Horizontal Link to a Mainframe Asset Connecting a Voice Horizontal Link to a Backbone AssetConnecting a Horizontal Link to Termination Hardware Identifying Horizontal Link Pathways Used Connecting a Horizontal Link to a Grounding Conductor SplicesEditing the Key Sheet Adding Splices Backbone Cables Connecting a Backbone Cable to a SpliceBackbones Setting up a backbone type Adding a BackboneDefining a Backbone Deleting a Backbone type Setting up the backbone destination Setting up the backbone sourceBackbone Source Backbone Source Backbone Pair/Strand Details Changing the status of a portBackbone Cross-Connects Identifying Backbone Pathways Used Connecting a Backbone to a Grounding Conductor GroundingAdding pathways used Adding Busbars Adding a Conductor Firestops Conductor Pathways UsedAdding a Firestop Adding firestops in your infrastructure Connecting a Firestop to a Pathway Connecting a Pathway to a FirestopPathways Adding a Pathway Connecting the Pathways Connecting to another pathwayContacts Adding a contact Connecting a User to Horizontal Links Defining a ContactDefine a contact type Deleting a contact type How to Run a Report ReportsCreating Cable Management Specific Users Generating a report from the Report Creator Sorting, Filtering, and Grouping Reports Print Details Button Available Reports Spreadsheet Tool Launching the Spreadsheet ToolSpreadsheet Tool Import from Excel About the Spreadsheet Tool Using the Import Tool to Transfer Data to Cable Management Adding data to the Import Tool Checking Data Importing Data Page Firestops Termination HardwareCross-Connects Grounding SplicesPathways Ability to see backbone pair/strand details/statusPage MA4000 Expense Management Cable Management User Guide