Register to Reply
Results 1 to 3 of 3

Thread: Looking for Add-On to auto-import users from external file

  1. Thread Starter #1
    vBulletin Enthusiast
    VIP
    cfleischmann's Avatar
    Click to Expand
    Join Date
    Feb 2016
    Posts
    349
    vB Version
    4.2.x
    Last Visit
    30th Jul 2021
    Likes
    125
    Liked 160 Times in 79 Posts
    Gender
    Female

    Lightbulb Looking for Add-On to auto-import users from external file

    Hello:

    I'm looking for an add on that takes a list of users and auto-imports them into vB4. I'm working on creating demo users from my volunteer job's employee directory which is just a CSV file from our HR dept for this purpose. at a minimum such an add-on would look for a username in the first column and additional fields as selected to the end-user.

    Possible Uses:
    • import users from external systems like student or employee databases
    • easy import demo accounts for a training install
    • auto-create accounts in batches (e.g. incoming batch of freshman students)
    • and may others


    features:
    • mass set password of all new accounts to same value that users would be instructed to change at first login by their admin as part of training. or read password from import file if admin is not using the same password for all imported users.
    • mass set primary usergroup by name or group ID number depending on either a selection made at time of import or as read from file.
    • read first line of file to determine additional fields present e.g. (username,email,birth date,extension,department) which would then automatically match up to either predefined fields already shipping with vB or to custom fields on the profile* as added by admin prior to import.
    • ignore duplicates for users who have already registered themselves manually prior to mass import thus admin can give users the choice to either create the account now if they want to get started or wait for the import if the user is not comfortable with registering an account themselves.
    • (optionally) automatically email all imported users who have an email address in their record from the import with at minimum the URL, their username, the admin set password, and any additional text the admin defined such as links to company technology use policies, instructions on how to reset a forgotten password, etc.
    • (optionally) send a massage by either email or PM to the user who initiated the job on completion with job status of how many users succeeded, how many failed, etc.


    * custom field must 1) already be defined in vB and 2) match exactly by name in both the file and in the field manager (e.g. have a field called "ADM Login" in the file and "ADM Login" already defined as a field in vB.)

    ---------- Post Merged at 10:23 ---------- Previous Post was at 09:45 ----------

    well I just thought of another feature:

    * set common email domain thus if the username for the vB is the same as the user email, the user's email address can be assumed (example: common domain: staffmail.example.com vb user= lsanders, email user: lsanders assumed email: Email Address:
    Only administrators can view email addresses.
    )

    thus one could add all the students without adding their student email addresses individually or as part of the file
    Thanks:
    Carly:
    Customer Experience Lead / Sr. Web Dev.:
    XDS Support & Training Services

  2. #2
    Administrator
    Tempus's Avatar
    Click to Expand
    Join Date
    Oct 2011
    Posts
    6,896
    vB Version
    4.2.x
    Last Visit
    22nd Oct 2021
    Likes
    2,199
    Liked 10,370 Times in 2,329 Posts
    Gender
    Male
    You could create a simple txt file with the user table populated with names etc. It would require you to log into your phpmyadmin table and delete the previous data then import the fresh file. The downside of your scenario is that it would be specific ONLY to your application. Your external system probably wont have the same table names as vB so it would need to be specific to your external system.
    The Small Print
    Our staff assume members have read the rules and will not accept ignorance as an excuse for not following the them.
    The breaking of any rule WILL lead to you being warned or even banned without notice so don't risk it!


  3. Thread Starter #3
    vBulletin Enthusiast
    VIP
    cfleischmann's Avatar
    Click to Expand
    Join Date
    Feb 2016
    Posts
    349
    vB Version
    4.2.x
    Last Visit
    30th Jul 2021
    Likes
    125
    Liked 160 Times in 79 Posts
    Gender
    Female
    Only registered members can view quoted posts.
    not necessarily because if the first line of the file defines the fields then each line after that is its own record and so long as all the fields are in the same order, the exporting application can put them in whatever order necessary see the following:

    Code:
    Only registered members can view code.
    notice how not all users have a value in customfield1 but the rest have values all starting with a username... I think it can be done just as a thought.
    Thanks:
    Carly:
    Customer Experience Lead / Sr. Web Dev.:
    XDS Support & Training Services

Register to Reply

Similar Threads

  1. HELP
    Error import the language ?
    By Taybac in forum Requests & Help
    Replies: 1
    Last Post: 10th Jul 2020, 19:22
  2. SOLVED
    [Impex] Permissions problem after import from phpbb3
    By MacOS86 in forum Solved Requests
    Replies: 11
    Last Post: 8th Oct 2019, 20:44
  3. External Online Users Page
    By Tempus in forum vBulletin 3.x Add-ons
    Replies: 0
    Last Post: 20th Apr 2015, 22:18
  4. Import/Export Smilies
    By Tempus in forum vBulletin 4.x Add-ons
    Replies: 0
    Last Post: 6th Apr 2015, 21:27
  5. Import External Images
    By Tempus in forum vBulletin 4.x Add-ons
    Replies: 0
    Last Post: 27th Feb 2015, 23:45

Tags for this Thread

Posting Permissions

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