How to Scan a File

To implement a Test Data Activity in Test Data Automation a Definition is required. For files this involves scanning a file. 

Scanning a file can be accomplished in two locations: 

1. Within the Files tab of the Data Dictionary, a procedure involving multiple steps which we will detail here
2. Within the Definitions tab of the Data Dictionary, an integrated process during the creation of a definition, to be explained later.

Test Data Automation has the capability to scan files in XML, JSON, or CSV formats, or alternatively, it can scan data already imported into a Data List.

1. Scan an XML

To scan an XML file, begin in the Data Dictionary, by clicking on Data Dictionary in the Master Data Management section of the Navigation Panel.

1.1 Create New Schema

Click on the / Files tab. The main pane changes to the File Schemas pane. Click on + New Schema.

1.2 Schema Details

The New File Schema panel appears. Enter a Name, select XML from the dropdown and enter a Description, then click on < Save.

1.3 Schema Created

The new schema appears in the table on the Files tab. To the left of the name is a number showing how many scans have been attached into the file schema. Right now, it says 0. We need to scan a file.

1.4 Create Schema Scan

Click on the name of the schema. The main pane changes to the Schema Details pane. Click on + Create schema scan.

1.5 Select File Schema

The Create File Schema Scan browse box appears. Click on the Browse button and select the file you want to scan.

The Create File Schema Scan browse box now shows the file, and a warning that an XSD schema will be extracted, and that if you already have an XSD file, you should use that. Click on OK.

1.6 Scan Complete

A Success notification appears, and a new scan appears in the table. In the File Schemas pane, the number of scanned files should now shows as 1.

To scan a CSV file, begin in the Data Dictionary, by clicking on Data Dictionary in the Master Data Management section of the Navigation Panel.

2.1 Create New Schema

Click on the / Files tab. The main pane changes to the File Schemas pane. Click on + New Schema.

2.2 Schema Details

The New File Schema panel appears. Enter a Name, select CSV from the dropdown and enter a Description, then click on < Save.

2.3 Schema Created

The new schema appears in the table on the Files tab. To the left of the name is a number showing how many files have been scanned into the schema. Right now, it says 0. We need to scan a file.

2.4 Create Schema Scan

Click on the name of the schema. The main pane changes to the Schema Details pane. Click on + Create schema scan.

The Create File Schema Scan browse box appears. Click on the Browse button and select the file you want to scan, then click on OK.

2.5 Schema Scan Complete

A Success notification appears, and a new scan appears in the table

In the File Schemas pane, the number of scanned files now shows as 1

---

3 Scan a JSON

To scan a JSON file, begin in the Data Dictionary, by clicking on Data Dictionary in the Master Data Management section of the Navigation Panel.

3.1 Create New Schema

Click on the / Files tab. The main pane changes to the File Schemas pane. Click on + New Schema

3.2 Schema Details

The New File Schema panel appears. Enter a Name, select JSON from the dropdown and enter a Description, then click on < Save.

3.3 Schema Created

The new schema appears in the table on the Files tab. To the left of the name is a number showing how many files have been scanned into the schema. Right now, it says 0. We need to scan a file.

3.4 Create Schema Scan

Click on the name of the schema. The main pane changes to the Schema Details pane. Click on + Create schema scan.

The Create File Schema Scan browse box appears. Click on the Browse button and select the file you want to scan.

Use the Yes/No switch to select whether you are importing a JSON schema file (Yes) or a JSON sample file (No). In this case, the file is a sample file, so we click No. A warning that an JSON schema will be extracted, and that if you already have an JSON schema file, you should use that. Click on OK.

3.5 Schema Scan Complete

A Success notification appears, and a new scan appears in the table

In the File Schemas pane, the number of scanned files now shows as 1

---

4 Scan a Data List

To scan a data list file, begin in the Data Dictionary, by clicking on Data Dictionary in the Master Data Management section of the Navigation Panel.

4.1 Create New Schema

Click on the / Files tab. The main pane changes to the File Schemas pane. Click on + New Schema.

4.2 Schema Details

The New File Schema panel appears. Enter a Name, select CSV from the dropdown and enter a Description, then click on < Save.

4.3 Schema Created

The new schema appears in the table on the Files tab. To the left of the name is a number showing how many files have been scanned into the schema. Right now, it says 0. We need to scan a list.

4.4 Create Schema Scan

Click on the name of the schema. The main pane changes to the Schema Details pane. Click on + Create schema scan.

The Create File Schema Scan dropdown box appears. Select the List you want to scan, then click on OK

4.5 Schema Scan Complete

A Success notification appears, and a new scan appears in the table

In the File Schemas pane, the number of scanned files now shows as 1