Page tree
Skip to end of metadata
Go to start of metadata

Summary

  • This operator exports a table of a data node into a CSV-file (Comma-Separated Values)
  • This operator requires that a file will be exported, which is created in file management.
  • Later you can download the file via file management.
  • Note: You do not need to recreate the operator every time you want to updated the file, you just need to recalculate the operator.

    Important:
    • This operator does NOT write on the drive of the server
    • This operator writes in: TIS file management.

Configuration

Which part of the Table is affected

Column(s) which should be exported. Select manually or by using the dialog on the right.

CSV-File Name
Name of the file in the file management. If the file does not exist you maybe have to upload an blankl file to the server

Column seperator
character used to separate columns in the CSV file.

Coulmn name in the first row
Should the name of the column used in TIS be written into the first row in the CSV file

Text delimiter
Should the text in the table be marked with a special character? Use this if the separator appears in the text, to avoid the wrong definition of columns

Note

  • The file needs to be uploaded on the server first. See TIS- file management.

Want to learn more?

 Settings

Exports the node result as a CSV file to the TIS file system. The existing file will be overwritten.

Parameter


ParameterValueOpt.DescriptionExample
Folder

System.String

-Target folder (in TIS file system) for the export-
File name

System.String

-Name of the export file (in TIS file system)-
Column separator

System.String

  • ;
  • ,
  • Tabulator
  • Blank
opt.The character used to separate the columns.-
Text delimiter

System.String

  • Blank
  • "
  • '
opt.The character that encloses a text.-
Decimal symbol

System.String

  • ,
  • .
-Decimal separator-
Decimal places

System.String

  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
-Number of decimal places to be output-
Output header

System.Boolean

-Exports the column headings as a header.-
Retain the order of the rows

System.Boolean

-The data sets will be exported in the same sequence as in the table.
If the option is not activated, multiple threads will be written simultaneously and the set sequence will then be undefined!
-
End of line

System.String

  • PC
  • UNIX
  • MAC
-Determines the symbol for end of line (PC=CrLf, UNIX=Lf, MAC=Cr)-
Date format

System.String

  • dd.MM.yyyy HH:mm:ss
  • dd.MM.yyyy HH:mm
  • dd.MM.yy HH:mm:ss
  • dd.MM.yy HH:mm
  • yyyy-MM-dd HH:mm:ss
  • yyyy-MM-dd HH:mm
  • M\/d\/yyyy h:mm tt
-Character string, which defines the date formatting-
Coding

System.String

  • UTF-8
  • ASCII
  • CP1252
-Character set coding of the output file-

 Screenshot

 Examples

Export in CSV


Initial situation


Prepare for the export


Enter the values into the operator


Note:

  • The file needs to be uploaded on the server first. (it can be blank) See TIS- file management.


Result

Download.

 Troubleshooting
  • There is no file in the Data management in which should be exported.
  • The separator is poorly chosen.
  • Problem: I tried to upload a empty file (*.csv), and there is an error message: "Bitte wählen Sie einen gültigen Dateinamen (Pfad) aus." (German)
  • Solution: Write something into the dummy file, that should fix the problem.

Related topics

  • ...