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

Dynamic Registration 4.0

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 4

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.

XMod Pro 2.7 - Forms and Views for Databases

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,

Smith Shopping Cart v3.88

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.

Event Calendar and Registration 4.0

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

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Opt In Email
Can't import CSV
Last Post 10-14-2011 12:44 AM by Francisco Pérez Andrés. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Francisco Pérez AndrésUser is Offline
going with the flow
going with the flow
Posts:53

--
01-27-2010 12:50 AM

    Hi,

    DNN 5.1.4 + OptIn 4.20.30

    I can't import any CSV file in my production server. It says nothing but doesn't import the records (after having uploaded the file) and issues a couple of error in log viewer:

      1/27/2010 11:33:31 AM   Page Load Exception   hostzbb     AssemblyVersion: 5.1.4; PortalID: 0; PortalName< ...
    AssemblyVersion: 5.1.4
    PortalID: 0
    PortalName: ZeBlueBox
    UserID: 1
    UserName: hostzbb
    ActiveTabID: 147
    ActiveTabName: Subscribers
    RawURL: /Corporate/Subscribers/tabid/147/ctl/ControlPanel/mid/522/Initial/ManageListsDiv/Default.aspx
    AbsoluteURL: /Default.aspx
    AbsoluteURLReferrer: http://www.zebluebox.fr/Corporate/S...fault.aspx" target="_blank" rel="nofollow">http://www.zebluebox.fr/Corporate/S...fault.aspx
    UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; es-ES; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: 6c5138c6-8fe5-4c63-92c5-04d61252a86a
    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.imgImport_Click(Object sender, ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.ImageButton.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: W31102
      1/27/2010 11:33:31 AM   Module Load Exception   hostzbb     ModuleId: -1; ModuleDefId: -1; FriendlyName: ...
    ModuleId: -1
    ModuleDefId: -1
    FriendlyName:
    ModuleControlSource:
    AssemblyVersion: 5.1.4
    PortalID: 0
    PortalName: ZeBlueBox
    UserID: 1
    UserName: hostzbb
    ActiveTabID: 147
    ActiveTabName: Subscribers
    RawURL: /Corporate/Subscribers/tabid/147/ctl/ControlPanel/mid/522/Initial/ManageListsDiv/Default.aspx
    AbsoluteURL: /Default.aspx
    AbsoluteURLReferrer: http://www.zebluebox.fr/Corporate/S...fault.aspx" target="_blank" rel="nofollow">http://www.zebluebox.fr/Corporate/S...fault.aspx
    UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; es-ES; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: 239a25a2-780b-4199-9ad2-4a0e9db5a85c
    InnerException: Error no especificado
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Data.OleDb.OleDbConnectionInternal..ctor
    StackTrace:
    Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Error no especificado ---> System.Data.OleDb.OleDbException: Error no especificado 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: W31102

    If I try on www.betasprings.com I get a warning as if the CSV file was wrongly formatted: 0 record(s) imported successfully, however there were errors within your import file, please check the following row numbers within the import file: at record(s) 0, 1, 2, .....

    The best part: I can import the same file, with no trouble, in my test server, which is a clone of the production one :-O

    Any help, please? Thanks,
    Francisco
    Expertos DotNetNuke en Madrid - Blog DotNetNuke España
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    02-02-2010 01:44 PM
    I believe this happens if you are running on a 64 bit version. Currently the only import that can work on 64 bit operating systems is SQL Import AND List Import/Copy. The Microsoft.JetEngine DLL isn't on the server or can't work on 64 bit servers and this is the component we utilize for importing CSV files. I have been told from some customers that they could set their app pool to 32 bit and it will work then however I have not directly tested this myself. We are in the process of reviewing 3rd party Excel components that we might be using for future versions that support both 32 bit and 64 bit operating systems because they don't rely on that Microsoft.JetEngine component.

    Thanks,


    -Chad
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    02-02-2010 01:45 PM
    Oh... and another option is to import the file directly into SQL Server and then run a SQL import instead of a CSV import. We have done this on a few implementations in the past before.

    -Chad
    Francisco Pérez AndrésUser is Offline
    going with the flow
    going with the flow
    Posts:53

    --
    02-04-2010 06:07 AM

    OK, thanks for the assistance. Finally, it seems as the issue was caused for some lack of permissions. Our hosting provider was able to fix it.

    Francisco
    Expertos DotNetNuke en Madrid - Blog DotNetNuke España
    Francisco Pérez AndrésUser is Offline
    going with the flow
    going with the flow
    Posts:53

    --
    10-14-2011 12:44 AM
    Posted By Chad Nash on 02-02-2010 03:44 PM
    I believe this happens if you are running on a 64 bit version. Currently the only import that can work on 64 bit operating systems is SQL Import AND List Import/Copy. The Microsoft.JetEngine DLL isn't on the server or can't work on 64 bit servers and this is the component we utilize for importing CSV files. I have been told from some customers that they could set their app pool to 32 bit and it will work then however I have not directly tested this myself. We are in the process of reviewing 3rd party Excel components that we might be using for future versions that support both 32 bit and 64 bit operating systems because they don't rely on that Microsoft.JetEngine component.

    Thanks,


    -Chad

    Hi Chad,

    Is this issue already solved? We're a bit tired of using the SQL Query.

    Thanks,
    Francisco
    Expertos DotNetNuke en Madrid - Blog DotNetNuke España
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Opt In Email
     
     

    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