nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Document effectivity aspect email notification

nikes

Hello all,

I need to implement email notification on effectivity aspect of document.

Lets say if I apply effectivity aspect to document, I want send email to users before particular days/time reminding for expiry of document.

How can I implement this in Alfresco?

Thanks in advance,
Nikesh

Find more posts tagged with

Comments

nikes

Please guide if you guys have any idea.

nikes

Still looking for the solution

mrogers

Look here -> http://wiki.alfresco.com/wiki/Content_Expiration

If that does not do what you want the same principles apply. Run a scheduled job to check for "effectivity" and process actions according to your buisness rules.

nikes

The link given talks about WCM. I want implement in DM module.

Can you provide some sample job scheduler example here or some link?

I have never implement scheduling in Alfresco. Your guidance would be very helpful for me.

thanks,
Nikesh

nikes

I am able to send notification using scheduler.

My updated requirement is…..

I developing a solution for UK work permit project….which stores documents of all employees work permit.
This document has expiration date property.
I want to remind employees say before 6 months of expiry of document.

I have written javascript to send email to hard coded email address. But I want to send email to employees whose work permits expires based on business rule dynamically.

I have added an aspect to document to contain email address,, but dont know how to fetch it in scheduler javascript action.

When I fetch documents having particular aspect applied to it, what properties it returns? from luceneSearch() method.

Thanks for any help.
Nikesh

yasosaran

Hi Nikesh,

Could you please help me or share how you acheived this? We are looking on implementing something like this , holding the documents for 4 months and send email notification to the users who have access to the document about the expiration.

Could you please guide or point me to some pointer on how to add effectivity aspect and sending notices.

Thanks

nikes

I am listing down what I did, what I achieved and what still needs to be achieved…………………

What I did………….

1.     Apply rule to your folder for attaching out-of-box "effectivity" aspect……
2.     Add some sample documents and apply expiry date to it.
3.     Rename "scheduled-action-services-context.xml.sample" by removing ".sample" extension.
4.     Write some Javascript to send email. I uploaded script in Company Home folder (Best place might be data dictionary/script folder……..)
5.     In scheduled-action-services-context.xml define your bean to execute javascript and cron expression using lucene query.
6.     Restart your server. Scheduler will start sending email to mentioned address on defined time interval.

What I achieved…………
1. I have hardcoded emaill address in javascript. If i have two documents matching scheduler requirements, I am getting two emails in my Inbox.

What still needs to be achieved……..

1.   I want to fetch email address in Javascript from document property……. so that email would be sent to concerned person or group only.
2.   I want to execute action (email) only once containing all document list. Currently if condition finds 5 documents, it is sending 5 emails.
3. In email body I want to display Document properties like………….
     a) Document name
     b) Expiry date…… etc…..

For those who want some link for basic of scheduling………
http://wiki.alfresco.com/wiki/Scheduled_Actions

Lucene search related…..
http://wiki.alfresco.com/wiki/Search

In query template we can write something like this:

@cm\:to:"2009-05-31T00:00:00.000Z"‍

Also refer above link for date range syntax.

I would request Alfresco members to add some inputs to my pending requirements…

Thanks in advance for any help..

Nikesh

baby77

Hi guys me to is trying to figure it out how work scheduled action.
I want to send mail to person using scheduled not every time when document arrive to space but to set some time to check if new document is still in the space and need to be approved.
I do all steps in scheduled-action-services-context.xml and include js to send mail but i dont get it to work. Js is working fine.
Why this won't work? I follow all steps written on wiki.
Some help needed here.
Thanks.
Here is my scheduled-action-services-context.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
     <!–
    Define the model factory used to generate object models suitable for use with freemarker templates.
    –>
    <bean id="templateActionModelFactory" class="org.alfresco.repo.action.scheduled.FreeMarkerWithLuceneExtensionsModelFactory">
        <property name="serviceRegistry">
            <ref bean="ServiceRegistry"/>
        </property>
    </bean>

    <!–
   Execute the script /Company Home/Data Dictionary/Scripts/    –>
    <bean id="test_runScriptAction" class="org.alfresco.repo.action.scheduled.SimpleTemplateActionDefinition">
        <property name="actionName">
            <value>script</value>
        </property>
        <property name="parameterTemplates">
            <map>
                <entry>
                    <key>
                        <value>script-ref</value>
                    </key>
          <value>{selectSingleNode('workspace://SpacesStore', 'lucene',
                    'PATH:"/app:company_home/app:dictionary/app:scripts/cm:sendMail.js"' )}</value>
                </entry>
            </map>
        </property>
        <property name="templateActionModelFactory">
            <ref bean="templateActionModelFactory"/>
        </property>
        <property name="dictionaryService">
            <ref bean="DictionaryService"/>
        </property>
        <property name="actionService">
            <ref bean="ActionService"/>
        </property>
        <property name="templateService">
            <ref bean="TemplateService"/>
        </property>
    </bean>


    <bean id="runScript" class="org.alfresco.repo.action.scheduled.CronScheduledQueryBasedTemplateActionDefinition">
        <property name="transactionMode">
            <value>UNTIL_FIRST_FAILURE</value>
        </property>
        <property name="compensatingActionMode">
            <value>IGNORE</value>
        </property>
        <property name="searchService">
            <ref bean="SearchService"/>
        </property>
        <property name="templateService">
            <ref bean="TemplateService"/>
        </property>
        <property name="queryLanguage">
            <value>lucene</value>
        </property>
        <property name="stores">
            <list>
                <value>workspace://SpacesStore</value>
            </list>
        </property>
        <!– Find all nodes that do not have the aspect –>
        <property name="queryTemplate">
      <value>PATH:"/app:company_home"</value>
        </property>
        <property name="cronExpression">
      <value>0 0/3 * * * ?</value>
        </property>
        <property name="jobName">
            <value>jobA</value>
        </property>
        <property name="jobGroup">
            <value>jobGroup</value>
        </property>
        <property name="triggerName">
            <value>triggerA</value>
        </property>
        <property name="triggerGroup">
            <value>triggerGroup</value>
        </property>
        <property name="scheduler">
            <ref bean="schedulerFactory"/>
        </property>
        <property name="actionService">
            <ref bean="ActionService"/>
        </property>
        <property name="templateActionModelFactory">
            <ref bean="templateActionModelFactory"/>
        </property>
        <property name="templateActionDefinition">
            <ref bean="test_runScriptAction"/>
        </property>
        <property name="transactionService">
            <ref bean="TransactionService"/>
        </property>
        <property name="runAsUser">
            <value>System</value>
        </property>
    </bean>

</beans>

baby77

Hi i figure it out.
The only mistake was that I forgot to set the $ before selectSingleNode.
After that scheduled action start working.

john90

Hi it's a very interesting post !
Could you share your sendmail.js file please ?

anwar501pasha

Hi guys me to is trying to figure it out how work scheduled action.
I want to send mail to person using scheduled not every time when document arrive to space but to set some time to check if new document is still in the space and need to be approved.
I do all steps in scheduled-action-services-context.xml and include js to send mail but i dont get it to work. Js is working fine.
Why this won't work? I follow all steps written on wiki.
Some help needed here.
Thanks.
Here is my scheduled-action-services-context.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
     <!–
    Define the model factory used to generate object models suitable for use with freemarker templates.
    –>
    <bean id="templateActionModelFactory" class="org.alfresco.repo.action.scheduled.FreeMarkerWithLuceneExtensionsModelFactory">
        <property name="serviceRegistry">
            <ref bean="ServiceRegistry"/>
        </property>
    </bean>

    <!–
   Execute the script /Company Home/Data Dictionary/Scripts/    –>
    <bean id="test_runScriptAction" class="org.alfresco.repo.action.scheduled.SimpleTemplateActionDefinition">
        <property name="actionName">
            <value>script</value>
        </property>
        <property name="parameterTemplates">
            <map>
                <entry>
                    <key>
                        <value>script-ref</value>
                    </key>
          <value>{selectSingleNode('workspace://SpacesStore', 'lucene',
                    'PATH:"/app:company_home/app:dictionary/app:scripts/cm:sendMail.js"' )}</value>
                </entry>
            </map>
        </property>
        <property name="templateActionModelFactory">
            <ref bean="templateActionModelFactory"/>
        </property>
        <property name="dictionaryService">
            <ref bean="DictionaryService"/>
        </property>
        <property name="actionService">
            <ref bean="ActionService"/>
        </property>
        <property name="templateService">
            <ref bean="TemplateService"/>
        </property>
    </bean>


    <bean id="runScript" class="org.alfresco.repo.action.scheduled.CronScheduledQueryBasedTemplateActionDefinition">
        <property name="transactionMode">
            <value>UNTIL_FIRST_FAILURE</value>
        </property>
        <property name="compensatingActionMode">
            <value>IGNORE</value>
        </property>
        <property name="searchService">
            <ref bean="SearchService"/>
        </property>
        <property name="templateService">
            <ref bean="TemplateService"/>
        </property>
        <property name="queryLanguage">
            <value>lucene</value>
        </property>
        <property name="stores">
            <list>
                <value>workspace://SpacesStore</value>
            </list>
        </property>
        <!– Find all nodes that do not have the aspect –>
        <property name="queryTemplate">
      <value>PATH:"/app:company_home"</value>
        </property>
        <property name="cronExpression">
      <value>0 0/3 * * * ?</value>
        </property>
        <property name="jobName">
            <value>jobA</value>
        </property>
        <property name="jobGroup">
            <value>jobGroup</value>
        </property>
        <property name="triggerName">
            <value>triggerA</value>
        </property>
        <property name="triggerGroup">
            <value>triggerGroup</value>
        </property>
        <property name="scheduler">
            <ref bean="schedulerFactory"/>
        </property>
        <property name="actionService">
            <ref bean="ActionService"/>
        </property>
        <property name="templateActionModelFactory">
            <ref bean="templateActionModelFactory"/>
        </property>
        <property name="templateActionDefinition">
            <ref bean="test_runScriptAction"/>
        </property>
        <property name="transactionService">
            <ref bean="TransactionService"/>
        </property>
        <property name="runAsUser">
            <value>System</value>
        </property>
    </bean>

</beans>

anwar501pasha

Hi All,

I have the same above requirement where I need to sendemail at regular Intervals, for that i have taken the above mentioned "scheduled-action-services-context.xml" and the sendmail.js file.

My sendmail.js file is scheduled to run for every 3 mins, but in my sendmail.js file I was not able to define the "ActivexObject".

can any one please help me how we can define the The ActivexObjects in alfresco.

The Exception what iam getting is mentioned below.

13:51:00,049 INFO [STDOUT] 13:51:00,039 ERROR [quartz.core.JobRunShell] Job jobGroup.jobA threw an unhandled Exception:
org.alfresco.scripts.ScriptException: Failed to execute script 'workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c': ReferenceError: "ActiveXObject" is not defined. (workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c#17)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:228)
        at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:187)
        at sun.reflect.GeneratedMethodAccessor808.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy231.executeScript(Unknown Source)
        at org.alfresco.repo.action.executer.ScriptActionExecuter.executeImpl(ScriptActionExecuter.java:157)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:127)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:688)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:625)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:487)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:475)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:696)
        at sun.reflect.GeneratedMethodAccessor805.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy78.executeAction(Unknown Source)
        at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition$1$2.execute(AbstractScheduledAction.java:574)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:322)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:229)
        at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition$1.runTransactionalAction(AbstractScheduledAction.java:564)
        at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition$1.doWork(AbstractScheduledAction.java:432)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:497)
        at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition.execute(AbstractScheduledAction.java:398)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.alfresco.error.AlfrescoRuntimeException: ReferenceError: "ActiveXObject" is not defined. (workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c#17)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:465)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:224)
        … 51 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "ActiveXObject" is not defined. (workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c#17)
        at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
        at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
        at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
        at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)
        at org.mozilla.javascript.gen.c8._c0(workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c:17)
        at org.mozilla.javascript.gen.c8.call(workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
        at org.mozilla.javascript.gen.c8.call(workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c)
        at org.mozilla.javascript.gen.c8.exec(workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:449)
        … 52 more
13:51:00,049 INFO [STDOUT] 13:51:00,049 ERROR [quartz.core.ErrorLogger] Job (jobGroup.jobA threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.scripts.ScriptException: Failed to execute script 'workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c': ReferenceError: "ActiveXObject" is not defined. (workspace://SpacesStore/6f3fe30e-8a40-4d73-a76
        at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.alfresco.scripts.ScriptException: Failed to execute script 'workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c': ReferenceError: "ActiveXObject" is not defined. (workspace://SpacesStore/6f3fe30e-8a40-4d73-a765-ec8322cb776c#17)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:228)
        at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:187)
        at sun.reflect.GeneratedMethodAccessor808.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy231.executeScript(Unknown Source)
        at org.alfresco.repo.action.executer.ScriptActionExecuter.executeImpl(ScriptActionExecuter.java:157)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:127)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:688)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:625)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:487)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:475)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:696)
        at sun.reflect.GeneratedMethodAccessor805.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)