Data Exchange Assignments Reference

Use this reference when preparing an Assignments import in Settings → Data Exchange.

Required Columns

  • user_id
  • event_id

Optional Columns

  • id
  • position_id
  • department_id
  • status
  • start_datetime
  • end_datetime
  • notes and metadata fields included in the template

Accepted Values

  • all ID columns must be integer display IDs
  • datetimes must be ISO format
  • boolean fields must use supported boolean values such as true / false

Relationship Rules

  • user_id must match an existing user in the same tenant
  • event_id must match an existing event display ID in the same tenant
  • optional foreign keys such as position_id must also exist in the same tenant

Example CSV Row

id,user_id,event_id,position_id,start_datetime,end_datetime,status
1,12,42,5,2026-05-12T09:00:00,2026-05-12T18:00:00,confirmed

Next article

Permissions Reference

A complete list of every permission in OpsOS, grouped by module, with a description of what each one allows.

Continue →

Related articles

Dashboard

The dashboard is the home page each system user sees after logging in. It gives you a quick view of the work, totals, and shortcuts that matter to you.

Managing Users

System users are the people in your organisation who log in to OpsOS directly. They are different from Planner workers, who use the worker portal rather than th

Roles and Permissions

Roles are named sets of permissions you assign to users. Permissions decide what someone can see and do in OpsOS.

The Permissions Manager

The permissions manager is the main grid for controlling what a role can do. Choose a role, then review and change its permissions grouped by module.