Summary

This operator allows to import data from a text file where values are separated by the symbols:

  • ;
  • ,
  • -
  • .
  • |
  • #
  • *
  • '
  • Tab
  • Blank

It can only be applied to an empty data node.

The text file has to be available in the TIS File on the TIS Server. Therefore, a file from a local storage has to be uploaded to the TIS Server. 


Configuration

Settings

Name

Value

Opt.

Description

Example

Select import file

System.String

-

Use the brows button to brows the "TIS Files" and select a file, or just type in the path manually

-

Text encoding

System.String

-

The text encoding on the import file.

  • Auto-detect
  • Ascii
  • Windows-1252
  • Utf8
  • Utf7
  • Utf32
  • Unicode

-

First row is a header row

System.Bool

opt.

Should be checked if the first row a header row is

-

Delete unnecessary blanks

System.Bool

opt.

Unnecessary blanks at the end of the column are removed

-

Column separator

System.Char

-

Which character separates the column

  • ;
  • ,
  • -
  • .
  • |
  • #
  • *
  • '
  • Tab
  • Blank

-

Text delimiter

System.Char

opt.

Selection of character for text delimiter

  • BLANK

  • "

  • '


Decimal symbol

System.Char

opt.

Selection of the decimal Symbol for numbers

  • ,
  • .


Behavior if data is missing

System.String

opt.

What happens to missing/nonexistent data

  • Set to NULL

  • Use default value

  • Error


Error output in node

System.String

opt.

You can define a node in which error messages are being saved


Freeze column assignment

System.Bool

opt.

Do not carry out new column assignment, last valid mapping will still be used.


Remarks

If you have an excel file please use the operator Import from Excel file.

A preview of the file that you want to import can be seen in the "TIS Files" just left click on the file you want to view and navigate to the content tab. (be aware this is just a preview, there is a limit at how much can be viewed)

Want to learn more?

Screenshot

Examples

Example: Importing a CSV file

Situation

In this example the text file DataSales.txt is going to be imported.

At first we need to upload the file into "TIS Files".

Settings

DataSales.txt looks like this and is UTF8:

And this are the settings to import this file:

Text encoding can be set to UTF8 but Auto-detect is also fine.


Result

Project File

-


Troubleshooting

Problem

Frequent Cause

Solutions

The columns have the wrong data types

-

Use the operator Format columns 2.0 to change the data types


Related topics