Follow-On Topics

Related Topics

# About the Import Flat File Tool

The Import Flat File tool imports a delimited or fixed-width file from disk into King Task Centre, extracts the file content including any file properties, then outputs it as either a recordset or as XML.

The columns that make up the recordset, and the nodes and nested elements for the XML file, can either be inferred from an imported example or created manually.

Data validation can also be applied to only import required data.

## Features

The Import Flat File Tool provides the following features

|  | Manually create a schema for the XML output consisting of Nodes and nested Elements

|  | Configure properties of each Node and Element to select the data to be extracted from the source file for each one

|  | Preview the XML schema structure before saving and running the Task

|  | Specify the source file properties to be extracted at Task run time and exposed to other Steps through the Task Browser dialog box

|  | Browse for and select a file containing column headings in the first row of the file to be used to structure the output data

|  | Output XML for use by other Task Steps

|  | Output XML as a string for use by other Task Steps

|  | Output a recordset for use by other Task Steps

Copyright © 2018 Quadrant Software B.V. All rights reserved.