About the TDF–CSV Editor


The Test Data File (TDF) Comma Separated Values (CSV) Editor allows you to  create, edit and save TDFs. Use TDF-CSV Editor to edit CSV files and quickly and easily provision unique values.   The TDF-CSV Editor provides a Column Fill Wizard to assist you to create complex incrementing values across many rows.  As well providing built-in support for the Auto-Incrementing Groups.

Learn more about:


You may launch the TDF-CSV Editor from the Landslide home page window or you can open either the Embedded TDF-CSV Editor or Standalone TDF-CSV Editor from the TDF Parameter field in the Test Case editor window. The “Embedded TDF-CSV Editor” means it executes within Landslide Client as internal window.

NOTE: Opening large files requires a lot of memory and thus the processing / parsing of the CSV may take a long time (i.e. a symptom of low memory is CPU churn). The client will attempt to warn you when it detects low memory. Consider using the non-Embedded, Standalone TDF-CSV editor to process large files. The standalone TDF-CSV editor gets it’s own separate memory thus all memory is dedicated to the TDF-CSV function.

 

Open TDF-CSV Editor from the Landslide Home page Window

Click the Launch button TDF-CSV Editor from the Home page window, and your browser will attempt to download the TDF-CSV Editor application. This may take more than a minute with a slow connection speed and will only occur on subsequent sessions if the test system has been upgraded.

Open TDF-CSV Editor from Test Case Window

 

You may launch the TDF-CSV Editor the Embedded TDF-CSV Editor or Standalone TDF-CSV Editor from the TDF Parameter field in the Test Case editor window where you can Apply Test Data File:

  1. Select Apply Test Data  File

  2. Click ... View TDF Actions/Options Menu

The following options are available:

  1. Select a TDF (on TAS)

  2. Create a new TDF-CSV: Click to open the Create Test Data File window, navigate to the required library/folder, and enter the name of the TDF-CSV file being created (at the bottom of the window). The file opens in the TDF-CSV Editor window.

  3. Edit Selected TDF in TDF-CSV Editor (available only when you have selected a TDF on TAS)

  4. Open Selected TDF in Standalone TDF-CSV Editor (available only when you have selected a TDF on TAS)

  5. Generate Stub TDF-CSV (opens an example context specific test data file in the TDF-CSV Editor. For example, on Phonebook tab in SGW Nodal and MME Nodal test cases (when you select VoLTE option)

  6. Launch Standalone TDF-CSV Editor (to open a blank TDF-CSV Editor)

  1. Select the required option to launch the TDF-CSV Editor.

The application opens the Start TDF-CSV Editor window where you can set Java Memory and then click Launch to open the TDF-CSV Editor application window.

NOTE: Where applicable, you may click Generate Empty TDF, enter the desired value and save the values to a .CSV file for reuse.

The TDF-CSV Editor application will be downloaded. This may take more than a minute with a slow connection speed and will only occur on subsequent sessions if the test system has been upgraded.

NOTE: The TDF-CSV Editor does not require you to login.

 

^ Back to Top


TDF-CSV Editor Window

Title bar and tooltip on the Embedded TDF-CSV editor (when associated with TDF Parameter):

The TDF-CSV Editor allows you to define a .CSV file with columns, rows and values that you may include in the Test Case, to override the previous values you defined in the test case.

The table below defines the command buttons and their functions.

Buttons

Actions/Functions...

Add

Click Add to insert rows and edit each cell in the table.

Delete

Cut to Clipboard

Copy to Clipboard

Paste

Move Up

Move Down

Select row and click Delete, Cut/Copy to Clipboard, Paste, Move Up or Move Down as required.

Edit Columns

Click to open Column Editor window.

Column Fill Wizard

Click to open Column Fill Wizard window.

Optimize

NOTE: Optimize is available only when the file can be compacted.

Click Optimize to display a window (Remove These Columns ?) with a list of columns (if applicable) to be removed, to compact the TDF. You may select to remove columns with static values, no values, or all same values or keep them.

NOTE: Optimize selects columns with no values, all the same values, or with just one value (rest are blank) for deletion.

Click Yes to delete selected columns or No to cancel the operation.

TDF Info

Select for TDF-Info Dialog to display the Parameters / Columns that apply to a TDF-CSV file.

Example:

Auto-Incrementing Groups (~)

Select to add a column labeled Group Size (~) in the TDF-CSV Editor window.

See About Auto-Incrementing Groups for more detailed information on this feature.

TDF Fields

Visible only when you select a TDF (on the TC window) and open it in the TDF-CSV Editor. Click TDF Fields to display the available parameters/fields as a scroll list.

File > New

Open, Save, Save As, Close, Exit

  • New:  Open a instant of the TDF-CSV Editor. The new TDF-CSV Editor state is the same as the current TDF-CSV Editor window. For example, if the Column Fill Wizard is currently docked, then the new TDF-CSV Editor opens in the Docked state.

  • Open: Open an existing file from your disk.

NOTE: A message displays when you select File->Open saying that opening a file replaces the current table, if the current table has more than 1 row and 1 column.

  • Save: Available only for a file that has been saved previously. For new TDF-CSV Editor, Save is available only after you have saves the table using Save As.

  • Save As: Use to save a file on your disk as a .CSV file.

  • Close: Use to close the TDF-CSV Editor window.

  • Exit: Use to exit the TDF-CSV Editor application.

 

^ Back to Top


Edit Columns

The Edit Columns window allows you to insert the first line in the CSV file, add more columns and define names/labels of each column.

Add

Add a new TDF column

Add a new blank column

Add/Duplicate selected column(s)

Click Add a new TDF Column to insert column and edit column name/label. The fields that have already been added to the TDF will now be shown in Bold.

Click Add a new blank Column to insert a non-standard (or just undocumented) column.

Click Add/Duplicate Selected Column (s) to make a copy of TDF field(s).

Test Case selected TDF Opened in TDF-CSV-Editor:

  • Click Edit Columns displays the Column Editor for the selected TDF.
  • Click + to add Columns displays Add TDF Fields/Column window as a scroll list, when there are more than 15 TDF fields available to add to CSV.

Move Up/Left or Down/Right

Select column and click Delete, Move Up/Left or Move Down/Right as required.

NOTES:

  • When you launch the TDF-CSV Editor to open a specific TDF file or generate a TDF file, the Column Names displays in Italics in the Edit Columns window. The Column Name in Italics indicates that the names are in context to the current test case. You may add, edit, delete these column names as required.
  • When you open a test case selected TDF in the TDF-SCV Editor, the column name displays in Italics and TDF in brackets (TDF) indicates that the field is in context to the current test case and in the selected TDF.

^ Back to Top


Column Fill Wizard

The Column Fill Wizard allows you to select a specific column and row-range and fill them with an incrementing value.

You may also save the incrementing options as templates for reuse. Complex incrementors can be saved off so you do not have to recreate them from scratch.

Column to Fill

Select a specific column to assign value.

Filler Type

 

 

Select the Filler type used to assign a incrementing value. You may select many variations and options for the incrementing values:

Filler Type Options

Description

Constant Fill

Enter a value to be applied for your selection (applicable only for Auto-increment only within the context of Cross-Reference table. )

Random Integers

Enter Min and Max values

Incremented Integers

Enter Starting Value, # Of Repeats, Increment, Loop @ Value, Loop To Value

Incremented IPv4 Address

Enter Starting Value, Subnet/CIDR, Loop At Subnet Boundary (Stay in Subnet), # of Repeats, Increment

Multi-Filled String

See section Multi-Filled String

WPS PIN

Add support for WPS PIN - In the Filler Options, may choose to Seed or not. Will generate 8 digit numerical pin(s).

 

Rows

Specify the row-range to fill with the defined incrementing value. For example rows 0 to 50 may have certain values with a specific filler type and rows 51 to 100 may have another set of values based on a different set of filler type.

Groups

Click ... to open Group Editor window and define groups of row as required. Use Add, Delete, move up and down arrows to define, order, and delete as required.

You may specify the number of rows of a column to be grouped together where you can define similar information to be filled.

NOTE: Groups defined are not saved with the TDF.

Use the row-range (for example 1 to 50) and Filler Type to define the information to be filled in each column for the specified range of rows, change the range of rows (for example 51 to 100) and repeat the process.

Save, Open, Select Built-In

These options apply only to Multi-String fillers.
Save Click to save a TDF-CSV multi-string filler template for later use.  
Open Click to open an existing TDF-CSV multi-string filler template.
Select Built-in Click to select a multi-string filler built-in template. For example, email address, IPv4 increment, and so on.

 

Dock as Panel

Click Dock as Panel to dock the Column Fill Wizard as a panel of the main TDF-CSV Editor window. When docked, the Column Fill Wizard is in a split pane on the right side, which may expanded or collapsed.

You may click Undock to separate the main window and the Column Fill Wizard.

When opening a new editor via File->New it will maintained the Docked state of the editor you called it from.

Fill and Close Click Fill and Close to fill the selected Column to Fill with the Filler Type and close the Column Fill Wizard window.
Fill Column Click Fill Column to fill the selected Column to Fill with the Filler Type and continue to work in the Column Fill Wizard window.
Close Click Close to exit the Column Fill Wizard window.

Multi-Filled String

Allows you to enter string format with five different incrementing values.

Base String

Indicates the name/text that appears in the parameter and is the initial value (non-incremented) for the Parameter (resulting text displayed in Preview pane).

String w/Fillers

Displays the resulting text based on the number of fills and values you select.

# of Fills

Select a fill value 1 to 5. The resulting text changes according to the # of Fills.

Edit Fill #

Select the Fill # and edit Fill Offset, Starting Value, # of Repeats, and the related information displayed below the Edit Fill #.

Fill 2 Offset

Offset is not available if Type is None (Do Not Increment). The parameter indicates the position of the auto-increment value. That is, whether the auto-increment value is a prefix, suffix, or within the base text. For example, if the Base String is user, the auto-increment value is positioned as follows according to the Offset value you select.

  • Offset 0= <auto-increment value>user
  • Offset 4= user<auto-increment value>
  • Offset 2= us<auto-increment value>er
NOTE: An error displays if you select a value larger than the length of the text. That is, selecting 5 when the Base Text is user, displays an error.

 

Increment/Random

Select the type of incrementer you want to use or incrementing you want to happen.

  • Increment: Indicates the Amount to increment by entering the Starting Value and # of Repeats

  • Random: Indicates a range of values used for incrementing. Enter the minimum and maximum values to be used.

Starting Value

The starting value in an incrementing field, for integer, any value, for IP can be v4 or v6

# of Repeats

The number of times to duplicate a value, that is whether to repeat once, twice, and so on. Valid range is 0 - 255.

The number of times to repeat the value,

  • 0 indicates no repeats, that is, the value appears once.
  • 1 indicates that the same value repeats once, that is, occurs twice.
  • 2 indicates that the same value repeats twice, that is occurs three times.

Increment

The value to increment (increase or decrease) each time, valid range 1 to 255.

Min

Max

Enter the minimum and maximum values to be used to Fill Offset value. Min and Max are available when you select Random Integers as the Filler Type.

Loop @ Value

Indicates the value that causes the incrementing to loop

Loop To Value

Indicates the reset value assigned after reaching the Loop To Value.

Padded Digits

Indicates the number of digits displayed. Select Padded Digits and increment the values as required. The incremented value is prefixed with 0’s until the number of digits is equal to Padding value. Valid values is 1-24.

Subnet Mask/CIDR

Enter a Slash/CIDR mask or 255.255.255.255 mask

Loop At Subnet Boundary (Stay in Subnet)

Select to make sure the IP address is incremented within the subnet boundary.

Preview

Displays the value of the parameter based on the auto-increment values. You may select to limit preview to 500 values.

^ Back to Top


About Auto-Incrementing Groups

TDF-CSV files allow users to define unique values for each individual object it is meant to support.   To accomplish this, the file must have a row for each object.   For example to provide auto-incremented round robin ports for UEs on a DMF, you would use the Apply DMF Initialization from Test Data File TDF and have a line for each UE.   This example is just for demonstration purposes.

Source Port Dest
Port
 Dest IP Address
110 2000  192.168.0.1
112 2002  192.168.0.1
114 2004  192.168.0.1
116 2008  192.168.0.1
118 2006  192.168.0.1
120 2010  192.168.0.1
110 2000  192.168.0.2
112 2002  192.168.0.2
114 2004  192.168.0.2
116 2006  192.168.0.2
118 2006  192.168.0.2
120 2010  192.168.0.2
... ... ...

The first 6 UEs will target the same destination address, but use different ports, then the next 6 repeat that on a different address. With 1000’s of UEs this could get quite large.

To reduce the size of the TDF, we can use the Auto-Incrementing Groups (AIG) feature. For most TDF-CSV files (Trial and error, or contact support to know), Landslide supports AIG where each line can represent a group of multiple objects, and the fields can use auto-incrementing syntax to define the sequence of values for each object in the group. This allows users to define much smaller files when sections are using the same values or simple auto-incrementing values. Using our example above, we can reduce it by a factor of 6 to 1, by using  auto-incrementing syntax for the Ports and having each row expand to 6 UEs, but using the Group (~) column to indicate the size of the Group:

~ Source Port Dest Port Dest IP Address
6 #(N110 0/2) #(N110 0/2)  192.168.0.1
6 #(N110 0/2) #(N110 0/2)   192.168.0.2
... ... ... ...

When executed the Test Server will automatically expand this to match the earlier example.

To help users build the Auto-Incrementing Groups, our TDF-CSV Editor  provides functions to add the Groups (~) column and to build the auto-incrementing syntax for the fields.


 

After which editing any field offers the Auto-Increment Syntax Wizard:

Click OK applies the syntax and saves it to the TDF:

Using the TDF-CSV Editor is not a requirement, how the TDF is filled out does not matter, as long as the Test Server supports AIG for the TDF-CSV parameter, and the TDF’s first column is the Group (~) indicator, the TDF will be using AIG.

^ Back to Top