topic Solution to fulfill OA functions in Alfresco without much coding in Alfresco Archive

Solution to fulfill OA functions in Alfresco without much coding

andy2_0 — Sun, 29 Dec 2013 04:51:14 GMT

The typical scenario is the expense reimbursement application process: application form (based on a template) submission; reimbusement-process follow-up; summarizing and reporting.Below is the solution I drafted1) create the Excel template, set a specific cell to a JSON string, in which the values

Re: Solution to fulfill OA functions in Alfresco without much coding

jpotts — Fri, 03 Jan 2014 17:13:49 GMT

Alfresco ships with Apache POI, a library that knows how to work with files created by office suites (like Excel). So you could write an Alfresco action that extracts the cell value using POI.

The POI method that looks most promising after a quick glance is:
http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html#getStringCellValue%28%29

If you need help writing actions, take a look at this:
http://ecmarchitect.com/images/articles/alfresco-actions/actions-article-2ed.pdf

You want the "action executer class" example.

Jeff

Re: Solution to fulfill OA functions in Alfresco without much coding

andy2_0 — Sat, 04 Jan 2014 05:51:54 GMT

Jeff, thanks!