How to Export Data from Avaya Site Administrator (ASA)

By Nishant Rane

Published on:

Views: 133

Complete guide to exporting user names, hunt groups, DID numbers, and configuration data from Avaya Communication Manager

Quick Answer: Use ASA Export Wizard for basic exports or use list commands with logging for detailed exports. For large systems, use Avaya System Manager CSV export.

Overview of Export Methods

Method Best For Output Difficulty
Export Wizard Single object export TXT / CSV Easy
List Commands Detailed exports TXT Medium
System Manager Large deployments CSV Advanced
Command Chaining Bulk export TXT Medium

Method 1: ASA Export Wizard

  1. Open Avaya Site Administrator (ASA)
  2. Go to System → Advanced → Export Data
  3. Select object type:
    • Station
    • Hunt Group
    • ARS
  4. Select required fields
  5. Save output file

Limitation: Output format is basic text and needs Excel cleanup.

Method 2: Using List Commands

Use list commands instead of display commands for structured output.

Data Type Command Purpose
Stations list station User and extension data
Hunt Groups list hunt-group Group members
DID Routing list ars route-pattern DID patterns
Digit Rules list ars analysis Digit manipulation
Route Patterns list route-pattern Routing destinations
Coverage Paths list coverage-path Forwarding rules
Vectors list vector IVR call flow

How to Capture Output

  1. Go to File → Start Logging
  2. Run required list commands
  3. Go to File → Stop Logging
  4. Open TXT file in Excel
  5. Use Data → Text to Columns

Method 3: Command Chaining

You can run multiple commands at once:

list station; list hunt-group; list ars route-pattern; list coverage-path
  1. Paste above command in ASA
  2. Enable logging
  3. Export to Excel

Method 4: System Manager CSV Export

  1. Login to Avaya System Manager
  2. Go to Elements → Communication Manager → Groups → Hunt Group
  3. Click Export All
  4. For stations: Endpoints → Station → Export All
  5. Download CSV file

Example: DID to Extension Mapping

list ars route-pattern
list ars analysis
list route-pattern
list station

Use Excel VLOOKUP to map: DID → Route Pattern → Extension → User.

Important Notes

Always use list commands for export. ASA does not generate true CSV files. System Admin access is required.

Recommended Method by Size

  • Small systems (≤50 stations): Export Wizard
  • Medium systems (50–500): List commands
  • Large systems (500+): System Manager CSV

Excel Cleanup Steps

  1. Open TXT file
  2. Select all data
  3. Data → Text to Columns
  4. Choose Space or Fixed Width
  5. Remove empty columns

Leave a Comment