Service: WorkstyleOS Portal

User: Administrator

 

This page explains how to register workers in the WorkstyleOS in a batch with a CSV file and how to export workers registered in the WorkstyleOS as a CSV file.

The asynchronous import procedure allows you to import from thousands workers at once.

 

About importing workers

⚠︎ ATTENTION
・ACALL has 2 options to import workers, "Import All" and "Import Batch (up to 100 items).
・This page explains "Import All". For "Import Batch (up to 100 items)", please refer to [Import/Export Workers].
・Please note that import may take up to 24 hours to complete.
・Please add the following FQDNs in advance, If you have restricted transmissible FQDNs.
　 publicapi-prod-temporary.s3.ap-northeast-1.amazonaws.com
　 publicapi-prod-excluded-password-import-users.s3.ap-northeast-1.amazonaws.com

 

You can import a CSV file and register workers in the WorkstyleOS in a batch.

• Since the importing procedure is asynchronous, you can even shut down your PC or web browser. You will get an email notification when the import is complete.
• When you "Import All", only the workers listed in the CSV file for import will be updated. The update will not be applied to the workers that are not listed in the CSV file.
• For existing workers, only email address will be used as the key.
• You can not update email addresses in a batch. Please update one by one.

 

Import workers

Download CSV template

💡 NOTE
・You can also edit exported CSV file using  [Exporting Workers] then import updated file. 
・If you want to update the existing worker information, please use the exported CSV file instead of the template.
・The items to be checked on our backend for importing are different from those for "Import Batch (up to 100 items)". For more details, please click "View your import history here" on WorkstyleOS Portal.

 

Open [Import & Export] in the side menu on WorkstyleOS Portal.

 

Select [worker] from the pull down menu in "CSV Template" section and click [DOWNLOAD].

 

Add/Edit worker information in CSV file

Add or edit worker information in downloaded CSV file and save.

⚠︎ ATTENTION
・Items marked with (*) are required.
・The character code of the CSV file is UTF-8.
・If you want to update the existing worker information, please use the exported CSV file instead of the template.
・If you leave any of the optional fields blank for existing workers, it will be overwritten with blank.
・If you want to assign a worker to a group, the group must be registered in the WorkstyleOS in advance.

 

Item	Description
Email address (*)	Worker's email address
Last name (*)	Worker's family name
First name	Worker's first name
Last name_pronunciation	Worker's family name in Hiragana (Japanese character)
First name_pronunciation	Worker's first name in Hiragana (Japanese character)
Display name	Worker's display name   ※Please add display name if you do not wish your actual name to be displayed on ACALL RECEPTION.
Permission	Worker's permission (General User/Administrator)   ※If you leave blank, the worker will be registered as "General User".
Password	Worker's login password   ※If you leave blank, the original password will remain.
Group	Group ID to identify the group that the worker belongs to   ※You need to create group in advance. ※You can find the group ID in "Organization">"Groups" in the side menu. ※If you want to add multiple group IDs, separate each group with "|". ※The first group will be the main group.
Phone number	Workers' phone number for SMS notification   ※Available on ACALL RECEPTION. ※Available only when you set to use SMS notification. ※When editing CSV file using Excel, put "'" in front of the first 0.  (ex) Enter '080 instead of 080.
Extension phone number	Extension number to be notified in the ACALL RECEPTION   ※Available on ACALL RECEPTION. ※Cloud extension or on-premise extension option is required. ※Reference: [Calling Using Cloud PBX], [Calling with On-Premise Extensions]
Search key	Workers' search key   ※Even if you leave blank, the search key will be set automatically when you enter 'Last name_pronunciation' or 'Last name_pronunciation' field.  Use this field only if you want to add additional search key manually.
Discharge	Worker's retirement status   ※Enter "0" or blank for current workers and "1" for retired workers. ※If you set the worker as retired, future appointments that the worker is in charge will be deleted.
Worker code	Worker code for workers   ※Reference: [Check in to the Meeting Room with the ACALL mobile Worker Code]
Worker message	Worker's message   ※Available on ACALL RECEPTION. ※Reference: [Setting/Displaying a Message for Each Person in Charge]
Additional Information	Worker information and memo   ※Within 500 characters
Slack user ID	Slack user ID for the worker   ※Available on ACALL RECEPTION. ※Available through service integration with Slack.
Chatwork account ID	ChatWork account ID for the worker   ※Available on ACALL RECEPTION. ※Available through service integration with ChatWork.
Skype email address	Email address in Skype for the worker   ※New Skype integration is no longer available.  Please use Microsoft Teams integration.
Workplace user ID	Workplace account ID for the worker   ※Available on ACALL RECEPTION. ※Available through service integration with Workplace.
G-Suite account	Google Workspace account for the worker for calendar integration Google Workspace account for the worker for Google Chat function   ※Available through service integration with Google calendar and Google Chat. ※If the account information is failed to be linked to the calendar (e.g, account does not exist etc.), error will occur.
HangoutsChat Webhook URL	Google Chat Webhook URL for the worker   ※Available on ACALL RECEPTION. ※Available through service integration with Google Chat.
Office365 account	Microsoft 365 account for the worker for calendar integration   ※Available through service integration with Google calender. ※If account information that can not be linked to the calendar (the account does not exist etc.), an error will happen as the integration has failed.
LINE WORKS ID	LINE WORKS ID for the worker   ※Available on ACALL RECEPTION. ※Available through service integration with LINE WORKS.
Microsoft Teams Webhook URL	Microsoft Teams Webhook URL for the worker   ※Available on ACALL RECEPTION. ※Available through service integration with Microsoft Teams.
AppleID	Apple ID for FaceTime notification   ※Available on ACALL RECEPTION. ※Available only when FaceTime function is turned ON.
FaceTime	Type of FaceTime notification (video/audio)   ※If you leave blank, "video" will be set. ※Available on ACALL RECEPTION.
Tel to call	Phone number for Voice Notifications   ※Available on ACALL RECEPTION. ※Available when voice notification option is ON. ※Less than 15 half-width number, international numbers are supported

 

Select CSV file and import

Click [Import & Export] in the side menu on WorkstyleOS Portal.
Select [workers] under "Import All", and click [IMPORT] after selecting CSV file.

 

Once import is completed, "Request completed, The import request is complete" message will be displayed in the import history screen.

 

It may take up to 24 hours for the import completion.

Please wait until you receive an email complete notification.

 

Import results

Receive an email notification for import result

Import completion notification will be sent to the email address of the person in charge of the import.

If the import result is "Completed without error", it means the import was successfully completed.

 

Click the URL in the email to see the details of the import results.

The status will be displayed as "Succeeded" and the import result will be displayed in the log.

 

Even if import fails, import completion notification will be sent to the email address of the person in charge of the import.

If the import result is "Encountered an error", it means error occurred during the import process.

 

Click the URL in the e-mail to see the details of the import result.

 

The status will be "Error" and you can see the import result in 'Logs'.

Rows with errors will be skipped while rows without errors will be completed.

Refer to the error details and correct the CSV file and import again.

 

 

⚠︎ ATTENTION
・It may take up to 24 hours for the import completion.
・Importing is performed asynchronously in parallel and the order of processing is not in the order of the CSV file.
・If worker registrations exceed your contracted worker limit, it will result in an error.
 If you want to change the worker limit, please contact us via [Contact form].
・If import is not completed after 24 hours, please check the following three items in the import history and contact us via [Contact form].
1. Details of the error (If applicable)
2. Import history ID
3. Date and time of the import

 

Check imported worker information

Click [Organization] > [Workers] in the side menu on WorkstyleOS Portal.

View the details of the imported worker and check if it is correctly registered, updated, or deleted.

⚠︎ ATTENTION
If you changed a worker status to retired by CSV import, reservations for the future external meetings that the worker is in charge will be deleted.

 

Check worker import history

List of import history

You can see the status of import process or review past import history.

 

Click [Import & Export] in the side menu on WorkstyleOS Portal.

Click [View your import history here] under "Import All".

 

You can see the list of the import history that are in progress and have been completed.

You can filter by status, date, and time.

 

Items in the import history

No.	Description
①	Last updated date and time. You can manually update to make sure it is up-to-date.
②	Filter import history by status. All / Queued / Processing / Succeeded / Error
③	Filter import history by import request start/end date.
④	The history that matches the filtering of import status and the start/end date of the import request will be displayed in the list. Status is automatically updated. Listed in order of most recent start date. Older history is also displayed by pagination. Details are below.

 

Details of item number 4

Item	Detail
ID	ID that uniquely identifies the import history.
Date	Date and time the import request was executed.
Status	Progression and errors. Status is automatically updated. All / Queued / Processing / Succeeded / Error
Type	Type of import processing Only "worker import" is available currently.
User	Worker icon and worker name that executed the import request.
Details	Click [open log] link to view import details.

 

View import details

You can check detailed information and logs for each import.

 

Click [open log] in import history.

You can check the processing status and details of each row in import details.

 

Items in the import details

No.	Description
①	Import history ID and last update date. You can manually update to see the latest status.
②	Overview of the import history. Same as "Import history" screen.
③	If the import process is completed, you can download CSV file.
④	Filter logs by status. All / Succeeded / Error
⑤	Row-by-row processing results. All results are displayed in order of newest by date.

 

Log display items

Item	Detail
Created Date	Date of import execution.
Process	Number of rows in the imported CSV file.
Status	Progression and errors. Status is automatically updated. Succeeded /Error
Detail	Details of the imported results. Error will be displayed if the line is not imported due to the wrong format or other reason.

 

Export workers

You can export workers registered in the WorkstyleOS as a CSV file.

• Items in the exported CSV file are the same as those in the CSV file for import.
• Character encoding of the exported CSV file is UTF-8.
• You can edit exported CSV file and use for importing.

 

Export workers

Open [Import & Export] in the side menu on WorkstyleOS Portal and click  [EXPORT] tab.

 

Select [workers] and click [EXPORT].

 

Once export is completed, "Success Exported" message will be displayed.