How to complete Akuvox "Community_Template" excel spreadsheet for mass upload. This will build out your new "property/project" in the Installer cloud saving time vs entering each tenant individually.
IMPORTANT: There cannot be extra spaces or characters in some of these required fields.
Tips: Required columns will have a Red triangle in the title field, if you mouseover will display format and instructions.
Below are explanations for each column as you build out your tenant lists.
A. Building
- You can enter the name or title of your Property here which will display as your building name.
B. Floor
- This is a required field and will correspond to the floor this Tenant belongs to. This field only accepts digits.
C. Apt
- This is a required field and only accepts 1 ~ 6 digits. Each tenant should have their own uncommon apartment number associated.
D. AptName
- This field will display on Akuvox Multi Tenant Door Phones with a display and Contact/ Tenant directory. The text in this field will show up on the Door Phone display under Contacts.
E. Device
- This option allows you to add devices belonging each tenant. Typically only used for Indoor Monitors for each tenant apartment. For example if this tenant has an Indoor monitor you would enter the location of their device, type of device and mac address of the device, IE: if the device for this tenant is a multi tenant with their own entrance, you would use this format based on criteria below: Front Door, 0, 0C1105123456. If your adding an Indoor Monitor you would use 2 for Indoor Monitor, ei: Kitchen,2,0C1105123456
F. FirstName
- Tenants First name
G. LastName
- Tenants Last name
H. Email
- Tenant's email address. If this is entered, once the spreadsheet is uploaded Akuvox will send each tenant a welcome email with instructions and credentials to download, login and use the SmartPlus app.
I. MobileNumber
- Tenants Mobile Phone Number for reference and also used when mass uploading assigning pins, rfid and other access spreadsheet.
J. TelephoneCallingCode
- Used for dialing landline phone numbers. Use "1" for USA
K. 1stPhone
- Tenants 1st Landline number to be called from the Door Phone contact list. Format is 10 digits, ie. 9492856677
L. 2ndPhone
- Tenants 1st Landline number to be called from the Door Phone contact list. Format is 10 digits, ie. 9492856677
M. 3rdPhone
- Tenants 1st Landline number to be called from the Door Phone contact list. Format is 10 digits, ie. 9492856677
N. CallType
- Used to determine the call path. If tenants only want to receive calls on their landline or cellular phone numbers then you would enter 1 in this field so all calls will ring their "landline" phone numbers entered on K - M of the spreadsheet.
O. Web Relay ID
- This will trigger the Web relay that is set in the device if you're using Web Relay to control web based doors/locks. Values for this field are 0 - 50 and should be left 0 if you're not using this feature.