Automatically Generate a list of hotspot user.
RouterOS Scripting and API

11 posts   •   Page 1 of 1
davidcam
just joined
 
Posts: 9
Joined: Tue Oct 21, 2008 6:59 am

Automatically Generate a list of hotspot user.

by davidcam » Mon Jan 12, 2009 6: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: 1675
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain

Re: Automatically Generate a list of hotspot user.

by Ibersystems » Tue Jan 13, 2009 12:51 am

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.
Martín
martinruiz at ibersystems.es
Experto en redes WiFi y enlaces WiFi.

Facebook: @Ibersystems
Twitter: @Ibersystems

Certified in Traffic Shaping, Wireless, Internetworking, Routing and User Management.
MTCTCE - MTCWE - MTCINE - MTCUME - MTCRE

davidcam
just joined
 
Posts: 9
Joined: Tue Oct 21, 2008 6:59 am

Re: Automatically Generate a list of hotspot user.

by davidcam » Tue Jan 13, 2009 6:50 am

Thanks!

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

Re: Automatically Generate a list of hotspot user.

by Ibersystems » Tue Jan 13, 2009 11: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,
Martín
martinruiz at ibersystems.es
Experto en redes WiFi y enlaces WiFi.

Facebook: @Ibersystems
Twitter: @Ibersystems

Certified in Traffic Shaping, Wireless, Internetworking, Routing and User Management.
MTCTCE - MTCWE - MTCINE - MTCUME - MTCRE

rumy1200
just joined
 
Posts: 4
Joined: Sat Dec 17, 2011 3:15 pm

Re: Automatically Generate a list of hotspot user.

by rumy1200 » Sun Dec 18, 2011 6: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: 1675
Joined: Wed Apr 12, 2006 12:29 am
Location: Cabrils, Barcelona - Spain

Re: Automatically Generate a list of hotspot user.

by Ibersystems » Mon Dec 19, 2011 5:36 pm

Hi,

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

create thousand users in HOTSPOT.xls
(524.5 KiB) Downloaded 1132 times
Martín
martinruiz at ibersystems.es
Experto en redes WiFi y enlaces WiFi.

Facebook: @Ibersystems
Twitter: @Ibersystems

Certified in Traffic Shaping, Wireless, Internetworking, Routing and User Management.
MTCTCE - MTCWE - MTCINE - MTCUME - MTCRE

siprox
Frequent Visitor
Frequent Visitor
 
Posts: 83
Joined: Fri Apr 01, 2011 11:14 am

Re: Automatically Generate a list of hotspot user.

by siprox » Tue Jan 03, 2012 11:07 am

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

Sila
just joined
 
Posts: 1
Joined: Wed Mar 20, 2013 9:13 am

Re: Automatically Generate a list of hotspot user.

by Sila » Wed Mar 20, 2013 10:25 am

Thanks!

:)
I just need this too.

Sila

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

Re: Automatically Generate a list of hotspot user.

by normis » Wed Mar 20, 2013 12:47 pm

Sila wrote:Thanks!

:)
I just need this too.

Sila


the file is still there.
No answer to your question? How to write posts

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

Re: Automatically Generate a list of hotspot user.

by Ibersystems » Wed Mar 20, 2013 12:55 pm

Downloaded 306 times.. :lol:
Martín
martinruiz at ibersystems.es
Experto en redes WiFi y enlaces WiFi.

Facebook: @Ibersystems
Twitter: @Ibersystems

Certified in Traffic Shaping, Wireless, Internetworking, Routing and User Management.
MTCTCE - MTCWE - MTCINE - MTCUME - MTCRE

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

Re: Automatically Generate a list of hotspot user.

by Ibersystems » Wed Mar 20, 2013 12:55 pm

siprox wrote:thanks for sharing, thats give me some "idea".



share the idea please!
Martín
martinruiz at ibersystems.es
Experto en redes WiFi y enlaces WiFi.

Facebook: @Ibersystems
Twitter: @Ibersystems

Certified in Traffic Shaping, Wireless, Internetworking, Routing and User Management.
MTCTCE - MTCWE - MTCINE - MTCUME - MTCRE

11 posts   •   Page 1 of 1

Who is online

Users browsing this forum: No registered users and 9 guests

It is currently Thu Nov 27, 2014 8:18 am