Opening Excel and PPT via WebDAV using add-in

[tonytony]

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.0


When 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 document with the file unlocking and versioning working.

When I open a file in excel using the plugin it downloads the file using Internet Explorer and the httprotocal and originally opened read-only in the browser. Using a few registry tweaks, i got it to open in excel but again read only, with the add-in not recognizing the file as "managed by alfresco". I can open the file R/W via webdav, but the add-in is a little flaky. It will crash if I try to do versioning and it shows the file as locked but dosen't recogonize that I have the check-out version in excel.

PowerPoint has similar issues with excel, only it downloads via IE and opens up in PPT but only as a slide show, I cannot edit it at all.

I think this is a IE configuration issue, but haven't figured out how to fix.

Thank for your time.

[mikeh]

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

[tonytony]

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

[invantix]

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

[mikeh]

Hi

This was just a fix to the Office webscripts.

Thanks,
Mike

[invantix]

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!

[mikeh]

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

[invantix]

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)  
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[invantix]

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

[mikeh]

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