ReadFromCSV

The ReadFromCSV component reads data from a CSV file

Screenshot

Ports

The ReadFromCSV component exposes the Control In, Control Out and Data Out ports by default.

Port Description
Control In Must be connected to the Control Out port of one or more components.
Control Out Can be connected to the Control In port of another component or the default end component.
Data In The ReadFromCSV component exposes the following Data In ports by default:
Filepath:specifies the location of the CSV file.
Delimiter:A type of data format in which each piece of data is separated by a comma.
Data Out Returns the data count (Int32) from the CSV file.
Data Out Returns the DataTable from the CSV file.

Properties

To edit the properties of the ReadFromCSV component, in thde Properties window, change the required property. You can edit the following properties.

Property Description
Search Search for the respective property.
Delay After Execution Specifies the wait time (in seconds) after the action is performed.
Delay Before Execution Specifies the wait time (in seconds) before the action is performed.

Example

Let us consider an example.

Screenshot

To read data from a CSV file:

  1. In the Toolbox, expand Utilities and then expand Data Reader.
  2. Drag the ReadFromCSV component and drop it on the Design surface.
  3. To specify the file location, double-click FilePath and enter the location of the file.
  4. To override the existing data source, right-click FilePath.
  5. Select Override and change the data source.

    Note

    To learn more about overriding the data source of the data port, refer the Override section.

  6. In the Toolbox, expand Utilities and then expand Data Writer.

  7. Drag the WriteToExcel component and drop it on the Design surface.
  8. To specify the file location, double-click FilePath and enter the location of the file.
  9. To override the existing data source, right-click FilePath.
  10. Select Override and change the data source.

    Note

    To learn more about overriding the data source of the data port, refer the Override section.

  11. Connect all the control ports in the activity.

  12. In the toolbar, click Run.
    Intellibot reads the data from the specified CSV file and transfers the Data to a the specified destination.