topic Re: Solution to fulfill OA functions in Alfresco in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285679#M238809 <HTML><HEAD></HEAD><BODY><SPAN>This isn't possible without some minor coding work. I think a custom action that knows how to extract an arbitrary cell value out of a spreadsheet and store it in a property on the node would be a useful action.</SPAN><BR /><BR /><SPAN>I think this would take someone already familiar with creating custom actions less than half a day (easily) to code.</SPAN><BR /><BR /><SPAN>Once created, you could set up rules on your folder to invoke the action and you could reuse it on any folder in the repository without getting a developer involved.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Wed, 15 Jan 2014 22:55:35 GMT jpotts 2014-01-15T22:55:35Z Solution to fulfill OA functions in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285678#M238808 I have a couple of Excel files stored in Alfresco Doc library, they are created based on several templates. I want to extract the values from the specific cells of those files for further process. I drafted the solution as below<IMG id="smileysad" class="emoticon emoticon-smileysad" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" />1) create the Excel templates, set a specific cell to a JSON string, i Fri, 27 Dec 2013 16:34:22 GMT https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285678#M238808 andy2_0 2013-12-27T16:34:22Z Re: Solution to fulfill OA functions in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285679#M238809 <HTML><HEAD></HEAD><BODY><SPAN>This isn't possible without some minor coding work. I think a custom action that knows how to extract an arbitrary cell value out of a spreadsheet and store it in a property on the node would be a useful action.</SPAN><BR /><BR /><SPAN>I think this would take someone already familiar with creating custom actions less than half a day (easily) to code.</SPAN><BR /><BR /><SPAN>Once created, you could set up rules on your folder to invoke the action and you could reuse it on any folder in the repository without getting a developer involved.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Wed, 15 Jan 2014 22:55:35 GMT https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285679#M238809 jpotts 2014-01-15T22:55:35Z Re: Solution to fulfill OA functions in Alfresco https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285680#M238810 <HTML><HEAD></HEAD><BODY><SPAN>Jeff, thanks for your response!</SPAN></BODY></HTML> Wed, 22 Jan 2014 15:47:09 GMT https://connect.hyland.com/t5/alfresco-archive/solution-to-fulfill-oa-functions-in-alfresco/m-p/285680#M238810 andy2_0 2014-01-22T15:47:09Z