Uploading Email Lists

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
6/21/2012 10:23:18 PM
Joe Vago
Gravatar
Total Posts 83
View Posts
-- Joe

Uploading Email Lists

I am helping a non-profit theatre group move to MojoPortal.  One existing email list has over 4000 addresses.

Is there any process (besides manual entry) that would help import the email addresses so the NewsLetter feature can be used?

Or maybe a generic SQL script that I can modify that shows the tables to import the addresses to?  (and turn on the specific newsletter)

Thanks for any help you can provide

-- Joe

6/22/2012 1:52:18 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Uploading Email Lists

Hi Joe,

If you can wait a few days I'll throw together a simple .aspx file with inline code that gives an example for importing from a csv file and share it with you. You may need to tweak it a little for the format of your file, the advantage of inline code is you don't have to compile it so its good for one off utilities where you may need to make small changes in the code.

Best,

Joe

6/23/2012 9:19:38 PM
Joe Vago
Gravatar
Total Posts 83
View Posts
-- Joe

Re: Uploading Email Lists

Any help you can provide is much appreciated.  

Thanks Joe.

6/24/2012 1:41:55 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Uploading Email Lists

I've uploaded example code mojoNewsletterSubscriberImportExampleCode.zip and an example csv file that works with the code. Thanks goes to Steve Railsback who implemented the code for importing. Read the readme.txt in the zip file.

Hope that helps,

Joe

6/27/2012 3:15:20 PM
Joe Vago
Gravatar
Total Posts 83
View Posts
-- Joe

Re: Uploading Email Lists

Joe,

This is just what I needed - and it worked perfectly on my local install.

I do have the legacy systems "date added" field that would be nice to keep.  Do you recall what property name would correspond to a "data added" in the LetterSubscriber object?  (you can tell me to read thru the documentation if you prefer)

Thanks again

-- Joe Vago

6/27/2012 3:18:10 PM
Joe Vago
Gravatar
Total Posts 83
View Posts
-- Joe

Re: Uploading Email Lists

Oops...I meant the "subscriber" object...

6/27/2012 3:29:38 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Uploading Email Lists

If you look in the AddSubscriber method in the example code you can see we are assigning DateTime.UtcNow  to BeginUtc

you could modify the code to also parse your date from your file and convert the string value to a DateTime object and then assign that instead.

Hope that helps,

Joe

6/27/2012 3:34:00 PM
Joe Vago
Gravatar
Total Posts 83
View Posts
-- Joe

Re: Uploading Email Lists

That should work - thanks again!

You must sign in to post in the forums. This thread is closed to new posts.