Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Summary

This operator allows to import data from a text file where values are separated by comma (comma separated values, CSV) or other symbolsanother symbol.

It can only be applied to an empty data node.

The text file has to be available in the Data Management of data sets on the TIS Server. Therefore, a file from a local storage has to be uploaded to the TIS Server. See Upload or download a data file to the TIS Server for how to do this. 


Import via Parameters

As of version 5.8 import files can be defined via Parameters.

Error Node

As of version 5.8 a specific error node can be defined. This way, error nodes can be displayed in TIS Board. The error node contains data rows that could not be properly interpreted.
Create an empty data node and choose the node as error node in the operation settings.

...

Situation

The text file Import_1.txt is to be imported into a data node.

Step 1

Go to start page and then to TIS Homepage and choose the Data Management tab; upload file (Upload or download a data file to the TIS Server)

Step 2

Create a an empty data node without any operations. To this node, add the operation "Import Text or CSV file 3.0".

Click on the folder symbol next to "Name" and select the import file.

Alternatively, files can be defined via parameters under "Path (manual):"

 

Then , choose the following settings:

Then click "Execute" to let TIS suggest the columns based on your suggestions. You will need to correct the suggested column "Bis" to Semantics: "Time (end)".

  • You get into the editing mode by clicking the icon Bearbeiten
  • You need to confirm changes by clicking the icon Übernehmen
  • Columns that are not supposed to be imported can be deleted with the icon Löschen
  • You can change the order of columns (how they will be displayed in the result table) with the icons Nach unten und Nach oben

As of version 5.8 a specific error node can optionally be defined. That gives the possibility that error nodes can be displayed in TIS Board.

Create an empty data node and choose the node as data node in the import operation.

Result

 

Further stepsThe resulting table should be converted to date+time/date+time to allow operations such as Scaling 7.0 
TIS ProjectConfluence Op Import Text or CSV file.gzip

...

Expand
titleSettings

Imports data from a text or csv- file.

Parameter


Advanced Tables - Table Plus
columnStyleswidth:10px,width:25%,width:20%,width=20px,width:40%,width:15%
autoNumberSorttrue
heading1
width100%
enableHeadingAttributesfalse
autoNumbertrue
enableSortingtrue


Int32Please define a data node in which possible error messages are saved
ParameterValueOpt.DescriptionExample
@LOADCSVFILE

System.String

---
NameSystem.String-Name of the file, including path. Entered by browsing the folders in data management.Confluence\confluence-upload-CSV.txt
Path (manual)System.String-

Name of the file, including path. Entered manually and can be a parameter.


Image Added

First lines / Last lines

-

-Information box showing the first and last lines of the import file defined above.

Image Added

First row is a header rowSystem.Boolean-When checked, the data of the first row in the file is used as headers.

Headers will be "Datum", "Von", and "Bis"

Image Added

Remove white space charactersSystem.Boolean-When checked, white space characters around the column separator will be removed.-
Column separatorSystem.String-Character that separates columns in the input file.-
Text delimiterSystem.String-Symbol enclosing text in the input file.-
Decimal symbolSystem.String-Symbol separating the integral part from the fractional part in decimal numbers (this is "," in German, but "." in English).-
Type of result tableSystem.String-Type of result table, see Types of Tables.-
Behavior in the case of invalid cell values – Apply default values, e.g. 0.0 with floating point values, if NULL should transferredSystem.Boolean

-

When checked, then default values are written instead of NULL, e.g. "0.0" in Double columns, "0" in Integer columns.-
Mapping--

Suggested mapping from the input file to the table.

Created after clicking "Execute" on the upper right.

Can be modified manually by using the symbols to the left.

Image Added

Error output in nodeSystem.Stringopt.An empty data node to save rows that could not be imported.-
@MODE

System.Int32

---
@IMPORTFILE

System.String

---



Page properties
hiddentrue


TranslationImport Text- bzw. CSV-Datei 3.0
GUIDB6645724-6D09-4E01-AD7E-9FE1C363D2BB
InternalImportFromCsvFile3
Version3
Legacy-
Assemblyxi.OpMisc
TotalUsage219
Status
Status
colourGreen
titleDone
Class
Status
titleIMPORT



...