Advertisement:

Author Topic: Adding Bulk Members  (Read 2746 times)

Offline RL Joneson

  • Jr. Member
  • **
  • Posts: 100
  • Gender: Male
  • RL Joneson. Design. Web. Print.
    • RL Joneson. Design. Web. Print.
Adding Bulk Members
« on: August 20, 2008, 01:46:11 PM »
Is there a way to add members by uploading an excel sheet or some other fashion to add a bunch of users at once? We are using the SMF to do our newsletter, but don't want to go through the headache of entering in our old newsletter member list one by one.

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Adding Bulk Members
« Reply #1 on: August 20, 2008, 01:51:16 PM »
You can save your excel spreadsheet as a csv and then use some php to import it into SMF. I wrote this script here: http://www.simplemachines.org/community/index.php?topic=211606.msg1348420#msg1348420

You'll most likely need to modify it as your columns will be different
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline RL Joneson

  • Jr. Member
  • **
  • Posts: 100
  • Gender: Male
  • RL Joneson. Design. Web. Print.
    • RL Joneson. Design. Web. Print.
Re: Adding Bulk Members
« Reply #2 on: August 20, 2008, 02:05:53 PM »
Thanks H. I figured there was no way to get by the user/password fields in the csv file... right? It doesnt make too much sense then i guess. I was just wanting to get emails uploaded to use the SMF Newsletter feature with. Any way to bypass so that the entrys aren't actual users, but SMF uses their emails for the Newsletter feature only??

Just wishful thinking I suppose...

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Adding Bulk Members
« Reply #3 on: August 20, 2008, 04:55:13 PM »
The only way I can think of would be to register them with their username as their e-mail. Their nickname could then be renamed to something random so their e-mail isn't public. Only issue with that would be if they did start using the forum and changed their e-mail they would be unable to change their main login username.

You may also be able to have a mod that just hides invalid users but still allows them to exist in the DB :)
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline RL Joneson

  • Jr. Member
  • **
  • Posts: 100
  • Gender: Male
  • RL Joneson. Design. Web. Print.
    • RL Joneson. Design. Web. Print.
Re: Adding Bulk Members
« Reply #4 on: August 20, 2008, 07:19:39 PM »
Hey thanks H. I think for this project we are going to just use some other email software. Are you able to Export SMF userrs to upload to another email client??

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Adding Bulk Members
« Reply #5 on: August 21, 2008, 01:43:18 PM »
You can use phpmyadmin, export the smf_members column into a CSV and then delete the non-email columns.

More info: What is phpMyAdmin?
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline RL Joneson

  • Jr. Member
  • **
  • Posts: 100
  • Gender: Male
  • RL Joneson. Design. Web. Print.
    • RL Joneson. Design. Web. Print.
Re: Adding Bulk Members
« Reply #6 on: August 21, 2008, 01:51:25 PM »
Great! Thanks H.

//Issue Resolved