Community discussions

MikroTik App
 
aSelfLion
just joined
Topic Author
Posts: 18
Joined: Sun Sep 23, 2012 9:47 pm

Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Excel e

Mon Aug 01, 2022 5:11 pm

Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings
How can I draw tables with Ms Excel e Vba?
 
User avatar
BrateloSlava
Member Candidate
Member Candidate
Posts: 168
Joined: Mon Aug 09, 2021 10:33 am
Location: Ukraine, Kharkiv

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Mon Aug 01, 2022 6:14 pm

What does your question have to do with the problems of the devices of this manufacturer? Or to the difficulties with setting it up.
 
User avatar
rextended
Forum Guru
Forum Guru
Posts: 11982
Joined: Tue Feb 25, 2014 12:49 pm
Location: Italy
Contact:

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Mon Aug 01, 2022 7:28 pm

The user ask how to draw µ$oft Ex¢el table$, with Vi$ual Ba$i¢ for Appli¢ation$,
using as data source the user-manager database.
But he can't ask it correctly.
 
aSelfLion
just joined
Topic Author
Posts: 18
Joined: Sun Sep 23, 2012 9:47 pm

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Tue Aug 02, 2022 11:53 am

Hello again

All I want is to import active users in Mikrotik Hotspot into Excel table.

Being able to connect and pull this with excel vba.
 
accarda
Member Candidate
Member Candidate
Posts: 208
Joined: Fri Apr 05, 2019 4:06 pm
Location: Italy

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Tue Aug 02, 2022 12:07 pm

You can have a look at how to use API to communicate with router and send your queries to receive the needed data:
https://help.mikrotik.com/docs/display/ROS/API

There is also some example using Python, which has lot of functions to manage Excel and PDF files:
https://help.mikrotik.com/docs/display/ ... n3+Example

There is also REST-API that you can check:
https://help.mikrotik.com/docs/display/ROS/REST+API
 
aSelfLion
just joined
Topic Author
Posts: 18
Joined: Sun Sep 23, 2012 9:47 pm

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Tue Aug 02, 2022 12:18 pm

You can have a look at how to use API to communicate with router and send your queries to receive the needed data:
https://help.mikrotik.com/docs/display/ROS/API

There is also some example using Python, which has lot of functions to manage Excel and PDF files:
https://help.mikrotik.com/docs/display/ ... n3+Example

There is also REST-API that you can check:
https://help.mikrotik.com/docs/display/ROS/REST+API
Thank you. I will try.
If you know of any other examples, I would appreciate if you could share them.
 
accarda
Member Candidate
Member Candidate
Posts: 208
Joined: Fri Apr 05, 2019 4:06 pm
Location: Italy

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Tue Aug 02, 2022 12:26 pm

Personally I have never used API approach as I mostly do all my stuffs with script directly on router.
However one thing you could also check is, if it fits your needs, an easy way to generate a sort of CSV file generated with a ROS script after that you have gathered the user information that you are looking for.
I'm not used to user management topics, so I don't know what options you have, but whatever can be scripted, then you can save such data directly to a file in CSV and then use Excel to import such file directly some way.
Options are there, you can choose the best for you.
 
aSelfLion
just joined
Topic Author
Posts: 18
Joined: Sun Sep 23, 2012 9:47 pm

Re: Mikrotik routerboard 1036 hotspot, Users, User Profiles, Active, Host, ip Bindings How can I draw tables with Ms Exc

Tue Aug 02, 2022 4:59 pm

Personally I have never used API approach as I mostly do all my stuffs with script directly on router.
However one thing you could also check is, if it fits your needs, an easy way to generate a sort of CSV file generated with a ROS script after that you have gathered the user information that you are looking for.
I'm not used to user management topics, so I don't know what options you have, but whatever can be scripted, then you can save such data directly to a file in CSV and then use Excel to import such file directly some way.
Options are there, you can choose the best for you.
Yes.
As you said, I can export to csv file and export it to excel. Let me work a little.
Thank you for your reply.

Who is online

Users browsing this forum: ivicask, LabarH, mrbroadband and 98 guests