Importing data from local file system

If you have data or a sample file, you can import it into your project and can use that data to design a schema.

Before you begin

  • You must have created a project.
  • You must have a data file in your local file system in CSV or Excel files.

About this task

The Files tab on the Data Fabrication page is one of the design components of a project. By clicking this tab, you can create a file. This tab helps you to import an existing file from the local file system, for which you want to generate test data.

Procedure

  1. Select your project in HCL OneTest Server and go to the Data Fabrication page.
  2. Click the Files tab.
  3. Click New from the Files to create a file.
    The New File dialog box is displayed.
  4. Select a file that you want to import from your local file system.
  5. Provide a name to a file, folder details, keyword as Tag for quick search, and a brief description of the file.
  6. Click OK to import and create a file.

Results

You achieved the following results:
  • View the list of all the files imported for this project in the Files tab.
  • Use the Search field to search any file from the existing files.
  • Sort the list of files by name, folder, and recently used files.

What to do next

After you have created a file into your project, you can import a file into schema designer to create a schema.

Importing files into schema designer

To create a schema by using the data you imported, you must import the data file into schema designer.

Before you begin

You must have imported a data file into your project from the local file system.

About this task

When you want to create a schema, you require data. You can use the data which you have imported from your local file system.

Procedure

  1. Click Import from the Schemas.
    The Import dialog box is displayed.
  2. Select the file type as CSV.
  3. Select the file that you want to import from the Sample File Path and define the import properties of the data.
  4. Provide a schema name for this data and click Import.
    The schema appears in the schema designer.
  5. Save the changes.

Results

You can view the imported file listed under the Schemas tab.

What to do next

You must define the types in the schema. For information about defining types, see Defining types.