Question

Log reader

Hi, are there any options in the readcsvlog plugin to extract specific columns? And how that csv can be stored in a table?

Brainy

When you download the plugin from the app market, it should include the documentation.

To store that data to your database, create a record with the required fields and create a scheduled process that reads the log and stores the data.

Can you help on how to extract specific columns?

Why not just index them explicitly in a rule?

a!forEach(
  items: readcsvlog(csvPath: "login-audit.csv").rows,
  expression: index(split(fv!item, ","), 3, {})
)

Csv can be stored in a table using the Excel tools plugin. Find it here - community.appian.com/.../excel-tools

Sign up