Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Live Content v1.6 :: Web 2.0

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Dynamic Forms 2.7

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Data Springs Collection 2.0 (20+ Modules)

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Catalyst By DrNuke

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Thursday, December 04, 2008   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Opt In Email
Subject: Import users from DNN role
Prev Next
You are not authorized to post a reply.

Author Messages
Willem
Posts:3
08/20/2007 2:46 AM  
Hello,
 
I noticed there is a way to import dnn role user into a mailing list.
When I perform the import it says 202 users imported, but when I look in the DB or Manage Lists/Users only the first user is imported.

I have a clean install of DNN 455. Can you tell me what I do wrong.

Thanks in advance,

Willem Bonekamp
www.dotnetnuke.nl

 
Chad
Posts:2271
river guide
river guide
08/21/2007 3:20 PM  

Hi, very odd. So far I cannot duplicate this. The quick test I did:

* Installed a fresh installation of DNN 4.5.5
* Added three test users under the 'Registered' role
* Create an opt in email list/category called test

After executing the import for registered users it told me that 4 records were imported, I checked and see them (my three test users and the registered user).

A few quick questions, mostly just to help determine what might be different from our installations. Are you using object qualifiers? Are these users Approved? Do they have emails?

I checked the code as well, the fact that its coming up with the right number (202) really looks like it should be adding them. The basically loops through the role and the counter only increments if it comes back successfully that it saved.

Final check, can you go to Host, SQL and execute this query:

Select * from DataSprings_OptInEmail

I am interested in determiningif the opt in emails are getting saved but just not tied to the category right. I think the way it works is after the initial import it will skip the user, this is useful in case a user has opted out and therefore you want that user skipped. Maybe in your case you imported them to a test category, then deleted that test category? Now when they are imported they are skipped? IF so you can delete all current users in that table:

DELETE from DataSprings_OptInEmail

Just thinking out loud here

-Chad
Willem
Posts:3
08/23/2007 2:33 AM  
Chad,
 
I found the problem, For testing purposes I always set the users e-mailadres to my own so they don’t accidently get an test mail.
When you import the users they get validated on a unique e-mailadres. So only one user gets imported.
 
Willem Bonekamp
www.dotnetnuke.nl
Brian
Posts:13
wading in the water
wading in the water
01/25/2008 5:07 AM  

Chad,

I have around 96 users in my portal, but when I run the import facility, only 66 records are being created in the dnn_DataSprings_OptInEmail and dnn_DataSprings_OptInEmailCategory tables.  All of the users are approved (at least according to the aspnet_Membership table entries).  What other criteria is being used to determine whether or not a user can be imported into the Opt In tables?  Is there a stored procedure I can review?

Thanks!
Chad
Posts:2271
river guide
river guide
01/26/2008 12:54 PM  
Brian,

Do all of these users have a unique email address?

-Chad
Brian
Posts:13
wading in the water
wading in the water
01/26/2008 1:05 PM  

Chad,

Yes, the users do have unique email addresses.  I have found a work around in which I simply populate the OptIn tables from a joining of the dnn_Users and aspnet_Membership tables (on email).  I think this will do the trick, unless there is some other criteria that you guys is feel is appropriate to take into account when importing emails into the OptIn tables.

Thanks!

Brian
Chad
Posts:2271
river guide
river guide
01/26/2008 7:15 PM  
No, this should to the trick. Just make sure to then insert rows into the opt in user/opt in list table. Not sure what the issue would be, I will do some testing. If you have a chance please post the script you are using as it might be helpful to other users down the road.

Thanks,

Chad
Daniel
Posts:24
going with the flow
going with the flow
07/17/2008 8:51 PM  

Hi there,

Is there a way to automate this process so Registered users are added to the recipient list in Opt in on the fly?

Thanks,

Dan
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Opt In Email > Import users from DNN role


ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement