3. FUNDAMENTACIÓN PROFESIONAL
3.6 Ejecución de la campaña
3.7.2 Desarrollo de contenidos
The important thing to remember about Analyzer’s network data import process is that the process requires two files:
1. A delimited text file that contains unformatted data arranged in tabular form, with one row for each individual sector in a network.
2. A blank file, containing only Analyzer header information, to be populated with formatted data.
Obtaining Site Data in Tabular Format
In order to import cell site data from your own network, you will need to obtain a delimited text file containing the data listed in the table below. To maximize the benefit Analyzer can bring to UMTS network analysis, the parameters listed in bold in the table on the following page are REQUIRED for cell data to function with logged data in the main workspace. All other parameters are optional.
The data may come from a network database or a planning tool
configuration file. As long as the data is in a tabular format with one row for each sector, Analyzer will be able to import the data.
Introduction to A-RVS for Network Optimization Page 143
Introdu
c
tio
n to
A-RVS
fo
r UMTS
UMTS Cell Site Parameters for Import:
Parameter Analyzer Group Analyzer Name Purpose
Site Name WCDMA_Site SiteName Text description of the
site for display on map. Site
Number WCDMA_Site SiteID Numeric identifier for the site.
Latitude WCDMA_Site Latitude Locates site icons on
map.
Longitude WCDMA_Site Longitude Locates site icons on
map. Sector
Number WCDMA_Cell Sector ID Sector-specific information useful for display on maps (can be alpha or numeric)
Azimuth WCDMA_Cell Azimuth Orients the sector icons
on the map.
Beamwidth WCDMA_Cell Beamwidth Governs the shape of the
sector ‘wedge’ icon to reflect the beamwidth of antenna deployed at the site.
Scrambling
Code WCDMA_Cell SC Used for cell site identification and to calculate lines to cells.
EIRP WCDMA_Cell EIRP Equivalent Isotropic Radiated Power – for informational purposes only Mobile
Country Code
WCDMA_Cell MCC Mobile Country Code – for informational purposes only Mobile
Network Code
WCDMA_Cell MNC National Domain Code – for informational purposes only Location
Area Code WCDMA_Cell LAC Location Area Code – for informational purposes only Cell Identity WCDMA_Cell WCDMA_CI Cell Identity – for
informational purposes only BSIC WCDMA_Cell BSCI Legacy parameter – unused Neighbor
List
WCDMA_Cell WCDMANeighborList Used to define a pre-defined neighbor list for each cell. Used during neighbor list recommendations analysis.
Introdu
c
tio
n to
A-RVS
fo
r UMTS
The figure below is an example of a delimited UMTS file that could be used to import a site list into Analyzer. Though the columns can be in any order for import into Analyzer, the figure shows all of the REQUIRED fields. Additionally, the Excel spreadsheet must be saved as a TEXT file for import into Analyzer.
Figure 91 - UMTS Cell Site Data Spreadsheet
Guidelines for Formatting Tabular Data
Although Analyzer does not require cell site data fields to be listed in a particular order, following these guidelines will provide the best results: 1. The Site ID field must contain a unique value for each site location.
Beware of non-unique Site ID's - that is, entries that have multiple sets of lats/longs for the same Site ID. Non-unique Site ID's will result in site markers appearing on the map without sector wedges. Site Names need not be unique - they are used for labeling purposes only.
2. Position information must be accurate in order for Analyzer to display sites in the correct location on the map. Longitudes that have a 'West' notation should be represented as a negative decimal, as should latitudes with a 'South' notation. Sites will appear skewed on the map if the latitude and longitude fields are transposed.
Introduction to A-RVS for Network Optimization Page 145
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Obtaining the File to be Populated With Formatted Data
Before importing new cells into Analyzer, ensure that Analyzer is pointing to a valid cell site database.
A valid cell site database is a text file in which the first line contains the text below:
; #NetworkData – datafile
Every Analyzer installation comes with a clean file called cellrefs.txt located in the directory called:
C:\Program Files\Actix\Analyzer\Bin\Cellrefs
The file to be populated need not be named “cellrefs.txt”. We recommend renaming this file with a meaningful name in order to prevent the file from being overwritten during reinstallation.
To point the Analyzer to the file you wish to populate with the new cell site data, use the File Location line in the Tools → Preferences dialog. See the section on Loading Cell Site Data for more details.
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Importing the Data
Once you have obtained your cell site database in delimited format and pointed Analyzer to a valid cellrefs file, you are ready to open the Network Explorer and import the site information.
1. To access the Network Explorer select Cells → Network Explorer.
Figure 92- Network Explorer Window
The Network Explorer display consists of two panels. The left panel contains a tree view of the network element data. The right panel shows details about relevant parameters for the current selection. If you have pointed Analyzer to a cellrefs file containing only header information, you will not see any cell site data at this time.
2. On the toolbar select Import → Import From New Template to open the Import dialog.
3. Select the appropriate network data file and click Open to display the Import Settings dialog.
Introduction to A-RVS for Network Optimization Page 147
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Figure 93- Import Settings Dialog (Step 1 of 2)
4. Give the Template a meaningful Template Name. 5. Check the appropriate Delimiter.
6. In most cases, the default information under the General Settings and Coordinate Information headers will apply. Adjust these settings if necessary.
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Figure 94 - Settings (Step 2 of 2) – Assign WCDMA_Site Data
8. Expand the WCDMA_Site data node. Click in the Column field next to the Site_Name parameter. Select the parameter name from your site database that corresponds to the Site_Name parameter. Repeat for each of the required fields in the WCDMA_Site data node, based on the table below:
Field Mapping required for proper operation? Site_Name Optional, but this field is frequently used for the
site label.
SiteID Required, and this field must be unique for each site in the database.
Latitude Required Longitude Required
Introduction to A-RVS for Network Optimization Page 149
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Figure 95 - Column Settings (Step 2 of 2) – Assign WCDMA_Cell Data
9. Expand the WCDMA_Cell data node. Click in the Column field next to the Sector_ID parameter. Select the parameter name from your site database that corresponds to the Sector_ID parameter. Repeat for each of the required fields in the WCDMA_Cell data node, based on the table below:
Field Required for proper operation? Sector_ID Required Azimuth Required Beamwidth Required EIRP Optional SC Required MCC Optional
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Field Required for proper operation? MNC Optional LAC Optional WCDMA_CI Optional
BSIC Unused WCDMANeighborList Optional
10. Click Finish when all the columns have been assigned. If the current workspace contains existing site data, you will be asked whether you want to remove existing data before importing new data. Select Yes to overwrite existing data. Select No to append to existing data.
11. If any errors occur during the import, a pop-up message will indicate that an error log has been created. The error log specifies the cause of each error encountered and can be found in:
C:\Program Files\Actix\Analyzer\Bin\Cellrefs\ImportErrors.log
12. Inspect the cell data in the Network Explorer by expanding the All_WCDMA_Site_Elements folder in the left-hand pane of the Network Explorer.
13. Double-click on any site name in the right hand pane. The Name, Location and ID of the site will appear, as well as a folder containing WCDMA Cell Elements. Drill into the WCDMA Cell Elements folder and examine the values corresponding to each sector.
14. To save the formatted site information, select the Save button.
15. Close the Network Explorer by clicking the “X” at the upper right hand corner.
16. After closing the Network Explorer, view a new map by selecting View → Display New Map.
17. If cell icons do not appear on the map, right click on the WCDMA_Cell layer in the map legend at the left hand side of the map window. Select Zoom to Layer to zoom the map to the appropriate location. Be sure to close the map with the “X” at the upper right hand corner to save all changes to the map view.
Introduction to A-RVS for Network Optimization Page 151
Introdu
c
tio
n to
A-RVS
fo
r UMTS
Figure 96 - Use Zoom to Layer to Locate Cells on Map