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 name Yes Name of the user.
2 username Yes Username of the user. This value must have to be unique, if username exist then user will not import as new.
3 password Yes Password for connection & portal access. User will use this password for PPPoE/Hotspot/Portal.
4 connectiontype Yes User connection type id : 1 (Radius PPPoE), 2 (Radius Hotspot), 3 (API PPPoE), 4 (API Hotspot), 5 (API Static).
5 nasid Yes NAS ID from Zal Pro network module.
6 package Yes Package ID from Zal Pro package module. You must set package id to auto activate user.
7 staticip No If you want to set static ip for user then set it here.
8 macaddress No If you want to set macaddress for user then set it here. User only able to login from this mac.
9 expiration 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.
10 nic Yes User national ID card information.
11 mobile 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.
12 phone Yes User phone number.
13 email 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 No Insert city id not city name. Check area module for city id.
16 area No Insert area id not area name. Check area module for area id.
17 subarea No Insert subarea id not subarea name. Check area module for subarea id.
18 lat No Insert user latitude coordinates. This info important for Map in dashboard. Use this format Ex: 23.810331
19 long No Insert user longitude coordinates. This info important for Map in dashboard. Use this format Ex: 90.412521
20 boxnumber No Box number, on which box user's cable connected.
21 boxaddress 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 backupconnection No Backup connection name or number if has any where user will be connected if necessary.
27 electricitysocket No How user router/swithc/hub powered.
28 cabletype No User cable type.
29 connectionstatus No User connection status ex: 1 enable and 2 disable. User can't connect if connection is disable/2.