Testflow - Wrong format error message when importing a CSV test file


Applies to

Testflow

Introduction

When trying to create Job tests using a selected CSV file the user gets the following error message: 'The File you selected has the wrong format.'

File Format error message

Procedure to follow

This error is due to the CSV file not being correctly formatted as per the support documentation which can be found in the Testflow online support pages - Importing Tests (using CSV file)

A quick check to confirm the formatting of the CSV file is to open it with the notepad application which will show any unintentional entries in the CSV file.

Example:

A File which fails to import has extra spaces in fields which are not used:

CSV file view

Loading the CSV file into Notepad you can see spaces between the commas which denote the cells within the CSV file. These additional spaces are not apparent in Excel since the cells appear to be empty.

CabinetArea, ,CabinetPort, ,DropTerminal, ,DropPort,---,FIP,FIP,iOLM
, ,, ,, ,, ,Cabinet Port,Drop Port,From Drop Port
SW-CHE-06,_,PANF-01-05,_,CLS0176,_,1,,x,x,x

Once these spaces are removed in Notepad and the file saved:

CabinetArea, ,CabinetPort, ,DropTerminal, ,DropPort,---,FIP,FIP,iOLM
,,,,,,,,Cabinet Port,Drop Port,From Drop Port
SW-CHE-06,_,PANF-01-05,_,CLS0176,_,1,,x,x,x

The updated CSV file will be imported successfully into TestFlow.

Example

This file failed to import as it  has additional unused cells created in the CSV file at the trail end of the tests

WM-EBURY,-,PANF03.25,_,LBN/CBT/21359,-,4,,,X,X
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,

Once these trailing cells are deleted in Notepad, the CSV file can be successfully imported into Testflow.

If when checking the file you cannot see any format or spacing issues then;

  1. you can start again from a fresh template provided in the TestFlow online help ( link above), or,
  2. contact our  Technical support for further assistance.