Community discussions

 
jkaram
just joined
Topic Author
Posts: 2
Joined: Tue Sep 29, 2015 1:53 pm

Is there a way to import users from Excel to User Manager?

Tue Sep 29, 2015 2:45 pm

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
 
ulysses
Frequent Visitor
Frequent Visitor
Posts: 79
Joined: Fri Sep 25, 2015 1:26 pm

Re: Is there a way to import users from Excel to User Manager?

Tue Sep 29, 2015 3:56 pm

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)
 
User avatar
pribasv
Frequent Visitor
Frequent Visitor
Posts: 67
Joined: Thu Mar 10, 2011 12:09 pm
Contact:

Re: Is there a way to import users from Excel to User Manager?

Fri Oct 02, 2015 2:58 pm

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.
 
User avatar
mousa1983
Frequent Visitor
Frequent Visitor
Posts: 79
Joined: Mon Apr 21, 2014 2:36 pm
Location: ilam-iran

Re: Is there a way to import users from Excel to User Manager?

Tue Oct 06, 2015 9:15 pm

I wrote a tiny program with VB6.0
If want it put private message to mail it for you.
Last edited by mousa1983 on Thu Jun 14, 2018 3:12 pm, edited 1 time in total.
 
jkaram
just joined
Topic Author
Posts: 2
Joined: Tue Sep 29, 2015 1:53 pm

Re: Is there a way to import users from Excel to User Manager?

Thu Oct 22, 2015 2:24 pm

Hi Mousa,
Thank you for your reply and for sending me the application.
My email is:
jkaram68@hotmail.com
 
sakhoshdel
just joined
Posts: 3
Joined: Fri Sep 04, 2015 8:35 pm

Re: Is there a way to import users from Excel to User Manager?

Tue Oct 27, 2015 1:03 pm

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!
 
yazbeck
just joined
Posts: 1
Joined: Tue Aug 09, 2016 10:39 am

Re: Is there a way to import users from Excel to User Manager?

Tue Aug 09, 2016 10:53 am

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

thanks
 
kbsunnah
just joined
Posts: 1
Joined: Mon Jan 09, 2017 5:46 pm

Re: Is there a way to import users from Excel to User Manager?

Mon Jan 09, 2017 5:49 pm

please kindly send to kbsunnah@gmail.com

Thanks
 
User avatar
mousa1983
Frequent Visitor
Frequent Visitor
Posts: 79
Joined: Mon Apr 21, 2014 2:36 pm
Location: ilam-iran

Re: Is there a way to import users from Excel to User Manager?

Sat Jan 21, 2017 11:21 am

Hi
Mail it to your address.
 
MetalSaint
just joined
Posts: 6
Joined: Mon Aug 03, 2015 1:47 am
Location: IRAQ
Contact:

Re: Is there a way to import users from Excel to User Manager?

Wed Feb 15, 2017 11:35 am

can you please send it to me as well?

fahad.snafee@iraquniversity.net
 
VlanLearner
just joined
Posts: 17
Joined: Fri Feb 17, 2017 1:27 pm

Re: Is there a way to import users from Excel to User Manager?

Sun Feb 19, 2017 1:29 am

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

Thank You,
vlanlearner
 
mcdavelodia
just joined
Posts: 1
Joined: Wed Feb 22, 2017 3:25 am

Re: Is there a way to import users from Excel to User Manager?

Wed Feb 22, 2017 3:30 am

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

davelodia@twoseasonsresorts.com


Thanks
 
fatihkutbay
just joined
Posts: 1
Joined: Thu Mar 29, 2018 3:44 am

Re: Is there a way to import users from Excel to User Manager?

Thu Mar 29, 2018 3:47 am

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

Thanks...
 
dcmumby
just joined
Posts: 2
Joined: Sun Apr 22, 2018 10:17 am

Re: Is there a way to import users from Excel to User Manager?

Thu May 24, 2018 2:53 pm

Hi Mousa

Please can you email it support @ openss.co.za
thanx
 
dcmumby
just joined
Posts: 2
Joined: Sun Apr 22, 2018 10:17 am

Re: Is there a way to import users from Excel to User Manager?

Thu May 24, 2018 3:01 pm

Hi Mousa

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

thanx
 
masterpianist
just joined
Posts: 13
Joined: Wed Sep 12, 2018 10:19 am

Re: Is there a way to import users from Excel to User Manager?

Tue Oct 23, 2018 4:03 pm

hello mousa1983 !
can you send a copy of the program on this email masterpianist@yandex.com
thanks !
have a nice day
 
distrailo
just joined
Posts: 1
Joined: Fri Mar 15, 2019 4:29 pm

Re: Is there a way to import users from Excel to User Manager?

Fri Mar 15, 2019 4:32 pm

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

Thanks in advance
 
aanset
just joined
Posts: 1
Joined: Tue Dec 05, 2017 6:16 am

Re: Is there a way to import users from Excel to User Manager?

Sat Mar 23, 2019 3:01 pm

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
 
tapsin
just joined
Posts: 6
Joined: Wed Feb 05, 2014 6:56 pm

Re: Is there a way to import users from Excel to User Manager?

Wed May 15, 2019 7:17 pm

Thanks mail to me pleas tapsin@tapsin.net
 
giegs
just joined
Posts: 2
Joined: Wed Jul 03, 2019 12:09 pm

Re: Is there a way to import users from Excel to User Manager?

Wed Jul 03, 2019 12:19 pm

can you please send it to me as well?

jaygie19@gmail.com
 
ronylove
just joined
Posts: 13
Joined: Fri Aug 10, 2018 6:33 pm

Re: Is there a way to import users from Excel to User Manager?

Wed Jul 17, 2019 7:56 pm

Hi mousa1983
I'm using the User Manager and I'd like you to send me the email:
ronylove2131@gmail.com
Please
Thanks
 
esantiago
just joined
Posts: 5
Joined: Wed Nov 06, 2013 9:40 pm

Re: Is there a way to import users from Excel to User Manager?

Fri Jul 19, 2019 5:18 pm

HI mousa1983

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

Who is online

Users browsing this forum: No registered users and 3 guests