In our project we have a large user base. It also means that we have a large email base. And in such case you sometimes need to inform your users about some changes or new features etc.
For this purpose we decided to use phpList (https://www.phplist.com/) as it offers templates/ subscribe lists and anything we basically need.
There are several ways you can add user to your base: one by one manual adding, adding of bulk email list as plaintext and import it in CSV file. The last way is pretty useful as you can export emails of your users to CSV using SQL statement like:
However, there is a way out. Which will require a bit of editing its core files.
You will have to open file lists/admin/import2.php and find line #95
After that just change this multiplier and save the file (you should reverse it after you uploaded the CSV file).
It will allow you to import your large CSV file.
NB!: Make sure you checked the subscribe list you would like to add your users to.
This way of hacking the core code is not a proper way of handling such problems. But if you do understand what you are doing and it is a one-time issue you surely can use it.
For this purpose we decided to use phpList (https://www.phplist.com/) as it offers templates/ subscribe lists and anything we basically need.
There are several ways you can add user to your base: one by one manual adding, adding of bulk email list as plaintext and import it in CSV file. The last way is pretty useful as you can export emails of your users to CSV using SQL statement like:
It will provide you with a nice solid CSV file which includes all emails you have in that table. However, if you have really large number of users the size of CSV file may be about 100 Mb or even more. You can make your server accept files in POST with such size by editing php.ini, that is not a big problem. However, phpList accepts only CSV files of 5 Mb. And that is a problem.SELECT email FROM emails INTO OUTFILE '/tmp/emails.csv' LINES TERMINATED BY '\n';
However, there is a way out. Which will require a bit of editing its core files.
You will have to open file lists/admin/import2.php and find line #95
After that just change this multiplier and save the file (you should reverse it after you uploaded the CSV file).
It will allow you to import your large CSV file.
NB!: Make sure you checked the subscribe list you would like to add your users to.
This way of hacking the core code is not a proper way of handling such problems. But if you do understand what you are doing and it is a one-time issue you surely can use it.