Creating a New Template

Previous  Top  Next

You can create a new template by using the Create New Template button from the template list or the Templates | New Template menu.

 

 

This will start the Create Template Wizard:

The Create Template Wizard

 

At the Welcome page, the first thing you need to do is to select a template data type by using the drop down box.

 

After selecting the data type, the next page will allow you to select the data-generation type and adjust the values accordingly. The possibilities are different for each data type:

 

Text
Integer
Number
Date/Time
Large Text
Large Binary

 

All templates need a name, unique for the specified data type, and a "value type" to generate data.

 

Selecting an item from the Value type box shows details on how to create such a value, in the lower part of the dialog.

 

After you have created one or more templates, you can use them when creating or modifying a Data Generator Project.

 

Text Template

The following are possible with a text data type template:

 

Fixed Value

Enter a value in the Fixed Value edit box. The same value will be used for all data-rows.

Random Values

Different random values will be generated, see below.

Increasing Values

A numerical sequence with optional leading digits.

Value from List

A random value from the specified list will be taken for each data-row.

 

Random Values

A random string value can mean a lot of things. For a template, the following random values are possible:

 

Random Values

A randomly generated string with a length between the specified values. Use the same values to generate a fixed-length string value. Single characters are taken from the "printable" range of characters.

Random GUID

A global unique identifier (GUID).

Example: {E2B6008E-24CE-4412-907F-5A764C033E02}

Random URLs

Creates random URLs from a set of top level domains and domains.

Random e-mail address

Creates a random email address take from a random last-name, random top level domain and a random provider name.

Random address

Creates a random street-address by taking a random street name from a data library and concatenating it with a (house) number.

Random full names

Creates a random first-name + last-name combination by taking both from a data library.

Macro

A powerful way to create custom values. See Macro Values for more information.

 

Integer Template

The following are possible with an integer data type template:

 

Fixed Value

Enter a value in the Fixed Value edit box. The same value will be used for all data-rows.

 

Random Values

Different random values will be generated, each value between the specified values.

 

Increasing Values

Creates a new value for each row starting at the specified Start at value and increasing the value for each row by the specified Step value.

 

Value from List

A random value from the specified list will be taken for each data-row.

 

Number Template

The following are possible with a number data type template:

 

Fixed Value

Enter a value in the Fixed Value edit box. The same value will be used for all data-rows.

Random Values

Different random values will be generated, each value between the specified values.

Increasing Values

Creates a new value for each row starting at the specified Start at value and increasing the value for each row by the specified Step value.

 

Date/Time Template

The following are possible with a date/time data type template:

 

Fixed Value

Enter a value in the Fixed Value edit boxes. The same value will be used for all data-rows.

Random Values

Different random values will be generated, each value between the specified values.

Increasing Values

Creates a new value for each row starting at the specified Start at value and increasing the value for each row by the specified stepping values. Increments can be per second, minute, hour or days.

 

When using a date/time template for a date-only column, the time will be truncated. When using it for a time-only column, the date will be truncated. Do note that, for example when using "Increasing values", you can use an increment of half a day (12 hours) and still insert only the day part. This will result in each 2nd row having a new "day" value.

 

Large Text Template

The following are possible with a large text data type template:

 

Fixed Value

A piece of text.

Random Values

One or more random generated paragraphs (Lorem Ipsum, see Wikipedia), with optional pre- and suffix.

Files from Folder

A random file from a certain folder, as specified according to the file filter.

 

Large Binary Template

The following are possible with a large binary data type template:

 

Fixed Value

A single file, make sure it's accessible when running the project.

Files from Folder

A random file from a certain folder, as specified according to the file filter.