Import Users (CSV)

Import users from a CSV file uploaded at a given location.

This flow allows automatic import of a CSV file containing users into Cells internal directory.

Interesting point here is that it takes a standard Cells file as input and listen for its changes (triggers on "Create Node" or "Update Content"). That way you just have to setup a specific location in a workspace accessed by administrator to upload an updated CSV and have it parsed and imported automatically.

Parameters

Trigger Type

Event-based

JSON Representation

{
  "Label": "Import Users (CSV)||Import users from a CSV file uploaded at a given location||mdi mdi-account-plus",
  "Owner": "pydio.system.user",
  "Custom": true,
  "EventNames": [
    "NODE_CHANGE:0",
    "NODE_CHANGE:3"
  ],
  "Actions": [
    {
      "ID": "actions.etl.users-csv",
      "Parameters": {
        "attribute": "Login",
        "attribute_1": "Password",
        "attribute_2": "Attributes.displayName",
        "attribute_3": "Attributes.email",
        "comma": ";",
        "comment": "#",
        "csv": "Login",
        "csv_1": "Password",
        "csv_2": "Name",
        "csv_3": "Email",
        "fieldname": "{\"@value\":\"PathPrefix\"}",
        "group": "",
        "trimLeadingSpace": "true"
      }
    }
  ],
  "NodeEventFilter": {
    "Query": {
      "SubQueries": [
        {
          "type_url": "type.googleapis.com/tree.Query",
          "value": "UgNjc3Y="
        },
        {
          "type_url": "type.googleapis.com/tree.Query",
          "value": "Ch97ey5Kb2JQYXJhbWV0ZXJzLkZpbGVMb2NhdGlvbn19"
        }
      ],
      "Operation": 1
    },
    "Label": "Watch CSV files in location"
  },
  "Parameters": [
    {
      "Name": "FileLocation",
      "Description": "Folder path where to watch for CSV files created or modified.",
      "Value": "personal/admin/imports/",
      "Mandatory": true,
      "Type": "text"
    }
  ]
}