MikroTik

Anyone knows if I can automatically generate a list of hotspot users and password for customers grouping by time limit (ex. 1hour hotspot usage, 3 hours hotspot usage) and print it out.
Thanks for your quick help

Hi,


yes you can.

TIP:

Use EXCEL ; )

you can make the profiles and you could make a XLS sheet with random username and password.

the cell must contain ip hotspot user add.. etc. The sentence to create users via telnet.

Every time you open the XLS random cells will random again.

When you have the XLS you can copy paste to console. I recommend you make it every 350 users. First paste user1 to user 349, second paste 350 to 699... etc. I put 5000 users without problems.


Regards.

Thanks!

Hi,


I'm at work now and I have my XLS:

ip hotspot user add limit-uptime=1h server=all name= 1h0001 password= D B S N F
ip hotspot user add limit-uptime=1h server=all name= 1h0002 password= I L E N Q
ip hotspot user add limit-uptime=1h server=all name= 1h0003 password= I K J C R
ip hotspot user add limit-uptime=1h server=all name= 1h0004 password= H Z I Y P
ip hotspot user add limit-uptime=1h server=all name= 1h0005 password= A K M W F
...

you can add profile instead of limit-uptime..


regards,

could you give me a sample excel sheet?

i want to create more than 500 user at a time for my college student by their student id with limitation of 2 hour and 200 MB limit
Advance thanks for help

Hi,

you can modify this XLS as you need. Really easy.

thanks for sharing, thats give me some "idea".

Thanks!


I just need this too.

Sila

Thanks!


I just need this too.

Sila

the file is still there.

Downloaded 306 times..

thanks for sharing, thats give me some "idea".

share the idea please!

hi all i form Egypt i can't speak English good but i have some problem in my server mikrotik ?
i need make some user in hotspot user but i need make 500 user fast make user name only and i need some help
to make it numbers user . and i need it very very important .
example :-
ip hotspot user add name=24531567642 user profile =1M .
i need this but i can't understand it how ?
i need make user hotspot on cardes to enter in my network
any one have any idea ??? ??? pleas i need some help

hi all i form Egypt i can't speak English good but i have some problem in my server mikrotik ?
i need make some user in hotspot user but i need make 500 user fast make user name only and i need some help
to make it numbers user . and i need it very very important .
example :-
ip hotspot user add name=24531567642 user profile =1M .
i need this but i can't understand it how ?
i need make user hotspot on cardes to enter in my network
any one have any idea ??? ??? pleas i need some help

if your are using mikrotik add it from terminal
i speak arabic if u need
use this code
ip hotspot user add limit-uptime=1h server=all name= 1h0001 password= DBSNF