Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Product Forums
Dynamic Forms Demonstrations
Sharepoint Forums
Newsletter
Page Tags
DNN Modules
SnowCovered Top Sellers

'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

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

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

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.

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.

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!Available for DNN4 and DNN5

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

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

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

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.

    |   Register   |   woensdag 7 januari 2009   
Data Springs Product Forums...
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  
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:2384
river guide
river guide

08-21-2007 3:20  

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

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:2384
river guide
river guide

01-26-2008 12:54  
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  

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:2384
river guide
river guide

01-26-2008 7:15  
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:25
going with the flow
going with the flow

07-17-2008 8:51  

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.



ActiveForums 3.7

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