Introduction to Templates

Previous  Top  Next

"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:

Creating a New Template
Using a Template
Deleting a Template (Includes notes about "dependency tracking")

 

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