Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Table Information
Value Library
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

Fill Methods

There are methods to fill in the fields:
  1. with random values. More...
  2. with the values from the list specified by the user. More...
  3. with the values from the column of another database table specified by the user. More...
  4. with the values from the file specified by the user (one value per line). More...
  5. .
  6. with the incremental values starting from the specified value. More...
  7. with the values from the Value Library. More...
  8. ignore field (uses for auto incremental fields such as identity or counter)
  9. with random values according to the mask. More...
  10. with result of the SQL statement execution. More...
  11. with results of the expression based on another column(s). More...
  12. Group item. You can not set or change this fill method directly.
  13. by custom data generator. More...

Also, you can refer to Named Generator instead of immediate specification of the data generation properties. You should select "Named Generator" from fill method drop down menu for this case.
Named Generator Selection screenshot

As to lists of values and lists in a file, the program allows you to use its special "use sequential values from the list" mode when data will be taken from the list not randomly, but sequentially in a loop.
Also, the program allows to interpret the value of the list as a mask. The "Use list items as a mask" checkbox is used to enable this mode. This option supports for "list", list "from file", "Value Library" and "From Table" fill methods.

See also: groups of fields.