Question

Report with timezone for session

  • 4 April 2022
  • 2 replies
  • 73 views

Userlevel 1
Badge

Hi,

 

Is there a report that includes the time zone for the sessions?  I have sessions in 3 time zones and need to report on each individually.  I’ve looked and can’t seem to find this field in the old or new reports.

TIA


2 replies

Userlevel 7
Badge +7

Hi @Colleen Rafter think all reports output with admin’s timezone that runs the report. you may need to do some math or use formulas to fix this in your report; which probably doesn't address your issue either.

Userlevel 2
Badge

Hi @Colleen Rafter ,

the correct answer i think is: is not possible to get the timezone in the report. 

To reinforce this concept there is the "Time Zone for Date Fields" field in the "Users - ILT Sessions" report which converts all dates into the chosen value. 

That said, there are several workarounds that can help you get what you are looking for. Here are some solutions: 

  1. User Custom Fields: you can add a “User Custom Field” that specified his/her “Timezone” only if you are sure that a user can enroll only into a specific “Timezone” event. I suggest you this solution because you can upload a CSV file that modify all the users custom field in one shot. 
  2. Session ILT Custom Fields: in the same way (as user custom field) you can create a “Timezone” custom field for the Session ILT. This solution is also better than the previous one. This is the solution that I suggest because you can upload the session via CSV and find the field in the report: 

     

  3. APIs: I know that this is not the best solution but the Get an event  GET  
    /course/v1/events/{event_id}

    can provide all the information that you need: 
    RESPONSE SAMPLE 

    {
    "data": {
    "course": {
    "id": 0,
    "name": "string"
    },
    "session": {
    "id": 0,
    "name": "string"
    },
    "instructors": [
    {
    "user_id": 0,
    "firstname": "string",
    "lastname": "string",
    "username": "string",
    "event_only": true
    }
    ],
    "event_id": 0,
    "name": "string",
    "day": "string",
    "description": "string",
    "time_begin": "string",
    "time_end": "string",
    "break_begin": "string",
    "break_end": "string",
    "timezone": "string",
    "id_classroom": 0,
    "id_location": 0,
    "effective_duration": "string",
    "collaboration_tool": "string",
    "cover_image": "string",
    "webinar_tool": "string",
    "webinar_tool_sync_failed": true,
    "external_calendar_sync_failed": true,
    "id_tool_account": 0,
    "name_tool_account": "string",
    "password": "string",
    "custom_url": "string",
    "allow_recording_completion": true,
    "allow_join_completion": true,
    "join_in_advance_time_user": 0,
    "join_in_advance_time_teacher": 0,
    "lastEdit": {
    "userId": 0,
    "firstName": "string",
    "lastName": "string",
    "dateTime": "string"
    }
    },
    "version": "string"
    }

Hope this could help.

Best,

MODO.

 

 

Reply