[TOOL] Import Users

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Get Involved
Locked
stevenospam
Registered User
Posts: 44
Joined: Thu Dec 15, 2011 2:02 am

Re: [TOOL] Import Users

Post by stevenospam » Thu Aug 09, 2012 6:53 pm

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 testemail@gmail.com,,testemail@gmail.com,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 ('testemail@gmail.com', 'testemail@gmail.com', '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()

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [TOOL] Import Users

Post by D¡cky » Thu Aug 09, 2012 8:02 pm

stevenospam wrote: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.
Have you hugged someone today?

stevenospam
Registered User
Posts: 44
Joined: Thu Dec 15, 2011 2:02 am

Re: [TOOL] Import Users

Post by stevenospam » Thu Aug 09, 2012 8:53 pm

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
Registered User
Posts: 44
Joined: Thu Dec 15, 2011 2:02 am

Re: [TOOL] Import Users

Post by stevenospam » Thu Aug 09, 2012 9:53 pm

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?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [TOOL] Import Users

Post by D¡cky » Thu Aug 09, 2012 11:36 pm

New users will be added with the board default language. I suspect that emails will be sent with the default language.
Have you hugged someone today?

User avatar
gs2088c
Registered User
Posts: 243
Joined: Thu Dec 03, 2009 7:09 pm

Re: [TOOL] Import Users

Post by gs2088c » Tue Aug 28, 2012 10:42 pm

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)
Mainframe Computer Operations (8 years)
Mainframe Technical Support (5 years)
Tandem System Admin (8 years)
Tandem DBA (15 years)
What is the one real database? Tandem Non-Stop :mrgreen:

User avatar
sebadamus
Registered User
Posts: 26
Joined: Thu Jul 14, 2011 1:23 am

Re: [TOOL] Import Users

Post by sebadamus » Wed Sep 12, 2012 8:24 pm

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 :D
Attachments
csv_user_import_V1.2.3(xml_path_fixed).zip
(48 KiB) Downloaded 139 times

Giles314
Registered User
Posts: 51
Joined: Thu Nov 11, 2010 12:12 am

Re: [TOOL] Import Users

Post by Giles314 » Thu Sep 13, 2012 10:13 pm

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

User avatar
sebadamus
Registered User
Posts: 26
Joined: Thu Jul 14, 2011 1:23 am

Re: [TOOL] Import Users

Post by sebadamus » Fri Sep 14, 2012 2:01 am

Giles314 wrote: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!

User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 6200
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

[TOOL] Import Users - Spanish Translation

Post by Raul [ThE KuKa] » Tue Sep 25, 2012 8:09 am

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.
Attachments
csv_user_import.zip
Import Users 1.0.0a - Spanish Translation
(44.22 KiB) Downloaded 110 times
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate with Image
:flag_es: phpBB Spain - Online Since 2003 :heart:



User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 6200
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: [TOOL] Import Users - Spanish Translation

Post by Raul [ThE KuKa] » Tue Sep 25, 2012 8:42 am

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.
Attachments
csv_user_import_123.zip
Import Users 1.2.3 Spanish Translation
(46.57 KiB) Downloaded 95 times
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate with Image
:flag_es: phpBB Spain - Online Since 2003 :heart:



User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [TOOL] Import Users

Post by D¡cky » Tue Sep 25, 2012 12:28 pm

Thank you, Raul, for both translations.
Have you hugged someone today?

steelnwool
Registered User
Posts: 3
Joined: Thu Sep 27, 2012 12:06 am

Re: [TOOL] Import Users

Post by steelnwool » Thu Sep 27, 2012 12:08 am

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

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [TOOL] Import Users

Post by D¡cky » Thu Sep 27, 2012 1:31 am

steelnwool wrote: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?
Have you hugged someone today?

simonishe
Registered User
Posts: 3
Joined: Wed Oct 31, 2012 2:06 pm

Re: [TOOL] Import Users

Post by simonishe » Wed Oct 31, 2012 2:29 pm

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;dfghlidfuhglisduhfglisduhfglis@bk.ru
etc

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

Locked

Return to “[3.0.x] Convertors”