I see in the RegistrationEvents there is a role field.

 

I'm trying to figure out how its inserted because I have multiple portals with the same roles but different role IDs (role belongs to a portal - not all portals) 

 

My form is shared across multiple portals but the only problem I have is assigning the roles - the RegistrationEvents table is designed to have 1 roleID per record

 

so my (best guess) choices are:

 

-replicate the one record for all portals in this table

 

- buy a module that allows roles to be shared among portals - though sucess depends on exactly how this sharing is accomplished

 

This one timy problem of not being able to assign roles is holding me back - it would be a shame not to overcome it

Hmm, the roles available within the registration form are based on the roles for that portal (not roles for all portals). In this case you would need to actually use the event called 'SQL Event' and do some insert/update statements. There are multiple ways of doing this and it provides the most flexibility but it can also be difficult to implement if you don't know SQL. With a SQL event you could pass all of the values of the field to a stored procedure which would insert or update the roles table as necessary. You wouldn't have to create a stored procedure but it would be easier for testing.

For general testing you could create a SQL event to only fire on initial registration but also fire no matter what (not question/answer specific for firing the event). From there you would do the inserting.

i.e.
Insert Into UserRoles(RoleID, UserID) Values(1, $(UserID))

This would insert the current userID and the roleID number 1 to the userroles table. You could just have one SQL events to do all of your inserting/updating etc...  Example:

 

Insert Into UserRoles(RoleID, UserID) Values(1, $(UserID))

Insert Into UserRoles(RoleID, UserID) Values(2, $(UserID))

Insert Into UserRoles(RoleID, UserID) Values(3, $(UserID))

Hope this helps.

-Chad

Chad,

 

Any possibility of passing the portalID or moduleID of the current portal to the SPROC?

 

I would then be able to make the roleID lookup for the current portal based on the name of the role in the master portal.

 

This seems like a powerful featur, especially is a parameter(s) can be passed to a sproc

 

Thanks Again

 

CF

Question to anyone -

 

Insert Into UserRoles(RoleID, UserID) Values(3, $(UserID))

 

the $(Userid) - is that a DNN thing or Dataprings thing?

 

Is this a way to pass parameters to SQL Via the site?

 

..sometimes it helps to read something twice - lol

The $(UserID) is a Dynamic Registration/ Data Springs thing. This is one of the default parameters that can be used within SQL Events, Email Events, etc...

Although you should be able to use the 'Role' dynamic event I can see from the example above a SQL dynamic event might work out better to setup the role/ser for multiple sites.

Ummm....
"Is this a way to pass parameters to SQL Via the site?" - Well you can use all question fields within the SQL Events area, as far as 'passing parameters' one option you could use would be to create hidden fields on the Dynamic Registration page, then set the field up under Advanced Options so that it would 'fill field from querystring value'. This way you could pass data to the registration form, the user wouldn't see the actual field data, but then you could use the hidden field data (i.e. what was passed from the querystring) within any SQL event. Does this help?

-Chad

Is there a list of the Dynamic parameters I can use somewhere - I know a couple are on the form itself, but seems like there are some undocumented. Is there a parameter for portal ID?

 

I understand what your saying, I would write a sproc that would take the portalID, userID and Role Name, then look up the RoleID based on the Role Name & assign it to the user.

 

This would save me the time of setting up each portal - and streamline my process, but its contingent on the parameters I am asking about

 

Thanks For the help

Well the latest documentation should reflect v2.4 and also include those in the list. I believe there is $(PortalID), $(ModuleID), $(UserID), $(RegType) and then of course all of the short names.

The only one thats not documented is upcoming and it is:
$(CurrentLanguage) - Used for SQL Options only for content localization. This can be used to pull in values for only a particular language for example into the dropdownlist.

A few others:
$(DateTime)
$(AutoCreateUserName) - Only if you have enabled the auto create user feature
$(AutoCreatePassword) - Only if you have enabled the auto create user feature

$(VerificationCode) - Used to send verification code to users for verified registration
$(VerificationCodeLink) - Used to send verificaiton code link to users to verify their registration

$(PortalURL) - Replaces with a link to the current portal

$(PortalName)

Also: AttachFiles within an email message will attach all of the files if they are uploaded within the registration form. Otherwise you can just provide a link to the file.

-Chad