This board is the new home for david63's extensions.

All of the extensions hosted here will need to be treated as a new install as there is no migration from the original ones to these, and furthermore, no support will be given to migrating to any of these extensions from previous versions.


Due to the selfishness of certain board members it has become necessary to apply a limit of how many downloads each member can make before making a donation. Once a donation has been made then you will have unlimited downloads.

[3.3.0] Bulk User Add

Fully working extensions
User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

[3.3.0] Bulk User Add

#1

Post by devspace »

Bulk User Add:

An extension that will add users from either an Excel spreadsheet or a CSV file.

Compatibility:

Image Image

Image

Note:
  • If you are using any other version of this extension then it must be Disabled /Delete data and the original files deleted before installing this version - you will loose all settings.
  • This extension makes use of the PhpSpreadsheet set of classes.
  • See additional notes below.
Features:
  • Add users from an Excel spreadsheet
  • Add users from a CSV file.
  • Option to copy a start date from the input file.
Language(s):
  • en
Version:
  • 3.3.0
Installation:
  • Download the latest release and unzip it.
  • Upload the unzipped files to [board root]/ext/devspace/bulkuseradd and enable it in the ACP
Configuration:
  • Extensions
  • Bulk user add
  • Bulk user add settings
  • Set required options
  • Extensions
  • Bulk user add
  • Bulk user add process
  • Upload the file containing the data
  • Extensions
  • Bulk user add
  • Bulk user add process
  • Upldate the file that has previously been uploaded
Extension Download:

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

[3.3.0] Bulk User Add

#2

Post by devspace »

Announcements:

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

[3.3.0] Bulk User Add

#3

Post by devspace »

Additional Notes:

This extension will add users from an Excel spreadsheet or a CSV file in which there is a Username column and an Email column.

The user will be added with a password that is exactly the same as their Username and upon the first time they log in they will be forced to change their password - as long as this extension is still enabled.
  • Any user found to have a Username that is already in use will not be added.
  • Any user row of the input file that does not have a Username will not be added.
  • Any user row of the input file that does not have an email address will not be added.
Any records in the input file that cannot be added will be reported in the board's Admin log.

Note you strongly recommend that you use this extension on a test board to ensure that it produces the results that are required and that before using it on a live board that the database is backed up as there is no "undo", "revert" or "restore" options available.

maupap01
Member
Member
Posts: 2
Joined: April 2023

Re: [3.3.0] Bulk User Add

#4

Post by maupap01 »

I can't download the extensions. Thanks for your help.

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

Re: [3.3.0] Bulk User Add

#5

Post by devspace »

maupap01 wrote: 18 Apr 2023, 09:05
I can't download the extensions. Thanks for your help.
Can you be a bit more specific. What error are you getting?

maupap01
Member
Member
Posts: 2
Joined: April 2023

Re: [3.3.0] Bulk User Add

#6

Post by maupap01 »

Thank you. Now the download works! Where do I find information to make the donation?

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

Re: [3.3.0] Bulk User Add

#7

Post by devspace »

maupap01 wrote: 18 Apr 2023, 18:38
Where do I find information to make the donation?
Either in the ACP module for the extension or at the bottom of the page

pfg
Member
Member
Posts: 2
Joined: May 2023

Re: [3.3.0] Bulk User Add

#8

Post by pfg »

Hello,

when adding users with the mod the users won't have a password. So they have to reset the password with e-mail. At least that is what I understood until now.

After that step they have to change the password again durin login and they are not allowed to skip that. Which was quite surprising for me.

Is this correct and intendet to be that way? Or is it some option in the acp?

I need to add about 200 people. A lot of them are older and not used to IT and stuff so I want to make it as easy as possible for them to join. Ofc I want them to change the password at least once. But twice?

Probably it is my own fault but I have not much of an idea what I do at all... that's why I volunteered to do it for 200 people. :cry:

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

Re: [3.3.0] Bulk User Add

#9

Post by devspace »

pfg wrote: 18 Jun 2023, 12:42
when adding users with the mod the users won't have a password.
devspace wrote: 17 Nov 2022, 11:30
The user will be added with a password that is exactly the same as their Username and upon the first time they log in they will be forced to change their password - as long as this extension is still enabled.

pfg
Member
Member
Posts: 2
Joined: May 2023

Re: [3.3.0] Bulk User Add

#10

Post by pfg »

devspace wrote: 19 Jun 2023, 07:39
pfg wrote: 18 Jun 2023, 12:42
when adding users with the mod the users won't have a password.
devspace wrote: 17 Nov 2022, 11:30
The user will be added with a password that is exactly the same as their Username and upon the first time they log in they will be forced to change their password - as long as this extension is still enabled.
Thank you, now I found it. I swear I tried to RTFM but failed.

rigrodesign
Member
Member
Posts: 1
Joined: June 2023

Re: [3.3.0] Bulk User Add

#11

Post by rigrodesign »

In what format should dates be entered?
I have tried several different formats and all the users I have added are showing as joined 'Thu Jan 01, 1970 11:45 am'

Thank you to anyone who can respond.

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

Re: [3.3.0] Bulk User Add

#12

Post by devspace »

rigrodesign wrote: 25 Jun 2023, 15:20
In what format should dates be entered?
Date format:
Is the date in European or US format?
This only applies to CSV files.

LaurentFR
Member
Member
Posts: 2
Joined: October 2023

Re: [3.3.0] Bulk User Add

#13

Post by LaurentFR »

Hello,
Download and install with no problem :D
Fisrt test close to perfect, 2 users imported with a wrong date.

I have selected European date, and in my file i have 31/07/2002, but it import : Thu Jan 01, 1970 10:24 am.
is this possible to have an example of the waiting european format ?

Last but not least, i have to import more than 20k users, i think i will have to do it this separate files, is someone able to tell me how many users i can import in the same file with no trouble ?

Big thanks for this usefull extension ! :D :D :D

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

Re: [3.3.0] Bulk User Add

#14

Post by devspace »

LaurentFR wrote: 22 Oct 2023, 10:12
Fisrt test close to perfect, 2 users imported with a wrong date.
What is the difference in those two dates to the other dates? It will almost certainly be something wrong with the date format.
LaurentFR wrote: 22 Oct 2023, 10:12
how many users i can import in the same file with no trouble ?
That will be totally dependant on your server resources.

LaurentFR
Member
Member
Posts: 2
Joined: October 2023

Re: [3.3.0] Bulk User Add

#15

Post by LaurentFR »

devspace wrote: 22 Oct 2023, 10:20
LaurentFR wrote: 22 Oct 2023, 10:12
Fisrt test close to perfect, 2 users imported with a wrong date.
What is the difference in those two dates to the other dates? It will almost certainly be something wrong with the date format.
I did not explain very well, i import a test file with only 2 users and both have trouble, 30/07/2002 in the csv file is imported and become Thu Jan 01, 1970 10:24 am in phpbb.
I did a second try with date like this 2002-07-13 and i get Fri Jul 12, 2002 10:00 pm, not perfect but sounds good for me !
devspace wrote: 22 Oct 2023, 10:20
LaurentFR wrote: 22 Oct 2023, 10:12
how many users i can import in the same file with no trouble ?
That will be totally dependant on your server resources.
OK, i will test increasing number of users step by step and give feedback.

Thanks for all !

Atifbut4356
New Member
New Member
Posts: 2
Joined: November 2023

Re: [3.3.0] Bulk User Add

#16

Post by Atifbut4356 »

Hi David,

Board version: 3.3.10

I have installed the extension but I am getting this below error:

Fatal error: Uncaught Symfony\Component\DependencyInjection\Exception\ServiceNotFoundException: You have requested a non-existent service "devspace.bulkuseradd.acp.manage.controller". in /home/customer/www/website.com/public_html/forum/vendor/symfony/dependency-injection/Container.php:348 Stack trace: #0

/home/customer/www/website.com/public_html/forum/ext/devspace/bulkuseradd/acp/bulkuseradd_module.php(28): Symfony\Component\DependencyInjection\Container->get('devspace.bulkus...') #1

/home/customer/www/website.com/public_html/forum/includes/functions_module.php(676): devspace\bulkuseradd\acp\bulkuseradd_module->main('\\devspace\\bulku...', 'manage') #2

/home/customer/www/website.com/public_html/forum/adm/index.php(81): p_master->load_active() #3 {main} thrown in /home/customer/www/website.com/public_html/forum/vendor/symfony/dependency-injection/Container.php on line 348

User avatar
devspace
Owner
Owner
Posts: 279
Joined: October 2022

Re: [3.3.0] Bulk User Add

#17

Post by devspace »

That error would imply that there is one, or more files missing. Did you by by chance unpack the .zip on the server?

Atifbut4356
New Member
New Member
Posts: 2
Joined: November 2023

Re: [3.3.0] Bulk User Add

#18

Post by Atifbut4356 »

issue is fixed, I did a fresh installation of phpbb

crutchlow
Member
Member
Posts: 1
Joined: December 2023

Re: [3.3.0] Bulk User Add

#19

Post by crutchlow »

This is exactly what I needed. Thank you so much!