Hi -

I'm having trouble importing email addresses.  Yesterday, I successfully imported more than 3700 email addresses from a CSV file.  I then sent the email out.

Today, I'm trying to import more email addresses, and the system is not responding.  I even tried to upload the emails I uploaded yesterday (to a test list) and it didn't work.   Since I was able to do it yesterday with the same list, I guess my list is ok. 

No error message is given from the Import List wizard, but the DNN event viewer gives me the following error:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Unspecified error ---> System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.getImportedData(String filename, String strFileDir, Boolean HasColumnHeader) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.ImportList(EventArgs e) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.lnkImport_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Any help is appreciated.

Cathy at CoolCoyotes

 

HI Allen, can you restart the DNN application under HOST / Host Settings and see if this will clear the error? Thanks. -- David

Hello -

I'm experiencing a similar problem, except this is the first time I'm trying to import an email list. I did restart the application without success.

I get the following messages:

AssemblyVersion: 5.1.4
PortalID: 6
PortalName: ChessBaseUsa
UserID: 1
UserName: _host
ActiveTabID: 435
ActiveTabName: Newsletter Signup
RawURL: /Home/NewsletterSignup/tabid/435/ctl/ControlPanel/mid/1495/Initial/ListImportDiv/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://chessbaseusanew.coolcoyotes....fault.aspx" target="_blank" rel="nofollow">http://chessbaseusanew.coolcoyotes....fault.aspx
UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 2f70292f-cb24-43db-919a-43813d371503
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Dataspring.DNN.Modules.OptInEmail.__OptInListImport.ImportList
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.ImportList(EventArgs e) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.lnkImport_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: COOLCOYOTES

followed by this one:

ModuleId: -1
ModuleDefId: -1
FriendlyName:
ModuleControlSource:
AssemblyVersion: 5.1.4
PortalID: 6
PortalName: ChessBaseUsa
UserID: 1
UserName: _host
ActiveTabID: 435
ActiveTabName: Newsletter Signup
RawURL: /Home/NewsletterSignup/tabid/435/ctl/ControlPanel/mid/1495/Initial/ListImportDiv/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://chessbaseusanew.coolcoyotes....fault.aspx" target="_blank" rel="nofollow">http://chessbaseusanew.coolcoyotes....fault.aspx
UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 5f560351-3989-44ab-8a19-d377ee197d91
InnerException: Unspecified error
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.OleDb.OleDbConnectionInternal..ctor
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Unspecified error ---> System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.getImportedData(String filename, String strFileDir, Boolean HasColumnHeader) --- End of inner exception stack trace ---
Source:
Server Name: COOLCOYOTES

Any suggestions would be appreciated.

Gail at CoolCoyotes

Hi guys... I just wanted to follow up on this thread. I know I sent you the latest patch and this fixed you up. We are now using a 3rd party custom Excel component that is allowing some of our modules that don't work with the Microsoft Excel DLL on the server. If anyone is running into this issue please make sure you are running on 4.3.7 or higher.


Thanks!

-Chad