<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Joe,<br>
<br>
Given our timeline, we might be able to do the engine part and give it
to you too. I'll chat to the guys now and come back to you on email
today.<br>
<br>
I'll also want Prasad to take a look over the plans so that whatever we
do, they can just pickup and roll into the core.<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.00040700.07080806@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.01000800.03060709@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_4A762B7B_1020203_tsolucio_com"
cite="mid:4A762B7B.1020203@tsolucio.com" type="cite"> Sounds like we
are on the same line of thought, which isn't surprising
as I think scheduling is the natural next step in the workflow
extension.<br>
<br>
We haven't started coding yet but we should :-)<br>
I have two clients who have asked for the AE update, there are two more
showing interest on the forum thread and I need the SMS for another
project in about two months, so....<br>
<br>
You indicate that you would need these enhancements for this week. I
can't get this done this week but maybe we can reach some agreement.
I'm thinking down the line of setting up a forge project with workflow
enhancements I would migrate/integrate the scheduling code from
autoemails and you could develop the SMS part.<br>
<br>
I would start with the part you need the most so you would have it ASAP.<br>
<br>
How does that sound?<br>
<br>
Joe<br>
TSolucio<br>
<br>
<br>
<br>
Brett Hooker escribió:
<blockquote id="mid_4A760DA8_8080006_roarz_com"
cite="mid:4A760DA8.8080006@roarz.com" type="cite">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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.roarz.com/bretts-blog"><img alt=""
src="cid:part3.09000600.05020604@roarz.com" border="0" height="68"
width="45"></a><br>
</td>
<td valign="top"><a moz-do-not-send="true"
href="http://www.roarz.com/email"><img alt=""
src="cid:part4.07090401.08070806@roarz.com" border="0" height="67"
width="154"></a><br>
</td>
<td valign="top"><small><a moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true"
class="moz-txt-link-freetext" href="http://jobs.vtiger.com">http://jobs.vtiger.com</a>
</pre>
</blockquote>
<br>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
Reach hundreds of potential candidates - <a moz-do-not-send="true"
class="moz-txt-link-freetext" href="http://jobs.vtiger.com">http://jobs.vtiger.com</a> </pre>
</blockquote>
<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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>