Bulk add users?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sm4uma
    Member
    • Feb 2018
    • 42

    Bulk add users?

    I have a CSV file of around 900 users that I need to bulk add to my forum. How can I accomplish this? Thanks.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    You can't - there is no option to do this without writing a custom script to import these users and setup all the relevant information for them in associated tables via the vB5 APIs.

    For further assistance with custom programming, please visit our customisation site, www.vbulletin.org
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • sm4uma
      Member
      • Feb 2018
      • 42

      #3
      Can't support execute a SQL query that will accomplish what I'm seeking? All user variables will be the same except user name and email address.

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73976

        #4
        There currently is no way to execute a query that can read a CSV file and properly create a user record in the system.
        Last edited by Wayne Luke; Mon 12 Mar '18, 8:36am.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • sm4uma
          Member
          • Feb 2018
          • 42

          #5
          If you gave me the format of the proper SQL query, I could prepare the query and then you could execute it. Or would that not work either?

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73976

            #6
            The user record is created over several tables that have to be synced properly for the record to work. There are a number of reasons for this including performance and database stability.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73976

              #7
              Adding users via the API shouldn't be that difficult to add. I've created a feature request issue for our developers to review.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...