Copied to clipboard

Flag this post as spam?

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


  • andy_rose 91 posts 117 karma points
    Sep 07, 2011 @ 11:58
    andy_rose
    0

    Excel import failing

    We now have a pro license and i attempted to import from an Excel spreadsheet and got the message that an additional Microsoft Office driver is required from this page http://www.microsoft.com/download/en/confirmation.aspx?displayLang=en&id=23734. This has now been installed on the server hosting the Umbraco website however I am still getting the same error message. Anybody got any ideas on how to fix this?

  • Richard Soeteman 3709 posts 11482 karma points MVP
    Sep 07, 2011 @ 12:48
    Richard Soeteman
    0

    Hi Andy,

    First of all thanks for the purchase. I think this can easily be fixed by restarting your application pool running the website.

    Cheers,

    Richard 

  • andy_rose 91 posts 117 karma points
    Sep 07, 2011 @ 13:22
    andy_rose
    0

    Hi Richard, I have recycled the application pool but I am still getting the same message when selecting and Excel file that I need to download and install a driver from Microsoft. Any other ideas? I've tried on my workstation and it works, the difference being it is running on a 32 bit OS whereas the development and UAT sites are running on a 64 bit server. Not sure if this would cause a problem?

  • andy_rose 91 posts 117 karma points
    Sep 07, 2011 @ 13:35
    andy_rose
    0

    Managed to solve it by checking the Umbraco logs for the error message which led me to this Stackoverflow Q/A http://stackoverflow.com/questions/238625/microsoft-ace-oledb-12-0-provider-is-not-registered.

    IIS 7 will not by default serve 32-bit apps, which is what the database engine operates on so you need to go into the app pools advanced settings and change the Enable 32-bit Applications property to true and then recycle the app pool.

  • Richard Soeteman 3709 posts 11482 karma points MVP
    Sep 07, 2011 @ 13:38
    Richard Soeteman
    0

    Hi Andy,

    Great that this issue is solver. I can confirm that you need 32 bits enabled.

    Cheers,

    Richard

  • andy_rose 91 posts 117 karma points
    Sep 07, 2011 @ 13:46
    andy_rose
    0

    Yes, it does seem you need this app pool property enabled for this to work with IIS 7 on a 64 bit server.

  • Fredrik Hansson 16 posts 36 karma points
    Apr 03, 2012 @ 14:47
    Fredrik Hansson
    0

    I have the same problem, but am running on IIS 6, 32 bit. IƤve restarted the application pool but still the same message. I've restarted my computer, tested in different browsers etc. Still the same message....

  • Richard Soeteman 3709 posts 11482 karma points MVP
    Apr 03, 2012 @ 14:51
    Richard Soeteman
    0

    Hi Frederik,

    The latest binaries are using a different Excel provider to avoid this issue and include several other fixes. You find the binaries on http://hotfix.soetemansoftware.nl/CMSImport/  Replace them with the ones in your bin folder and you should be fine.

    Thanks,

    Richard

  • Fredrik Hansson 16 posts 36 karma points
    Apr 03, 2012 @ 14:56
    Fredrik Hansson
    0

    Thanks, you kick ass :)

  • andy_rose 91 posts 117 karma points
    Apr 04, 2012 @ 09:36
    andy_rose
    0

    Richard, do the latest binaries allow CMSImport to work with Excel spreadsheet with 32 bit mode enabled in the app pool?

  • Richard Soeteman 3709 posts 11482 karma points MVP
    Apr 04, 2012 @ 09:48
    Richard Soeteman
    0

    No either 64 bits or 32 it's up to you, using a third party component now. Hope to release it very soon in an official release.

     

Please Sign in or register to post replies

Write your reply to:

Draft