Filter
Top Products
11-4
Cisco WAN Modeling Tools Guide
OL-10426-01, Rev. A0
Chapter 11 SpreadSheet Interface
Microsoft Excel to NMT
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
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.