NEC MA4000 User Manual download pdf (Page 67)

Setting Up Infrastructures 4-33

MA4000 Expense Management Cable Management User Guide - Issue 1

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

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 e

xisting 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.

IMPORTANT

1 2 ... 62 63 64 65 66 67 68 69 70 71 72 73 74

No comments

NEC MA4000 User Manual Page 67