Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3256
  • Last Modified:

email to phpBB forum

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
0
Peregian
Asked:
Peregian
  • 4
  • 3
1 Solution
 
CelardoreCommented:
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.
0
 
daleoranCommented:
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

0
 
PeregianAuthor Commented:
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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
PeregianAuthor Commented:
I'd better clarify. I'm not interested in hteir email addresses just the email message content.
0
 
CelardoreCommented:
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('localhost','dbuser','dbpass') or die('could not connect to database');
 $list = file('mailinglist.txt');
 foreach ($list as $line_num => $line)
{
 $data = explode(' - ',$line);
 mysql_query("INSERT INTO emails ('email','subject') VALUES('.$data[0].','.$data[1].'),$link) or die(mysql_error());
}
?>

I can't actually test any php at the moment, but I hope that the above code may guide you.

=)
0
 
PeregianAuthor Commented:
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)
0
 
CelardoreCommented:
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! =)
0
 
PeregianAuthor Commented:
Thanks, I appreciate you taking the time to explain that for me.
Looks pretty easy, so I'll see how we go.
I'll get back to you :)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now