Skip to content

CSV Membership Import and Export

CSV Format

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. This does not work as it will not be properly recognised as the column separator.

GMS

The CSV file has 4 columns:

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

Backwards compatible

This format is provided to assist with migration from egroups. Please see https://confluence.cern.ch/pages/viewpage.action?spaceKey=ED&title=3.5.+Export+and+Import+members for more information.

Import

Only 1000 members can be imported at a time. For programmatic use we strongly encourage use of the API. Two 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