- Help Center > Meeting Room Check-in ／ Acall Meeting > Administrator > Import/Export > Export Workspace Log
Export Workspace Log
- Category :
Answer
Contents
This page explains how to export workspace log and the specifications of the log file.
Note: Customers using port restrictions by FQDN
FQDN must be added to use the workspace reservation history data export function.
If you are using FQDN or IP address restrictions for security management purposes, please add the following FQDN to use this function.
publicapi-prod-export-workspace-reservations.s3.ap-northeast-1.amazonaws.com:443
Please refer to "Acall Portal Operational Requirements (FQDN)" for port and FQDN restrictions.
You can download past and future appointment data of meeting rooms/equipment as a CSV file in a batch.
Downloaded data can be used for analyzing meeting room utilization.
Workspace log
Workspace appointment data can be exported as a CSV file by specifying a time period.
- Maximum period is 3 months.
- Character encoding of the exported CSV file is UTF-8.
- You can export by specifying future or past dates.
Information in the workspace log
| Item | Description |
|
Appointment ID |
ID that uniquely identifies each appointment |
|
Data source |
Reservation Created From: ・Acall Meeting: Immediate use on Acall Meeting |
| Meeting room name | Name of the reserved workspace |
| Meeting room capacity |
Capacity of the reserved workspace |
|
Meeting room location |
Location of the reserved workspace |
|
Meeting room type |
Type of the reserved workspace (meeting room/equipment) |
|
Meeting room simultaneous |
Availability of the reserved workspace for concurrent use |
| Meeting room fee |
Fee of the reserved workspace |
| Meeting type |
Type of the appointments (internal meeting/appointment) |
| Title |
Subject of the appointment |
| Scheduled start at |
Scheduled start date and time of the appointment |
| Scheduled end at |
Scheduled end date and time of the appointment |
|
Scheduled usage time (Minute) |
Scheduled end time - scheduled start time |
| Extension time (Minute) |
Scheduled extension time of the appointment |
|
Started time |
Date and time of entry |
| Ended time |
Date and time of exit |
|
Used time (Minute) |
Actual usage time. Ended time - Started time |
| Extended time (Minute) |
Actual extended time of the appointment |
| Billing time (Minute) |
Usage time + Extended time |
| Billing amount |
Billing time (minutes) × Meeting room fee |
| Canceled*1 |
Cancellation status |
| Canceled time*1 |
Date and time of cancellation |
| Appointment created time |
Creation date and time of the appointment |
| Appointment creator's company name |
Company name of the person created the appointment |
| Appointment creator name |
Name of the person created the appointment |
|
Appointment creator email address |
Email address of the person created the appointment |
| User count |
Number of people in charge of the appointment |
|
Guest count |
Number of visitors for the appointment |
| Participant count |
Number of people in charge + visitors of the appointment |
| Number of Users |
Number of people who actually used the meeting room *Available with meeting system integration. |
| User's company name |
Company name of the main person in charge of the appointment |
| User name |
Name of the main person in charge of the appointment |
|
User email address |
Email address of the main person in charge of the appointment |
| User group (Hierarchy 1) |
Main group of the main person in charge of the appointment ※If the person belongs to more than one group, the group of the name displayed on [Workers] screen under [Organization] is the main group. ※The main group and its higher hierarchy groups will be in exported log. Lower hierarchy groups of the main group will not. |
| User group (Hierarchy 2) | |
| User group (Hierarchy 3) | |
|
User group (Hierarchy 4) |
|
| User group (Hierarchy 5) | |
|
User group (Hierarchy 6 over) |
Note (※1): For customers using calendar linking
There are three patterns in which a reservation is marked as "Cancelled" and a timestamp appears in the "Canceled time" field:
- The reservation was deleted from the calendar before the scheduled start time.
- The reservation was automatically cancelled by the auto-cancellation feature.
- The meeting was checked in and then checked out within approximately one minute.
To identify which of the above patterns applies, please refer to the "Cancel time" value:
- If the cancellation date is before the scheduled start time:
→ The reservation was deleted from the calendar.
- If the cancellation date is after the scheduled start time and matches or exceeds the auto-cancellation threshold:
→ The reservation was either automatically cancelled by the system,
or it was cancelled shortly after the meeting started (checked out within approximately one minute after check-in).
NOTE
- If there are more than 6 hierarchies, it will be lined up horizontally.
(Example: Hierarchy 6, Hierarchy 7, Hierarchy 8, Hierarchy 9)
- "User group" is the user's current group. It will not be the user's group used in past appointments.
(Example: if you are assigned from the "Sales group" to the "Marketing group",
"User group" will be "Marketing group" which you currently belong.
- "Meeting room name" is the current meeting room name.
Export workspace log
Open [Import & Export] in the side menu on Acall Portal and click [EXPORT] tab.
Select [workspace] in"Asynchronous export", specify a period, and click [EXPORT].
Once export is completed, "Success Exported" message will be displayed.
It may take some time for the export to complete.
Please wait until you receive an email notification of completion.
Check the results of exporting workspace log
Receive the results of your export request by email
When the export process is complete, an export completion notification e-mail will be sent to the e-mail address of the person in charge of the export operation.
Click on the URL in the email to display the Export Details screen.
Click download icon to download the CSV file.
Check the export history of workspace log
Check the list of export history
You can check the status of the export process or review the past export history in Export History screen.
Open [Import & Export] in the side menu on Acall Portal and click [EXPORT] tab, and click [View your export history here]
You can see the history of all exports that are in progress or have been completed in the Export History.
You can also filter the export history by status, date, and time to see the information you need.
Export history details
| Description | |
| ① |
Last update date You can manually updated to ensure that it is up-to-date. |
| ② |
You can filter export history by status. All / Queued / Processing / Succeeded / Error |
| ③ |
You can filter export history by export request start and end dates. ※ It is not the export period. It is a refinement by the date and time of the export operation. |
| ④ |
Lists the history that matches the export status refinement and the export request start and end date and time refinement. ※ Automatically updated when status is updated. ※ Displayed in order of newest start date. ※ Older history is also displayed by pagination. |
Details of export history ④
|
|
Description |
|
ID |
ID to uniquely identify export history |
|
Date |
Date and time the export request was executed |
| Status |
Progress and error (All / Queued / Processing / Succeeded / Error) ※ Automatically updated when status is updated. |
| Type |
Type of export process |
| User |
Worker icon and name that executed the export request |
| Details |
You can see the export details by clicking [open log]. |
Export details
You can review detailed information about the export process and download exported files in export details screen.
Details of export details
| Description | |
| ① |
ID to uniquely identify export history |
| ② |
Last update date You can manually updated to ensure that it is up-to-date. |
| ③ |
Export details |
| ④ |
Log of the export process. |
Details of export detail ④
|
|
Description |
|
ID |
ID to uniquely identify export history |
|
Date |
Date and time the export request was executed |
| Status |
Progress and error (All / Queued / Processing / Succeeded / Error) ※ Automatically updated when status is updated. |
| Type |
Type of export process |
| User |
Worker icon and name that executed the export request |
| Export period |
Export period |
| CSV |
You can download CSV file by clicking download icon |