SharePoint Access Using Office 2010

[jmoconnell]

I am using a fresh install of alfresco 3.3. I have been able to connect Office 2003 or 2007 using the sharepoint protocol without any problem. However, when I use Office 2010 I am unable to access the same document libraries. I can connect to the libraries from the OS but when I try to open the file from the OS, not inside the Office product, the office application launches but the file does not display and I do not get an error message. I have tried modifying various Office security settings but still the same experience. Inside the Office application, if I try to open a file from the connection installed in the OS I get the same experience it seems like it is downloading and ready to open but does not.

I have searched this problem but have not found a solution. Any pointers would be appreciated.

[mikeh]

I guess Microsoft broke the Sharepoint protocol by adding some proprietary Office 2010 bits. Welcome to the world of Closed Source!

Please raise in JIRA; although it depends on the scope of their changes as to whether we can patch it or not.

Thanks,
Mike

[lannex]

Hi Mike,

I am  having the same problem. I searched in all forums but I haven't found anything.

Have you solve your problem?

With Regards,

[mikeh]

Development work is currently underway to support Office 2010.

Thanks,
Mike

[mthomas]

I was hoping that the latest 3.4b release would fix this.  But I still get a blank when I click "edit online" in Alfresco and Word2010 opens.
Does anyone know if this is supposed to be fixed or if I need to look at my configuration?
Word2003 and Word2007 open the files correctly for online edit.
Additionally, I am unable to connect to Sharepoint2010 using the launchbar.

[mthomas]

With ldap passthu authentication I got this working.  Edit Online launches Word or Excel and opens the file.  Office 2010 doesn't throw up a log in dialog box like 2003 or 2007.  For 2010 if the user is not authenticated then the file simply doesn't open and no error message is given.  Synchronizing with our Active Directory solved this.
I still don't know what the extra SharePoint Launchbar application is in Office 2010.  I try to connect to the afresco server at http://myservername:7070/alfresco but I can't.  Should I be able to connect to Sharepoint workspaces? Or create new ones in Office?
Thanks.

[ivan_plestina]

Is this fixed in 3.4.c? We are still getting the blank Word 2010 on Win 7 when doing Edit Online (basic auth) from share. BasicAuthLevel=2 added to registry. When opening http://server:7070/alfresco from Word nothing happens. We are never asked for login.

[mthomas]

I copied the below code from another post months ago.  After I completed authentication passthru Office 2010 could recognize our users editing rights and allow editing of word, excel and powerpoint files.

Edit file \Alfresco\tomcat\shared\classes\alfresco-global.properties and modify:

# Active Directory Sync
authentication.chain=passthru1:passthru,ldap-ad1:ldap-ad,alfrescoNtlm1:alfrescoNtlm
ntlm.authentication.sso.enabled=true


Then, create the file \Alfresco\tomcat\shared\classes\alfresco\extension\subsystems\Authentication\passthru\passthru1\changes.properties and put the following inside:

    passthru.authentication.useLocalServer=false
    passthru.authentication.domain=
    # (domain specific property): NetBIOS name of your domain and
    # domain controller’s IP address, add more separated by commas
    passthru.authentication.servers=Domain\\10.10.85.3,10.10.85.1
    ntlm.authentication.sso.enabled=true
    alfresco.authentication.allowGuestLogin=false
    ntlm.authentication.mapUnknownUserToGuest=false
    passthru.authentication.authenticateCIFS=true
    passthru.authentication.authenticateFTP=false
    passthru.authentication.guestAccess=false
    # (domain specific property): list of usernames from AD
    # that are to be Alfresco administrators
    passthru.authentication.defaultAdministratorUserNames=admin.user

Next, edit \Alfresco\tomcat\webapps\share.war\WEB-INF\web.xml:

I WAS TOLD THE BELOW WASN'T NEEDED IN 3.4
    <filter>
    <filter-name>Authentication Filter</filter-name>
    <filter-class>org.alfresco.web.site.servlet.NTLMAuthenticationFilter</filter-class>
    <init-param>
    <param-name>endpoint</param-name>
    <param-value>alfresco</param-value>
    </init-param>
    </filter> 

    <filter-mapping>
    <filter-name>Authentication Filter</filter-name>
    <url-pattern>/page/*</url-pattern>
    </filter-mapping>

    <filter-mapping>
    <filter-name>Authentication Filter</filter-name>
    <url-pattern>/p/*</url-pattern>
    </filter-mapping>

THIS IS THE ONLY ONE to add IN 3.4b

    <filter-mapping>
    <filter-name>Authentication Filter</filter-name>
    <url-pattern>/s/*</url-pattern>
    </filter-mapping> 

Copy and rename the file \Alfresco\tomcat\shared\classes\alfresco\web-extension\share-config-custom.xml.sample to \tomcat\shared\classes\alfresco\web-extension\share-config-custom.xml then edit it and make sure the following section is uncommented:

I ADDED IT because it wasn't there.

    <!–
    NTLM authentication config for Share
    NOTE: you will also need to enable the NTLM authentication filter in Share web.xml
    change localhost:8080 below to appropriate alfresco server location if required
    –>
    <config evaluator="string-compare" condition="Remote">
    <remote>
    <keystore>
             <path>alfresco/web-extension/alfresco-system.p12</path>
             <type>pkcs12</type>
             <password>alfresco-system</password>
         </keystore>
    <connector>
    <id>alfrescoCookie</id>
    <name>Alfresco Connector</name>
    <description>Connects to an Alfresco instance using cookie-based authentication</description>
    <class>org.springframework.extensions.webscripts.connector.AlfrescoConnector</class>
    </connector>

    <endpoint>
    <id>alfresco</id>
    <name>Alfresco – user access</name>
    <description>Access to Alfresco Repository WebScripts that require user authentication</description>
    <connector-id>alfrescoCookie</connector-id>
    <endpoint-url>http://localhost:8080/alfresco/wcs</endpoint-url>
    <identity>user</identity>
    <external-auth>true</external-auth>
    </endpoint>
    </remote>
    </config> 

If Share is not on the same server as Alfresco then edit the endpoint-url to match your configuration.

Single Sign On via Active Directory should be fully functional now for Alfresco Explorer and Alfresco Share.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[jzaruba]

UPDATE: Finally, I managed to make it work. The Authentication Filter is not needed, in fact its class can not be found anyways. Again one needs to make sure the client (Windows/PC) sends NTLM, not NTLM2.

–
Still no luck with 3.4c.

Could someone make this clear please?
The above at one place says NTLM Authentication Filter might be unnecessary, later it contains note that contradicts that. Also the class-name org.alfresco.web.site.servlet.NTLMAuthenticationFilter is probably obsolete as the class can not be found (At least that's what my log says, Share itself says 404.)

I understand that this is caused by changes made in Office 2010 but this is one of The Key Features in enterprise environment yet it we have to tune several config files to make it work.

[mthomas]

Sorry for the unclean cut and paste.  The "NOTE:" that contradicts the other statments is from the original author, it is from a Blog that I don't remember the link to at the moment.  The uncommented caps statements are my own notes that I took as I was working on this so that I could recreate the settings.
In addition to the above I also altered the authentication.chain to be "alfrescoNtlm1:alfrescoNtlm,passthru1assthru,ldap-ad1:ldap-ad"  in alfresco-global.properties to enable outside users to log on.
I'm using 3.4b Community.
-mthomas