[TOOL] Import Users

Giles314 · Post by **Giles314** » Sat Nov 24, 2012 11:36 pm

By using a text editor!!!

nickyha · Post by **nickyha** » Mon Jan 07, 2013 10:06 am

Hi.
Just install the mod through AutoMod. Painless. Works perfectly. Brilliant piece of kit.
0ne question through. Is it possible to increase the strenght of the auto generated passwords. Like 8 caracters, upper / lower case, numbers, signs.
This to minimize the hazzle of asking our members to login and change the autogen passwword. A bit stronger and they could keep it as is.

steelnwool · Post by **steelnwool** » Mon Jan 07, 2013 12:42 pm

Hi,

I imported a number of topics using this script, but ran into an issue loading images.. Here is a description of my error:

viewtopic.php?f=46&t=2168154

Any ideas?

Daffy-7 · Post by **Daffy-7** » Sun Feb 03, 2013 12:46 am

User Import Tool: Profile standard field 'Location' missing!

I have (finally) got the TOOL working and understand it but the User Import 'form' does not show all the basic user's UCP profile fields in the Board's display ie 'Website' and 'Location'.

Is there a way to add 'Location' in the import field such that it shows in the standard UCP Profile field for Location?

Is there a way to assign any 'non-standard' field values to a place holder like {FIRST_NAME} etc?

I have created custom profile fields but they are added, not overwritten, in the UCP display.

Bill

prototech · Post by **prototech** » Sun Feb 03, 2013 2:05 am

Daffy-7 wrote:I have (finally) got the TOOL working and understand it but the User Import 'form' does not show all the basic user's UCP profile fields in the Board's display ie 'Website' and 'Location'.

The location is there; it is the "user_from" field. You are correct about the website field not being available. Try adding the following to includes/acp/acp_import_users.php:

Code: Select all

			'user_website'		=> 'String',

After:

Code: Select all

			'user_from'			=> 'String',

Daffy-7 wrote:I have created custom profile fields but they are added, not overwritten, in the UCP display.

What do you mean they are added but not overwritten?

Daffy-7 · Post by **Daffy-7** » Wed Feb 06, 2013 7:49 am

prototech wrote: Daffy-7 wrote:I have created custom profile fields but they are added, not overwritten, in the UCP display.

What do you mean they are added but not overwritten?

A little clarification from me - sorry.
UCP>Profile>Edit profile:
Displays the following 'Standard' fields (on my board setup)....
Website: (now!)
Location:
Occupation:
Interests:
Birthday:
[I have removed from the profile display other 'standard' fields not needed in my Board]

Then below them ... my added custom profile fields;
Phone number:
Mobile number:
Address:
Firstname:

An earlier suggestion in this Topic said to just add a custom profile field for 'Location' (or any other) but this would only duplicate the content on the database, as displayed here.

That was what I meant about them being "...added but not overwritten".

Thank you for the solution to add custom profile fields, and to put the Location in the correct place, and to include the 'website' field properly - works fine now.

The system did not like me trying to add another profile field for 'firstname' (or whatever). Apparently the database needs adjusting for this some other way? I would like to know how!
Bill

prototech · Post by **prototech** » Thu Feb 07, 2013 4:02 am

Thanks for the clarification.

Daffy-7 wrote:The system did not like me trying to add another profile field for 'firstname' (or whatever). Apparently the database needs adjusting for this some other way? I would like to know how!

What does the error say when you try to add it?

Daffy-7 · Post by **Daffy-7** » Fri Feb 08, 2013 1:12 pm

prototech wrote:What does the error say when you try to add it?

Re-reading my reply I realise I may have given the wrong impression; I tried to include (add) a new field for 'user_firstname' in the file includes/acp/acp_import_users.php as I did to include the 'user_website' field name as suggested!

The error message generated was as included here.

I am not suprised by this error because the database would not be expecting an additional field (my mistake) but I would like to know how to 'extend' the number of fields in the database to accommodate this.

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_firstname' in 'field list' [1054]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt, user_from, user_birthday, user_firstname) 
VALUES (content removed)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 754
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_user.php
LINE: 250
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_import_users.php
LINE: 389
CALL: user_add()

FILE: [ROOT]/includes/acp/acp_import_users.php
LINE: 227
CALL: acp_import_users->import()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_import_users->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

prototech · Post by **prototech** » Fri Feb 08, 2013 6:26 pm

You don't need to add a new field to the users table to do this. In order to support the user_website field, it was only a matter of adding that single line because the field is already implemented in phpBB, so we were only supplying the field value to something that already existed. If you were to add a field manually, you would also need to modify several files so that the users would actually be able to edit the information.

phpBB already has the ability to add custom profile fields, which this tool supports. Go to the ACP => Users and Groups => Custom profile fields. Type in firstname in the form provided in that page and select Single text field and submit. Adjust the settings as necessary in the next two pages. Once the profile field is created, it will show up under the Custom Values section of the Import users page.

Daffy-7 · Post by **Daffy-7** » Thu Feb 21, 2013 1:22 pm

prototech wrote:Type in firstname in the form provided in that page and select Single text field and submit. Adjust the settings as necessary in the next two pages. Once the profile field is created, it will show up under the Custom Values section of the Import users page.

Thank you 'prototech'. I did include the custom profile field for 'firstname', as you described.
All is fine with that but I would like to use the content of that field in messages from the Board, such as is done with {USERNAME} but don't know where to find the place holder for the 'firstname' data or how to assign that to a place holder!
Bill (in OZ)

Markus.T · Post by **Markus.T** » Wed Mar 20, 2013 9:15 am

It would be nice, if there also be a possibility to import the user's language from the csv-file...

Maybe this anybody has a hint how to integrate that manually?

Thanks,
Markus

prototech · Post by **prototech** » Fri Mar 22, 2013 9:17 am

Take a look at this post: viewtopic.php?p=13229713#p13229713
Instead of user_website, use user_lang. Make sure that the data that you provide corresponds to a valid language pack.

colin.awbery · Post by **colin.awbery** » Mon Jun 17, 2013 1:10 pm

Hi

I'm a newbie at this so please forgive me if I sound think.

I have copied the files then I tried the DIY instructions which I believe I did correctly but now every time I try to go into the Module Management>Administration Control Panel, this comes up;

General Error
Module not accessible

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/functions_module.php
LINE: 439
CALL: trigger_error()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
Please notify the board administrator or webmaster: [email protected]
Powered by phpBB® Forum Software © phpBB Group

Any help would be much appreciated, thanks!

pierrelabrecque · Post by **pierrelabrecque** » Thu Aug 08, 2013 6:06 pm

Hello,

I just installed phpBB 3.0.11 and I need to create around 1000 users for a private intranet. I didn't find in the ACP a way to create multiple users (import a user list from a txt or csv...).
I installed https://www.phpbb.com/customise/db/mod/ ... _user_mod/, but it allows me to create a single user at a time.
So, I google it, and what I found is viewtopic.php?f=65&t=1494875, which seems the more recent post I can find...

Please could you tell me if this tool is stable ? compatible with 3.0.11 ?

Or maybe you can suggest something better (and simple

)

Thanks in advance !

Pierre

Giles314 · Post by **Giles314** » Thu Aug 08, 2013 9:34 pm

pierrelabrecque wrote: So, I google it, and what I found is viewtopic.php?f=65&t=1494875, which seems the more recent post I can find...

The most recent update of this convertor is here

pierrelabrecque wrote:Please could you tell me if this tool is stable ?

As far as I know: yes. I fixed all known anomalies and I tried to add the maximum operator or input data error diagnostics.

pierrelabrecque wrote:compatible with 3.0.11 ?

I did very limited regression tests with the 3.0.11. So again as far as I know it is compatible with this release.

Philippe