"Templates" are a powerful way of making it more easy to create your Data Generator Project. They can be seen as "shortcuts" to data generation, or as a library of pre-configured data generation.
The Advanced Data Generator comes with a set of pre-defined templates to get you started.
Templates are data type specific, when you choose to select a template as the method of generating data, only the templates for that specific data type will be shown.
Templates are supported for the following data types:
Data type
|
Description
|
Database data types
|
Text
|
Character data, can be Unicode
|
CHAR, VARCHAR, NCHAR, NVARCHAR, GUID
|
Integer
|
A number without a decimal component
|
INTEGER, SMALLINT, TINYINT, LARGEINT, BYTE, WORD
|
Number
|
A number with a decimal component
|
REAL, FLOAT, DOUBLE
|
Date/Time
|
A date, time or combined "date/time" value, no "duration"
|
DATE, TIME, DATETIME, TIMESTAMP
|
Large Binary
|
Sequence of bytes of specified or unspecified length
|
BLOB, IMAGE, VARBINARY, BINARY
|
Large Text
|
Large pieces character data, can be Unicode
|
TEXT, NTEXT
|
More information can be found here:
List of pre-defined templates with explanation
There are a few sample templates inserted into the database at your first start of the Advanced Data Generator.
Some of these templates are used in the sample project & video.
Name
|
Description
|
Company domain name
|
Takes a company name from the data library, removes special characters and prefixes it with "www" and adds ".com"
|
Postcode: Australian
|
A postal code, formatted as a valid Australian postcode, eg: 0247
|
Postcode: Belgian
|
A postal code, formatted as a valid Belgian postcode, eg: 2457
|
Postcode: Dutch
|
A postal code, formatted as a valid Dutch postcode, eg: 8365 AB
|
Postcode: French
|
A postal code, formatted as a valid French postcode, eg: 87524
|
Postcode: German
|
A postal code, formatted as a valid German postcode, eg: 23324
|
Postcode: Italian
|
A postal code, formatted as a valid Italian postcode, eg: 23324
|
Postcode: Spanish
|
A postal code, formatted as a valid Spanish postcode, eg: 044621
|
Postcode: UK
|
A postal code, formatted as a valid UK postcode, eg: BA4 4RG
|
Postcode: US
|
A postal code, formatted as a valid US postcode, eg: 06512
|
Sequence, 4 digits, leading zeros
|
A numerical sequence, starting at 1, with leading zeros, of 4 digits wide
|
Sequence, 6 digits, leading zeros
|
A numerical sequence, starting at 1, with leading zeros, of 6 digits wide
|
|
|
Sequence, starting at 1
|
A numerical sequence, starting at 1, increased by 1 for each step
|
|
|
Product images
|
Takes product JPEG-images from a folder
|
|