To upload the initial user database, Floorsense requires a spreadsheet with the following table. It is crucial to include all usernames and emails exactly as they appear in the client's Active Directory, especially if Single Sign-On (SSO) is planned for later implementation, to prevent duplicates.

Additionally, the client can provide locker and desk allocations in the same spreadsheet. Please enter the locker and desk numbers precisely as they should be in the system. Since spreadsheets often convert numbers like "001" to "1," ensure that the data type for these entries is formatted as text to avoid this issue.

Example of UserDB table

optional mandatory optional optional optional optional mandatory optional optional optional
user/cleaner Full name default_PIN cards CSN Permanent Locker reservations Adhoc Locker Reservations email group Permanent Desk Reservation User Tags
user John Smith Sample 8878 B1.002 [email protected] Default Group L1.023 First Aid
user Eric Sample 2424 B2.225 [email protected] IT Fire Warden
cleaner Dan Porter 1214 d0d6a814feff12e0 B1.020 [email protected] G.355

Desk type table

Sit-Stand Double Monitor Stand only
L1.001-050 G.302 L2.001-100
L1.102 L3.004
L2.103

Locker type table

Locker type Locker number
Top B1.002-019
Bottom B1.020-029
Large B1.050, B2.070