Hi,

I'm running Hotspot 4.17 with User Manager in a Hotel.
I was wondering if there is a way to import the list of clients that need to login on daily basis from an Excel sheet to the User Manager including the required username, password and login time.

Thx,
Joe

I think the easiest way is to create some formulas in a separate excel sheet that render the needed commands in the RouterOS CLI format. Then, export the sheet as text and upload to the router. After that execute /import file-name=filename.txt
The upload(fetch) and /import can be automated with a rather simple script, either from the router side or from the host side. Upload can be easy if you enable SMB share for one of the drives on RouterOS

Otherwise you will end up creating a complex script on mikrotik, but you will still get to a point that the data needs to be prepared and made available to the script via some kind of local web server.. so at the end of the day I think that preparing a command list from excel (especially if you already have the excel spreadsheet) and /import ing it in the shell is the cleanest way.

Another good point about this way is that there is no limitation on the size of the script (well, apparently there is some, but it's much bigger that the 4096 byte limit of a script variable. I have used this approach to add 15k addresses to an address list)

We already have a software solution to do this, you can try it before purchasing a license:

http://www.infinitel.es/productos/infin ... to_en.html

HotSpotAuto work as a system service and can be connected to any database with an available JDBC driver. For Excel you can use http://sourceforge.net/projects/xlsql/, but there are other available Excel JDBC drivers.

I wrote a tiny program with VB6.0
If want it put private message to mail it for you.

Hi Mousa,
Thank you for your reply and for sending me the application.
My email is:
jkaram68@hotmail.com

I wrote a tiny program with VB6.0
If want it put private message to mail it for you.

Could you please send me this program as well?!
And will it import passwords from the excel file too?!
my email: sakhoshdel@gmail.com

thanks!

hello moussa , kindly send the app to yazbeck@gmail.com

thanks

please kindly send to kbsunnah@gmail.com

Thanks

Hi
Mail it to your address.

can you please send it to me as well?

fahad.snafee@iraquniversity.net

Hello mousa1983,
could you please be so nice and mail me a copy to: vlanlearner@emailn.eu

Thank You,
vlanlearner

Hi Mousa,
I Use Mikrotik User Manager I need to upload User Using Excel file application.
My email is:

davelodia@twoseasonsresorts.com


Thanks

Hello mousa1983,
could you please be so nice and mail me a copy to: fatihkutbay@yandex.com

Thanks...

Hi Mousa

Please can you email it support @ openss.co.za
thanx

Hi Mousa

Please can you send a copy to support @ openss.co.za

thanx

hello mousa1983 !
can you send a copy of the program on this email masterpianist@yandex.com
thanks !
have a nice day

Could you also send me a copy of it?
davey@outlook.in

Thanks in advance

I wrote a tiny program with VB6.0
If want it put private message to mail it for you.

Salam Mousa,

Can you send it to my email jalan.keberhasilan@gmail.com ?
Thanks

Jalan

Thanks mail to me pleas tapsin@tapsin.net

can you please send it to me as well?

jaygie19@gmail.com

Hi mousa1983
I'm using the User Manager and I'd like you to send me the email:
ronylove2131@gmail.com
Please
Thanks

HI mousa1983

Could you send it too to elias.santiago@gmail.com?

I wrote a tiny program with VB6.0
If want it put private message to mail it for you.

can u send it to me likopurba.gs@gmail.com

thx

You can use voucher of hotspot by usermanger and printing card include username and password and limit of time.

Im Helal alans From http://alraziuni.edu.ye/ Al-Razi University in Yemen
please send me the program to this email : it@alraziuni.edu.ye
>>>>

I wrote a tiny program with VB6.0
If want it put private message to mail it for you.

você pode enviar no meu email: reginaldoalves2016@gmail.com