[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.
Scam Warning
engkuskusnadi
Registered User
Posts: 5
Joined: Tue Feb 21, 2012 10:00 am

Re: [TOOL] Import Users

Post by engkuskusnadi »

Hi, i have error import with modules [TOOL] Import Users.

[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 263: Undefined variable: pass_chng
[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 479: Undefined index: user_email

i used phpbb 3.0.10, can you help me? :(
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [TOOL] Import Users

Post by D¡cky »

engkuskusnadi wrote:Hi, i have error import with modules [TOOL] Import Users.
If you have phpBB debug turned on, turn it off.
OPEN config.php
FIND

Code: Select all

@define('DEBUG', true);
@define('DEBUG_EXTRA', true);
REPLACE WITH

Code: Select all

// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
Have you hugged someone today?
engkuskusnadi
Registered User
Posts: 5
Joined: Tue Feb 21, 2012 10:00 am

Re: [TOOL] Import Users

Post by engkuskusnadi »

hi,

Thank you for your reply. I had to turn on the debug in config.php to see what error that caused me can`t import user to my phpbb 3.0.10 board.

Could you help me solved my problems above ? (cant import user) with the error message that i describe in my previous post.

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

Re: [TOOL] Import Users

Post by D¡cky »

engkuskusnadi wrote:hi,

Thank you for your reply. I had to turn on the debug in config.php to see what error that caused me can`t import user to my phpbb 3.0.10 board.

Could you help me solved my problems above ? (cant import user) with the error message that i describe in my previous post.

Thank you
I don't find a post by you stating that you can't import users. I only see the one with undefined variables. Are you getting these errors even when phpBB debug is turned off? At what point do you get these errors, before or after staring the import?
Have you hugged someone today?
shubhangi
Registered User
Posts: 3
Joined: Wed May 16, 2012 3:24 am
Location: India
Name: shubhangi srivastava

Re: [TOOL] Import Users

Post by shubhangi »

hi,
i have a blog site in wordpress and now i am planning to add forum to that site.Can you please tell me that how can i import my wordpress user into phpBB automatically. Please help me asap.


thanks
http://www.bestjobstore.com
-------------------------
Latest Technological Updates, Tips and Tricks ,Tutorials , How Tos , Online Business and
many more .
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [TOOL] Import Users

Post by D¡cky »

shubhangi wrote:hi,
i have a blog site in wordpress and now i am planning to add forum to that site.Can you please tell me that how can i import my wordpress user into phpBB automatically. Please help me asap.


thanks
You need to export the Wordpress users into a CSV file. The username and email are required fields. The password and other fields are optional. Read the first post in this topic to see how passwords are handled. If you are planning on using a phpBB3 to Wordpress bridge, how the bridge handles passwords will need to be taken into consideration.
Have you hugged someone today?
jhalbrook
Registered User
Posts: 2
Joined: Sun Jun 24, 2012 12:05 am

Re: [TOOL] Import Users

Post by jhalbrook »

engkuskusnadi wrote:Hi, i have error import with modules [TOOL] Import Users.

[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 263: Undefined variable: pass_chng
[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 479: Undefined index: user_email

i used phpbb 3.0.10, can you help me? :(
I am having the same problem. I have a csv with 55 users that I am trying to add and when I try to import, it imports one with the following message in a green box:
The 1 following accounts were imported:
DBoots001

At the top of the screen I get:
[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 263: Undefined variable: pass_chng

I will also add that the screen font is increasing by 1 or 2 sizes on the confirmation screen.

Example of CSV file:
JNorth,,"North, Josh",[email protected],Vancouver,
JSouth,,"South, Jay H",[email protected],Salem,
CEast,,"East, Chad",[email protected],Salem,
SWest,,"West, Steve W",[email protected],Eugene,

Example of settings on import screen:
CSV Filename: supervisor_import.csv
Email: YES
Password Format: tried both
username*: 0
password*: 1
user_email*:3
pf_office_location:4
pf_full_name:2

-----------------------------
Update prior to posting this (in case it helps others)
Make sure you save it in DOS CSV format (ref link from this thread http://www.phpbb.com/community/viewtopi ... #p13105383)
..and..
this helped me - copy your username column and put it in colum 2 also, then in the setup of the import, select 1 for username rather than 0. This fixed a special character generation that was occuring.

Thanks Dicky for a great MOD.
Giles314
Registered User
Posts: 51
Joined: Thu Nov 11, 2010 12:12 am

Re: [TOOL] Import Users

Post by Giles314 »

jhalbrook wrote:I am having the same problem.
Did you try the same solution? :shock:

Else you can try the last MOD version where I hope I have fixed the issues that occur in debug mode.
jhalbrook
Registered User
Posts: 2
Joined: Sun Jun 24, 2012 12:05 am

Re: [TOOL] Import Users

Post by jhalbrook »

I was able to the users added and the emails fired off. However, when I got the confirmation message of the users added and this message:

[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 263: Undefined

I confirmed that my config.php has this:

Code: Select all

// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
Plus the screen font increases by 1 or 2 points.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [TOOL] Import Users

Post by D¡cky »

jhalbrook wrote:I was able to the users added and the emails fired off. However, when I got the confirmation message of the users added and this message:

[phpBB Debug] PHP Notice: in file [ROOT]/includes/acp/acp_import_users.php on line 263: Undefined

I confirmed that my config.php has this:

Code: Select all

// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
Plus the screen font increases by 1 or 2 points.
Whoa! You got the undefined index message after all the users were imported? That's odd. What PHP version are you using?
The other odd thing is that it appears that pass_chng is not used anywhere in the script so it should be able to be removed.
FIND line 263

Code: Select all

				$this->import($email_users, $this->pass_fmt, $pass_chng);
REPLACE WITH

Code: Select all

				$this->import($email_users, $this->pass_fmt;
FIND line 378

Code: Select all

	function import($email_users = false, $pass_fmt = false, $pass_chng = false)
REPLACE WITH

Code: Select all

	function import($email_users = false, $pass_fmt = false)
Have you hugged someone today?
tagetoft
Registered User
Posts: 3
Joined: Thu Jun 28, 2012 12:47 pm

Re: [TOOL] Import Users

Post by tagetoft »

Hello, I keep getting the message:
Warning
No Username found on line 1: line skipped.

My testfile is as simple as this:
"RasmusKlump","123456789","[email protected]"

I've read all 22 pages in this thread + 2 hours of creating different versions of a csv-file hoping to find a solution. I've got the feeling that I miss something essential. Please help
/tage toft
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [TOOL] Import Users

Post by D¡cky »

tagetoft wrote:Hello, I keep getting the message:
Warning
No Username found on line 1: line skipped.

My testfile is as simple as this:
"RasmusKlump","123456789","[email protected]"
Are you setting the field identifiers correctly?
Username = 0
Password = 1
Email = 2
Have you hugged someone today?
tagetoft
Registered User
Posts: 3
Joined: Thu Jun 28, 2012 12:47 pm

Re: [TOOL] Import Users

Post by tagetoft »

I'm not sure I understand "field identifiers". I tried to make like a header row:

"0","1","2"
"RasmusKlump","123456789","[email protected]"

... with no positive result.

What is field identifiers and what is the syntax?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [TOOL] Import Users

Post by D¡cky »

tagetoft wrote:I'm not sure I understand "field identifiers". I tried to make like a header row:

"0","1","2"
"RasmusKlump","123456789","[email protected]"

... with no positive result.
Do NOT use a header row.
tagetoft wrote:What is field identifiers and what is the syntax?
Field identifiers may not have been the best term to use. When you first enter the import tool, you need to enter where the field is located within the csv file. In your example, the username is the first field so you would enter 0, password is the second field so its value is 1, email is the third field so you enter 2.
Have you hugged someone today?
tagetoft
Registered User
Posts: 3
Joined: Thu Jun 28, 2012 12:47 pm

Re: [TOOL] Import Users

Post by tagetoft »

Ahhh, Thank you! I'm back on track. I thought the mapping 0=username, 1=user_password ... was predefined /tage

Return to “[3.0.x] Convertors”