Newsletter

[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!

[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.

[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...

[pgoneill]

No ideas, anyone?  Could it be the Windows server it's running on?

[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).

[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.

[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

[cfarrell]

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.

[benn]

Thanks cfarrell

I will wait for the next FrontEndUsers release.

[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