+ Post New Thread
Results 1 to 2 of 2
Web Development Thread, MRBS - Bulk import DB users in Coding and Web Development; To all, I am trying to create a CSV to import all our teacher users into the MRBS database (the ...
  1. #1
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    908
    Thank Post
    92
    Thanked 118 Times in 95 Posts
    Rep Power
    46

    MRBS - Bulk import DB users

    To all,

    I am trying to create a CSV to import all our teacher users into the MRBS database (the server that runs it is totally outside of our network, and this was the only usable method). I export a CSV for phpmyadmin and then added a few more users as a test, just copying the default passwords hash key.

    I then go to import it back in MRBS_users but it just does not play ball, as there is something wrong with line1, which is out of the database itself, I have told it to ignore duplicates.

    Any ideas on how to import would be greatly appreciated, as I have a nice excel sheet which has made the email addresses for me, but I need to import them :-/

    Looking forward to hearing suggestions,

    Thank you.

  2. #2
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    908
    Thank Post
    92
    Thanked 118 Times in 95 Posts
    Rep Power
    46
    OK I have solved this one,

    you need to make sure that the top row is not the column/table heading (i.e.) delete it.

    Need to make sure that the CSV is quoted (with the ") and that you use CSV Load Data and change the fields terminated by setting from ; to , (semicolon to comma)

    then it works :-)

SHARE:
+ Post New Thread

Similar Threads

  1. Bulk Import Contacts into Exchange 2003
    By TheFopp in forum Windows
    Replies: 4
    Last Post: 6th May 2010, 07:01 PM
  2. Bulk import of 'sites' in Sharepoint 2007
    By bandgeekmafia78 in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 4th September 2009, 11:09 AM
  3. MRBS - Bulk upload
    By AdamM in forum How do you do....it?
    Replies: 2
    Last Post: 23rd March 2009, 08:56 AM
  4. Importing new users into Active Directory
    By Mr_M_Cox in forum How do you do....it?
    Replies: 16
    Last Post: 4th November 2008, 11:36 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •