Nortel ICSRT, User Manual

Page: 84 / 138

84 Chapter 7 Using Workbooks and off-line programming
N0004999 01
Understanding workbooks and off-line programming
Use the ICSRT off-line programming tool as another way to enter programming into a Norstar
system. This tool also allows you to acquire programming from a Norstar system. This Off-line
Programming tool uses a Microsoft Excel workbook file which contains a number of worksheets
that contain the system data, some macros, and a map file specific to the type of system you are
programming.
With this off-line programming tool, you can:
• program a Norstar system by transferring customized programming data from a workbook to
the system, via the customer record in ICSRT
• populate a workbook with information from a Norstar system which is already programmed
• add new programming to a Norstar system which is already programmed by selecting a second
workbook that contains only the required changes and either adding the information to
existing programming or overwriting the information with the information from the workbook
To use the workbook tool, you need Microsoft Excel version 5.0 or higher. For best results, use
Excel version 7.0 or higher.
You can use the workbook to record or plan programming without connecting to a Norstar system,
but to transfer the programming to the system, or to populate a workbook with the programming
information from a Norstar system, you need to use the Off-line Programming tool and a
connection established through a customer record in the ICSRT.
Each version of Norstar systems has an Excel workbook consisting of a number of worksheets and
macros that allow you to enter data from any computer that runs Excel for a specific system. This
means that you can take the appropriate workbook file on a laptop to a customer meeting. After
you enter programming information, you can assign the workbook to a customer database record
and use the information in the record to configure a new Norstar system or update an existing
system.
Restrictions
• DO NOT activate the Microsoft Excel feature Share Workbook in the Tools menu when you
are programming a system or acquiring programming from a system. If it is turned on, data in
some cells may be corrupted.
• Although the tool allows you to acquire and upload all the data, it is recommended that you
only use this tool to acquire only those sections that need changing, and only change and
upload those sections that have changed.
• Hardware settings cannot be updated with this tool, they can only be acquired.
Use the Remote set tool or the Browser tool if you need to change hardware settings.
• Do not use workbooks as a backup and/or restore vehicle.
Caution:
To avoid damaging the programming ability of the workbook, do not unhide,
delete, or rename any of the worksheets inside the workbook. Do not alter the Address
worksheet in any way.