Import of Shift subscription

In User Menu - Configuration - Import it is possible to perform import of Shift subscription. This means that you can import shifts listed for individual days in bulk so that individual users can report for them directly (for example, via the mobile application).

Data structure

The data in Excel format must have a structure corresponding to this sample.

The columns must be listed in this order:

  1. ShiftShortcut
  2. DateValid
  3. Department
  4. MinimumRequiredUsers
  5. MaximumAllowedUsers
  6. NumberOfAutoApprovedRequests
  7. MaximumAllowedRequests
  8. AllowSubscribingSince
  9. AllowSubscribingTill
  10. AllowUnsubscribingTill

Optional columns

Optionally, you can add the Description (registration description) and Tags (space-separated labels) columns at the end.

The Tags column can only be added if the Description column is also present, as it must come immediately after it.

Mandatory information

Only the ShiftShortcut and DateValid columns must be filled in each row - a row with an empty shift shortcut or date will be skipped and marked as an error.

The cells of the other columns can be left empty: when editing an existing record, the original value of the given field will remain unchanged (an empty cell will not overwrite or delete the value), when creating a new record, the field will remain empty.

The exception is the Description and Tags columns: if these columns are present in the file, an empty cell in an existing record will delete the corresponding value (description or tags). If an optional column is completely missing from the file, the value of the given field in existing records will remain unchanged.

Data update

If the import file contains Shift Registrations that already exist in GIRITON (i.e. the shift day, shift time/abbreviation and possibly the center match), no duplicates will be created – only the filled-in values ​​for the given records will be modified: allowed number of people, dates from when or until when registration is possible and possibly description or labels (if the relevant columns are present in the file and the cell is filled in).

Shift day, shift time/abbreviation and center serve as a key for matching the record and are never overwritten for an existing record.