VPT allows you to create your own custom test data that can be immediately used as a supporting file for your tests.
Navigate to Supporting File Creation
Supporting files can be created from two different locations:
1. Project Page: Navigate to a Project page, select Files tab, and click on the “Create Supporting File” button.
2. Test Run Configuration: Navigate to the Test Run Configuration page by clicking on the "Run a Test" button on the header, VPT Home page, or Project page and click on the “Create Supporting File” button.
Creating Your File
After clicking “Create Supporting File”, the user will be navigated to the test data generation page. This page has 3 major sections, all of which are mandatory before data can be generated. After selecting options for all sections, click on “Create Supporting File” in the bottom right of the page to generate data.
1. File Name - The name of the file can only include alphanumeric characters as well as dot (.), dash (-), and underscore (_).
2. Data Fields – The user can select a maximum of 10 fields that will fill columns in the data sheet in the order that they are listed on the page. (more detail below)
3. Amount of Data – The user can select how many lines of data the file will have per field with a maximum of 40,000.
Data Fields
There are 7 different data field options all with different types of data associated with them.
The first is Address. The user will have 7 different options: City, State, Zip Code, Street Address, Street Name, Country, and Full Address. If a user were to select address and city, the resulting .csv file would contain a column with random cities in every row up to the maximum number of data lines the user specified. Data is randomly generated and may repeat. For example, if the user selects the "address" field, then "state" with a number of data lines greater than 50, there will be multiple repeated entries because there are only 50 states. This does not mean there will be no repeated entries if the number of lines is less than 50.
The next field option is Date. There are 4 options here for Month, Weekday, Past, and Future. Month and Weekday fill the file with randomly generated values of January-December and Monday-Friday respectively. Past and Future allow the user extra configuration options such as how far in the past or future should the data be bound to, and the format of the dates generated (mm-dd-yyyy, or dd-mm-yyyy, etc.)
Another option is Finance. All three options are straightforward, creating random valid entries for possible credit card numbers and credit card CVVs. ‘Amount’ will generate a random three-digit number with two decimal places for cents.
The Internet option allows for 5 different types of information. Email, Username, Password, IP, and URL. These fields will generate random data as expected. The Name field has options for first name, last name, and full name.
The phone field only has one option of phone number, but it will generate phone numbers in a few different formats. It could generate a normal 10-digit number, 11 digits for an area code in front, or either of those options with an extension at the end.
Lastly the Random field has options for number, string, Boolean value, Guid, and Uuid. The number option allows the user to set a minimum and maximum for the randomly generated data, and the string option allows the user to set a maximum length for the generated strings.
Viewing Your Created Data
If the file is created from the project > files page (Option 1 above), the file will show up at the top of the list of all files. Click on the blue cloud icon in the "Download" column, and then the file can be opened in your spreadsheet software.
If the file is created from the test run configuration page (Option 2 above), the file will be listed under "supporting files" in the section below the button used to create the file. Click on the blue cloud icon to download the file and then open it.
