create hotspot users using hotel management software data

Hi everyone. We have a small hotel. Just bought MikroTik RB951Ui-2HnD for WiFi hotspot purposes. We would like to create users and passwords automatically since we don’t have enough staff and time to create a WIFI hotspot user every time guests checks-in.
I don’t have an idea how mikrotik works. Can you suggest me how we can create users automatically using hotel management software data?
If I create a csv file every 30 minutes which contains the Guest name, email address, check-out date
For example,
John Vikas;john@bigpond.com;09/02/15
Timothy Young;tim@westnet.com.au;07/02/15

Can I use this data to create users automatically? Guest name could be use as a username and email address could be use as a password and the account would be valid until check-out date. Can you suggest any other method if this is not possible.

Thank you in advance for your replies.

I don’t know what software you are using, but for that purpose, you’re software should be capable of:
1- connecting to MT (radius)
2- and creating users automatically as you desired.

or if you want to use free radius of MT there is only “batch” option which will let you to make numbers of users at once.

Hi,
Thank you for your reply. As I said I don’t have a clue how mikrotik works. Our hotel management software called guestpoint (www.guestpoint.com) Can you explain how to:
1- connect to MT (radius)
2- create users automatically

Thanks a lot.

The website is blocked in my country :smiley: :smiley:
so you should check the software and see whether there is any radius section or not.

No it doesn’t have any radius section. I also contacted the developer team off the software they said that they don’t have wifi hotspot integration.

If so, you’re not able to use that because there is no facility in software to do your jobs and no connecting to router.
maybe you should use mikrotik free radius, ha?

Can I install free radius on windows?
What I need to ask to the guestpoint development team After install the free radius?
Thanks.

You could use our solution, it’s been developed just to do exactly this.

http://forum.mikrotik.com/t/generate-user-manager-users-from-an-external-data-base/85586/1

The download link in the post includes a working example that reads data from a text file, just as in your case, and creates the users on the mikrotik router. In the readme.txt there’s a brief usage explanation.

Thank you very much I will look at it and I will let you know.

Yes, We can Create username and password automatically but you can’t have access to your log’s. It may be an issue if users misuse the data.
Iconwifi is the one of leading wifi hotspot management software provider with affordable price and advanced features. Our software most secure platform for connecting your users.
When you create customized login page by using OTP based registration to the register mobile number. splash pages and also can promote your social media presence to engage the users on social media for remarketing purpose.
With iconwifi you can manage multiple locations from a single dashboard and also you can create banners ads, video ads an landing page for multiple locations for the single dashboard.
where you can create individual bandwidth for the users and limitations of the user as you customized like hourly, daily, and weekly wise. We also integrated with online payment gatway. You can analyze complete data using Insights And Analytics.
For More Details:https://www.iconwifi.in/

Why create/print individual usernames/pass for every customer and not just create ONE username/password for all customers? (shared users must be set to something like 200)

Another one. Create permanent username/password for every room like…

Room 100 = User:36406 pass:13546
Room 101 = user:62494 pass:38262

You can set shared users to 2 for example so every room can login with only 2 devices!

With both ways you dont have to use USER MANAGER.