Page 1 of 1
Newsletter
Posted: Fri Aug 11, 2006 2:05 pm
by pgoneill
So, I need to create a newsletter that will go out to 500+ FrontEndUsers on a regular basis.
Can NMS interact with FEUs - i.e. pull their email addresses from the database?
The ability to subscribe/unsubscribe is unimportant - this is a mandatory, internal newsletter.
My other thought was, if that wouldn't work, exporting the FEUs to CSV, opening in excel and simply copy/pasting the emails into a new Outlook message or feeding it to a different (non-CMSMS-module) newsletter script. Only problem with that was that exporting to CSV doesn't seem to work - it just spits out 4 "users" (of 500+) with inaccurate properties.
I'm open to all suggestions or ideas. Thanks in advance!
Re: Newsletter
Posted: Fri Aug 11, 2006 2:49 pm
by calguy1000
NMS doesn't have this ability (yet). But the 1.0 series of NMS does have a CSV import ability, and feusers has a CSV export
So with a bit of manipulation in excel you should be able to import your feusers into NMS quite easily.
Re: Newsletter
Posted: Fri Aug 11, 2006 3:54 pm
by pgoneill
That was the plan, but FEU doesn't export CSV properly...it spits out only 4 of my 500+ users and with some fields mixed up...

Re: Newsletter
Posted: Mon Aug 14, 2006 2:22 pm
by pgoneill
No ideas, anyone? Could it be the Windows server it's running on?
Re: Newsletter
Posted: Mon Aug 14, 2006 2:56 pm
by calguy1000
sure, I'll blame windows for that.... last time I tested it on a linux server it worked fine. we exported 14000 users with little difficulty (except timeouts).
Re: Newsletter
Posted: Mon Sep 25, 2006 2:56 pm
by calguy1000
It's easier to do yes, you'd create a bridge module that trapped events from feusers, and then using the feusers api, and some code in NMS (NMS Isn't as well organized), create users in NMS.
I did a similar thing in the NewsToCalendar module.
Re: Newsletter
Posted: Thu Mar 15, 2007 2:34 pm
by benn
I am having a problem with exporting users to CSV using the module FrontEndUsers.
When I Export Users to CSV the file i get reads:
Code: Select all
Table 'news24.cms_module_feusers_groups' doesn't exist
end
Why is it looking for the table prefix cms_ when my table prefix is fn24_
Am I supposed to leave the default prefix cms_ when I first install cmsms or is there something wrong with FrontEndUsers?
Please help
Re: Newsletter
Posted: Fri Mar 23, 2007 2:33 am
by cfarrell
benn wrote:
I am having a problem with exporting users to CSV using the module FrontEndUsers.
When I Export Users to CSV the file i get reads:
Code: Select all
Table 'news24.cms_module_feusers_groups' doesn't exist
end
Why is it looking for the table prefix cms_ when my table prefix is fn24_
Am I supposed to leave the default prefix cms_ when I first install cmsms or is there something wrong with FrontEndUsers?
Please help
There's something wrong with FrontEndUsers

We hardcoded our table prefix into the code and replaced the module.
Re: Newsletter
Posted: Fri Mar 23, 2007 10:42 am
by benn
Thanks cfarrell
I will wait for the next FrontEndUsers release.
Re: Newsletter
Posted: Fri Mar 23, 2007 12:37 pm
by skypanther
I've been working on an update to NMS to get it to work with Front End Users. I've added an import from FEU option on the Users tab. It checks to see if the FEU email address exists in the NMS table before importing the record. Then, it checks to see if the email address is already subscribed to the target list before subscribing the address.
It needs more testing. I don't think the new NMS code is ready for a full beta yet (I'm working on further feature enhancements and bug fixes which aren't done yet). So, you'll have to be brave and run the SVN version. Check it out on the project page in the forge.
http://dev.cmsmadesimple.org/projects/newsletter/
Tim