DriveWorks Pro 17: Import Lines From a Text File into an Existing Simple Table [send feedback...]

Import Lines From a Text File into an Existing Simple Table

This Specification Task reads in a multiline text file, and passes the data into an existing Simple Table in DriveWorks.

Blank lines will be ignored.

If a line contains commas it will be separated into different columns in the table.

If a single entry starts and finishes with quotes, it will be taken as a single column entry even if it contains a comma.

Import Lines From a Text File into an Existing Simple Table Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
File NameFile Name of the txt or csv file - Including Extension.
Simple Table NameThe name of the Simple Table that the array value will be written to.
First Line is HeadersTRUE if the first line in the text file is to be treated as headers, FALSE to use generic headers instead (Column1, Column2....ColumnN).
Constant NameConstant that the none empty line count will be stored in for reference only.
DelimiterCharacter that is used between the values on each row (comma by default).

Using the Task in a Specification Macro

This task has different types of Outputs. For more information about Outputs see Specification Macros Task Node.

Outputs are only available within Specification Macros. Currently Outputs are not available for Specification Flow.

Status Outputs

This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.

The status output navigation is as follows:

Success

  • Data imported successfully.

Success with Warnings

  • N/A - should never be fulfilled.

Failed (one of the following occurred)

  • Error while importing data.
  • Simple Table cannot be found.
  • File Name does not exist.
  • File Name cannot be empty.
  • File extension not valid.
  • General failure - Check the Specification report for more details.

Table of Contents