Import email addresses into MT?

A week and still no replies. :-(

Perhaps no one else has a need for notifications within MT? I'd love to see a solution or a plugin for this. What would be better is if MT could just import a list of emails somehow.

I wish I knew SQL so I could just create the sql and put it into MT myself, but I don't know how MT numbers the emails going into the database.

Okay after much testing and restesting this is what worked for me using a csv file and phpmyadmin. I only imported the blog ID and the email address. I realize you can also import name and URL as well but I didn't need to.

Here's what I did:

1) Create a .csv file with all of your email addresses in this format:
blog id,email address

so an example would be

11,sam@sam.com
11,joe@joe.com

etc.

You can use just about any spreadsheet application to create a CSV. I just used excel.

2) Go the the main phpMyAdmin page.

3) Next, click on the database that you are using for MT.

4) Then, click on the table in the far left column called mt_notification. This is the table you want to import the data into.

5) Click Import at the top of the page.

6) Click browse to choose your .csv file

7) In the section called 'Format of imported file' select CSV using LOAD DATA

8) Change the following:
Fields terminated by: , (thats a comma)
Fields enclosed by: [remove default value and leave it blank]
Fields escaped by:[remove default value and leave it blank]
Lines terminated by: \r
Column names: notification_blog_id,notification_email

9) Click "go"

10) When it is done importing, click "Browse" to check that everything worked.

I would do a test file first with about 3 email addresses to make sure that it works before importing a huge list.

I still don't know how to get mysql to put in a date and time for when the record was created but then again I'm not sure how necessary it is.

Hopefully this will help anyone in need of importing large amounts of contact emails into MT for notifications!

Oops!
my example should have read:
11,sam@sam.com
11,joe@joe.com
11,george@george.com

showing that 11 = blog id and the next part after the comma is the email address. Each line is followed by a carriage return.

Hi!

Sorry for hijacking into your thread, but your discussion seems to imply that you how to do email notifications.

Can you answer my question in

http://forums.movabletype.org/2008/09/e-mail-notification---how.html

?

Thanks,

Steffen (clutching at any straws)