Filter
Top Products
11-6
Cisco WAN Modeling Tools Guide
OL-10426-01, Rev. A0
Chapter 11 SpreadSheet Interface
SSI TroubleShooting
SSI TroubleShooting
The table below describes a common SSI problem and what can be done about it.
Symptom
Network data gets rounded incorrectly when converting from Excel to
NMT'’s CNF file.
Probable Causes
The SSI user enters new connections or links in Excel using the SSI
macros. The user then runs NMT_Unload macro, and transfers the tarred
DBF file back to Unix. The user then enters the following commands:
run tar2nmt
run nmt
and then discovers that the hub IDs and data conn types have been
converted to integers.
For example, a HUB id:
4.3 -> 4
or a data connection type:
19.2 -> 19
Solution
To avoid this corruption, make sure that one of the following is true for
your link connection tables:
• The first line (not the column header's but the first data line) originally
came from NMT and has not been modified in Excel.
• All fields in the first line (again, first data line not field name line) with
this potential corruption (data conn type, all hub IDS and Feeder IDs)
have a single quote prepended to them. For example:
19.2 --> ‘19.2
This forces the DBF translation to treat these columns as strings, so
truncation is avoided. This is only necessary in the first data line.