|
|
|
|
|
|
|
To help you navigate to pages you most recently visited, select from the links below.
|
|
|
Product Forums
|
|
Sharepoint Forums
|
|
Page Tags
|
|
Newsletter
|
|
Dynamic Forms Demonstrations
|
|
|
|
|
|
|
|
| Login | Register | Thursday, January 08, 2009
|
|
|
| Data Springs Product Forums...
|
|
|
|
|
| Author |
Messages |
|
Niclas
Posts:11
wading in the water
 |
| 06/30/2007 9:25 PM |
|
Dear Datasprings, thanks for a great product, it is almost perfect, aside from three issues and I am wondering if you are planning to incorporate any of these in a future release, or maybe they exist today?:
1 - Automatic email to Admin, or other email address: We have very few people signing up to our newsletters and would like to be notified every time someone signs up.
2 - Date Picker: In the extended fields, I would like to be able to insert a date picker. We might have clients that want to sign up to a vacation rental newsletter, and it is great to know when they are planning to visit. I know that there is a date picker in Dynamic Registration, so hopefully it will be fairly easy to incorporate?
3 - Extended fields order: Maybe I am completely off here, but when I add some extended fields, they always show up the way I entered them. I would like to be able to move them up or down (maybe this problem is only for the "simple opt in"
Thanks and appreciate a reply... |
|
|
|
|
Chad
Posts:2385
river guide
|
| 07/03/2007 9:44 AM |
|
Niclas,
Hi. Thanks for your feedback. I think adding an option to notifiy an administrator would be a nice option to add. We will review all of the these for a future enhancements. I did want to add though that if you are using Dynamic Registration or Dynamic Forms you can already integrate these modules together and can have these features you would like. Dynamic Registration includes a full integration option that allows you to have a checkbox on the registration field represent an opt in/out of an opt in email category in the opt in email module. Additionally we recently posted a stored procedure that you can add to your database that allows Dynamic Forms to work in a similar way (just need to setup a Dynamic SQL Event to execute and add the email to the opt in email tables). Both of these modules also include the ability to use Date Picker fields and setup completion events such as firing off an email to administrators etc... Just wanted to let you know while you review these you might have some work-arounds to get the functionality you are looking for.
-Chad
|
|
|
|
|
Niclas
Posts:11
wading in the water
|
| 07/03/2007 9:51 AM |
|
Thanks Chad for your response.
I also own Dynamic Registration for the above us, but I never go the integration to work. It always gave me an error and after a while I gave up. I will try again and post the error message here and hopefully get it all working...
|
|
|
|
|
Chad
Posts:2385
river guide
|
| 07/03/2007 9:58 AM |
|
Check out page 87 of the user guide (currently the 2.4 release of the user guide). There is a SQL script you need to execute in order for the integration to work properly.
http://www.datasprings.com/userguides/DataSprings_DynamicRegistration_UserGuide.pdf
From the guide...
Note: to fully enable integration between Dynamic Registration and Opt In Email modules, you
must execute an SQL query that was included in your Dynamic Registration download called
Dynamic_OptInIntegration.sql. This must be executed after both modules have been installed
(see section 7.9.1).
Tip: If this file is not included in your installation file you can download it here:
http://www.datasprings.com/UserGuides/Dynamic_OptInIntegration.zip
This should work unless your site uses object qualifiers and then we just need to tweak the script a little. |
|
|
|
|
Niclas
Posts:11
wading in the water
|
| 07/03/2007 10:06 AM |
|
Yup, been there, done that..Get the following Error:
----
System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_GetOptInCategoriesByPortal' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* Opt In Email / Dynamic Registration Installation Script */ create procedure dbo.DynamicRegistration_GetOptInCategoriesByPortal @PortalID as integer AS select * from dbo.DataSprings_OptInCategory where PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_GetOptInEmailByEmailAddress' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_GetOptInEmailByEmailAddress @EmailAddress as varchar(255), @PortalID as integer AS select * from DataSprings_OptInEmail where EmailAddress = @EmailAddress And Inactive=0 AND PortalID = @PortalID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_UpdateOptInEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_UpdateOptInEmail @OptInEmailId as uniqueidentifier, @FirstName as varchar(255), @LastName as varchar(255), @EmailAddress as varchar(255), @IsVerified as Integer, @PortalID as integer AS Update DataSprings_OptInEmail Set FirstName = @FirstName, LastNAme = @LastName, EmailAddress = @EmailAddress, IsVerified = @IsVerified, PortalID = @PortalID Where OptInEmailID = @OptInEmailID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_AddOptInEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_AddOptInEmail @FirstName as varchar(255), @LastName as varchar(255), @EmailAddress as varchar(255), @IsVerified as Integer, @PortalID as integer AS Insert Into DataSprings_OptInEmail (FirstName, LastName, EmailAddress, IsVerified, PortalID) Values (@FirstName, @LastName, @EmailAddress, @IsVerified, @PortalID) System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_UpdateOptInCategoryEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_UpdateOptInCategoryEmail @OptInEmailCategoryID as uniqueidentifier, @OptInCategoryID as uniqueidentifier, @OptIn as integer, @OptInEmailID as uniqueidentifier AS Update DataSprings_OptInEmailCategory Set @OptInCategoryID = @OptInCategoryID, OptIn = @OptIn, OptInEmailID = @OptInemailID Where OptInEmailCategoryID = @OptInEmailCategoryID System.Data.SqlClient.SqlException: There is already an object named 'DynamicRegistration_AddOptInCategoryEmail' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_AddOptInCategoryEmail @OptInCategoryID as uniqueidentifier, @OptIn as integer, @OptInEmailID as uniqueidentifier AS Insert Into DataSprings_OptInEmailCategory (OptInCategoryID, OptIn, OptInEmailID) Values(@OptInCategoryID, @OptIn, @OptInEmailID) System.Data.SqlClient.SqlException: Line 15: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.DynamicRegistration_GetOptInCategoryEmail @EmailAddress as varchar(255), @PortalID Integer, @OptInCategoryID uniqueidentifier AS select A.OptInEmailCategoryID, A.OptInEmailID, A.OptInCategoryID, A.OptIn, A.Inactive from DataSprings_OptInEmailCategory A Inner Join DataSprings_OptInEmail B on A.OptInEmailID = B.OptInEmailID Where EmailAddress = @EmailAddress AND PortalID = @PortalID AND OptInCategoryID = @OptInCategoryID GO
My set up is:
DNN: 03.03.07
.Net: 1.1.4322.2300
Dynamic Registration: 2.40.20
Opt in: 2.60.10 |
|
|
|
|
Chad
Posts:2385
river guide
|
| 07/03/2007 4:48 PM |
|
Hi. Well yes that message there means that you already did run it once. Do you know if your site uses object qualifiers (in other words are your tables named something like dnn_portals instead of just portals?). Either way, open a support ticket and ill make sure you get setup correctly.
-Chad
|
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|
|
|
|
|
|
|
|
|
|