Skip to content

CSV Membership Import and Export

It is possible to integrate GMS with your CSV (typically spreadsheet) workflows.

Note: The format CSV stands for "Comma Separated Values", so the character that separates columns is a comma (,). Some programs create CSV files that use a semicolon ( ; ) as the separator character. Semicolons are not supported by GMS.

GMS CSV Format

The CSV file has 4 columns:

  • Member Type (Application, Secondary, Service, Person, Unconfirmed person, Group)
  • GMS Unique Identifier GUID
  • Human readable Unique Identifier
  • Comment

Egroups Backwards Compatibility Format

This format is provided to assist with migration from Egroups and is not intended to be maintained long term. Please see the Egroups Documentation for more information.

The CSV file has 6 colums: * Type of the member (P, person; A, account; E, external email, S and D, static and dynamic egroup) * The name of the account/egroup. * The email associated to the account/egroup * The person ID of the owner of the resource (account/egroup) * The name of the owner * The primary email of the owner.

Import

Only 1000 members can be imported at a time. For programmatic use we strongly encourage use of the API. POST and DELETE endpoints are provided for updating group membership:

  • https://authorization-service-api.web.cern.ch/api/v1.0/Group/GROUP_ID/members/identities
  • https://authorization-service-api.web.cern.ch/api/v1.0/Group/GROUP_ID/members/groups