Hi, are there any options in the readcsvlog plugin to extract specific columns? And how that csv can be stored in a table?
Discussion posts and replies are publicly visible
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, {}) )
But how to extract suppose 4 columns at one go?
index() function can take list of indexes...
a!forEach( items: readcsvlog(csvPath: "login-audit.csv").rows, expression: index(split(fv!item, ","), {1,2,3}, {}) )
Thanks for that. Now suppose I am saving these values in a CDT. I assign each column to particular fields, but why does it give me an error?
The error message is pretty clear, cannot index property 'values' as there is no such property. Just use fv!item[1], fv!item[2]...
Sorry I used values while reading excel but now I got it