Skip to content

Configuration

RealTestData - Testdata generator for real world scenarios

RealTestData is the only test data generator that creates simulated yet realistic data for testing purposes. It can produce a wide range of data types, including names, addresses, emails, passport numbers, passwords, credit card numbers, IBANs, and much more.

RealTestData_Windows GUI makes it easy to manage the three parts Init, Configure and Generate on Windows in one GUI. For Mac and Linux, command-line versions are available to handle Init, Configure, and Generate operations.

You will find here a full list of supported data types and detailed functionality. This configuration description covers all all available countries and data types.

The documentation describes all functionalities of the programs (CLI for Windows, Linux and Mac, GUI for Windows) which are part of RealTestData platform.

Picture

How RealTestData works

RealTestData uses several datasets and puts together data in a realistic and random way. Here is a brief explanation of how it works:

  1. Names: We use real, most common first and last names for each country.
  2. Addresses: We use real addresses, including streets, ZIP codes, and towns for the supported countries.
  3. Credit Cards: Valid numbers that pass the Luhn test.
  4. Phone Numbers: Correct country and area codes.
  5. Birthdates: Valid dates within a specified age range.
  6. Emails: Use real domains and random names, sometimes adding numbers for uniqueness.
  7. Passwords: Randomly generated based on specified criteria.
  8. Other Data: Simulated but realistic other personal details.

Info

You can find a list of all supported fields under “Supported Data Fields”

Configuration and Templates

RealTestData allows you to customize the output format and data through configurations and templates. Here’s what you can do:

  • Use templates for specific export formats such as CSV or JSON.
  • Edit configurations directly or using the command line or GUI.
  • The configuration and template files are stored in the “Documents” folder.

The template is part of the configuration. You can set up as many templates as you want, name them and save them. The template can be CSV output settings, output columns settings, or anything else stored in the configuration or output countries or language settings. The template names their file names and part of the used configuration is stored in the configuration. When you add a new template or edit a template, you must specify the parts of the configuration that you want to include in the template. For example, if you want to save the output columns, you must set the output columns in the configuration. After saving the template, you should reload the configuration.

Command Line Interface (CLI) and Graphical User Interface (GUI)

RealTestData offers both CLI and GUI for configuration and data generation:

  • CLI: Available for Windows, Linux, and Mac.
  • GUI: Available for Windows, user-friendly, with templates and self-explanatory options.

Export Formats

Our platform creates and exports test data to the most common formats you need: CSV, JSON, XML, SQL, and Excel. The export can be adjusted to your needs:

  • CSV
    Delimiter like Semicolon, Comma, and Tab are choosable, Quotes (single and double quote or nothing), and Linebreaks (PC, Linux, and Mac Format) are choosable

  • JSON
    You choose whether to export empty strings or output as a JSON array

  • XML
    XML Root and Record are choosable

  • SQL
    Table creation and Database name are choosable. The result can be directly imported to any database like SQLite, SQL Server, Oracle, Postgres, and others

  • XLSX
    Creates a valid Excel file, which can be loaded directly into Excel

You choose the path where our platform stores the exported data. Local and network paths are possible.

Configuration

The whole configuration of how our platform creates real test data is stored in a “config” file in your Documents folder. You can decide to change the configuration file directly in any text editor or you have the option to use a command line utility which is available for Windows, Linux, and Mac. The best option is to use our Windows GUI. The GUI is completely self-explanatory so there is no need for extensive documentation.

Templates

RealTestData allows you to customize the output format and data through configurations and additionally templates. Use templates for specific export formats like CSV or JSON.

There are also several templates available which make it even easier. You can load a template specific for CSV output or you can also load a template, which uses different columns for output. So you want to change only a few parameters? Use a template with industry-approved data. You can create your templates also manually by storing a part of the configuration file.

Language Support

Our RealTestData Platform (CLI and GUI) is available in 4 languages for output and configuration

  • English
  • French
  • German
  • Czech

Our platform can export the data also in these 4 languages, you can change the language anytime in the menu or the configuration file.
This is important when you need test data like country name or salutation in another language than English.
The export itself includes Headlines and all other data (like Salutation, Marital Status, Eye color, etc.) in these 4 languages.

Realistic Data

Just to repeat here: all created random and simulated data is realistic, this includes:

  • The companies in these datasets do exist
  • Forenames and Lastnames are representative of the countries selected (most common Forenames and Lastnames in these Countries)
  • Addresses do exist including Street, ZIP, and Town in selected countries and street, Zipcode, Town, and State always fit
  • Especially ZIP and Town fit, so it is always an existing ZIP in that town
  • Passport IDs are valid according to rules known for the specific country
  • Phone numbers have the correct Country Code and for larger cities mostly the correct area code. We have collected thousands of area codes for many countries
  • Credit Card numbers are valid, either test numbers or numbers which pass the Lund Test
  • You can decide how many percent are used to use testing numbers or are random numbers which pass the tests for valid credit cards
  • Credit Card expiry dates are valid and CCV numbers are random
  • Birthdates are valid dates and you can decide from what to what age the birthdates should be created
  • Emails are simulated but all domains used are real and existing. You can add personal, university, and business domains from huge companies
  • You decide whether we should add personal, university, and company addresses
  • As known personal emails are today 50% Gmail addresses, so here are fantasy names allowed. We use musicians, stars, old Greek gods, etc. for creating an email address
  • To have unique email addresses we use additionally in many cases up to 5 extra numbers, you can decide about the percentage of fantasy mail and if extra numbers should be used
  • Fantasy names include Greek gods, musicians, historic figures, or films to be taken for private emails
  • Passwords are created according to selectable schemes with lower/uppercase letters, numbers, and special characters
  • Passwords are completely random but according to the rules which contain also min. and max. length of the password
  • Any number is a very powerful feature, you can use it for social security number as well as personal identifier
  • Any number can include initials, first and last names as well as birthday date and additional random numbers/letters
  • You can exactly decide about the format of the any number feature
  • Working day is also a powerful feature when you need a delivery day in the future on a workday
  • Our platform has all public holidays included, so the delivery date 10 days in the future may be different for different countries
  • Marital status is used randomly
  • Birth name is according to the marital status of the person, like single women do not have a different birth name
  • State is used only for Italy and the US where it is part of the address
  • Phone numbers have the correct area code for most cities according to the town. When using mobile numbers, the mobile area codes are correct
  • For countries like Czech, Slovakia, Iceland, and others the woman names are correct according to first names and an “ova” or “dottir” are added
  • Eye Colour is taken randomly but all colors do exist

Info

Our platform can create up to any number rows to export (usually 100-1000 should fit).

You can use as many countries for an output as you want. You can decide how many columns you want to have, this may be only first/last name but maybe also all available columns. Also composite columns are available, where you can summarize more than a column to a new column.

Supported Countries

Our platform supports today 41 different countries from Europe, the US, and India. New countries will be added continuously. Right now CA = Canada, MX = Mexico and TR = Turkey are in the making. All source data files are stored in the TestData directory in an encoded format.

Note

The trial version supports only the first 5 countries (Germany, US, UK, France, Czech Republic) and is limited to 20 different entries per First/Lastname, Address, Area Code, and all other entries. Nevertheless you can see the power of our platform creating umlimited data.

  • Germany
  • US
  • UK
  • France
  • Czech
  • Italy
  • Belgium
  • Netherland
  • Luxembourg
  • Austria
  • Switzerland
  • Spain
  • Portugal
  • Poland
  • Slovakia
  • Slovenia
  • Croatia
  • Hungary
  • Norway
  • Sweden
  • Denmark
  • Finland
  • Romania
  • Bulgaria
  • Liechtenstein
  • Monaco
  • San Marino
  • Andorra
  • Iceland
  • Greece
  • Estonia
  • Latvia
  • Lithuania
  • Cyprus
  • Bosnia-Herzegovina
  • Montenegro
  • North Macedonia
  • Serbia
  • Albania
  • Malta
  • Ireland
  • India
  • Worldwide

Supported Data Fields

RealTestData can generate a wide range of data fields, including

Abbr Name Description
N Number Every datarow gets an unique sequence number
S Salutation Depends on the Forename, Salutation is in German, English or French
F Forename The most used Forenames in the selected country
L Lastname The most used Lastnames in the selected country, with the correct ending for women (CZ,SK,BG,MK;IS;LV;LT)
R Birthname Empty when Gender male or female is single, otherwise choose from the most used Lastnames in the selected country
U Marital Status Single, Married, Widowed, Divorced in German, English or French
V Credit Card No Either a test CC number or an emulated CC Number which passes the Lund test with the extra checked number
8 CC Expiry Date Either a month in the future or the actual month
9 CC CVV Any number with 3 or 4 digits
M Company An in the selected country existing company
A Address/Street An existing street in this town and country incl. street number
Z ZIP An existing zip which belongs to this town, all UK ZIPS are correct with street and town, all German ZIP are correct for Street and Town
P Part Town Only when specified for the address, used seldomly mostly UK
T Town Existing Town in the country, no fake names
E State Used in US and Italy only
C Country The long countryname in English, German or French
O Phone Correct Country Code and AreaCode when known, only small towns will have a simulated Areacode, All mobile phones have the correct AreaCode
B Birthday It´s an existing date and person is between 18 and 80
I eMail Either a university, a company email or a private email from Gmail and other providers. First and Last is either shortened in different ways like companies do or it is a specific email with numbers and known personalities
X Passport ID Create a valid ID for all countries with the country specific characteristics
W Password Create a password according to choosable rules: Length min/max, Lower/Uppercase/Numbers/SpecialCharacters
H AnyNumber Create any kind of string using different formats according to choosable rules:
N=Number, L=Lower, U=Upper, A=lower+upper, X=Upper+Numbers M=mix of all, other chars are not converted
Example of any number = “YYMMDD-FL-NNN.UUU/XXX-UNX”, (YYMMDD can be Birthdate, FL can be initials,
FLLL can be Firstname Initial + Lastname full
VAT Creates a european VAT number for you
PERSID Creates a personal identification number which is valid in CZ and SK and follows specific rules
Y Eye Colour Selects an existing eye color according to world standards
1 Linkedin Emulated Social Account Name
2 Facebook Emulated Social Account Name
3 Instagram Emulated Social Account Name
4 Pinterest Emulated Social Account Name
5 X Emulated Social Account Name
6 Telegram Emulated Social Account Name
D IBAN Emulated IBAN Number
7 WorkingDay A working day in the future (STD: delivery in 10 working days)
Q Composite Field A field composed of several fields like specified in setting
G Composite Field A second field composed of several fields like specified in setting
J Long Text Produces a text field with 100s to 1000s characters long. The language is either the native country language or Englisch.
K Bitcoin Address A simulated Bitcoin Address
0 UUID A Universally Unique Identifier (UUID)

Composite Testfields

Additionally Realtestdata can create composite fields which connects more than one field. Example: Salutation Forename and Lastname in one field.
You specify these fields in a composite field. In order to do that mark these fields on the selected fields and click CF1, which is composite field 1. The same procedure is valid for CF2, where you can choose fields like Zip and Town to connect both in one field.

Data for Negative Testcases

Realtestdata can produce data for negative testcases. With negative testing, a software program is evaluated against false or incorrect data. Negative testing is a technique to ensure an application can handle unexpected input, when inputting invalid or out-of-range data. This testing identifies vulnerabilities or weaknesses in error-handling capabilities. It ensures the system fails gracefully rather than crashing or providing incorrect results. By identifying such issues beforehand, you can improve the application’s robustness and ensure users have a seamless experience even under negative conditions.

For the following fields data for negative testcases can be produced:

Forename
Lastname
Company
Address/Street
Town
eMail
Linkedin
Facebook
Instagram
Pinterest
X
Telegram

You can specify, which fields should produce data for negative testcases.
Data for negative testcases means, that the field length will exceed the maximum length of a field specified and you will get errors.

Example

When Town is marked as negative and the max. length is specified to 30 characters then RealTestData will produce towns with 30+ characters. To achieve this RealTestData is using Wordlists in specific languages or English, when no wordlist exist for this specific language.

Names and Addresses

Forenames are specific to the country. Depending on the forename is the salutation and also the Lastname in countries where is a difference between male and female last names exist. Addresses have valid street, which really exist in these towns, also States are correct for those addresses and towns. ZIP is always correct and corresponding to the town chosen.

Passport ID

Passport ID is very realistic. All forms of european passport numbers are included and even it is a random number the IDs may exist

AnyNumber

AnyNumber is a very powerful feature: it can be a Healthcare Number, or a personal identifier or a social security number. You decide about the format of this number with Names, Birthday, Numeric or Alphanumeric letters. Additional RealTestData can produce realistic VAT numbers valid in the EU. Also a personal identification number is possible, which is used in CZ and SK only.

Social Accounts

Social accounts are as realistic as possible Minimum and maximum length are taken into account as well as extra letters allowed like underscore or period.

IBAN

The IBAN is computed as realistic as possible. Digits 3 and 4 are correctly computed so the IBAN passes the major tests. Many european countries have in their local part also check digits. For most of these countries the check digits are computed correctly. When the check digit is unknown or does not exist, RealTestData takes random values. Also the length of the IBAN is taken into account. India, US and other countries do not use IBAN, so the IBAN is blank.

An IBAN has the following look: CCXXBBBBBBBBBBBBBBBBBBBBB (CC = Country Code, XX = 2 check digits computed by MOD97-10, BB = National Basic Bank Identification Number). BB may consist of Bankcode and Bankbranch to identify a bank and the Account number. Both can include additional check digits and are numbers or upper letters. An IBAN can be between 16 and 31 chars long. When a list of Bank Codes of the Country do exist, then this one is chosen otherwise a random number When a list of Branch Codes of the Country do exist, then this one is chosen otherwise a random number. The account number is always created by random and can start with 4 digits up to the national length. When an national check exist, then this is computed for every number extra when the algorithm is known.

Bitcoin Address

A simulated Bitcoin Address which is 27-34 char long and unique. Numbers 0-9 and chars a-z are used.

UUID

A Universally Unique Identifier (UUID) is a 128-bit label used for information in computer systems. The term Globally Unique Identifier (GUID) is also used, mostly in Microsoft systems. A UUID has 32 bytes. Here numbers 0-9 and chars a-f are used.

RealTestData Platform

Usage Scenarios

RealTestData is suitable for various testing scenarios, such as:

* Load Testing
* Functional Testing
* Regression Testing
* Security Testing
* GDPR Compliance Testing
* Negative Testing
* Edge case Testing

By using RealTestData, you ensure that your test data is realistic, compliant, and safe from privacy concerns.

Installation and Setup

To install RealTestData:

  1. Download the Windows installer from our website.
  2. Run the installer and follow the instructions.
  3. Open the GUI (RealTestData Windows) or CLI (RealTestData Program, RealTestData Configuration ) to configure your test data generation.

Note

For detailed instructions, refer to our user manual or online documentation.

Updates

RealTestData is continuously updated to include new features and supported countries.

  • Visit our Homepage or Contact us via email at info@realtestdata.com.
  • You can download our Trial Version from our website to try out, whether our platform is suitable for you.
  • The trial version is limited to 4 countries (Germany, UK, US and France) and uses only 20 datalines for every field like 20 Forenames or 20 Lastnames.

License Information

RealTestData is licensed software. Please refer to the license agreement provided with your purchase for terms and conditions.
Our licensed platform supports 41 countries listed here and have Millions of addresses and names included.
You can create millions of datasets without repeating any of these.

Conclusion

RealTestData provides a robust and flexible solution for generating realistic test data, ensuring your testing process is efficient, secure, and compliant with data protection regulations. With extensive customization options, support for multiple languages and countries, and various export formats, RealTestData is the ideal choice for your testing needs.

Contact Information:

Real Test Data
RealTestData s.r.o., Hlavni 373, 25089 Lazne Tousen, Czech Republic
info@realtestdata.com