Data Generator

The Data Generator page provides the ability to generate data records for testing.

Available operations:

• View a list of data types in ReadyWorks
  • Columns available
    • Id – System Id of the data type
    • Data Type Name – Name of the data type
    • Type – Function of the data type (Primary, Secondary)
      • Filter by type
    • Count – Total number of data records of the data type
• View data records by selecting a data type (row) and clicking the View Records button on the toolbar
• Generate data records by selecting a data type (row) and clicking the Generate Data button on the toolbar
• Truncate (delete) data records by selecting one or more data types (rows) and clicking the Truncate Data Type button on the toolbar
• Truncate (delete) all data records by clicking the Truncate All Data Types button on the toolbar
• You can also change the number of visible rows in the table, set column visibility, refresh the table, and search for text

NOTE: The Data Generator is only available in Development mode to ReadyWorks users in the Administrator security group.

View Records

From the Data Generator page, you can view data records. To view:

1. Select a data type (row) to view
   
2. Click the View Records button on the toolbar
   
3. Clicking the View Records button will bring up the data records in a new browser tab

Generate Data

From the Data Generator tab, you can generate data. To generate data:

1. Select a data type (row) to generate data for
   
2. Click the Generate Data button on the toolbar
   
3. Select the properties of the data records to generate
   
   1. Number of Rows to Insert – Number of data records to generate (required)
   2. Name – How the name will be generated (Starts With, Random, Exactly Like)
      1.  Name String – String to prepend to generated data record names (required)
         1. Not applicable for Random
      2. Start From – Number to append to generated data record names (required) (e.g., 1, 01, 001, 0001)
         1. Not applicable for Exactly Like
   3. Data Columns (specific to the data type) – Data columns of the data type
      1. None – Do not populate the column
      2. Random Choice – Select a random value
      3. Random Date – Generate a random date
      4. Random Email – Generate a random email address
      5. Random String – Generate a random string
      6. Random Text – Generate random text
         NOTE: A required field is denoted with an orange asterisk.
4. Click the Submit button to generate data. Click the Close button to cancel the operation.

Truncate Data Types

From the Data Generator tab, you can truncate data types (delete all data records from the selected data types). To truncate:

1. Select one or more data types (rows) to truncate
   
2. Click the Truncate Data Type button on the toolbar
   
3. Click the Delete button to confirm the truncate operation. Click the Cancel button to cancel the operation.
   

Truncate All Data Types

From the Data Generator tab, you can truncate all data types (delete all data records from all data types). To truncate all:

1. Click the Truncate All Data Types button on the toolbar
   
2. Click the Delete button to confirm the truncate all operation. Click the Cancel button to cancel the operation.