- Cisco WAN Modeling Tools User Guide

Table Of Contents

11-4

Cisco WAN Modeling Tools Guide

OL-10426-01, Rev. A0

Chapter 11 SpreadSheet Interface

Microsoft Excel to NMT

The following procedure is for the archiving of Microsoft Excel files so they can be easily moved from

a PC to a UNIX workstation and for converting the Microsoft Excel files into NMT .cnf file format:

Step 1 To archive an Microsoft Excel file, use a program like tar.exe for PCs or StuffIt Deluxe for Macintoshes.

Note If the destination PC has not been used for reading archived .cnf files, you should copy the

following files from the NMT directory to the PC: SSIDOSKT.TAR (containing DOS .bat files

for tarring and untarring the NMT SSI .dbf data files), the tar.exe program, and the Microsoft

Excel macro SSI. Also, you should read the file SSI.readme.

Step 2 The archived file should have a filename with a .tar extension.

Step 3 FTP the archived file to a workstation that has a directory linked to the NMT.

Alternatively, copy the file to a PC- or Macintosh-compatible diskette. To copy from a PC or Macintosh

diskette to a UNIX workstation, use the mcopy command. For example, mcopy a:\filename copies the

file “filename” to the UNIX workstation directory from which the command was issued.

Step 4 To read the DBF or tar file from NMT, go to the FILE/IMPORT menu, and select DBF Files. If you are

on the unix side, you will be prompted if you want to open a tar file, or read directly from a DBF file set.

To perform this same functionality in UNIX command mode, perform command 4 alt.

Step 5 To unarchive the file, enter the following command:

tar2nmt

filename

is the name of any .tar file in the current directory.

Step 6 The unarchived file will have a .cnf extension and can be opened and edited in the NMT.