Open topic with navigation

Importing and Exporting Multi-UE Settings Files

This topic provides information on importing and exporting multi-UE settings files, using *.csv and *.txt file formats.

File Format

Setting Parameters

MS Excel Tips

File Format

Delimiters

Comma ',' or Tab can be used as a delimiter of parameters.

File extension

".csv" or ".txt" can be used as file extension.

Parameter notations

Signal Studio treats data strings as shown in the following table.

Setting Parameters

The lines in the CSV file are categorized to lines described in the following table.

Parameter type and line structure

The following table shows the parameter types of lines and the line structure of the CSV file. The parameter type specifies a category of a line in a CSV file.

The parameter type starts with a "*" character, and it is located at the beginning of parameter lines.

CSV format version setting line

Common parameters line for all UEs

The following parameters are required for the common setting of all UEs. These parameters are defined in one line.

The range or choices of parameters are basically the same as GUI's parameters definition.

PUSCH parameters line for each UE

The following parameters are required for each UE setting. These parameters are lined into one line. And one line represents the setting of one UE. One hundred lines, therefore, are required for 100 UEs settings, because one hundred is the maximum number of UEs and always all definitions are listed in a setting file.

The range or choices of parameters are basically the same as GUI's parameters definition.

Comment line

Comment lines are ignored for reading setting data.

The comment line is a line started with "#" character.

Blank line

The blank line is a line which does not have any characters.

The blank lines are ignored for reading data.

MS Excel Tips

Open file

Excel behavior has difference with the file extension of opening file name.

TXT extension: Users can choose several setting parameters for opening file.

CSV extension: Comma delimiters are expected, and parameter values are automatically converted by Excel.

Operation sample

Reading data as Text; How to set cell attribute to "Text"

1. File tab, click Open.

2. Set file extension to Text Files (*.prn, *.txt, *csv).

3. Select a file (*.txt extension file) and open it.

4. In the Text Import Wizard:

   Step 1 of 3:

   Select Delimited, then click Next button.

   Step 2 of 3:

   Select Tab as Delimiters. When commas are used as delimiter, click Comma as Delimiters. Then click Next button.

   Step 3 of 3:

   Click the column 1 in the Data preview area, then scroll the preview cell image to the most right side.

   Then Shift + click the most right cell. (All columns are selected on this action.)

   Select Text in the Column data format area. (All cells are recognized as Text cell.

   Then, click Finish button.

Import file

TXT, CSV extension: Users can choose several setting parameters for opening file.

Operation sample

Data tab, Get External section, click From Text.

Select *.csv or *.txt file on Import Text File window.

Proceed setting same as "File open" method.

Proceed as desired.

Save file

Excel behavior has difference with the file extension of saving file name.

TXT extension: Tab characters are used as delimiters.

CSV extension: Comma characters are used as delimiters.

Notes of values on Excel

Some values, such as 00000001, are treated by Excel when Excel reads a file and values. The values are sometimes converted with undesired manner. For example, 00000001 is recognized to 1 if Excel recognizes it as a numeric number. If Excel recognizes it as a text value, 00000001 is read correctly as 00000001.

Treat as a string:

Use "…" notation for bit data, such as "00001", because Excel treats 00001 to 1. If the type of cell is set to "string", this does not happen.

Hints: Set cell attribute to string type

1. Select cells.

2. Select Format Cells.

   In the Number tab, select Text in the Category selection.

   Click OK.