Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DR and OWS Integration for Private Registration
Last Post 01-08-2013 10:09 AM by Ryan Bakerink. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Resolved
Mark EmmersonUser is Offline
skipping stones
skipping stones
Posts:7
Avatar

--
12-20-2012 07:23 AM
    The requirements are:
    • Private registration with manual authorization
    • Authorization based upon user multiple item selection via an Open Web Studio (OWS) using ows.Fetch call (User GUI is better in OWS than can be constructed in DR)
    • User has a specific role assigned upon registration

    I currently have an initial DR registration page with forwarding to the OWS page upon user submission

    Question: how can I set-up the registration so that:

    • The user completes the DR registration
    • The user is not authorized but may be assigned a specific role
    • The UserID is transferred to the OWS module (session or Querystring) so that the multiple items can be saved as keyed by the UserID integer?

    Using latest DR and DNN 6.2. Thanks bunches and a Merry Christmas to All.


    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    12-21-2012 05:11 AM
    Hello Mark,

    Step 1: Making new users unauthorized

    Dynamic Registration has Form Completion Events. I would recommend using a SQL Form Completion Event to set the User Account that was just created to Unauthorized. You can achieve this type of lookup and UPDATE by reivew the UserPortals SQL Table and using the $(UserID) token.

    Step 2 A: Pass the UserID

    If you've setup redirection rules in Dynamic Registration to redirect the User to your OWS grid, then you need to consider the following:

    * In Dynamic Registration, once creating an account, a UserID is assigned to that account and you're redirected to the OWS page. Dynamic Registration automatically signs the user in upon Successful registration.

    * By the time the User is redirected to the OWS page, he should be assigned a UserID and should be logged in. Therefore, you can use the [UserId,System] OWS Token to render the UserID of the User viewing this Grid.

    Step 2 B: Pass the UserID

    If the User is never actually being redirected to the OWS page after successful account registration, then you'll need to add a Hidden field to your Registration form that has a SQL Default Value of:

    Select '$(UserID)' As DefaultValue


    This hidden field will also need to pass value via one or more of the following ways:
    * Querystring
    * Session
    * Cookie

    You can indicate this by Managing this new hidden field and looking under Advanced Field Options. In this location, you'll be able to configure how you wish to pass this field's value.

    Please let me know if you have any questions.

    Thanks,

    Ryan

    Mark EmmersonUser is Offline
    skipping stones
    skipping stones
    Posts:7
    Avatar

    --
    12-21-2012 08:44 AM

    Hi Ryan…thank you for responding so promptly.  I’ve been struggling with this process for a few days now.  I could write the whole mechanism using OWS, but I wanted to cut a few corners by using your DR module.

     

    In Step 2A, I was unaware that the user is automatically logged in for a Private Registration, even if the user is returned to Unauthorized in your Step 1.  My requirement is that the user is not signed in (is unauthorized) but is able to navigate to the OWS page for further item entry.

    You infer that the DR $(UserID) token is the same value as the UserID value given by DNN.  If this is the case, then passing the variable via the querystring would work for the redirection to OWS.

    Step 2B would not be an option in that the DR registration page is for unathenticated users only for initial registration.

    Again many thanks.

    Mark EmmersonUser is Offline
    skipping stones
    skipping stones
    Posts:7
    Avatar

    --
    12-21-2012 09:51 AM

    Further thoughts on the sequencing:

    *  For a user that has not submitted or has not had a successful initial registration, there is no value for $(UserID) and none can be assigned while the form is being completed
    *  Upon submitting the initial registration form, user is assigned a UserID (token $(UserID)) obtained from successful registration from DNN which can be used in DR completion events
    *  For Private Registration, the Authorised bit in DNN UserPortals is 0, the user is not logged in (for Public Registration yes but not for Private)

    In this scenario, is there a way that the $(UserID) can be passed via a DR completion event to the OWS page?  Or would I have to set-up some kind of user unique identifier, save it to a core value field, then search in OWS for the DNN UserID from the unique identifier?  If directed to OWS without a $(UserID) in the querystring and the user is not logged in nor authorized, then OWS has no way of determining the [UserID,System] value.

    Your suggestions are very much appreciated.

    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    12-27-2012 08:19 AM
    Hello Mark,

    What if you had a Hidden field on your Dynamic Registration form with a SQL Default Value of:

    Select '$(UserID)' As DefaultValue

    You would also need to enable the Pass value to Cookie Variable within this Hidden Field. 

    That way after successful registration with Dynamic Registration, a cookie named UserID will have been created and stored on the User's computer, with the stored value of the UserID that was generated for that user after successfully creating an account.

    Then within OWS you should be able to use the following token to extract that User's ID from Dynamic Registration:

    [UserId,Cookie]


    Unfortunately you won't be able to use a Dynamic Registration SQL Form Completion Event to pass the value. I feel that passing the Cookie value may be the best method to handle this.

    Please let me know if you have any questions.

    Thanks,

    Ryan
    Mark EmmersonUser is Offline
    skipping stones
    skipping stones
    Posts:7
    Avatar

    --
    01-07-2013 09:18 AM
    • Accepted Answer
    Thank you Ryan..the approach you suggested works well having the hidden UserID field and passing this variable via a query string to the second registration OWS page as redirected from a DR completion event.

    I'm experimenting passing a session variable or cookie rather than via the query string and risk SQL injection.  The second page is a public-facing registration page and the user is not authorized any access pending vetting to this private site.

    Again, many thanks and you can mark this a 'solved'.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    01-08-2013 10:09 AM
    Great to hear Mark. Glad that I could be of assistance.

    If you ever have any questions please let us know.

    -Ryan
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi