Fixing Errors and Adding Parameters
Search Knowledge Base by Keyword
Adding Parameters
It is possible to add VIP Arguments/Values by opening VIP, to identify which Argument you would like to add or change. Then open a text editor such as Notepad++. You can then add the Argument details in the file.
Example of entering an Argument into a file:
This text file should be saved as XML. You can store multiple Arguments in the same file.
Parameters are also used to control Variables.
Locating Errors in VIP Flows and side-by-side in the Control Spreadsheet
In general, an Error in the Flow is indicated by a red circle with an exclamation mark in it.
Fixing Error with Country
This Error is caused because a Table Name and a Column Name in the Configuration sheet have the same name. This is not allowed. In order to fix the problem an ‘_’ is added to the variable name.
Fix
Open the Supplier Sheet in the Configuration Spreadsheet
Change .Country should to ._Country
Fixing an IF Expression in VIP and the Control Spreadsheet
Using a Function Parameter
Whenever an ‘IF’ Expression is used, the Value must be Typecast.
Fix
Check the Type using the Expression Editor in VIP.
Example: We see that the Type is set to ‘Boolean’
It is necessary to Cast the InArgument using CTYPE((…………), Boolean)
Also be sure to put the above Type Casting statement in the Product sheet, FunctionParameters Column of the Configuration spreadsheet:
Product IsDiscontinued “CTYPE((……), Boolean)”
Using a Wrap Expression to change Values after Generation
This demonstrates how to use a Wrap Expression to generate new data based on previously generated data.
Open Order sheet and look at the WRAP_IN_EXPRESSION Column
add:
CTYPE(_VALUE_, Boolean) statement
In the In the (IF) Function Parameter Line add the IF statement as above (fixing an IF Expression)
This will have the same effect as in the previous section.
Updating the VIP flow to implement the fixes
In VIP, Save the Flow by going to File->Save and Override the Flow that you have.
Next, Open a blank Flow by going to
Tools–>Accelorator–>DataGeneration–>Browse
Select the Spreadsheet and Process
This may take a bit of time.
-
-
-
- IEnumerable to Data Reader
- Data Table to List
- Nested String List to Data Table
- List to Data Table
- IEnumerable to List
- List to IEnumerable
- Remove from List
- Exists in List
- Value Exists in Dictionary
- Key Exists in Dictionary
- Remove from Dictionary
- Get from Dictionary
- Clear Dictionary
- Add to Dictionary
- Clear List
- Add to List
- Show all articles ( 1 ) Collapse Articles
-
-
-
-
- Introduction
- Overview of the Advanced Control Spreadsheet
- Refining the Control Spreadsheet
- The ProcessModel sheet – Toggling Subset Rules
- The Tables Sheet: Defining Metadata that will be read from the Source Database
- The ForeignKeys Sheet - Specifying which Foreign Keys to read from the Source Database
- Explanation of Remaining Sheets in the Control Spreadsheet (for reference only)
-
- Overview of Post-Subset Actions
- Add Primary Keys
- Add Foreign Keys
- Add Both Primary and Foreign Keys (The Composite ADDKEYS action)
- Validate that Primary Keys are Unique
- Validate that Foreign Keys are Unique
- Validate Both Primary and Foreign Keys (The composite ValidateKeys Action)
- Drop Foreign Keys
- Drop Primary Keys
- Drop both Primary and Foreign Keys (The composite DROPKEYS Action)
- Delete Orphans
- Truncate Data
- Drop Tables
-
-
- How to Configure the Synthetic Test Data Configuration Control Sheet
- Sample Commerce Configuration Sheet Examples
- Adding Event Hooks in Configuration sheet for custom functionality
- Use Event Hooks to call VIP Flows
- How the PreProcessVariables Table is used in the Configuration sheet
- PreProcess Variables and Parameters
- Using SQL Functions to query Databases and Using the Queries in Data Generation Functions
- Different Methods for Connecting to Source Databases
- Summary of the Process to Configure the Test Data Configuration sheet
-
-
-
-
-
- Test Modeller : System requirements (Windows, Linux)
- Test Modeller : Installation components
- Test Modeller: Software Pre-requisites
- Test Modeller Core (Linux) Installation
- Test Modeller Core (Linux) Optional – Active Directory
- Test Modeller Core (Linux) Optional – SSL Certificate Installation
- Test Modeller Core (Linux) Optional – Postgres LDAP
- Test Modeller – Maintenance
- The UI Recorder
-
-
-
- Articles coming soon
-
- Articles coming soon
-
-
-
- Welcome Selenium (Java)
- Prerequisites (Selenium Java)
- Configuration (Java)
- Scan an Existing Web App
- Build a Model (Java)
- Generate Automation Code
- Execute Tests (Java)
- Import existing framework / custom page objects (Advanced)
- Edit Code Templates (Advanced)
- Extend Test Modeller (Advanced)
- Common Problems
-
-
-