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	connection type	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	static ip	No	If you want to set static ip for user then set it here.
8	mac address	No	If you want to set mac address 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 mobile 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	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	uplink port	No	Switch or Hub uplink port number.
23	fiber code	No	Code number of fiber/main cable, on which user connected.
24	fiber color	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/switch/hub powered.
28	cable type	No	User cable type.
29	connection status	No	User connection status ex: 1 enable and 2 disable. User can’t connect if connection is disable/2.