Generating a schema based on an Excel file

After you establish the connection between HCL® OneTest Data and Excel, you can generate a schema that is based on an Excel file in HCL® OneTest Data.

Procedure

  1. Log in to HCL OneTest Server and open the team space that contains your project.
  2. Open your project.
    The Overview page is displayed.
  3. Click Author > Data Fabrication.
    The Data Fabrication page is displayed.
  4. Click the Connections tab and select the connection that you created.
  5. Click the menu, and then select New Action.
  6. Select Target as the Action Type in the New Action dialog box, and then click Next.
  7. Enter the following properties of the schema that you want to generate, and then click Next:
    • Select the Excel file that you imported into your project from the Excel File drop-down list.
    • Click Fetch to upload all the worksheets of the Excel file in the Worksheet drop-down list.
    • Select the worksheet from the Worksheet drop-down list.
    Note:

    You can retain the default property settings for all other fields.

  8. Select New, and then click Generate.
    The schema is generated in HCL® OneTest Data. HCL® OneTest Data generates the schema name as schema_<number>.
    Note: You must select this schema name as the schema for HCL® OneTest Data to generate the test data.
  9. Select the schema type as Sheet.
  10. Click Next to provide the identification details of the new action, and then click OK.

    The new action is created and listed under the connection that is established between HCL® OneTest Data and Excel.

Results

You have successfully generated the schema in HCL® OneTest Data.
Note:

You can modify the schema name schema_<number> from the Schemas tab.

Tip: If you want to generate schemas for other Excel files, then you must click New Action on the existing Excel connection. You need not create a new connection.

What to do next

You can view the generated schema listed under the Schemas tab. You can generate the test data for the generated schema in HCL® OneTest Data. See Generating test data by using the generated schema.