AnsweredAssumed Answered

Solution to fulfill OA functions in Alfresco without much coding

Question asked by andy2.0 on Dec 29, 2013
Latest reply on Jan 4, 2014 by andy2.0
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 drafted:

(1) create the Excel template, set a specific cell to a JSON string, in which the values (extracted from other cells) are stored in a format;
(2) put the template file to Repository>Data Dictionary>Node Template;
(3) add a property to those kind of templates, the property could be "value-in-json"
(4) user to create files based on the templates
(5) after the file edited and submitted, an additional action will be executed to get the json string from the specific cell and set it to the "value-in-json" property.
(6) get the JSON string for further process, for example, for sum-up.

My questions are as below:
a. in step 5, how to get the cell value from an Excel file in alfresco?
b. how about this solution, are there any better solutions without much coding?

Thanks in advance!