Nemo Analyze: Creating The Data base

Adding Files to Database

When you start Nemo Analyze 5.0 for the first time, the database is empty. Adding files - measurements, BTS files, and maps - to the database may take a while, but once files have been added, they will remain in the database until you remove them.

Select File | Measurement | Open Measurement /Map/BTS/Report/Data Source File. From the Open dialog box, select the files you want to add to the database and click Open. You can select several files by holding down the Shift key.

Note: Adding files to the database may take several minutes depending on the number and size of the files.

Note: All the files need to have unique file names.

The added measurement files will appear in the All Measurements folder in the Workspace view in the left-hand side of the Nemo Analyze main window.

Adding Maps to Database

In addition to adding map files in the database through File | Measurement | Open Map, you can import image files to be used as maps. Select File |Import | Image as mapC. In the Open dialog, select the image that you want to use as a map. It can be, for example, a floorplan from a test site. After selecting the image file you need to define either the width and length of the map area in meters or the GPS coordinates for two map corners. After you click OK, the map is added in the database and it will appear in the Maps folder in the workspace.

You can create black and white copies of raster maps by right-clicking on a map in the workspace and selecting Create Black & White Copy. The map is saved with the same name with ‘BW’ added at the end of the file name.

Adding CSV Files to the Database

In addition to files produced with Nemo tools, you can import any character-separated value (CSV) ASCII data into the Nemo Analyze database. The data can be post-processed and visualized using the dataviews available in Nemo Analyze.

Select View | Tools | Database manager.

The User Manager dialog opens.

To create a new CSV import template, select the folder Database Management | CSV Templates from the directory tree, right-click on the Template field right of the directory tree, and select Add Template… from the popup menu.

The CSV Import Wizard – CSV Template File dialog opens.

Template file enables you to select a CSV file to serve as a basis for the import template. Click the browse button to browse for CSV files.

Extension enables you to define the file type the import template will apply to.

Note: It is recommended that the extensions of CSV files with different content structures are renamed to provide each type with a unique extension. For instance, four different types of CSV files, all originally with the extension .csv, could be renamed as .csv1, .csv2, .csv3, and .csv4.

Once Template file and Extension have been defined, click Next.

The CSV Import Wizard – CSV Import dialog opens.

Ignore defines the parts of the imported data set that are to be ignored when uploading the data, i.e. the parts that do not contain relevant data. Column row defines the number of top rows to be ignored. Rows allows you to define specific rows to be ignored. Rows starting with allows you to define rows starting with a specific string to be ignored.

Columns allows you to divide a CSV data set into columns. Fixed lines defines the content of each column based on the number of characters in a CSV string. For example, the setting 12, 22, 32 defines that the first twelve characters (including spaces) belong to column 1, the next 22 characters to column 2, and the next 32 characters to column 3. Fixed lines should only be used if there are no delimiters in the data set. Delimiter defines the character that separates columns in the CSV data set. You can use one of the default delimiters, i.e. comma, dot, semicolon, , or , or you can define your own delimiter character by entering a character to the Delimiter field.

Strip leading and trailing quotation marks removes leading and trailing quotation marks from each column of the imported data set.

File preview displays a preview of the CSV file contents.

Once the Ignore and Columns settings have been defined, click Next.

The CSV Import Wizard – Database Schema Definition dialog opens.

Table name defines the name of the template.

Columns enables you to select which columns are included in the imported data set and to define the properties of each column using Column, Column type and Format.

Decimal separator defines the decimal separator as comma or dot.

Column defines the name of the column selected in the Columns control.

Column type defines the data type of the column selected in the Columns control.

Keyword allows you to define the content type of columns containing some general data types, such as time and positioning data. Based on these defined content types, the data can be correlated with measurement files of other formats.

Format defines the data display format of the column selected in the Columns control.

Data preview displays a preview of the data set structure.

Once the properties of each column have been defined, click Finish.

The new template is displayed in the Template field of the User Manager window.

To open a CSV files using an import template, select File | Measurement | Open Measurement.

The Open dialog opens.

Select CSV import template (e.g. Template1) using the Files of type drop-down menu, browse to a folder containing measurement files with the extension defined in the template, select a file, and click Open.