Generates human names (mostly Western) in any format you need. You can specify multiple formats by separating them with the pipe (|) character. The following strings will be converted to their random name equivalent: Name A first name, male or female. MaleName A male first name. FemaleName A female first name. Initial An upper-case letter, A-Z. Surname A random surname.

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: Name A first name, male or female. MaleName A male first name. FemaleName A female first name. Initial An upper-case letter, A-Z. Surname A random surname.

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.

Generates 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.

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

This Data Type generates a random SIRET/SIREN French business identification number. SIRET: A random SIRET compound of a SIREN and NIC ( 508102811-00009 ). SIREN: A random SIREN (508102811). More info: WIKI SIRET

No help available.

Generates a personal number, used in some countries for social security insurance. At the present time only swedish ones are supported. The personal numbers are generated according to the format you specify: PersonalNumberWithoutHyphen A (swedish) personal number with 12 siffers and no hyphen PersonalNumberWithHyphen A (swedish) personal number with 12 siffers and an hyphen

Generates organisation numbers, used in some countries for registration of companies, associations etc. At the present time only Swedish ones are supported. The organisation numbers are generated according to the format you specify: OrganisationNumberWithoutHyphen A (Swedish) organisation number with 12 siffers and no hyphen OrganisationNumberWithHyphen A (Swedish) organisation number with 12 siffers and a hyphen

No help available.

No help available.

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.

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. L An uppercase Letter. V An uppercase Vowel. l A lowercase letter. v A lowercase vowel. D A letter (upper or lower). F A vowel (upper or lower). C An uppercase Consonant. x Any number, 0-9. c A lowercase consonant. X Any number, 1-9. E A consonant (upper or lower). H An Hexidecimal number (0-F)

Generates a Boolean value in the format you need. You can specify multiple formats by separating them with the pipe (|) character. The following strings will be converted to their Boolean equivalent: Yes or No

False or True

0 or 1

Y or N

F or T

false or true true and false values are special. Depending on the export type, these may be output without double quotes.

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, ...

-> 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.

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. Format The format field governs exactly how the money value should be formatted. X's are converted into a number: all other values are left as-is. Range - From Specifies the lower range of whatever values you want to generate. Note: this field should only contain numbers and (if you want) a decimal point and two following numbers to represent cents/pence/etc. Range - To The upper range of the numbers to generate. Currency Symbol Whatever currency symbol you want to use, e.g. $, €, etc. Prefix/Suffix This determines where the currency symbol should appear.

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.