MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
email to phpBB forum
Posted on 2004-09-14
Is there a simple way to take an email archive (mailing list) and import it into a forum created with phpBB. This would have to be sorted by the email subject and have some filtering options available.
Thanks
Peregian
Thanks
Peregian
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
-
3
8 Comments
What do you mean? Import your mailing list into where?
You can run a MySQL query to import the email addresses into your PHPbb database.
You can run a MySQL query to import the email addresses into your PHPbb database.
Hi Peregian
Check this out
http://www.phpbbhacks.com/download/3016
it will allow you to import your mailing list in the form of a csv
Hope this helps
Michael
Check this out
http://www.phpbbhacks.com/download/3016
it will allow you to import your mailing list in the form of a csv
Hope this helps
Michael
Yes, import a mailing list archive into phpBB bulletin board database. I just want a simple way to do that. So it would become a searchable archive in a forum. I want it to just group all messages by email subject.
What format is your original mailing list in?
If it is like this?
user@email.com - Subject1
another@user.com - Hello!
A simple PHP script to insert all the data into the database.
<?php
$link=mysql_connect('local
$list = file('mailinglist.txt');
foreach ($list as $line_num => $line)
{
$data = explode(' - ',$line);
mysql_query("INSERT INTO emails ('email','subject') VALUES('.$data[0].','.$dat
}
?>
I can't actually test any php at the moment, but I hope that the above code may guide you.
=)
If it is like this?
user@email.com - Subject1
another@user.com - Hello!
A simple PHP script to insert all the data into the database.
<?php
$link=mysql_connect('local
$list = file('mailinglist.txt');
foreach ($list as $line_num => $line)
{
$data = explode(' - ',$line);
mysql_query("INSERT INTO emails ('email','subject') VALUES('.$data[0].','.$dat
}
?>
I can't actually test any php at the moment, but I hope that the above code may guide you.
=)
The original list could be exported into many formats I suppose but I was thinking csv would be easiest to work with. That script may look simple but I have no idea how to run it. Would I have to upload the list and the script to my hosts webserver and run it from there somehow?
You'll have to excuse my dumbness on this subject :o)
You'll have to excuse my dumbness on this subject :o)
To run the script, select everything between and including <?php and ?> then save that in notepad or something similar, as 'emailscript.php'. You will need to change some things, like the 'dbuser', 'dbpass' and the $file variable.
You can export your original list as CSV, but make sure to change the ' - ' in the explode function to be ','
Change the values in the mysql_query() to represent those of your database table.
Also, if you want to use more information from the email information, you can use $data[2],[3],etc. Every time the explode function hits your explode character (' - ') it will dump the results into the $data[] array which will increment each time it finds a new ' - '.
So once you've made all the changes to that script, you upload the emailscript.php and the mailinglist.txt to your host, then run the location of the script in your address bar. It should work automatically, but like I said; I'm afraid I can't test it!
Good luck! =)
You can export your original list as CSV, but make sure to change the ' - ' in the explode function to be ','
Change the values in the mysql_query() to represent those of your database table.
Also, if you want to use more information from the email information, you can use $data[2],[3],etc. Every time the explode function hits your explode character (' - ') it will dump the results into the $data[] array which will increment each time it finds a new ' - '.
So once you've made all the changes to that script, you upload the emailscript.php and the mailinglist.txt to your host, then run the location of the script in your address bar. It should work automatically, but like I said; I'm afraid I can't test it!
Good luck! =)
Featured Post
In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 10 hours left to enroll
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.