Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Sharepoint Forums
Product Forums
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...

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.

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

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!

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.

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.

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.

XMod 5.1

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.

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   |   Wednesday, November 19, 2008   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Opt In Email
Subject: Automatic email to Admin?
Prev Next
You are not authorized to post a reply.

Author Messages
Niclas
Posts:11
wading in the water
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:2167
river guide
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
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:2167
river guide
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
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:2167
river guide
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.
Forums > Product Discussion - DotNetNuke Modules > Opt In Email > Automatic email to Admin?


ActiveForums 3.7

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