Contents
This page explains how to register spots in Acall in batch, and how to export/import and update spots registered in Acall using CSV files.
⚠️ Note: Customers using port restrictions by FQDN
FQDNs must be added to import/export spots.
If you are using FQDN or IP address restrictions for security reason, please add the following FQDN to use this feature.
publicapi-prod-import-spots.s3.ap-northeast-1.amazonaws.com:443
※Please refer to Acall Operational Requirements (FQDN) for port and FQDN restrictions.
To register new spots, please refer to "Register new spots with Import All".
If you have already registered floor or seats and wish to add, edit, or delete spots, please refer to "Update existing spot by Import All".
⚠️ Notes on using spot import
You can use the spot import feature to register spots in batch, but just importing spots does not make the spots available for use.
The following settings are required.
What you can / cannot do with spot import/export
What you can do
- Register new spots
- Update existing spots
- Delete existing spots
What you cannot do
- Register image for spot
- Register spot permission
- Output QR code/QR code image
- Register a spot hierarchy in a single import
- Place spots on the floor map
Items that can be registered/updated in batch
⚠️
・(*)is required.
・The character encoding of CSV files is UTF-8.
・If you leave optional fields for existing spots blank, it will be overwritten as blank. To retain existing value, enter the value in the field.
Item | Description |
Spot ID (*) | Spot ID ※ Leave blank when you create new spot ※ Required when you update/delete the spot (This cannot be duplicated) |
Spot name (*) | Spot name |
Parent spot ID |
Parent spot ID
※To the parent spot ID, please refer to "Check spot ID on Acall".
※For instructions on registering a spot hierarchical structure, please refer to "How to Register a Spot Hierarchical Structure".
⚠️ If the parent spot ID is not specified, no permission is set and only the administrator can use the spot. Please refer to "Register a spot with inherited permission". |
Spot category |
Spot category
Select one of the following: "Office", "Home", "Public Facility", "Rental Space", "Public Transport", "Outdoors" or "Other". ※ If you leave blank, "Office" will be set. |
Authenticators |
How to check in to a spot
Select from "Acall Desktop", "QR Code", or "Acall Portal". ※ Separate multiple entries with "|". |
Simultaneous use setting |
Simultaneous use setting ※ Enter "1" for ON and "0" for OFF. ※ If you leave blank, it is set to "1" (ON). |
Spot capacity |
Capacity of the spot
|
Instantly use setting |
Immediate use setting ※ Enter "1" for ON and "0" for OFF. ※ If you leave blank, it is set to "0" (OFF). |
Open 24 |
24-hour operation setting
※ Enter "1" for ON and "0" for OFF. ※ If you leave blank, it is set to "1" (ON). |
Start time |
Open time
※ Enter only if 24-hour operation setting is OFF. ※ If you leave blank, it is set to "00:00". |
End time |
Close time
※ Enter only if 24-hour operation setting is OFF. ※ If you leave blank, it is set to "23:59". |
Auto cancel setting |
Auto-cancel setting
※ Enter "1" for ON and "0" for OFF. ※ If you leave blank, it is set to "1" (ON). |
Auto cancel time (min) |
Auto-cancel time for the spot
※ Set within the range of 1 to 120. ※ Enter only when auto cancel setting is ON. If you leave blank, it is set to 15. |
Limit Reservable Time Period |
ON / OFF for the setting of the limit of the reservable period. ※ Set "1" for ON and "0" for OFF. ※ When blank, it is set to "0" (OFF). |
Limit Reservable Time Period (Day) |
Reservable period for the spot. ※ Set in the range of 1 to 1000. ※ Only when the Limit Reservation Period is ON (30 when blank). |
Description | Description of the spot ※ Up to 500 characters |
Delete |
Delete the spot
※ If you want to delete the spot, enter "1". When you register or update the spot, enter "0". ※ If you leave blank, it is set to "0". |
Register new spots with Import All
Download template
Download CSV template to register new spots.
Open Import and Export on Acall.
Select "spots" from CSV Template and click [DOWNLOAD].
Enter spot information in CSV file
Enter the spot information in the downloaded CSV file and save.
Please refer to "Items that can be registered/updated in batch" for the details of the items in the CSV file.
⚠️ How to Register a Spot Hierarchical Structure
You must register the parent spot in advance and specify the ID of the parent spot when importing the child spots.
Please refer to the following instruction.
Import CSV file
Click [Import & Export] on the side menu on Acall.
Select [spots] under "Import All", select a CSV file, and click [IMPORT].
Once you see "Request completed. Your request to import is complete." popup, import request is complete.
Please allow up to 24 hours for the import to complete.
Please wait until you receive an email notification of completion.
How to register a spot hierarchical structure
You cannot register a hierarchical structure of spots (parent and child spots) in a single import.
You must register the parent spot in advance and specify the ID of the parent spot when importing the child spots.
There are two methods to register parent spots.
- A:Register in spot setting screen
- B:Register using Import All
For method A, please refer to "Registering and Editing Spots" and register the parent spots one by one.
Register a spot with inherited permission
When registering a new child spot by importing without specifying its parent spot ID, the "Inherit permission settings from parent spot" check box will be unchecked.
In this case, permission is not set and only the administrator can use the spot.
If you want to turn on "Inherit permission settings from parent spot" when importing the spot, you must specify the parent spot ID.
If you edit a spot that has already been registered and register its parent spot ID by importing, the permission will not be inherited.
Please set the permission individually on the spot edit screen.
💡 Please refer to the following for the detail of spot permission.
・Spot Permissions
・Set Spot Permission
The following is an example of a spot with hierarchical structure.
If you want to inherit all the permissions of the Tokyo HQ building to all spots under the building, follow the steps below.
- Import or register on spot edit screen Tokyo HQ building
- Import 1st floor.
Specify Tokyo Head Office building's spot ID issued in step 1 as the parent spot ID. - Import Seats 01 - 03.
Designate the 1F floor issued in *2. as the parent spot ID.Specify 1F's spot ID issued in step 2 as the parent spot ID.
Update existing spot by Import All
There are two methods to update existing spots by Import All: using a template or using an exported CSV file.
This section describes how to update using an exported CSV.
Export spot information
Spots registered in Acall can be exported as a CSV file.
💡 Note
・The items in the exported CSV file are the same as those in the CSV file used for import.
・The character encoding of the exported CSV file is UTF-8.
・The exported CSV file can be edited and used for import.
Open [Import & Export] and click [Export] tab.
Select [spots] and click [EXPORT].
Once you see "Success. Exported." popup, export is complete.
Edit spot information on CSV file
Edit and save the exported CSV file.
Please refer to "Items that can be registered/updated in batch" for the items in the CSV file.
⚠️
If you edit a spot that has already been registered and register its parent spot ID by importing, the permission will not be inherited.
Please refer to the following section.
・Register a spot with inherited permission
Import CSV file
Click [Import & Export] on the side menu on Acall.
Select [spots] under "Import All", select a CSV file, and click [IMPORT].
Once you see "Request completed. Your request to import is complete." popup, import request is complete.
Please allow up to 24 hours for the import to complete.
Please wait until you receive an email notification of completion.
Check the results of spot import
Receive the results of your import request by email
When all rows in the CSV file have been imported, completion notification will be sent to the e-mail address of the person who did the import operation.
If the result is "Completed without error", the import was succeeded.
Click on the URL in the email to view the details of the import results.
The status will be "Succeeded" and the results of the import is displayed in the log.
Even if an error occurs during import, import completion notification will be sent to the e-mail address of the person who did the import operation.
If the result is "Encountered an error", an error has occurred during the import process.
Click on the URL in the email to view the details of the import results.
If an error occurs, the status will be "Error" and the log shows the result of the import.
Rows with errors will be skipped; rows without errors are is complete.
For rows with errors, you can check the log details. Correct the CSV file where the error occurred and re-import.
⚠️ Attention
・Please allow up to 24 hours for the import to complete.
・Import is performed asynchronously and in parallel, so the order of process is not in the order of CSV files.
・If any problem occurs, such as the import not completing after 24 hours, please check the following points in the import history and contact us via contact form.
1. if there is an error during the import, please provide the details of the error.
2. Import history ID
3. Date and time of the import
Check imported spot information
Click [Spots] on the side menu on Acall.
View the imported spots and check that they have been properly registered, updated, and deleted.
Identify spot IDs
You can identify sport IDs on Acall.
💡 Note
You can also identify spot IDs in the exported CSV file.
Click [Spots] on the side menu on Acall and click edit icon of the spot.
Spot ID is displayed below the spot name on the edit screen.
Comments
0 comments
Article is closed for comments.