<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Joe,<br>
<br>
Great post. Thanks. <br>
<br>
Love the SMS point as well. I'd put a vote in for ClickATell support
out of the box due to its API, international coverage, excellent
pricing and support in other apps (like Joomla!). We've been using it
for years, and are very happy with it. <a class="moz-txt-link-freetext" href="http://www.clickatell.com/">http://www.clickatell.com/</a><br>
<br>
Just last night I wrote some notes up for a similar change to the
workflow engine so that we can implement our automated invoice
processing and overdue reminder code. Details included below.<br>
<br>
We'll need to make our changes pretty quickly, like this week, so that
we can get our internal systems up on 5.1 asap.<br>
<br>
I'd like to co-ordinate our changes with yours and with the core team
so that this change ends up in vTiger 5.1.1.<br>
<br>
Are you already coding this on your side?<br>
<br>
<u><b>Cron Initiated Workflows</b></u><br>
<br>
<ul>
<li>
<p style="page-break-inside: avoid; widows: 2; orphans: 2;"
align="left" lang="en-AU"> <font color="#000000"><font
face="Times New Roman, serif"><font size="3">Extend 5.1 workflow
engine to launch workflows based on conditions being true in the
database on a scheduled basis (new for 5.1). <br>
</font></font></font></p>
</li>
<li>
<p style="page-break-inside: avoid; widows: 2; orphans: 2;"
align="left" lang="en-AU"><font color="#000000"><font
face="Times New Roman, serif"><font size="3">On the Edit Workflow
screen, add a new radio button to the “When to run the workflow” list
titled “On a schedule” and when chosen, add a extra set of options for
what the schedule will be:</font></font></font></p>
<ul>
<li>
<p style="page-break-inside: avoid; widows: 2; orphans: 2;"
align="left" lang="en-AU"> <font color="#000000"><font
face="Times New Roman, serif"><font size="3">Valid time intervals
would be cron-like, i.e. once a day at a specific time, every {x}
minutes, every {x} hours, specific days of the week (Mon, Wed, Fri)</font></font></font></p>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<p style="page-break-inside: avoid; widows: 2; orphans: 2;"
align="left" lang="en-AU"> <font color="#000000"><font
face="Times New Roman, serif"><font size="3">A cron job runs
regularly, and checks for handlers that have been defined within vTiger
5.1 workflow engine. If any exist for the given time interval, the cron
job tests the conditions and if true, invokes the actions as defined in
the workflow.</font></font></font></p>
</li>
</ul>
<ul>
<li>
<p style="page-break-inside: avoid; widows: 2; orphans: 2;"
align="left" lang="en-AU"> <font color="#000000"><font
face="Times New Roman, serif"><font size="3">This is how we implement
invoice reminders code that we have in 5.0.4; i.e. once a day at
midnight, look for any invoice with a due date < now()-7 and send an
email per the email setup on the worflow entry. May need to explore the
limits of the current condition functionality within the workflow
definition to implement the < now() business rule.</font></font></font></p>
</li>
</ul>
<br>
<br>
<br>
Thanks,<br>
Brett<br>
Phone 0404 067 421<br>
<br>
<table border="0" cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td valign="top"><a href="http://www.roarz.com/bretts-blog"><img
alt="" src="cid:part1.03080001.07000305@roarz.com" border="0"
height="68" width="45"></a><br>
</td>
<td valign="top"><a href="http://www.roarz.com/email"><img alt=""
src="cid:part2.04040104.02000406@roarz.com" border="0" height="67"
width="154"></a><br>
</td>
<td valign="top"><small><a href="http://www.roarz.com/email">www.roarz.com</a> Phone:
1300 885 125 Fax: 07 3009 0648 ABN: 69 113 777 594 <br>
<a href="http://www.roarz.com/capalaba">Capalaba HQ</a>: Suite
2A, 26 Redland Bay Road Capalaba Qld 4157<br>
<i>ROARZ will help you get your website up to date and keep it
that way.</i><br>
</small></td>
</tr>
</tbody>
</table>
<br>
<br>
Joe Bordes wrote:
<blockquote id="mid_4A75E970_8050703_tsolucio_com"
cite="mid:4A75E970.8050703@tsolucio.com" type="cite">
<pre wrap="">Hi,
Those users of the autoemails extension may find this interesting:
<a class="moz-txt-link-freetext" href="http://vtiger-spain.com/wiki/doku.php?id=autoemailvsworkflow">http://vtiger-spain.com/wiki/doku.php?id=autoemailvsworkflow</a>
Regards, Joe
TSolucio
_______________________________________________
Reach hundreds of potential candidates - <a class="moz-txt-link-freetext" href="http://jobs.vtiger.com">http://jobs.vtiger.com</a>
</pre>
</blockquote>
<br>
</body>
</html>