Skip to content

CSV Membership Import and Export

It is possible to integrate GMS with your CSV (typically spreadsheet) workflows. This feature is intended for humans, not automations.

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 5 columns:

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

Egroups Backwards Compatibility Format

This format is provided to assist with migration from Egroups. Please see the Egroups Documentation for more information.

The CSV file has 6 columns:

  • 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.

Troubleshooting

All columns should be included in the file (there should be 5 commas on each line). No header line is expected.

Example file

A,caccount,,,,
E,,some.address@external.com,,,
P,,,123456,,
S,it-dep,,,,
D,it-dep-dynamic,,,,

Import

Only 1000 members can be imported at a time. For programmatic use please call 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