[TOOL] Import Users

[stevenospam]

PHPBB 3.0.10,
I'm using the original version of this tool with the changes to allow PF fields. I have created a one line test import file that contains [email protected],,[email protected],999,testurb
The appropriate fields are configured 0,1,2,3,4 on the Import Users screen.
There are no " marks on any of the fields and, as you can see the password is not specified. I get the following SQL error when I run the tool:

I do have the phpBB Digests mod installed.

General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb3_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_digest_type, user_digest_send_hour_gmt, user_digest_format, user_digest_show_mine, user_digest_send_on_no_posts, user_digest_show_pms, user_digest_max_posts, user_digest_min_words, user_digest_remove_foes, user_digest_sortby, user_digest_max_display_words, user_digest_reset_lastvisit, user_digest_filter_type, user_digest_pm_mark_read, user_digest_new_posts_only, user_digest_no_post_text, user_digest_attachments, user_digest_block_images, user_digest_toc) VALUES ('[email protected]', '[email protected]', 'f8322cbf682c9f84d0c6bf0b9d1195af', 0, '', '00', 2, 0, '', -5, 'D M d, Y g:i a', 'en_us', 1, '', '', 1344537474, 1344537474, 230271, 0, 0, 0, 1344537474, 0, 0, '', 0, '0', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 1, '', '', '', 'a1ae4d2869b1d85d', 'DAY', '6', 'HTML', 0, '1', '1', '0', '0', '0', 'board', '15', '0', 'ALL', '0', '0', NULL, NULL, NULL, NULL)

BACKTRACE

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

FILE: [ROOT]/includes/functions_user.php
LINE: 275
CALL: dbal_mysql->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()

[D¡cky]

General Error
SQL ERROR [ mysql4 ]

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

It looks like an improper install of the digest MOD. For some reason, user_digest_attachments didn't get added to the database.

[stevenospam]

It looks like you are correct. I checked my production system and the field is defined. I'm running this on my test system where it is not defined.

[stevenospam]

How does this tool deal with languages? If the default language for the board is Spanish, will the new user be added with Spanish as his preferred language? Also, will the email text that is sent be retrieved from the ES directory rather than the EN language directory?

[D¡cky]

New users will be added with the board default language. I suspect that emails will be sent with the default language.

[gs2088c]

Just FYI if you want to know:

To uninstall Import Users:

1. Start board.
2. Go to ACP.
3. Go to Module Management and remove Import Users
4. Delete (or rename) these files:

Code: Select all

root/adm/style/acp_import_users.html
root/includes/acp/info/acp_import_users.php
root/includes/acp/acp_import_users.php
root/languages/en/email/user_import.txt
root/languages/en/mods/acp_import_users.php
root/languages/en/mods/info_acp_import_users.php

5. Purge cache
6. Refresh template(s)

[sebadamus]

Thanks, I could install 1.2.3 mod fixing the "install path" inside the xml, I upload it (hope not to bother the author)

Now lets try to import

[Giles314]

Thanks a lot for this fix. I have built the V1.2.4 with it.

[sebadamus]

Thanks a lot for this fix. I have built the V1.2.4 with it.

Thanks to you! I have imported 288 users easy as pie!

[Raul [ThE KuKa]]

Hi Dicky

Attach Spanish translation to this interesant script, i have translated /contrib/csv_import_users_readme.txt and install.xml (select language Spanish - Español).

Regards.

[Raul [ThE KuKa]]

Hi again Dicky

Attach Spanish translation to 1.2.3
I have translated /contrib/csv_import_users_readme.txt and install.xml (select language Spanish - Español).

Regards.

[D¡cky]

Thank you, Raul, for both translations.

[steelnwool]

I'm a bit lost. Where do I upload the csv_user_import too, so that is appears in ACP?

[D¡cky]

I'm a bit lost. Where do I upload the csv_user_import too, so that is appears in ACP?

Did you read the installation instructions section in the first post of this topic? If you did, which part do you not understand?

[simonishe]

Hello! Thank you a lot for ur tool. Used it successfully for several months.
But now I've got some strange problem.
When i want to import users, so i make csv file as usual, but the error is that theese users already exist.

Even if its
dfghlidfuhglisduhfglisduhfglis;[email protected]
etc

Got this problem just today, it was ok before. What can be wrong?