Fixing Errors and Adding Parameters

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.