Read CSV File

Version 3.1 by Giang Tran on 2022/05/13 13:59
Warning: For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.

RCA.Activities.CSV.ReadCSVFile

Description

This activity allows you to read all entries from a specified CSV File.

image-20220505105117-1.jpeg

(* is mandatory)

In the body of activity

  • File Path (String) - You can add the file path of the CSV here. String supported only.

Properties

File

  • File Path (String)* - The file path of the CSV file
    E.g: “C:\CSVFolder\clientList.csv”

Misc

  • Public (CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it.
  • Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better.
    E.g: Read CSV

Options

  • Delimiter (DropDownList) - Specifies the delimiter in the CSV file. The options are: Tab, Comma, Semicolon
  • Encoding (String) - The type of encoding you want to use. To specified the encoding type to be used, used the value from the Name field. Strings variables only.
    E.g: “utf-8”
  • Include Column Names (Checkbox)- Specifies if the first row in the CSV file should be considered a header row. If unselected, the output DataTable will have columns with default names. By default, it is selected.

Output

  • Data Table (DataTable) - Represents the output DataTable that contains the information obtained from the CSV file.

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:Activities.CSV Activities.Activities.Read CSV File.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

  
Navigation