Generate a user list


First of all, we define the columns of the file based on these variables.

  • The column "firstname" takes the variable first_name as is, without further modification.
  • In the same way the column "lastname" takes the variable name as is.
  • The "email" column is defined by concatenating the first name variable, the string ". ", the "first name" variable and the character string that represents the sequence " @ ". Note that we apply the « remove accent and lower case » function to convert first and last name to be compatible with an email address (lowercase, without accents etc..).
  • The "login" column is also assembled from the variables "first_name" and "email" and we apply the function that replace accented characters, spaces etc..
  • As the login must be unique within the application, we check the box "unique" to ensure the uniqueness of the data in this column.

The column "password" call the "password" variable applying the encryption function desired.


Then, we define the global file parameters.

  • The language / the country (which will giv us phone numbers)
  • The encoding
  • Then, we will define four variables : the first name, the lastname, the password and the company.

Note: it is possible to generate two columns, one with the password in plain text, the other with the encrypted password. The second is to be inserted into the base application, the first allows to know the passwords to perform tests with user accounts.

It only remains to choose the export formats expected. If you choose the CSV, a new line allows you to specify additional options specific to this format. Then, click on "Generate Data" to download data, aggregated in a ZIP archive. This archive contains a file for each export format handpicked, plus an XML file containing the entire set definition test. To generate a new test set, just reload the XML file.

Once the form is pre-filled with the previous parameters. We can modify it if necessary, and generate new data.