User -> Import Users
First, download this sample csv file as example of data input, download here. Please read below table carefully to insert data into csv file properly. If you want to activate users automatically with an expire date then you need to set expire date and package properly. You must set expire date format like this : 01 Jan 2020 23:59 or 01-01-2020 23:59
Note : Lat & Long use this format : 23.810331 & 90.412521
Number | Attribute | Description |
---|---|---|
1 | Reseller | Select a reseller to whom you want to add imported users as their salesperson. Leave blank if you want to add imported users to admin/logged in account. |
2 | Select Type | Select Zal Pro dropdown. |
3 | Upload File | Upload Zal Pro CSV file which you filled with your users data. Keep 1000 users in each CSV file for convenience. Make sure you did not changed any column name in Zal Pro CSV file. |
Sample User Import
Number | Attribute | Required | Description |
---|---|---|---|
1 | Full Name | Yes | Full name of the user. |
2 | Identity Number | Yes | User national identity number. |
3 | Mobile Number | Yes | User moible number. This is the number where system will send SMS notification. You must insert mobile number with country code, otherwise it will failed to receive SMS. |
4 | User Name | Yes | Username of the user. This value must have to be unique, if username exist then user will not import as new. |
5 | Password | Yes | Password for connection & portal access. User will use this password for PPPoE/Hotspot/Portal. |
6 | Connection Type | Yes | User connection type id : 1 (Radius PPPoE), 2 (Radius Hotspot), 3 (API PPPoE), 4 (API Hotspot), 5 (API Static). |
7 | Expiration Date | Yes | You must set expiration date if you want to auto activate user during import. Expiration date should be this format : 01 Jan 2020 23:59. Hint: If you use Excel then check field option to set the date format. |
8 | Package Id | Yes | Package ID from Zal Pro package module. You must set package id to auto activate user. |
9 | Nas Id | Yes | NAS ID from Zal Pro network module. |
10 | Static Ip | No | If you want to set static ip for user then set it here. |
11 | Mac Address | No | If you want to set macaddress for user then set it here. User only able to login from this mac. |
12 | Phone Number | Yes | User phone number. |
13 | Email Address | Yes | User email address. |
14 | Address | No | User address. Try to insert short address in few words, long address will cut in half. |
15 | City Id | No | Insert city id not city name. Check area module for city id. |
16 | Area Id | No | Insert area id not area name. Check area module for area id. |
17 | Subarea Id | No | Insert subarea id not subarea name. Check area module for subarea id. |
18 | Latitude | No | Insert user latitude coordinates. This info important for Map in dashboard. Use this format Ex: 23.810331 |
19 | Longitude | No | Insert user longitude coordinates. This info important for Map in dashboard. Use this format Ex: 90.412521 |
20 | Box Number | No | Box number, on which box user's cable connected. |
21 | Box Address | No | Box address, on which box user's cable connected and where is the box or tower located. |
22 | Uplinkport | No | Switch or Hub uplink port number. |
23 | Fibercode | No | Code number of fiber/main cable, on which user connected. |
24 | Fibercolor | No | Fiber/Main cable color, on which user connected. |
25 | Switchboard | No | Number/Name of switch board, on which user connected. |
26 | Backup Connection | No | Backup connection name or number if has any where user will be connected if necessary. |
27 | Electricity Socket | No | How user router/swithc/hub powered. |
28 | Cable Type | No | User cable type. |