[Tool] Import users for 3.1.x

Looking for an Extension? Have an Extension request? Post your request here for help. (Note: This forum is community supported; while there is an Extensions Development Team, said team does not dedicate itself to handling requests in this forum)
Scam Warning
stefandebeer
Registered User
Posts: 7
Joined: Tue Feb 17, 2015 9:01 am

[Tool] Import users for 3.1.x

Post by stefandebeer »

There is a very clever tool for importing users from a CSV file:

viewtopic.php?f=65&t=1494875

This is however not supported in 3.1.x

I moved from another forum software to phpBB and this would help me a lot as it makes importing my old user base of 500+ a breeze. Is it possible to port this to 3.1.x? Please.
bjarnig
Registered User
Posts: 5
Joined: Thu Jan 15, 2015 11:06 pm

Re: [Tool] Import users for 3.1.x

Post by bjarnig »

Hi,

I'm in the same situation. Moving from old snitz to phpBB and need to import the users.

Have anyone done this with phpBB 3.1?

Is the only way to downgrade the portal and install this mod?

Thanks in advanced.
maxlinux2000
Registered User
Posts: 20
Joined: Fri May 31, 2013 3:19 pm

Re: [Tool] Import users for 3.1.x

Post by maxlinux2000 »

+1

i need this tool too.
maxlinux2000
Registered User
Posts: 20
Joined: Fri May 31, 2013 3:19 pm

Re: [Tool] Import users for 3.1.x

Post by maxlinux2000 »

There is the mod acp_add_user for 3.0.12...
https://www.phpbb.com/customise/db/mod/ ... _user_mod/

...that was be converted to add_user extension:
viewtopic.php?f=456&t=2271266

How about to ask to RMcGirr83 to have a look to csv_import_users?
viewtopic.php?f=65&t=1494875

i'll write to RMcGirr83,

max
bjarnig
Registered User
Posts: 5
Joined: Thu Jan 15, 2015 11:06 pm

Re: [Tool] Import users for 3.1.x

Post by bjarnig »

Great thanks :-)

Greetings to RMcGirr83 from me :-)
maxlinux2000
Registered User
Posts: 20
Joined: Fri May 31, 2013 3:19 pm

Re: [Tool] Import users for 3.1.x

Post by maxlinux2000 »

please
install and test this extensions in phpbb3.1.3
https://github.com/ForumHulp/Export-Import-Users

instead a csv file, this tool, use a xml ... but is easy for we, to generate them, instead a csv, with ours scripts.

regards
MaX
maxlinux2000
Registered User
Posts: 20
Joined: Fri May 31, 2013 3:19 pm

Re: [Tool] Import users for 3.1.x

Post by maxlinux2000 »

ok... it's works for me in php3.1.3.
have a look in the readme, about the folders names to put in the ext directory

There are a limit of 200 users at a time, but it's not a problem... i can generate more xmls to import.

regards
MaX
bjarnig
Registered User
Posts: 5
Joined: Thu Jan 15, 2015 11:06 pm

Re: [Tool] Import users for 3.1.x

Post by bjarnig »

Hi maxlinux, I can't see that in the readme file. I have installed the mod, and it seems that I can only create one user each time.

Can you inform about the bulk import?
maxlinux2000
Registered User
Posts: 20
Joined: Fri May 31, 2013 3:19 pm

Re: [Tool] Import users for 3.1.x

Post by maxlinux2000 »

I have 2 different forums in developpement, so in the first I have exported all the users in the xml file.
Then I have imported in the second forum (limiting at 20 users, cutting a big part of the xml file)

I have limited to 20 users because with 6300 of them, I have received an error 500 from apache.
Now i'm writing a script that extract from csv the list of users, create an md5 passwd compatible with phpbb, and create various xml of 200 users, in order to import to phpbb witout overcharging apache.

I think that if it can import 20 users, it will be working fine, with 200 of them.
but... for now is only a testing

regards
MaX
bjarnig
Registered User
Posts: 5
Joined: Thu Jan 15, 2015 11:06 pm

Re: [Tool] Import users for 3.1.x

Post by bjarnig »

well, I dont have the programming skills to do this. I have 3000 users that I want to import to my new phpbb forum.

I have been looking for a solution that can import bulk of users to phpBB so they will be a normal users. It's no problem if I have to take 200 in a bulk, but how can I do that.
maxlinux2000
Registered User
Posts: 20
Joined: Fri May 31, 2013 3:19 pm

Re: [Tool] Import users for 3.1.x

Post by maxlinux2000 »

please, send me a private message. I will help you
am-webwerbung
Registered User
Posts: 1
Joined: Sun May 24, 2015 1:59 pm

Re: [Tool] Import users for 3.1.x

Post by am-webwerbung »

Hi everybody,
I would like to import NEW users of a specific group to a new (closed) forum. I want to send them their login data afterwards so they do not have to go through the registration process.
I even managed to set the xml-file which cost me some time, but it's done.

Unfortunately, I always get the error "wrong password". How can it be wrong if they are new users? Are there any password rules I have to obey?

Thanks for your help,

Andreas
wilsonlogan
Registered User
Posts: 32
Joined: Wed Nov 25, 2015 9:48 am

Re: [Tool] Import users for 3.1.x

Post by wilsonlogan »

Hi All,

Sorry, newbie question... I could not find either the XML or XSD definition to use this mod.

Can anyone point me in the right direction?

Thanks,

Wilson.
wilsonlogan
Registered User
Posts: 32
Joined: Wed Nov 25, 2015 9:48 am

Re: [Tool] Import users for 3.1.x

Post by wilsonlogan »

Never mind.

I looked through the code....

For anyone else with this question, example XML is :

<USERS>


<user>

<user_id>51</user_id>

<user_ip>31.216.7.202</user_ip>

<user_regdate>1448369701</user_regdate>

<username>Example User Name</username>

<user_email>[email protected]</user_email>

<user_birthday>01/01/1900<user_birthday/>

<user_password>WTF goes here?</user_password>

</user>


</USERS>


Now I've got the same issue as Andreas... I always get the error "wrong password" when trying to add new users. I've tried text string, empty field, no field, etc.

Back to trawling through the f*cking code then...

Cheers,

Wilson.
wilsonlogan
Registered User
Posts: 32
Joined: Wed Nov 25, 2015 9:48 am

Re: [Tool] Import users for 3.1.x

Post by wilsonlogan »

Okay....


$pass = ((strlen($value['user_password']) == 34 && (substr($value['user_password'], 0,3) == '$H$' ||
substr($value['user_password'], 0,3) == '$P$')) || (strlen($value['user_password']) == 60 &&
(substr($value['user_password'], 0,3) == '$2y'))) ? ' Password ok' : 'Password not ok';


Which I suspect is the test against the password.

Now... trying to decode this...

1) The password length must be 34 chars?

AND

2) The first 4 chars must contain "H"

OR

3) The first 4 chars must contain "P"

OR

4) The password length must be 60 chars?

AND

5) Chars 2,3 must be "2y"


So, this isn't a normal user password. Its an already hashed password....
Post Reply

Return to “Extension Requests”