Configuration

RealTestData - Safety, Speed, Accuracy in Test Data Generation

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. Referantial integrity is the main goal of RealTestData. As example the ZIP always belongs to the correct town and the phone is possible in this town. When the last name has a special format like in Czech Republic or Iceland, then the first name is corresponding.

The RealTestData GUI for Windows, MacOS and Linux makes it easy to manage all the data to get correct results. When you loose your configuration data, run Init in the GUI. When clicking on Generate, the results will be computed according your configuration.

In this configuration you will find 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 in the GUI and what to choose when in the RealTestData platform.

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:

What does RealTestData create

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

Referential integrity

Realtestdata produces data with correct referential integrity. That means that street belongs to this specific town and zip also belongs to town and country. Phone number are from this country and has usually the correct area code.

Note

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 or for othe specific data like renaming colummns.
• Edit configurations and templates using the 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 and configuration, you should reload the configuration.

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.
This setting is done through the output path in the configuration.

Configuration File

The whole configuration of how our platform creates real test data is stored in a “config” file in your Configuration folder. In Windows it is in your documents folder, in Linux it is stored in opt/var and in MacOS the directory is stored in Library/RealTestData/ConfigData where Library is a hidden folder in your home directory. This is the common place where to store configuration data.

Templates

RealTestData allows you to customize the data through configurations and additionally with templates. Use existing templates and create your own templates or edit existing templates. You can specify any of the different screens as part of a template

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 also create your own templates by choosing different names for the output columns.

Language Support

The Windows, MacOS and Linux GUI are available in 4 languages (German, English, French, Czech). You can switch between the languages anytime through the language menu.

Our platform can export the data also in these 4 languages, you can change the language anytime in the output screen.

This is important when you need test data like country name or salutation in another language than English.
RealTestData is a multi-language platform that supports 4 languages (German, English, French and Czech).
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:

How we produce realistic data

• The companies in these datasets do exist, but under a different address
• 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.
• 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
• “Special number” is a very powerful feature, you can use it for social security number as well as personal identifier
• “Special 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 “Special number” feature
• Working day is also a powerful feature when you need a delivery day in the future after 10 days 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, but when you´re young the chance to be widowed is much smaller
• Birth name is according to the marital status of the person, like single women do not have a different birth name as a standard
• 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 existing mmobile area codes
• 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

Note

In the full version 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, like salutation, first and last name or zip and town.

Supported Countries

Our platform supports today 66 different countries from Europe, the US, Canada, Mexico and India. New countries will be added continuously. Right now TR = Turkey is in the making. All source data files are stored in the TestData directory in an encoded format. Small countries include less data (Andorra, San Marino, Liechtenstein etc.)

Trial Version

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.

Our supported countries

• DE Germany
• US United States of America
• UK UK
• FR France
• IT Italy
• BE Belgium
• CZ Czechia
• NL Netherland
• LU Luxembourg
• AT Austria
• CH Switzerland
• ES Spain
• PT Portugal
• PL Poland
• SK Slovakia
• SI Slovenia
• HR Croatia
• HU Hungary
• NO Norway
• SE Sweden
• DK Denmark
• FI Finnland
• RO Romania
• BG Bulgaria
• LI Liechtenstein
• MC Monaco
• SM San Marino
• AD Andorra
• GR Greece
• CY Cyprus
• MT Malta
• IE Ireland
• LV Latvia
• LT Lithuania
• EE Estonia
• IS Iceland
• BA Bosnia and Herzegovina
• RS Serbia
• MK North Macedonia
• ME Montenegro
• AL Albania
• IN India
• CA Canada
• TR Turkey
• MX Mexico
• AM Armenia
• AU Australia
• AZ Azerbaijan
• BY Belarus
• BR Brazil
• EG Egypt
• GE Georgia
• ID Indonesia
• IL Israel
• JP Japan
• KZ Kazakhstan
• KG Kyrgyzstan
• MD Moldova
• NZ New Zealand
• RU Russian Federation
• SA Saudi Arabia
• ZA South Africa
• TM Turkmenistan
• UA Ukraine
• AE United Arab Emirates
• UZ Uzbekistan

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, French or Czech
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, French or Czech
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 move the selected fields. The same procedure is valid for CF2.

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:

• M - Company
• F - Forename
• L - Lastname
• A - Address/Street
• Z - Zip
• T - Town
• I - eMail
• 1 - Linkedin
• 2 - Facebook
• 3 - Instagram
• 4 - Pinterest
• 5 - X
• 6 - Telegram
• J - LongTest
• K - IBAN
• B - Birthday
• V - Credit Card
• 8 - Expiration Data
• 9 - CVV
• K - Bitcoin
• 0 - UUID

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.
Or the ZIP is too lang, Bitcoin addresses can be too short and UUID as well.
EMail address do not follow predefined the rules.

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.

Special Number

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

Birthday:

YY, YYYY = year with two or four digits
M, MM = month with one to two or two digits
D, DD = day with one to two or two digits
Name:
F, FF, FFF = one letter of the first name, two letters, the complete first name
L, LL, LLL = one letter of the last name, two letters, the complete last name
N = Number
S = special chars
L = Lower char
U = Upper char
X = all combined incl. Special chars
Example: YYMMDD-FL-NNN.UUU/XXX-UNX

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. We use real und very realistic data but not any personal data

Installation and Setup

To install RealTestData

1. Download the Windows / MacOS DMMG or Linux DEB-RPM installer from our website.
2. Run the installer and follow the instructions.
3. Open the RealTestData GUI to configure your test data generation.

Documentation 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 5 countries (Germany, UK, US, France and Czech Republic) 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 66 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
Hlavní 373
25089 Lázně Toušeň
Czech Republic
info@realtestdata.com