T10 - Automated Test Data Generator |
Task Description |
To test your application, you often need large random data created in database. This example demonstrates how to use random variables to generate test data for testing.
 T10.htm
Note: Save the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks. Before executing the task make sure Microsoft Access with a blank table is open.
|
| Solutions |
 |
Record a new task
- Record a task that enters a value in one of the columns in your database for e.g. Microsoft Access
|
Screenshot 1
Screenshot 2
|
 |
Create a random variable
Create a random variable using the Tools->Variable Manager.
You can generate two types of random values in Automation Anywhere
- String - Specify the length of random string you want to generate
- Numbers - Specify the lower and upper range between which you want to generate random numbers. For e.g. to generate random numbers between 4 and 10 you would specify 4 in From and 10 in To.
|
 |
Populate seed data in multiple columns
Open the recorded task in Editor and put a loop of 100 around the keystroke action that enters the value in your database. Replace the recorded keystroke action with a random variable. |
| |
When you run this task, it will enter 100 random values in your table. You can change 100 to any other number and enter thousands of rows for testing purposes and save time creating those records in your database.
|
|
 |
 
| We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys. |
- Jack Greenberg
|
| Read Customer Testimonies >> |
|
