Avaya MasterDirectory, User Manual

Page: 91 / 218

Chapter 4: Importing Data
83
6. In the Server box, enter the name of the server that contains the information you want.
7. In the Database box, enter the name of the database that contains the information you want.
8. In the User Name box, enter the user name.
9. In the Password box, enter the password.
10. Choose the Browse button next to the Table Name box.
The Choose Destination Table dialog box appears.
11. In the Tables list box, select the appropriate table and then choose the OK button.
The name of the selected table appears in the Table Name box.
12. Choose the Next button.
The Create Import Map (Step 3 of 4) dialog box appears.
The Field [Offset: Length] box shows the field labels for the source file. The MasterDirectory Fields
box shows the fields available in the MasterDirectory window.
13. In the Field [Offset: Length] box, select a field that you want to import from the source file.
14. In the MasterDirectory Fields box, select the field in the MasterDirectory window where you want the
selected field in the source file to appear.
15. Choose the Map button.
The selected MasterDirectory field appears next to the selected field from the source file, under the
Mapped To column.
16. Repeat steps 13 to 15 for all of the fields that you want to import from the source file.
17. When you are finished mapping fields, choose the Next button.
The Import Map (Step 4 of 4) dialog box appears.
18. In the Import Mode box, select how you want the information imported. You have the following
options:
•
AppendAll , which adds all of the specified information from the source file to the current
MasterDirectory file. (This is the default.)
•
AppendNew , which appends only new information from the source file to the current
MasterDirectory file. MasterDirectory compares the source file information with the information in
the current MasterDirectory file to determine what information is new.
•
Update , which takes only the new information from the source file, and places it in the current
MasterDirectory file.