Community discussions

MikroTik App
 
davidcam
just joined
Topic Author
Posts: 9
Joined: Tue Oct 21, 2008 6:59 am

Automatically Generate a list of hotspot user.

Mon Jan 12, 2009 5:41 am

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
 
User avatar
Ibersystems
Forum Guru
Forum Guru
Posts: 1686
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain
Contact:

Re: Automatically Generate a list of hotspot user.

Mon Jan 12, 2009 11:51 pm

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.
 
davidcam
just joined
Topic Author
Posts: 9
Joined: Tue Oct 21, 2008 6:59 am

Re: Automatically Generate a list of hotspot user.

Tue Jan 13, 2009 5:50 am

Thanks!
 
User avatar
Ibersystems
Forum Guru
Forum Guru
Posts: 1686
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain
Contact:

Re: Automatically Generate a list of hotspot user.

Tue Jan 13, 2009 10:32 am

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,
 
rumy1200
just joined
Posts: 4
Joined: Sat Dec 17, 2011 2:15 pm

Re: Automatically Generate a list of hotspot user.

Sun Dec 18, 2011 5:00 pm

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
 
User avatar
Ibersystems
Forum Guru
Forum Guru
Posts: 1686
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain
Contact:

Re: Automatically Generate a list of hotspot user.

Mon Dec 19, 2011 4:36 pm

Hi,

you can modify this XLS as you need. Really easy.
create thousand users in HOTSPOT.xls
You do not have the required permissions to view the files attached to this post.
 
siprox
Frequent Visitor
Frequent Visitor
Posts: 83
Joined: Fri Apr 01, 2011 11:14 am

Re: Automatically Generate a list of hotspot user.

Tue Jan 03, 2012 10:07 am

thanks for sharing, thats give me some "idea".
 
Sila
just joined
Posts: 1
Joined: Wed Mar 20, 2013 8:13 am

Re: Automatically Generate a list of hotspot user.

Wed Mar 20, 2013 9:25 am

Thanks!

:)
I just need this too.

Sila
 
User avatar
normis
MikroTik Support
MikroTik Support
Posts: 26322
Joined: Fri May 28, 2004 11:04 am
Location: Riga, Latvia

Re: Automatically Generate a list of hotspot user.

Wed Mar 20, 2013 11:47 am

Thanks!

:)
I just need this too.

Sila
the file is still there.
 
User avatar
Ibersystems
Forum Guru
Forum Guru
Posts: 1686
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain
Contact:

Re: Automatically Generate a list of hotspot user.

Wed Mar 20, 2013 11:55 am

Downloaded 306 times.. :lol:
 
User avatar
Ibersystems
Forum Guru
Forum Guru
Posts: 1686
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain
Contact:

Re: Automatically Generate a list of hotspot user.

Wed Mar 20, 2013 11:55 am

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

share the idea please!
 
eltnen
just joined
Posts: 2
Joined: Sat Dec 13, 2014 9:58 pm

Re: Automatically Generate a list of hotspot user.

Sat Dec 13, 2014 10:09 pm

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
 
bsrour
just joined
Posts: 1
Joined: Sun Jul 14, 2019 4:18 pm

Re: Automatically Generate a list of hotspot user.

Sun Jul 14, 2019 4:33 pm

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

Who is online

Users browsing this forum: No registered users and 23 guests