Learn how to bulk import and export attendance locations and Wi-Fi networks. Admins can use templates to add locations or Wi-Fi networks in bulk when configuring clock-in methods, with answers to common questions such as import errors and how to obtain latitude and longitude.
Users in your organization can clock in from their mobile device at fixed locations or over a fixed Wi-Fi connection. When configuring location-based clock-in or Wi-Fi clock-in, Admins can use Bulk Import/Export Clock-in Methods to add attendance locations and attendance Wi-Fi networks in bulk.
Bulk import attendance locations and Wi-Fi networks
1
Download the spreadsheet template. On DingTalk desktop, go to Workbench > Attendance > Attendance Group Management > Edit attendance group > Clock-in Method settings > Export Clock-in Methods to obtain the template along with any existing location or Wi-Fi information.
Example: path to export clock-in methods
Notes:For both location-based clock-in and Wi-Fi clock-in, attendance group members can complete their clock-in as long as one method is satisfied. Multiple clock-in methods can coexist, depending on which methods the Organization Admin selects.
2
Fill in the spreadsheet. Enter or edit the information in the Excel spreadsheet as required, then Save the file once the information is correct.
Example: local spreadsheet entry page
3
Import clock-in methods. On DingTalk desktop, go to Workbench > Attendance > Attendance Group Management > Edit attendance group > Clock-in Method settings > Import Clock-in Methods to import the attendance location or Wi-Fi information. Only the Excel format is currently supported.
When bulk importing attendance locations, the message 'A cell in the Office Address worksheet cannot be empty and must be a number' appears. How can I fix it?
This happens because every required field in the import spreadsheet must be filled in. Complete the spreadsheet before importing.
How do I obtain latitude and longitude?
On DingTalk desktop, go to Workbench > Attendance > Attendance Group Management > Edit attendance group > Clock-in Method settings > Add Location to view the latitude and longitude.
Why are the previously configured attendance locations gone after importing?
Importing attendance locations overwrites existing data. To keep existing addresses, do not delete them in Excel after exporting. Add new entries on top of the existing data before importing.
How many attendance groups can an organization add? How many Wi-Fi networks and addresses can be set?
An organization can add up to 10,000 attendance groups, with up to 5,000 users per attendance group. Each attendance group can have up to 1,000 Wi-Fi networks and addresses.
Chats
Calendar
Meetings
Contacts
Mail
Docs
Drive
AI Table
AI Minutes
Attendance
Approval
YiDA
Admin Console
