Import multiply users from CSV

Get help from other users here.

Moderators: Contributor, Developer

Import multiply users from CSV

Postby titovetch » Jul 03, 2017 3:43 am

Hi,
i see that its possible to import multiply users in MantisHUb with a new plugins called "Import Users from CSV ", how can i use the same plugin or its exclusive for MantisHUb .

another questions can i create user manual and set a default password for the user and to be changed once logged
titovetch
 
Posts: 19
Joined: Jun 20, 2017 9:26 am

Re: Import multiply users from CSV

Postby atrol » Jul 04, 2017 6:01 am

I don't see the plugin at https://github.com/mantisbt-plugins/ or https://github.com/mantishub
So it seems to be exclusive. You could contact MantisHub and ask if they publish the plugin.

titovetch wrote:can i create user manual and set a default password for the user and to be changed once logged
Not possible out of the box.
Please use Search before posting and read the Manual
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6714
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Import multiply users from CSV

Postby titovetch » Jul 05, 2017 1:54 am

i just found the below link and its a good feature to be added :)


https://support.mantishub.com/hc/en-us/ ... s-from-CSV
titovetch
 
Posts: 19
Joined: Jun 20, 2017 9:26 am

Re: Import multiply users from CSV

Postby titovetch » Sep 04, 2017 5:42 am

@atrol
can a create 200 users using sql script
titovetch
 
Posts: 19
Joined: Jun 20, 2017 9:26 am

Re: Import multiply users from CSV

Postby atrol » Sep 04, 2017 8:34 am

I am not sure if I understand what you are asking for.

You can use SQL to create users by inserting rows to database table mantis_user_table.
Have a look at function user_create in file core/user_api.php to get an impression how to populate database fields.
Please use Search before posting and read the Manual
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6714
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Import multiply users from CSV

Postby titovetch » Sep 06, 2017 8:38 am

i have more than 200 users need to be created so i'm asking if there is any solution to do that, sorry but im not a developer and i tried to INSERT INTO databse useing sql and the user was created as i need but unfortunately i can't login because the password seated as text.

i need your support to know how can i do it using sql
titovetch
 
Posts: 19
Joined: Jun 20, 2017 9:26 am

Re: Import multiply users from CSV

Postby atrol » Sep 06, 2017 8:58 am

titovetch wrote: i can't login because the password seated as text.l
Code: Select all
UPDATE mantis_user_table SET `password` = MD5(password);
Please use Search before posting and read the Manual
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6714
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Import multiply users from CSV

Postby titovetch » Sep 08, 2017 2:35 am

i have used the below query but its gave me this error because the last cookie_string was empty

Code: Select all
INSERT INTO `mantis_user_table`(`username`, `realname`, `email`,  `enabled`, `protected`, `access_level`,`password`)
VALUES ("username","fullname","fullname@gmail.com",1,0,25,MD5("passw0rd"))


Code: Select all
#1062 - Duplicate entry '' for key 'idx_user_cookie_string'
titovetch
 
Posts: 19
Joined: Jun 20, 2017 9:26 am

Re: Import multiply users from CSV

Postby atrol » Sep 12, 2017 4:12 pm

You have to insert unique values for cookie_string.
Please use Search before posting and read the Manual
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6714
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Import multiply users from CSV

Postby sandyj » Nov 15, 2017 4:16 pm

Importing users via CSV is a MantisHub exclusive plugin.
sandyj
 
Posts: 4
Joined: Nov 14, 2017 8:16 pm


Return to Help

Who is online

Users browsing this forum: Bing [Bot] and 18 guests