Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sean 141 posts 179 karma points
    May 04, 2012 @ 23:08
    Sean
    0

    Driver not installed

    Hi There,

    I'm getting an error when I try to use my CMS import on a production server. The error relates to a driver not being installed but the problem for me is I can run exe's on that server. I was hoping to find out if I can copy a .dll into the bin folder on the server to run it. If I can use this approach, which .dll files do I need for this?

     

    Driver not installed, please download and install the following driver from Microsoft to handle all versions of Microsoft Excel

    http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=7554f536-8c28-4598-9b72-ef94e038c891&displayLang=en

  • Richard Soeteman 3920 posts 12267 karma points MVP
    May 07, 2012 @ 05:55
    Richard Soeteman
    0

    Hi,

    The driver is updating registry as well. So you need to install on the server. The next version of CMSImport is using a different component for Excel that doesn't require installation on the server. You can already use it when you download the latest dll's from 

    http://hotfix.soetemansoftware.nl/CMSImport/

    Copy the dll's to your bin folder then all should work.

    Best,

    Richard

  • Sean 141 posts 179 karma points
    May 08, 2012 @ 11:20
    Sean
    0

    Hi Richard,

    I downloaded the hotfix and copied the .dlls into the bin folder and now I get the following error. Any ideas?

     

    Server Error in '/' Application.

    Object reference not set to an instance of an object.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

     

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

     

    Source Error:

     

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

     

    Stack Trace:

     

    [NullReferenceException: Object reference not set to an instance of an object.]

       CMSImport.Controls.ImportSteps.ContentImport.SelectUmbracoTypeAndLocation.SetTextValues() +531

       CMSImportLibrary.BaseTypes.ImportStepBase.OnLoad(EventArgs e) +22

       System.Web.UI.Control.LoadRecursive() +74

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

     

  • Richard Soeteman 3920 posts 12267 karma points MVP
    May 08, 2012 @ 11:23
    Richard Soeteman
    0

    Hi Sean,

    Think there is still some info in cache. Can you reset the site?

    Thanks,

    Richard

  • Sean 141 posts 179 karma points
    May 08, 2012 @ 11:35
    Sean
    0

    Hi Richard,

    I restarted the app pool and I'm still getting the error. Anything else I can try?

    Sean

     

     

  • Richard Soeteman 3920 posts 12267 karma points MVP
    May 08, 2012 @ 11:39
    Richard Soeteman
    0

    What version of Umbraco are you using?

     

  • Sean 141 posts 179 karma points
    May 08, 2012 @ 11:43
    Sean
    0

    HI Richard, I'm using 

    umbraco v 4.7.0 (Assembly version: 1.0.4090.38017)

  • Sean 141 posts 179 karma points
    May 08, 2012 @ 12:34
    Sean
    0

    Hi Richard, Is the version of umbraco I'm using compatable?

    Sean

  • Richard Soeteman 3920 posts 12267 karma points MVP
    May 08, 2012 @ 12:44
    Richard Soeteman
    0

    Hi Sean,

    Yes is comatible I assume you used the latest CMSImport before installing the hotfix as well?

    Thanks,

    Richard

  • Sean 141 posts 179 karma points
    May 08, 2012 @ 13:00
    Sean
    0

    HI Richard,

    I did not upgrade the CMS import install. Is the upgrade available from here? Do I just import the whole package and write over what is there already?

    Sean 

  • Richard Soeteman 3920 posts 12267 karma points MVP
    May 08, 2012 @ 13:05
    Richard Soeteman
    0

    HI Sean,

    Sorry thought you were already using the latest version. Yes install the latest version then replace the dll's

    Thanks,

    Richard

  • Sean 141 posts 179 karma points
    May 11, 2012 @ 10:13
    Sean
    0

    Hi Richard,

    Thanks for your help on this.

    I installed the latest version and applied the hotfix and it works fine.

    I used Excel files with the extension .xlsx

    Sean

  • Richard Soeteman 3920 posts 12267 karma points MVP
    May 11, 2012 @ 10:17
    Richard Soeteman
    0

    Great to hear Sean can you mark the topic as solved please?

    Thanks,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft