TSV Test Data Generator Tool

TSV Test Data Generator Tool

This tool allows you to generate random TSV files from a template. The utility allows you to generate TSV data, and export the generated TSV files. Mock Data can start developing an app and testing and problem solving when data service is unavailable or requires significant work to set up.

How to use TSV Generator Online

1.  Fill in the editor "Your TSV template" and click on the "Generate" button.
2. The "TSV generated" editor will contain the result.
3. You have a "Field Tags" section which shows you the available tags that you can use
4. You can dowload your TSV files below the editor.  

Using tags

You can also use tag in a property name. The tag must be in a string, enclosed in double curly brackets. Example:

{{uuid}}    {{date}}    {{firstname}}    {{surname}}    {{email}}

Test TSV Object Generator Overview

Data Generator for TSV is a tool for software developers and quality assurance engineers who need to generate test JSON documents in bulk for software or service testing. The document's structure can be explicitly created or imported from an existing TSV file. For smart data creation, the application uses a data generation engine that enables complicated data generation and value-to-value dependencies. The user can make test data more realistic by using the built-in Value Library, which contains predefined lists (names, dates, cities, streets, currencies, email, statecodes, firms, and so on).

TSV Data Generator 

The Data Generator data source is a built-in engine that generate many types of property values. This method eliminates the need to manually create data storages and populate them with data. Manually populating a database is a time-consuming and stressful task.
A test data creation tool enables business owners to try out and test their technologies before releasing them to the general market. It's recommended to avoid manual operations and instead use one of the above-mentioned test data creation solutions, which have a higher success rate.

Generate TSV from a Template

The TSV Generator uses a TSV template to generate data. Basic and custom settings are available in the TSV Generator's box. You can personalise the generator by altering the parameters as needed.
JSON Generator also includes Template and Preview dialogue boxes. By modifying the default script, you can customise the default template.

How Do You Create Various Name Test Data?

Each set is randomly generated to simulate real data.

Test data is actually the input given to a software program. It represents data that affects or is affected by the execution of the specific module. Some data may be used for positive testing, typically to verify that a given set of input to a given function produces an expected result. Other data may be used for negative testing to test the ability of the program to handle unusual, extreme, exceptional, or unexpected input. Poorly designed testing data may not test all possible test scenarios which will hamper the quality of the software.

Testing is an iterative part of the development process that it performed to ensure the quality of the code. During the development process you will need fake data similar to real data for testing purposes.

What is Test Data? Why is it Important?

Dummy Test data is actually the input given to a software program. It represents data that affects or is affected by the execution of the specific softwar feature. Some data may be used for positive testing, typically to verify that a given set of input to a given function produces an expected result. Other data may be used for negative testing to test the ability of the program to handle unusual, extreme, exceptional, or unexpected input.

Software Testing Methodologies

1. Black Box Testing - A software testing method in which the internal structure/design/implementation of the item being tested is not known to the tester. These tests can be functional or non-functional, though usually functional. Test design techniques include: Equivalence partitioning, Boundary Value Analysis, Cause Effect Graphing.
2. White Box Testing - A software testing method in which the internal structure/design/implementation of the item being tested is known to the tester. Test design techniques include: Control flow testing, Data flow testing, Branch testing, Path testing.
3. Gray Box Testing - A software testing method which is a combination of Black Box Testing method and White Box Testing method.
4. Agile Testing - A method of software testing that follows the principles of agile software development.
5. Ad Hoc Testing - A method of software testing without any planning and documentation.

What to Look for in Mobile Testing Tools?

How do you choose the best tool for creating test scripts? Begin by focusing on the following characteristics, which are critical for successful mobile app testing.

• Multiple scripting languages are supported. It's critical to have a variety of test creation choices.
  This involves having a selection of scripting languages to pick from. Naturally, your QA staff should be able to work with those with whom they are already acquainted. As a result, look for a tool that supports a variety of programming languages.                
• You are developing tests for a variety of mobile operating systems. Look for a program that allows you to conduct your tests on many mobile platforms. It would be ideal for including a code reuse option, so you wouldn't have to write separate test scripts for each platform.
• Test creation choices that don't require any scripting. It is critical to creating tests without coding. This feature of mobile testing tools is beneficial to folks who do not have programming expertise. You may also develop tests very quickly this way.
• CI/CD tools are seamlessly integrated. Make sure your mobile testing tool is simple to integrate with the technologies you already use for your CI/CD procedures.

Tag reference

{{addressuk}} : Single-line UK address.
{{addressuk}} ---> 9315 Lancaster Circle, Haslingden, Nottinghamshire, HS15 6YD

{{addressus}} : Single-line US address.
{{addressus}} ---> 8184 Ambrose, Fontana, Minnesota, 44626

{{addressgerman}} : Single-line German address.
{{addressgerman}} ---> Bahnhofsstrasse 12, 80335 München

{{airport}} : Three-digit airport code.
{{airport}} ---> MTK

{{autoinc}} : Auto-incrementing number. starting number (default 1)
{{autoinc 1000}} ---> 1000
{{autoinc}} ---> 1001

{{boolean}} : Boolean value. probability of being true (default 0.5)
{{boolean}} ---> false
{{boolean 0.95}} ---> true

{{cat}}: Cat name.
{{cat}} ---> Smokey

{{city}} : US city name.

{{cityGerman}} : German city name.
{{cityGerman}} ---> Berlin

{{company}} : Company name.|
{{company}} ---> Venusian Software Corp

{{country}} : Country name.
{{country}} ---> Lebanon

{{county}} : UK county name.
{{county}} ---> Derbyshire

{{creditcard}} : Credit card number.
{{creditcard}} ---> 6011867289904845

{{currency}} : Currency code.
{{currency}} ---> USD

{{date}} : Random date in YYYY-MM-DD format.
Parameters:
min - minimum date (default '1970-01-01')
max - maximum date (default 'now')
{{date}} ---> 1977-02-28
{{date 2015-01-01}} ---> 2018-08-02 // date after 2015-01-01
{{date 2015-01-01 2016-01-01}} ---> 2015-04-23 // date in 2015

{{date_iso}} : Random date in ISO-8601 format.
Parameters:
min - minimum date (default '1970-01-01')
max - maximum date (default 'now')
{{date_iso}} ---> 2013-05-24T02:44:04.687Z
{{date_iso 2015-01-01}} ---> 2018-07-09T22:15:30.512Z // date after 2015-01-01
{{date_iso 2015-01-01 2016-01-01}} ---> 2015-04-21T18:08:33.979Z // date in 2015

{{digits}} : String of numerals.
Parameters:
numDigits (default 5)
{{digits}} ---> 06984
{{digits 8}} ---> 61103920

{{dog}}: Dog name.
{{dog}} ---> Lucky

{{domainname}}: Domain name.
{{domainname}} ---> yallaer.com

{{email}} : Email address. Whether to use the previous firstname/surname for the email generation
{{email}} ---> jermaine.buchanan@drilling.com
# based on previous name
{{name}} ---> Sheba Arthur
{{email true}} ---> sheba21436@yes.etnedal.no

{{emojii}} : Emojii.
numChars - number of characters (default 1)
{{emojii}} ---> 
{{emojii 3}} ---> 

{{file}} : Get a random line from a simple text-file, e.g.
line1
another line
yeah
Parameters:
filename - full path to the file (no default)
{{file /path/to/file.txt}} ---> line1

{{firstname}} : Human first name.
{{firstname}} ---> Bethan

{{float}} : Floating point number.
Parameters:
min (default 1)
max (default 100)
decimalPlaces (default 4)
{{float}} ---> 13.8592
{{float 1000 2000 2}} ---> 1750.06

{{integer}} : Integer number.
Parameters:
min (default 1)
max (default 100)
{{integer}} ---> 99
{{integer 1000 2000}} ---> 1523

{{ip}} : IP4 address.
Parameters:
local - boolean (whether to generate an IP in the 192.168.1 range or not)
{{ip}} ---> 63.235.50.110
{{ip true}} ---> 192.168.1.58

{{ip6}} : IP6 address.
Parameters:
local - boolean (whether to generate an IP in the fc00::: range or not)
{{ip6}} ---> 487d:375d:7bfe:b23b:d1e2:8934:cfb2:c17e
{{ip true}} ---> fc00:cefe:5dfc:14da:691d:b4bf:63ac:6d17

{{kuuid}} : Time-sortable, unique identifier. see here
Parameters:
min (optional) - minimum date
max (optional) - maximum date
{{kuuid}} ---> 001g8LWk0Svk222Bd0Et0GeaBl1P1gkP
{{kuuid 2010-01-01 2019-01-01}} ---> 001eWhUE2HLix22HqmL5436NDm1p02X6

{{kuuidr}} : Time-sortable, unique identifier, but in reverse order. see here
Parameters:
min (optional) - minimum date
max (optional) - maximum date
{{kuuidr}} ---> zzzwSGtT2o36oK17mC4R26dkHI1f1Xm0
{{kuuid 2010-01-01 2019-01-01}} ---> zzyTAKwG1uzH1N4Cl4xi1vZIE22oxrrT

{{last}} : The last generate value of the supplied tag. This is used to re-use generated data elsewhere in your template.
Parameters:
tag - the name of the tag
{{last uuid}} ---> HSFC5LQPCP84IVY7 (the last uuid that was generated by datamaker)

{{latitude}} : Decimal latitude.
{{latitude}} ---> -54.4371

{{letters}} : String of uppercase characters.
Parameters:
numLetters (default 5)
{{letters}} ---> TVEHJ
{{letters 10}} ---> WOBOJRJFCU

{{longitude}} : Decimal longitude.
{{longitude}} ---> 175.2526

{{mac}} : Mac address
{{mac}} ---> 23-0d-a3-3e-cf-d8

{{marque}} : Car manufacturer.
{{marque}} ---> Bugatti

{{monarch}} : King or Queen.
{{monarch}} ---> Henry VIII

{{oneof}} : Picks one of supplied values.
Parameters: any number of strings
{{oneof Gryffindor Hufflepuff Ravenclaw Slytherin}} ---> Slytherin

{{name}} : Combination for firstname and surname. Equivalent of {{firstname}} {{surname}}.
{{name}} ---> Anna Flint

{{normal}} : Generates numbers on a normal distribution
Parameters:
mean - centre of distribution (default 50)
stddev - standard deviation (default 1)
decimalPlaces - number of decimal places (default 4)
{{normal}} ---> 50.1097
{{normal 20000 1000 2}} ---> 20370.88

{{password}} : A commonly-used password.
{{password}} ---> abcd1234
{{password | md5}} ---> 1f3870be274f6c49b3e31a0c6728957f

{{president}} : A US president
{{president}} ---> Richard Nixon

{{postcode}} : UK postcode.
{{postcode}} ---> KT4 0XS

{{price}} : Floating point price.
Parameters:
min (default 1)
max (default 100)
{{price}} ---> 65.29
{{price 500 700}} ---> 521.98

{{prime}}: Prime number. If you supply impossible parameters, you will get 1 in reply.
Parameters:
min (default 1)
max (default 100)
{{prime}} ---> 17
{{prime 1000 3000}} ---> 1657

{{product}} : Product name.
{{product}} ---> CARABAO
{{product | toTitleCase}} ---> Salt

{{sic}} : Industry standard SIC code - business category
{{sic}} ---> Growing of tobacco

{{state}} : US state name.
{{state}} ---> Ohio

{{statecode}} : 2-letter US state code
{{statecode}} ---> NC

{{street}} : Street address.
{{street}} ---> 6502 Chantler Avenue

{{streetGerman}} : German Street name.
{{streetGerman}} ---> Schulstrasse

{{surname}} : Human surname.
{{surname}} ---> Doyle-Tyson

{{tel}} : International telephone number.
{{tel}} ---> +43-3040-100-474

{{time}}:Time in HH:MM:SS format.
{{time}} ---> 10:45:59

{{timestamp}} : Timestamp in milliseconds since 1970.
Parameters:
min - minimum timestamp (default 0)
max - maximum timestamp (default 'now')
{{timestamp}} ---> 351543517819
{{timestamp 946684800000}} --> 1163308913102  // timestamp after 2000-01-01
{{timestamp 946684800000 978307200000}} --> 959753617250  // timestamp in year 2000

{{title}} : Honorific or title e.g. Mr, Mrs etc.
{{title}} ---> Reverend

{{tld}} : Top level domain, or common domain name ending.
{{tld}} ---> gov.pr

{{town}} : UK town name.
{{town}} ---> Dudley

{{unit}} : An SI Unit
{{unit}} ---> °C

{{url}} : Full URL.
{{url}} ---> https://www.jovinianist.com/microcosmology.html?adrenalone=VEF0TSB23N04V8MO

{{uuid}} : Unique identifier.
{{uuid}} ---> C3QTU8YIVKZY126Q

{{uuidv4}} : Unique identifier v4.
{{uuidv4}} ---> d1e606b0-0452-46a7-9190-8671a82fdea0

{{website}} : Full website URL.
{{website}} ---> http://unlyrically.com

{{word}} : Single word.
{{word}} ---> synentognathous

{{words}} : Multiple words.
Parameters:
count (default 5)
{{words}} ---> piacularly burp archisymbolical glumaceous Calinago
{{words 2}} --->Xenomorpha mauler

{{youtube}} : Random YouTube URL.
{{youtube}} ---> https://www.youtube.com/watch?v=dQw4w9WgXcQ

{{zip}} : US ZIP code.
{{zip}} ---> 69882

What Are Tab Separated Values and How Can They Be Used?

Tab separated values (TSV) are a great way to store and transfer data quickly and simply. Get the basics in this comprehensive guide!

Tab separated values (TSV) is a simple format to save and transfer data. It's handy when the data contains multiple columns, ensuring each value is clearly grouped into its specific field. In this guide, we'll explain the basics of TSV and how you can make use of it.

What is a Tab Separated Value (TSV)?

A tab-separated value (TSV) is a simple file format that stores data in a tabular format. The data is structured by separating each field with a tab (\t) character and a new line separates each row of data. It's commonly used to store datasets, such as those used in spreadsheets or databases, since it's very easy to parse.

Why Use TSV Over Other File Formats?

TSV files offer several benefits over more complex file formats such as CSV or JSON. For one, they are easily readable by both humans and machines. Additionally, TSV files are often faster to read since there is no need for parsing the data into separate fields. Finally, TSV files offer a lightweight way to transfer data from one platform to another without requiring any transformation or additional processing.

How Can You Create and Edit TSVs?

TSVs are one of the simplest file formats to create and edit. The most straightforward way is to use a basic text editor such as Notepad, TextEdit, VS Code, or Sublime Text - enter your data in plain text separated by tabs. Additionally, many data management platforms, such as Excel have built-in support for editing TSV files. It's also possible to create TSVs from existing structured data sources such as JSON objects, relational databases, or XML documents with the help of a library like PapaParse.

What Are the Advantages of UsingTSV With a Database System?

Tab-separated values offer plenty of advantages when you're working with databases. The format is less verbose than most alternatives and takes up less space while providing the same amount of data. It's much simpler to parse, which makes it faster to load into a database system. Furthermore, TSV files are easier to convert into structured objects, so downstream processing can be done more quickly and efficiently. Therefore, if data speed and efficiency are essential factors in your business, tab-separated values may be an excellent option!

What Are the Drawbacks of TSV Files?

Despite its many advantages, tab-separated values have some flaws that should be highlighted before use. The main issue is that a TSV file can easily become corrupted when improperly managed. If any fields contain spaces or special characters, then it's crucial to ensure they are adequately escaped so downstream systems can recognize them correctly. Furthermore, text editors often include features specific to particular data types, such as column queries and sorting, which do not work correctly in a TSV environment. As such, extra precautions must be taken when editing and maintaining your data files to remain clean and organized.