Skip to content

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.

It takes a normal 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

Name Type Default Mandatory Description
FileLocation text personal/admin/imports/ true Folder path where to watch for CSV files created or modified.

Trigger Type

Event-based

JSON Representation

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
{
  "Label": "Import Users (CSV)",
  "Owner": "pydio.system.user",
  "Metadata": {
    "Description": "Import users from a CSV file uploaded at a given location",
    "Icon": "mdi mdi-account-plus",
    "TplCategory": "idm",
    "Usage": "This flow allows automatic import of a CSV file containing users into Cells internal directory.\n\nIt takes a normal 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 \nlocation in a workspace accessed by administrator to upload an updated CSV and have it parsed and imported automatically."
  },
  "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"
    }
  ]
}