Exporting a datapool as a Comma-Separated Value (CSV) file
Test data in a datapool can be exported to a Comma-Separated Value (CSV) file. Test data can exported from a datapool, edited in a
Comma-Separated Value (CSV) file editor (for example, Microsoft® Excel®), and re-imported into a new or existing datapool. This is the recommended
approach when working with large quantities of data.
Export test data from a datapool to a Comma-Separated Value (CSV) file with the Export Datapool as CSV File wizard:
- Open the
Test Perspective, right-click in the
Test Navigator, and select Export....
- Select Test > Datapool as CSV File, and click Next.
- Select an existing datapool from the list of datapool. Select Show folders to show the list of datapools in the workspace project structure. If the selected datapool contains an encrypted variable, provide the password for the selected datapool.
- Click Next.
- Provide or select (click Browse...) the path to the new Comma-Separated Value (CSV) file.
- Select the encoding of the Comma-Separated Value (CSV) file. This encoding is used to write the Comma-Separated Value (CSV) file.
- Select Export the variable names and suggested types to the first row of the CSV file if the first row of the Comma-Separated Value (CSV) file will contain the variable names and suggested types. That is, the first row of the Comma-Separated Value (CSV) file will contain:
<variable 1 name>[::<variable 1 type>],<variable 2 name>[::<variable 2 type>]...<variable n name>[::<variable n type>]
- Select Export the equivalence class names and record numbers to the first column of the CSV file if the first column of the Comma-Separated Value (CSV) file will contain the equivalence class names and record numbers. That is, the first column of the Comma-Separated Value (CSV) will contain:
<equivalence class 1 name>[::0]
<equivalence class 2 name>[::1]
...
<equivalence class n name>[::<n>]
- Select Enclose cell values in XML tags if the cell values of the Comma-Separated Value (CSV) file will be enclosed in XML tags. That is, the cell values of the Comma-Separated Value (CSV) will contain:
<Literal><cell value></Literal>
- Click Finish to export test data from the datapool to the new Comma-Separated Value (CSV) file .
Related concepts
Datapool Editor
Related tasks
Creating a datapool
Importing a Comma-Separated Value (CSV) file as a datapool
Related samples
Tutorial: Accessing a datapool from a TPTP JUnit test