topic Re: Alfresco as the underbelly of a legacy system in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-as-the-underbelly-of-a-legacy-system/m-p/251085#M204215 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">i´d like to know whether alfresco provides a native functionality for symlinks of folders?</BLOCKQUOTE><SPAN>A given node can have multiple parents. In your example, doc_root/case_type/serial_no/location_id/extender/ might be the primary parent of letter.doc and doc_root/case_typeserial_nolocation_idextender/ could be a secondary parent.</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Secondly i´d like to have a script watch each folder on the bottom layer and perform CRUD operations against the legacy app´s SQL db (mainly T-SQL or PL/SQL), so that a table on the legacy apps´s db is being updated each time I add a file to one of the bottom folders of the legacy app.<BR />What would be the best environment to create such a script ? .js? java?<BR /><BR />In general what would be the best way to let Alfresco drive CRUD Operations against extern databases ?</BLOCKQUOTE><SPAN>There are a lot of ways to do this. You could:</SPAN><BR /><SPAN> - Put a rule (Java, JavaScript) on the folder so that when a new document gets added, the rule fires and then invokes a web service.</SPAN><BR /><SPAN> - Implement a behavior bound to a specific type or aspect that would trigger the web service invocation.</SPAN><BR /><SPAN> - Implement your file-system polling idea using any language you want that knows how to either look at the repository as if it were a file system via CIFS, WebDAV, or FTP and then makes calls to the db</SPAN><BR /><SPAN> - Implement a poller that looks at the repository via CMIS using one of the CMIS APIs (Java, Python, PHP). When you configure Alfresco to turn on auditing, CMIS change sets can be used. Seems like that might be a nice thing to leverage for something like this.</SPAN><BR /><BR /><SPAN>Hope that gives you some ideas to go on.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Thu, 23 Aug 2012 19:06:35 GMT jpotts 2012-08-23T19:06:35Z Alfresco as the underbelly of a legacy system https://connect.hyland.com/t5/alfresco-archive/alfresco-as-the-underbelly-of-a-legacy-system/m-p/251084#M204214 Hi,i might be OT or asking way too obvious questions&nbsp; here but&nbsp; was simply unable to find the answers in this forum so far, maybe to a lack of correct lingo on my side:What I am trying to achieve is geared more towards old fashioned DMS:I would like to mount my Alfresco Repository via CIFS and use i Thu, 23 Aug 2012 18:54:19 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-as-the-underbelly-of-a-legacy-system/m-p/251084#M204214 jay_ydar 2012-08-23T18:54:19Z Re: Alfresco as the underbelly of a legacy system https://connect.hyland.com/t5/alfresco-archive/alfresco-as-the-underbelly-of-a-legacy-system/m-p/251085#M204215 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">i´d like to know whether alfresco provides a native functionality for symlinks of folders?</BLOCKQUOTE><SPAN>A given node can have multiple parents. In your example, doc_root/case_type/serial_no/location_id/extender/ might be the primary parent of letter.doc and doc_root/case_typeserial_nolocation_idextender/ could be a secondary parent.</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Secondly i´d like to have a script watch each folder on the bottom layer and perform CRUD operations against the legacy app´s SQL db (mainly T-SQL or PL/SQL), so that a table on the legacy apps´s db is being updated each time I add a file to one of the bottom folders of the legacy app.<BR />What would be the best environment to create such a script ? .js? java?<BR /><BR />In general what would be the best way to let Alfresco drive CRUD Operations against extern databases ?</BLOCKQUOTE><SPAN>There are a lot of ways to do this. You could:</SPAN><BR /><SPAN> - Put a rule (Java, JavaScript) on the folder so that when a new document gets added, the rule fires and then invokes a web service.</SPAN><BR /><SPAN> - Implement a behavior bound to a specific type or aspect that would trigger the web service invocation.</SPAN><BR /><SPAN> - Implement your file-system polling idea using any language you want that knows how to either look at the repository as if it were a file system via CIFS, WebDAV, or FTP and then makes calls to the db</SPAN><BR /><SPAN> - Implement a poller that looks at the repository via CMIS using one of the CMIS APIs (Java, Python, PHP). When you configure Alfresco to turn on auditing, CMIS change sets can be used. Seems like that might be a nice thing to leverage for something like this.</SPAN><BR /><BR /><SPAN>Hope that gives you some ideas to go on.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Thu, 23 Aug 2012 19:06:35 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-as-the-underbelly-of-a-legacy-system/m-p/251085#M204215 jpotts 2012-08-23T19:06:35Z