import cvs or sql file to user manager
how can i import cvs or sql file(contain user and pass) to userman mikrotik?
Re: import cvs or sql file to user manager
What information do you want to import to User Manager ?
Re: import cvs or sql file to user manager
user
password
group
time
password
group
time
Re: import cvs or sql file to user manager
Why do you need to import them ?
Where is the problem to generate new batch of users with 'Add Batch' option ?
Where is the problem to generate new batch of users with 'Add Batch' option ?
Re: import cvs or sql file to user manager
i want user the sql existing database
Re: import cvs or sql file to user manager
I would like to know if it is possible, I have the same problem.
I have a Mikrotik 3.19 with external Radius Server (Radius Manager) but I already have many (300 users names registered) but now I'm getting a lot of problems, the Mikrotik just get freeze every couple hours, I think that is a problem with Radius Comunication, So I was wondering if I can import all those users names to the User Manager database.
How can we edit the usermanager database? Is it possible... (myphpadmin or remote Mysql commands???)
I have a Mikrotik 3.19 with external Radius Server (Radius Manager) but I already have many (300 users names registered) but now I'm getting a lot of problems, the Mikrotik just get freeze every couple hours, I think that is a problem with Radius Comunication, So I was wondering if I can import all those users names to the User Manager database.
How can we edit the usermanager database? Is it possible... (myphpadmin or remote Mysql commands???)
Re: import cvs or sql file to user manager
i have same problem 
i solved a little piece of it. i created some excel file, and i generated command (with concatenate command) for adding every of user in user manager. now i have another problem. when i paste 50 lines of commands in terminal window, it ask me for name, and i need press enter after every of command for adding user
examaple: when i paste this in terminal window
in the end of terminal window i get line name: and that for each user can i bypass that?
i solved a little piece of it. i created some excel file, and i generated command (with concatenate command) for adding every of user in user manager. now i have another problem. when i paste 50 lines of commands in terminal window, it ask me for name, and i need press enter after every of command for adding user examaple: when i paste this in terminal window
Code: Select all
/tool user-manager user add username=adelina.avdic password=qk3421e subscriber=admin group=ucenici
/tool user-manager user add username=adnan.avdicevic password=wl3422r subscriber=admin group=ucenici
/tool user-manager user add username=aida.avdic password=ey3423t subscriber=admin group=ucenici
/tool user-manager user add username=aldin.alihodzic password=rx3424z subscriber=admin group=ucenici
/tool user-manager user add username=armel.abdurahmanovic password=tc3425u subscriber=admin group=ucenici
/tool user-manager user add username=asima.abidovic password=zv3426i subscriber=admin group=ucenici
/tool user-manager user add username=belmin.avdic password=ub3427o subscriber=admin group=ucenici
/tool user-manager user add username=dina.alihodzic password=in3428p subscriber=admin group=ucenici
/tool user-manager user add username=ekma.avdic password=om3429a subscriber=admin group=ucenici
/tool user-manager user add username=eldin.abdurahmanovic password=pq3430s subscriber=admin group=ucenici
/tool user-manager user add username=eldin.ahmetovic password=aw3431d subscriber=admin group=ucenici
/tool user-manager user add username=elmir.avdusinovic password=se3432f subscriber=admin group=ucenici
/tool user-manager user add username=fadil.alajmovic password=dr3433g subscriber=admin group=ucenici
Re: import cvs or sql file to user manager
maybe you should add name=something to the end of each line in what you are pasting 
note that username and name are different things
note that username and name are different thingsRe: import cvs or sql file to user manager
thanks man 
u solved my problem
u solved my problem Re: import cvs or sql file to user manager
Is it possible to run this with a script that would automatically scan the file every 24 hours. That way if a new user was added it would automatically get added.