Protocol: Listing to Dataset Action

(Require EAM) The Protocol: Listing to Dataset Action is used to read from a remote directory listing to create a dataset or read from a CSV file to create a dataset.

NOTE: Dataset size is limited to 10,000 rows to avoid out-of-memory crashes.

To create the dataset

  1. Create an Event Rule using the Scheduler (Timer) Event.

  2. Add the Get listing from host Action to the Rule.

  3. Click the server link to open the Get Listing Action wizard.

  4. Specify the Connection details. (See Download Action for details, if needed.)

  5. Specify the Source path (See Download Action for details, if needed).

  6. Specify the Dataset properties.

  7. The Dataset can name can be whatever you want.

  8. The File date format can be Default, Epoch, or ISO-8601.

  9. The Columns are based on the directory you're pointing to.

  10. Click Finish to close the wizard.

  11. Add the Loop through dataset Action, and specify the Loop properties. (Refer to Loop Through Dataset Action for more information, if needed.)

  12. The Dataset name that you specified in the Get Listing Action wizard appears as a selection in the Dataset drop-down list..

  13. The column names from the Get Listing Action wizard appear in the Ordering column drop-down list.

  14. Click OK.

  15. Add an Action for what to do with the data, such as the CSV export dataset to path Action.

  16. Using the CSV export dataset to path Action, the output looks similar to this:

  17. Which you can then open as a spreadsheet:

Related Topics