This data type randomly generates human names (mostly Western) according to the format you specify. You can specify multiple formats by separating them with the pipe (|) character. The following strings will be converted to their random name equivalent:

This data type randomly generates names. It works in the same way as the Names data type, except that it creates slightly more realistic data sets since the names are mapped to the country; e.g. Italian names appear when the data set row has Italy for the country field. Because of this additional complexity, however, the code runs slightly slower. You can specify multiple formats by separating them with the pipe (|) character. The following strings will be converted to their random name equivalent:

Whatever text you enter into the options text field will be used to generate telephone numbers. Capital X's will be converted to a random number between 1 and 9; lower-case x's will be converted to a random number between 0 and 9.

Select one of the values in the example dropdown for some ideas. Remember: anything other than the X and x character are left unconverted.

As with many of the other data types, to generate phone numbers in multiple format separate them with a pipe | character.

This Data Type tries to generate a phone number in an appropriate format for the row of data. If it encounters an unfamiliar country, it generates a default phone number in the format (xxx) xxx-xxxx.

No help available.

This data type generates a random company name, comprised of a lorem ipsum word and an appropriate suffix, like Dolor Inc., or Convallis Limited.

Generates IBAN (International Bank Account Number).
The generated IBAN has a valid checksum, countrycode and length and the BIC is in the right place.
The number is highly unlikely to be really "valid" tho, since there are usually a bunch of checks to do which are country specific.

No help available.

No help available.

Generates a random zip or postal code. For greater control, use the alpha-numeric data type option.

Generates random Canadian provinces, states, territories or counties, based on the options you select. The Full Name and Abbreviation sub-options determine whether the output will contain the full string (e.g. "British Columbia") or its abbreviation (e.g. "BC"). For UK counties, the abbreviation is the standard 3-character Chapman code.

No help available.

This data type generates a random latitude and/or longitude. If both are selected, it displays both separated by a comma.

This data type generates random, valid credit card numbers according to the format you specify. It is currently capable of generating numbers for the following brands: Mastercard, Visa, Visa Electron, American Express, Discover, American Diner's, Carte Blanche, Diner's Club International, , JCB, Maestro, Solo, Switch, Laser.

Generates a random credit card PIN number from 1111 to 9999.

Generates a random credit card CVV number from 111 to 999.

Track 1 contains the cardholder's name as well as account number and other discretionary data. The credit card may be of any type (Visa, Mastercard, etc).

Track 2 contains the cardholder's account, encrypted PIN, plus other discretionary data. The credit card may be of any type (Visa, Mastercard, etc).

This option generates a fixed number of random words, pulled from the standard lorem ipsum latin text.

This option generates a random number of words - the total number within the range that you specify (inclusive). As with the Fixed number option, the words are pulled the standard lorem ipsum latin text.

This Data Type lets you generate random alpha-numeric strings. The following table contains the character legend for this field. Any other characters you enter into this field will appear unescaped.

Generates a column that contains a unique number on each row, incrementing by whatever value you enter. This option can be helpful for inserting the data into a database field with an auto-increment primary key.

The optional placeholder string lets you embed the generated increment value within a string, via the {$INCR} placeholder. For example:

• ROW-{$INCR} -> ROW-1, ROW-2, ROW-3, ROW-4, ...
• {$INCR}F -> 1F, 2F, 3F, 4F, ...

This randomly generates a number between the values you specify. Both fields allow you to enter negative numbers.

Generates a unique, random GUID (globally unique identifier) of the form: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX, where X is any hexidecimal digit).

This data type generates random currency values, in whatever format and range you want. The example dropdown contains several options so you can get a sense of how it works, but here's what each of the options means.

No help available.

This data type lets you generate a column of data that has repeating values from row to row. Here's a couple of examples to give you an idea of how this works.

• If you'd like to provide the value "1" for every row, you can enter "1" in the Value(s) field and any value (>0) in the Loop Count field.
• If you'd like to have 100 rows of the string "Male" followed by 100 rows of the string "Female" and repeat, you can enter "100" in the Loop Count field and "Male|Female" in the Value(s) field.
• If you'd like 5 rows of 1 through 10, enter "5" for the Loop Count field, and "1|2|3|4|5|6|7|8|9|10" in the Value(s) field.

Try tinkering around with it. You'll get the idea.

The Composite data type lets you combine the data from any other row or rows, and manipulate it, change it, combine the information and more. The content should be entered in the Smarty templating language.

To output the value from any row, just use the placeholders {$ROW1}, {$ROW2}, etc. You cannot refer to the current row - that would either melt the server and/or make the universe implode.

Here are a few examples:

• Display a value from row 6: {$ROW6}
• Assuming row 1 and row 2 contain random numbers, the following are examples of some simple math:
  • {$ROW2-$ROW1} - subtraction
  • {$ROW2*$ROW1} - multiplication
  • {$ROW2/$ROW1} - division
• If row 1 contains the number 5, display "N/A", otherwise just display the number. {if $ROW1 == 5}N/A{else}{$ROW1}{/if}

Please see the Smarty website for more information on the syntax.

This data type lets you generate tree-like data in which every row is a child of another row - except the very first row, which is the trunk of the tree. This data type must be used in conjunction with the Auto-Increment data type: that ensures that every row has a unique numeric value, which this data type uses to reference the parent rows.

The options let you specify which of your form fields is the appropriate auto-increment field and the maximum number of children a node may have.

Enter a list of items, separated by a pipe | character. Then select whether you want Exactly X number of items, or At most X items from the list. Multiple items are returned in a comma-delimited list in the results. If you want your data set to include empty values, just add one or more pipe characters at the end - the more pipes you enter, the greater the probability of an empty value being generated.