Welcome to QTools.
QTools is a powerful associative big test data generator suite for Mac, Linux and Windows. The test data generator produces realistic test | mock-up data and includes more than 90 field types that can be used and contains the following special features:
- Test data export in different formats: XLSX, XLS, CSV SQL (MySQL syntax).
- Generate realistic and associative test data in no time: ca. 10 million records, 10 associative tables within 1 minute!
- The test data files generated are already linked within the structured QlikView / Qlik Sense script created.
- You can use variables (field names) from other fields to generate a field value; e.g. Field substitution, e.g. <value> = Hello {fieldNameFirstName} {fieldNameLastName} → Hello Kenny Loggins.
- You can add your own custom types to create test data. They then can be used within the Excel definition file.
- Custom types can also be structured: This means that a generated test record preserves the relation between different generated field values for a defined structure within a record; e.g. Field A → Carnivora, Field B → Felidae, Field C → Cheetah.
- Simple math expressions such as "+-*/()", e.g. <formula> = {fieldA} * 10 - {fieldB} / 0.5 .
- Not-type: By using a "!" sign in front of a type, the generated test value will be assuredly different from the value used in another field with the same type.
- %-Blank-type: By using "%%-" in front of a type, the generated values are left blank for a certain amount of percentage %%.
- You can define the amount of records per table. The test generator is able to create foreign keys between the tables, so an associative out-of-the-box QlikView / Qlik Sense model can be loaded within the QlikView / Qlik Sense editor with the exported script.
- You can generate up to 1 million records per table (SQL and CSV format only if one table exceeds 20000 records) in the licensed pro-version.
Note: The generated QlikView / Qlik Sense script follows the syntax for QlikView version 11.20 and has not been adjusted since then. Contact us if you need QlikView / Qlik Sense syntax updates. Also, download and check the example projects below to inspect the script syntax; it still should work fine!
The QlikView / Qlik Sense script generator creates a structured QlikView / Qlik Sense script based on an Excel definition file and it includes most common features (free) such as:
- Rename routine that maps database field names to GUI field names; renaming is done within an Excel file.
- Geo-data with latitude and longitude for countries as well as flag images for these countries; flags images are also provided by the tool.
- QlikView / Qlik Sense Toolbar: The QlikView / Qlik Sense toolbar and even the right-click context menu can be configured through an Excel.
- Translation defined in external Excel sheet.
- Variables defined in external Excel sheet.
- Pre- and Post-Script inclusion mechanism.
Have a look at the documentation to find out more about QTools.
Project Settings
Output including Test Data
Example Projects
Credits
Geo-data
The used flag pictures are provided by Go Square Ltd. Copyright © 2013 Go Squared Ltd.
https://www.gosquared.com/resources/flag-icons/.
Sample | Test data
Some of the sample data provided by the sample data generator has been grabbed from the following sources:
Used Icons
Information, Close, Save, Open and Help icon by http://www.visualpharm.com.
Output folder icon by Alexandre Moore, http://sa-ki.deviantart.com.
Process icon purchased from https://dryicons.com.
Register icon purchased from http://www.webiconset.com/application-icon-set/.
Language icon from http://www.designcontest.com.
All others icons are from http://www.iconarchive.com or http://openiconlibrary.sourceforge.net.
Used Libraries
Apache POI: http://poi.apache.org.
Dom4j: http://dom4j.sourceforge.net.
Janino Compiler: https://janino-compiler.github.io/janino.
JGoodies Commons, Forms, Validation: http://www.jgoodies.com.
Log4j: http://logging.apache.org/log4j/1.2/.
Math-Parser: https://code.google.com/p/mathparser-java/.
RSyntaxTextArea, © 2012-today, Robert Futrell. All rights reserved: https://github.com/bobbylight/RSyntaxTextArea.
XMLBeans: http://xmlbeans.apache.org
Trademarks
QlikView® and Qlik Sense® are a registered trademark of Qlik coorperation. QTools is in no way associated with QlikView®, Qlik Sense® or Qlik, it is a developer tool that exports a QlikView / Qlik Sense script next to the data generated in a chosen format (CSV, XLS, XLSX and SQL).