JSON Upload of Staffed Role & Team Schedules (6.9.1.0+)

The schedules for Staffed Roles and Team members may be uploaded to Flight Vector with a JSON file.

Instructions

1. Set the file path for the schedule import in Edit → Settings → Schedule Import Directory.

2. When a JSON file is added to the directory inserted above, the file will disappear once it is consumed by the server.

 a. JSON fields:

i. staffedRoleID = A database ID which can be obtained using select ID, * from StaffedRole

ii. staffedrole = Name of the staffed role.

iii. id = Unique ID to differentiate between shifts. A new ID will create a new shift. If a shift is being updated, the same ID should be used as the ID from the initial upload.

iv. start = Start of the shift using Zulu time formatting.

v. end = End of the shift using Zulu time formatting.

vi. deleted= true or false

vii. crew ID = A database ID which is obtained using select id2, * from Crew

viii. crew = The Crew Member ID. This is set in the crew member dialog but may also be found using select crewid, * from Crew

ix. primaryPhone = Primary phone number (###) ###-####

x. secondaryPhone = Secondary phone number (###) ###-####

xi. teamid = A database ID which is obtained using select ID,* from team

xii. team = The team name that is set in the Teams tab.

b. JSON Example:

i. [
{
"staffedRoleId": 1,
"id": "Oct 20 AM Bham TX Phy",
"start": "2023-10-20T12:00:00Z",
"end": "2023-10-20T23:00:00Z",
"deleted": false,
"crew": "Ex01",
"primaryPhone": "[phone]",
"secondaryPhone": "[phone]"
},
{
"staffedRole": "Birmingham Medical Control",
"id": "Oct 20 AM Med Control",
"start": "2023-10-20T12:00:00Z",
"end": "2023-10-20T23:00:00Z",
"deleted": false,
"crew": "Ex02",
"primaryPhone": "[phone]",
"secondaryPhone": "[phone]"
},
{
"teamId": 4,
"crewTypeId": 15,
"id": "Oct 20 AM Team 4 Nurse",
"start": "2023-10-20T12:00:00Z",
"end": "2023-10-20T23:00:00Z",
"deleted": false, 
"crewId": 22966,
"primaryPhone": "[phone]",
"secondaryPhone": "[phone]"
},
{
"team": "Team 4",
"crewType": "Paramedic",
"id": "Oct 20 AM Team 4 Medic",
"start": "2023-10-20T12:00:00Z",
"end": "2023-10-20T23:00:00Z",
"deleted": false, 
"crew": "Medic01",
"primaryPhone": "[phone]",
"secondaryPhone": "[phone]"
}
]

staffedRoleID & staffedRole are redundant and only one or the other is required.

crewID & crew are redundant and only one or the other is required.

After importing the above, here is how the crew and team members appear in the Client:

Staffed Roles

Team Members

Associate the Base for the Team in the Teams setup of the Teams tab.