Summary

Exports the node result in a CSV file directly into the server file system. The existing file is overwritten.

Configuration

Settings

Name

Value

Opt.

Description

Example

Export file name incl. path

System.String

-

Exported file incl. path (from the view of the web server)

-

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

-

Encoding preamble

System.Boolean

-

Inserts encoding preamble (BOM, byte order mark)

-

Remarks

Format your table and cut columns using Filter on columns 1.2.

Want to learn more?

Screenshot

Examples

Example:  Export in server file system

Situation

Data should be exported for logging reasons

Settings

OPTION 1: Write the path from the view-point of the server and a filename
E.g.: C:\inetpub\wwwroot\XIMES04\Fileshare\Example.csv

OPTION 2: With Parameters
Two parameters were used:

  1. PATH: to describe the path: typically C:\inetpub\wwwroot\XIMES04\Fileshare\
    • Board and editor have access to this folder
    • Other folder like ... \TIS\UPLOAD only allow for the TIS-Editor
  2. Use a static file name, or e.g. for logging reasons create one. E.g. in the formulaoperator
rowNumer == 0 ? (
XIH.SetParam("PATH and File",
System.DateTime.Now.Year.ToString("0000")
+ System.DateTime.Now.Month.ToString("00")
+ XIH.UserName
+ System.DateTime.Now.ToString("yyyymmddHHmm")
+ "AndereTage"
+ ".csv")
) : false

Result

-

Project-File

-

Troubleshooting

Nothing known up to now.


Related topics