topic Opening Excel and PPT via WebDAV using add-in in Alfresco Archive

Opening Excel and PPT via WebDAV using add-in

tonytony — Thu, 06 Dec 2007 16:36:31 GMT

I think I have a windows or IE configuration issue.Using XP SP2 and Office 2003 SP2 and a very recent office add-in downloaded via SVN and IE 6.0When I open a document in Word everything works as expected, it opens read-write in word via the webDAV protocal , the file locks, and I can save a changed

Re: Opening Excel and PPT via WebDAV using add-in

mikeh — Thu, 03 Jan 2008 11:15:18 GMT

Hi

This has been fixed for 2.1.2 Enterprise and will also be in the next drop of v2.9 Community.

Improvements have been made to the handling of webdav links in the Office add-in web scripts. You'll find that documents will load ok over webdav from the userhome folder (the first one displayed) but not from other spaces.

Thanks,
Mike

Re: Opening Excel and PPT via WebDAV using add-in

tonytony — Fri, 04 Jan 2008 15:07:23 GMT

Mike:

Thanks. I got a nightly build of 2.9B and this issue is gone. I now have an issue trying to save a new document, but this is an issue for a new thread.

Happy New year and keep up the good work.

Tony

Re: Opening Excel and PPT via WebDAV using add-in

invantix — Mon, 19 May 2008 20:39:11 GMT

Hi

This has been fixed for 2.1.2 Enterprise and will also be in the next drop of v2.9 Community.

Improvements have been made to the handling of webdav links in the Office add-in web scripts. You'll find that documents will load ok over webdav from the userhome folder (the first one displayed) but not from other spaces.

Thanks,
Mike

Do we have to download server code or just the latest plug in?
If the web scripts are on the server side can we just download the scripts. I prefer not to do a full upgrade.
Thanks

Re: Opening Excel and PPT via WebDAV using add-in

mikeh — Tue, 20 May 2008 13:21:06 GMT

Hi

This was just a fix to the Office webscripts.

Thanks,
Mike

Re: Opening Excel and PPT via WebDAV using add-in

invantix — Tue, 20 May 2008 19:03:22 GMT

Hi

This was just a fix to the Office webscripts.

Thanks,
Mike

Do you mean the scripts in (webapps/alfresco/scripts/office)? I tried updating those from nightly builds and still have the problem with excel and pp opening via IE instead on inside the application.

Is there something else I need to update?

Thanks!

Re: Opening Excel and PPT via WebDAV using add-in

mikeh — Tue, 20 May 2008 19:57:38 GMT

No, those would just be the client-side scripts. You (also) need to update the webscripts in:

projects/web-client/config/alfresco/templates/webscripts/org/alfresco/office/‍

Thanks,
Mike

Re: Opening Excel and PPT via WebDAV using add-in

invantix — Wed, 28 May 2008 15:44:12 GMT

No, those would just be the client-side scripts. You (also) need to update the webscripts in:
projects/web-client/config/alfresco/templates/webscripts/org/alfresco/office/‍
Thanks,
Mike

I was hoping I could just update these to directories but there must be another piece. After doing so I get an error when opening the pligin. Any ideas on what is missing? Thanks.

The Web Script /alfresco/wcservice/office/documentDetails has responded with a status of 500 - Internal Error.  

500 Description: An error inside the HTTP server which prevented it from fulfilling the request.  
   
Message: Error during processing of the template 'Expression message("office.title.document_details") is undefined on line 16, column 13 in org/alfresco/office/documentDetails.get.html.ftl.'. Please contact your system administrator.  
   
Exception: freemarker.core.InvalidReferenceException - Expression message("office.title.document_details") is undefined on line 16, column 13 in org/alfresco/office/documentDetails.get.html.ftl.  
    
 freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124)  
 freemarker.core.Expression.getStringValue(Expression.java:118)  
 freemarker.core.Expression.getStringValue(Expression.java:93)  
 freemarker.core.DollarVariable.accept(DollarVariable.java:76)  
 freemarker.core.Environment.visit(Environment.java:196)  
 freemarker.core.MixedContent.accept(MixedContent.java:92)  
 freemarker.core.Environment.visit(Environment.java:196)  
 freemarker.core.Environment.process(Environment.java:176)  
 freemarker.template.Template.process(Template.java:232)  
 org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:200)  
 org.alfresco.web.scripts.AbstractWebScript.renderTemplate(AbstractWebScript.java:329)  
 org.alfresco.web.scripts.DeclarativeWebScript.renderFormatTemplate(DeclarativeWebScript.java:232)  
 org.alfresco.web.scripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:158)  
 org.alfresco.web.scripts.WebScriptRuntime.wrappedExecute(WebScriptRuntime.java:342)  
 org.alfresco.web.scripts.WebScriptRuntime.authenticatedExecute(WebScriptRuntime.java:308)  
 org.alfresco.web.scripts.WebScriptRuntime$1.execute(WebScriptRuntime.java:163)  
 org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)  
 org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)  
 org.alfresco.web.scripts.WebScriptRuntime.executeScript(WebScriptRuntime.java:174)  
 org.alfresco.web.scripts.WebScriptServlet.service(WebScriptServlet.java:109)  
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)  
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)  
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)  
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)  
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)  
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)  
 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)  
 org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)  
 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)  
 org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)  
 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)  
 org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)  
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)  
 java.lang.Thread.run(Thread.java:619)  
    
Exception: org.alfresco.service.cmr.repository.TemplateException - Error during processing of the template 'Expression message("office.title.document_details") is undefined on line 16, column 13 in org/alfresco/office/documentDetails.get.html.ftl.'. Please contact your system administrator.  
    
 org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:204)  
    
Server: Alfresco Community Network v2.1.0 (482) schema 64  
Time: May 28, 2008 11:31:34 AM  
   
Diagnostics: Inspect Web Script (org/alfresco/office/documentDetails.get)  
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Opening Excel and PPT via WebDAV using add-in

invantix — Wed, 28 May 2008 16:13:04 GMT

OK so the html.flt files were changed to use message properties (a good thing)…

For example <title>Document Details</title> was changed to <title>${message("office.title.document_details")}</title>

So I found "office-addin.properties" file in \webapps\alfresco\WEB-INF\classes\alfresco\messages of 2.9 and added it to my 2.1 deployment but it does not seem to get picked up even after restarting.

Any ideas?

Thanks

Re: Opening Excel and PPT via WebDAV using add-in

mikeh — Wed, 28 May 2008 16:24:45 GMT

Good spot! Sorry, I'd forgotten those messages were new in V2.9.

You'll also need office-addin-context.xml from projects/web-client/config/alfresco (the parent folder to the .properties file) which will bootstrap the messages file into Spring.

Thanks,
Mike

Re: Opening Excel and PPT via WebDAV using add-in

invantix — Fri, 30 May 2008 14:57:37 GMT

Good spot! Sorry, I'd forgotten those messages were new in V2.9.

You'll also need office-addin-context.xml from projects/web-client/config/alfresco (the parent folder to the .properties file) which will bootstrap the messages file into Spring.

Thanks,
Mike

That file did not load the message properties so I added a line to another file for now (I know it is a hack but it worked).
I added this line <value>alfresco.messages.office-addin</value> to the file action-services-context.xml as shown below


   <bean id="actionResourceBundles" class="org.alfresco.i18n.ResourceBundleBootstrapComponent">
       <property name="resourceBundles">
          <list>
             <value>alfresco.messages.action-service</value>
             <value>alfresco.messages.action-config</value>
                <value>alfresco.messages.office-addin</value>
      </list>
       </property>
   </bean>
‍‍‍‍‍‍‍‍‍‍‍

I also had to copy of the missing images from /images/office and the new css files. Now everything is working fine!