Skip to content

Creating Multiple Data Definitions at once by CSV Import - An alternative way

If you have multiple Data Definitions to create in the context of your real-life AUT, you don’t necessarily have to create them one at a time in Worksoft SaaS using the steps described in the previous article. Worksoft SaaS offers an alternate easier approach to "bulk" create multiple definitions in one shot. You can do achieve this by creating an Import Spreadsheet (using Microsoft Excel or Google Sheets or just a plain text editor if you are a technical geek J) with each row containing each of your data definitions and saving it as a Comma-Separated Value file (.CSV extension file).

Each row in your Import CSV file should have as the first two columns the “Name” and “Description” for your Data Definition and as additional columns the “Attribute Names” that make up your Data Definition. Please note that even if your intention is to leave the “Description” field blank for your Data Definition, your CSV should have a blank in the 2nd position of your CSV file.

For the example AUT and the test coverage of interest, your Spreadsheet and CSV should like shown below:


Same data definition import file would like shown below once saved as a “CSV” file:

As mentioned above, if you want to keep the data definition name and the attribute names short and want to skip entering a description for your definition, your Spreadsheet and CSV import file would like shown below:

Same data definition import file would like shown below once saved as a “CSV” file:

When you are ready to import the CSV file, just toggle the radio button to “Import multiple Definitions from a CSV file”, click “Upload CSV File” button, browse and select the appropriate CSV file you created and saved on your local machine (or network drive), and click ‘Ok’

Once the data definition(s) from your CSV file is imported you should see all the data definitions in the CSV appears as rows on the Worksoft SaaS screen.

  

Feedback and Knowledge Base