Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Bulk import users
Avatar
Ronald de Caluwe
Netherlands
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2013 - 5:12 am

Hi,

Today I started with SP. Overwhelming futures, but so nice!

To be sure, a question, since I'm planning to import 700 users and would to this right the first time...

I understand that the SP user management makes use of the WP user databasetables.
What is the mimimum amount of information that is needed?

I guess name and emailaddress?

Do I have to preset a password for all users?
Is it possible to auto-generate welcome message with login data tot the users?

(I searches in the forum with "bulk import users" but couldn't find anything usefull...)

Thx in advance for replying!

Ronaldussmile

 

 

Ronaldus

__()__

 

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2013 - 5:20 am

Let's take the user question first. 'Bulk import' from where? And/or from what?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ronald de Caluwe
Netherlands
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2013 - 9:04 am

From a csv or xls file.

My customer planned to give access to all his students, approx. 700 people...

 

Ronaldus

__()__

 

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2013 - 10:05 am

Ok - well that was not what I was expecting! But now I know that then the important question is the how? How will these be imported? I need to determine whether whatever imports these users creates a proper WP user record using the WP API as that is the only way that the forum is going to also have the user data it needs created.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ronald de Caluwe
Netherlands
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2013 - 10:18 am

I'm not sure I understand you well.

Do you mean that I have to create users in the WP admin area?
Then I could use this plugin perhaps:
http://wordpress.org/extend/pl.....-from-csv/

Would that do the trick you think?

 

Ronaldus

__()__

 

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2013 - 10:32 am

That plugin does look it comes from a reputable source although I can't try it of course.

So two options really. Import your users into WP and as long as the import mechanism abides by WP API and rules then it will create the user data specfic to the forum. Or - and this would actually be easier - import your users BEFORE you install SP and let SP create the data during the installation process.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ronald de Caluwe
Netherlands
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2013 - 10:42 am

OK thx!

I think it'll be option one I guess. The 700 people will not be added at once. 20 to 30 per week.
Now I know what to do and know that I'm not missing a handy tool and made it myself more difficult than necessary...

Cheers and thx for the quick responses!!

 

Ronaldus

__()__

 

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2013 - 11:10 am

Simply check after the first batch are imported (or do a test run) to make sure that the forums 'sfmembers' table is getting populated correctly.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ronald de Caluwe
Netherlands
Member
Free Members
sp_UserOfflineSmall Offline
Jan 17, 2013 - 2:35 am

Did a test with an import of 2 users and they showed up as members.

Thx and cheers!

kiss

 

Ronaldus

__()__

 

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 17, 2013 - 4:42 am

That's excellent.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625