[3.2][RC] Bulk User Add

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Post Reply
User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

[3.2][RC] Bulk User Add

Post by david63 » Tue Jan 01, 2019 1:39 pm

Extension Name: Bulk User Add
Author: david63

Extension Description: An extension for phpBB 3.2.x that will add users from either an Excel spreadsheet or a CSV file.

This extension makes use of the PhpSpreadsheet set of classes.

Extension Version: [RC] 2.1.0-rc1

Requirements: 3.2.0

Notes:
See next post

Features:
  • Add users from an Excel spreadsheet.
  • Add users from a CSV file.
  • Option to copy a start date from the input file.
Installation:
  • Download the latest release and unzip it.
  • Upload the unzipped files to root/ext/david63/bulkuseradd and enable it in the ACP

GitHub Repository: https://github.com/david63/david63-bulkuseradd
Extension Download: https://github.com/david63/david63-bulk ... ve/3.2.zip
Last edited by david63 on Fri Jan 04, 2019 9:32 pm, edited 3 times in total.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Bulk User Add

Post by david63 » Tue Jan 01, 2019 1:40 pm

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 I strongly recommend that this extension is used 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.
==================================================================================
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

igorbond
Registered User
Posts: 104
Joined: Sun Mar 24, 2013 5:54 pm

Re: [3.2][RC] Bulk User Add

Post by igorbond » Fri Jan 04, 2019 12:46 pm

I have such a CSV file with

Code: Select all

163 users; exunoz;60@cpocz.net.pl;28.03.2016, 10: 14 
but nothing happens, what's wrong with this file? And can you know how to import users from the forum first?
Image

User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Bulk User Add

Post by david63 » Fri Jan 04, 2019 1:10 pm

igorbond wrote:
Fri Jan 04, 2019 12:46 pm
what's wrong with this file?
Without seeing the file I have no idea
igorbond wrote:
Fri Jan 04, 2019 12:46 pm
And can you know how to import users from the forum first?
Don't know what that means
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

igorbond
Registered User
Posts: 104
Joined: Sun Mar 24, 2013 5:54 pm

Re: [3.2][RC] Bulk User Add

Post by igorbond » Fri Jan 04, 2019 1:13 pm

Or you can just give an example of the design of the CSV file
Image

User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Bulk User Add

Post by david63 » Fri Jan 04, 2019 1:37 pm

igorbond wrote:
Fri Jan 04, 2019 1:13 pm
Or you can just give an example of the design of the CSV file
Standard CSV file - data fields separated by a comma
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

igorbond
Registered User
Posts: 104
Joined: Sun Mar 24, 2013 5:54 pm

Re: [3.2][RC] Bulk User Add

Post by igorbond » Fri Jan 04, 2019 1:55 pm

Image

User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Bulk User Add

Post by david63 » Fri Jan 04, 2019 2:06 pm

Works just fine for me.

Have you set the sheet, start row and columns?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

igorbond
Registered User
Posts: 104
Joined: Sun Mar 24, 2013 5:54 pm

Re: [3.2][RC] Bulk User Add

Post by igorbond » Fri Jan 04, 2019 2:11 pm

And where and what to install?
Image

User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Bulk User Add

Post by david63 » Fri Jan 04, 2019 2:15 pm

igorbond wrote:
Fri Jan 04, 2019 2:11 pm
And where and what to install?
ACP > Extensions > Bulk user add > Bulk user add settings
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

nou nou
Registered User
Posts: 328
Joined: Sat Oct 29, 2016 8:08 pm

Re: [3.2][RC] Bulk User Add

Post by nou nou » Fri Jan 04, 2019 7:30 pm

david63 wrote:
Tue Jan 01, 2019 1:39 pm
Extension Description: An extension for phpBB 3.2.x that will automatically backup your database using the phpBB 3.2 Cron.add users from either an Excel spreadsheet or a CSV file.
I don't think it does a database backup as well, right?

User avatar
david63
Registered User
Posts: 16317
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Bulk User Add

Post by david63 » Fri Jan 04, 2019 9:33 pm

nou nou wrote:
Fri Jan 04, 2019 7:30 pm
david63 wrote:
Tue Jan 01, 2019 1:39 pm
Extension Description: An extension for phpBB 3.2.x that will automatically backup your database using the phpBB 3.2 Cron.add users from either an Excel spreadsheet or a CSV file.
I don't think it does a database backup as well, right?
:oops: :oops: :oops: That's copy, paste and edit for you (and not reading what you have typed)!!!!
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

mywork
Registered User
Posts: 1
Joined: Sat Dec 29, 2018 5:59 pm

Re: [3.2][RC] Bulk User Add

Post by mywork » Wed Jan 23, 2019 3:07 pm

What is the date time format ? do you have any example for US format if using CSV? i tried different formats but seems to be not same when users are created.

oleggorfinkel
Registered User
Posts: 1
Joined: Tue Mar 12, 2019 2:15 pm

Re: [3.2][RC] Bulk User Add

Post by oleggorfinkel » Tue Mar 12, 2019 2:20 pm

Hi, David. I have followed the instructions for installing the Bulk User Add extension and it is now enabled in the Extension Manager. However, when I go to the Settings page, everything that appears on it is informational, and I can't see how I can actually use this extension to import users from a CSV file. Please help... Thanks!

technicalplay
Registered User
Posts: 1
Joined: Fri Mar 22, 2019 12:48 am

Re: [3.2][RC] Bulk User Add

Post by technicalplay » Fri Mar 22, 2019 8:08 pm

Hi David thanks for this super mod! Though I am having a little trouble (not sure if user error or mod).
I successfully installed the mod, Activated it no problem, go to Extensions tab in ACP, BULK USER ADD /Bulk user add settings fill out sheet name "members" (not adding the xlsx extension), First data field is 1 which is the cell row that starts a member, Username "A", Email column "B", Start date column "C", I switch to US for date format (I just read this only applies to CSV files) I didn't know this mod could accept CSV I will try that and see if better results. I then click Submit button and it shows green banner it was successful.

Next click on Bulk user add process to upload th actual file "members.xlsx" click upload, I can now see in the UPDATE area this name of the file (backed up the database as you suggested) click UPDATE and hold my breath! Sure enough get the green banner successful! Whoosh... ok so now I look at the Maintenance Tab and shows this: Bulk User Add - there is no username for email.

I then go to the manage users to see how many actually made it over and nothing no import at all.

Please help!
Ralph

Post Reply

Return to “Extensions in Development”