ActionQ User Manual
<!-- If the browser does not support frames put the first topic content here --> <div class="WordSection1"> <p class="MsoNormal" align="center" style='text-align:center'> <b><span style='font-size:24.0pt;color:#993300'><img width="44" height="44" id="Picture 13" src= "ActionQ_User_Manual_files/image001.jpg" alt="image" name= "Picture 13" /></span></b><b><span style= 'font-size:24.0pt;color:#993300'> </span></b><b><i><span style= 'font-size:24.0pt;color:#1F497D'>ActionQ</span></i></b> <span style='font-size:24.0pt;color:#1F497D'>User Manual</span><span style='font-size:24.0pt'> <b><i><span style='color:#993300'><img width="44" height="44" id="Picture 14" src="ActionQ_User_Manual_files/image001.jpg" alt= "image" name= "Picture 14" /></span></i></b><br /></span><span style='font-size:14.0pt'>Trigger Dynamic SQL, Emails, REST APIs, and Applications (exe, cms, PowerShell)<br /> as Responses To Events<br /> (Database, Email, Folder, PowerShell, Scheduled Task)</span></p> <p class="MsoTitle"><span style= 'font-size:14.0pt;font-weight:normal'> </span></p> <p class="MsoTitle"> </p> <p class="MsoNormal" align="center" style='text-align:center'> <span class="MsoHyperlink"><b><a href= "http://www.milletsoftware.com/">www.MilletSoftware.com</a></b></span></p> <p class="MsoTitle"><span style= 'font-size:12.0pt'> </span></p> <p class="MsoTitle"><span style='font-size:12.0pt'>Version 3.0.4.10</span></p> <p class="MsoTitle"><span style= 'font-size:11.0pt;font-weight:normal'>(April 2024)<br /> <br /></span></p> <p class="MsoTitle"><span style= 'font-size:11.0pt;font-weight:normal'>By</span></p> <p class="MsoTitle"><span style= 'font-size:11.0pt;font-weight:normal'> </span></p> <p class="MsoTitle"><span style= 'font-size:11.0pt;font-weight:normal'>Ido Millet</span></p> <p class="MsoTitle"><span style= 'font-size:11.0pt;font-weight:normal'><br /> <br /> 5275 Rome Court, Erie PA 16509<br /></span><a name= "_Hlt490206814"></a><a href= "mailto:ido@MilletSoftware.com"><span style= 'font-size:11.0pt'>ido@MilletSoftware.com</span></a><span style= 'font-size:11.0pt;font-weight:normal'><br /> (814) 825-6009</span></p> <p class="MsoTitle"><span style= 'font-size:11.0pt;font-weight:normal'> </span></p> <p class="MsoTitle" align="left" style='text-align:left'> <span style='font-size: 8.0pt;font-weight:normal'> </span></p> <p class="MsoTitle" align="left" style='text-align:left'> <span style='font-size: 8.0pt;font-weight:normal'> </span></p> <p class="MsoTitle" align="left" style='text-align:left'> <u><span style= 'font-size: 12.0pt;font-weight:normal'>Disclaimer:</span></u><span style='font-size:12.0pt; font-weight:normal'> These component and accompanying files are provided "as-is" by Ido Millet without assuming any responsibility for harm to computer systems, software, or data with which these files are used.</span></p> <p class="MsoTitle" align="left" style='text-align:left'> <span style= 'font-size: 12.0pt;font-weight:normal'> </span></p> <p class="MsoTitle" align="left" style='text-align:left'> <span style='font-size: 12.0pt;font-weight:normal'><br /> <br /></span></p> </div> <span style= 'font-size:8.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <div class="WordSection2"> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135439">Introduction<span style= 'color:windowtext;display:none;text-decoration:none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>5</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135440">Installation<span style= 'color:windowtext;display:none;text-decoration:none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>6</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135441">Launch<span style= 'color:windowtext;display:none;text-decoration:none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>7</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135442">Initial Setup<span style= 'color:windowtext;display:none;text-decoration:none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>8</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><span style= 'background:white'><a href="start.htm#_Toc165135443">Encrypted Strings<span style= 'color:windowtext; display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>9</span></a></span></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135444">Using the Encrypted Strings Manager <span style= 'color:windowtext;display:none;text-decoration:none'>9</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135445">Database Connections<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>10</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135446">Using the Connections Manager <span style='color:windowtext;display:none;text-decoration:none'>10</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135447">Using the Encrypted Strings Dialog (old method) <span style= 'color:windowtext;display:none;text-decoration:none'>11</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135448">Email Profiles<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>12</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135449">Using the Email Profiles Manager <span style= 'color:windowtext;display:none;text-decoration:none'>12</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135450">Email Settings for the Service Administrator <span style= 'color:windowtext;display:none;text-decoration:none'>13</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><span style= 'background:white'><a href="start.htm#_Toc165135451">Email_From Accounts for Events as Senders<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>14</span></a></span></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135452">Email Inbox Settings<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>15</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135453">Using the Email Inboxes (POP3) Manager <span style= 'color:windowtext;display:none;text-decoration:none'>15</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135454">Use the Global Settings Dialog<span style='color:windowtext;display:none;text-decoration: none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>16</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135455">Set the ActionQ Service to Run Under a User Account <span style= 'color:windowtext;display:none;text-decoration:none'>17</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135456">Setting Up Events<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>18</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135457">Global Properties<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>19</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135458">Individual Events Properties<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>19</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135459">Example<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>19</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135460">Supported Event Types<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>20</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135461">Monitoring Frequency<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>20</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135462">Failure Retry Period<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>20</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135463">Automatic Snapshot Table<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>20</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135464">Response Properties<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>21</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135465">SQL Response<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>21</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135466">EXE or CMD Response<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>22</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135467">PowerShell Response<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>22</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135468">REST API Call Response<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>23</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135469">Email Response<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>25</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135470">Viewing and Editing Properties<span style='color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>26</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135471">Embed Dynamic Tokens in Response Properties<span style= 'color:windowtext;display: none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>27</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135472">Edit Text for Non-Response Properties<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>28</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135473">HTML Editor for Email Message Body<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>29</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135474">Using {aq_HTML_Table} Token in Email Responses<span style= 'color:windowtext; display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>30</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135475">Using {aq_HTML_Table} Token in Email Responses<span style= 'color:windowtext; display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>32</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135476">View Dynamic Tokens for Each Process<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>32</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135477">Event Types<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>33</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135478">"Folder_Not_Empty" Event Type<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>33</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135479">Dynamic Tokens for Response Logic<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>34</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135480">Dynamic Tokens for Renaming Files<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>34</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135481">Database Events<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>35</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135482">Source_SQL_Template Editor <span style= 'color:windowtext;display:none;text-decoration:none'>35</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135483">Using a Stored Procedure as Data Source<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>36</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135484">"DB_LastMaxN" Event Type<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>37</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135485">"DB_Flag" Event Type<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>38</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135486">"DB_Mirror_Skip_Remove_T1" Event Type<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>39</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135487">PowerShell "PS_Mirror_Skip_Remove_T1" Event Type<span style= 'color:windowtext; display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>41</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135488">Calling REST APIs such as RabbitMQ<span style= 'color:windowtext;display:none;text-decoration: none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>41</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135489">Typical Properties<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>41</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135490">Avoiding Duplicate Processing<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>42</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135491">"Email_POP3_T1" Event Type<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>43</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135492">Typical Use Case: <span style= 'color:windowtext;display:none;text-decoration:none'>43</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135493">Setting Default Email Client <span style= 'color:windowtext;display:none;text-decoration:none'>44</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135494">Email Server and Inbox Settings<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>45</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135495">Event Settings<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>45</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135496">Standard Dynamic Tokens<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>47</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135497">Dynamic Tokens By Regular Expressions<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>47</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135498">Dynamic Tokens By Brackets<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>47</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135499">SQL_After Logic<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>47</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135500">Setting Up Alerts for Windows Scheduled Task Failures<span style= 'color:windowtext; display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>48</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135501">Monitoring Snapshot and Mirror Tables<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>49</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135502">Options<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>50</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135503">Customizing About Window in ActionQ Manager<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>50</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135504">Handling Failures<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>50</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135505">Setting Failure Retry Period<span style= 'color:windowtext;display:none;text-decoration: none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>51</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135506">Technical Notes<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>53</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135507">Database Connectivity<span style= 'color:windowtext;display:none;text-decoration:none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>53</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135508">64 vs 32-Bit DSNs<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>53</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135509">NT Authentication<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>53</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135510">SQL Statements<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>54</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135511">SQL_After as SELECT Query<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>54</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135512">SQL Statement Subquery<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>55</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135513">SQL Server (fully qualify table names) <span style= 'color:windowtext;display:none;text-decoration:none'>56</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135514">ProgramData Folder<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>57</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135515">Settings Files (ActionQ.ini and ActionQ_Data.ini) <span style= 'color:windowtext;display:none;text-decoration:none'>57</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135516">UNC Paths rather than Mapped Drives<span style= 'color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>57</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135517">Invisible Mapped Drives<span style= 'color:windowtext;display:none;text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>57</span></a></span></p> <p class="MsoToc3"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135518">Batch File to Make Mapped Drives Visible<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>57</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135519">Queuing Emails to smtpQ Outgoing Folder<span style= 'color:windowtext;display:none; text-decoration:none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>58</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135520">ActionQ Service Fails to Start<span style='color:windowtext;display:none;text-decoration: none'>.</span> <span style= 'color:windowtext;display:none;text-decoration:none'>58</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135521">Custom Logging (override appsettings.json) <span style= 'color:windowtext;display:none;text-decoration:none'>58</span></a></span></p> <p class="MsoToc1"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135522">Update History<span style= 'color:windowtext;display:none;text-decoration:none'>..</span> <span style= 'color:windowtext;display:none;text-decoration:none'>59</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135523">Version 3.0.4.10 (entered testing April 27, 2024): <span style= 'color:windowtext;display:none;text-decoration:none'>59</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135524">Version 2.0.8.01 (February 28, 2024): <span style= 'color:windowtext;display:none;text-decoration:none'>59</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135525">Version 2.0.2.01 (August 1, 2023): <span style= 'color:windowtext;display:none;text-decoration:none'>59</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135526">Version 2.0.1.01 (July 04, 2023): <span style= 'color:windowtext;display:none;text-decoration:none'>59</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135527">Version 2.0.0.01 (June 12, 2023): <span style= 'color:windowtext;display:none;text-decoration:none'>60</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135528">Version 1.1.97.02 (November 20, 2022): <span style= 'color:windowtext;display:none;text-decoration:none'>60</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135529">Version 1.1.89.02 (July 10, 2022): <span style= 'color:windowtext;display:none;text-decoration:none'>60</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135530">Version 1.1.0.95 (March 2, 2022): <span style= 'color:windowtext;display:none;text-decoration:none'>60</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135531">Version 1.1.0.93 (January 6, 2022): <span style= 'color:windowtext;display:none;text-decoration:none'>61</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135532">Version 1.1.0.87 (November 6, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>61</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135533">Version 1.1.0.83 (September 19, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>61</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135534">Version 1.1.0.82 (September 8, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>62</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135535">Version 1.1.0.74 (August 17, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>62</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135536">Version 1.1.0.71 (July 23, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>62</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135537">Version 1.1.0.63 (June 25, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>62</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135538">Version 1.1.0.61 (March 29, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>63</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135539">Version 1.1.0.57 (February 9, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>63</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135540">Version 1.1.0.52 (January 24, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>63</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135541">Version 1.1.0.47 (January 13, 2021): <span style= 'color:windowtext;display:none;text-decoration:none'>63</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135542">Version 1.1.0.34 (December 7, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>63</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135543">Version 1.1.0.33 (November 30, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135544">Version 1.1.0.31 (November 12, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135545">Version 1.1.0.22 (October 3, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135546">Version 1.1.0.21 (September 23, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135547">Version 1.1.0.12 (September 7, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135548">Version 1.1.0.10 (August 27, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135549">Version 1.1.0.9 (August 25, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>64</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135550">Version 1.0.0.8 (August 16, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>65</span></a></span></p> <p class="MsoToc2"><span class="MsoHyperlink"><a href= "start.htm#_Toc165135551">Version 1.0.0.0 (August 2, 2020): <span style= 'color:windowtext;display:none;text-decoration:none'>65</span></a></span></p> <p class="MsoTitle" align="left" style='text-align:left'> <span style='font-size: 10.0pt'><a name= "_Toc519529255"></a><a name="_Toc509669390"></a><a name= "_Toc506904354"></a><a name="_Toc502988794"></a><a name= "_Toc502915223"></a><a name="_Toc502588207"></a><a name= "_Toc502587265"></a><a name="_Toc502510225"></a><a name= "_Toc502508620"></a><a name="_Toc502422874"></a><a name= "_Toc502421956"></a><a name="_Toc502335337"></a><a name= "_Toc502334882"></a><a name="_Toc502315906"></a><a name= "_Toc502315688"></a><a name="_Toc502315601"></a><a name= "_Toc502315416"></a><a name="_Toc501975016"></a><a name= "_Toc501974947"></a><a name="_Toc501974101"></a><a name= "_Toc501973377"></a><a name="_Toc501973286"></a><a name= "_Toc501973151"></a><a name="_Toc501970026"><br /> <br /> <br /></a></span></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135439">Introduction</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal"><b><i>ActionQ</i></b> is an inexpensive BAM (<b><i>Business Activity Monitoring</i></b>) software. It can trigger, <span style='background: yellow'>within seconds</span>, <b>dynamic SQL</b>, <b>command lines</b>, <b>PowerShell</b> scripts, <b>REST API calls</b>, or <b>emails</b> in response to <b>database</b>, <b>email</b>, <b>PowerShell</b>, and <b>folder</b> events.<br /> It can also alert you when Windows Task Scheduler fails to launch a task.<br /> Typical triggers include new leads, documents, credit holds, inventory shortage, schedule delays, complaints, support requests, pricing exceptions, returns, defects, cancelations, and system exceptions.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><b><i>ActionQ</i></b> can use ODBC data source/target (including cloud databases). It can call any windows software (EXE, Batch Files, PowerShell, etc.) and pass dynamic arguments and parameters. In the case of <span class= "MsoHyperlink"><i><a href= "https://www.milletsoftware.com/visualcutBenefit.htm">Visual CUT</a></i></span>, this supports reporting, exporting, printing, emailing, uploading/downloading/processing files, capturing/parsing email attachments, and facilitating approval workflows.</p> <p class="MsoNormal"><br /> <span class="MsoHyperlink"><span style= 'font-size:11.0pt;font-family:"Verdana",sans-serif'><a href= "https://youtu.be/c7zDLqNfEts" target="_blank" title= "video demo">video demo</a></span></span><span style= 'font-size:11.0pt;font-family:"Verdana",sans-serif; color:black'> </span>of using ActionQ to <b>automate responses to database & email events</b>.</p> <p class="MsoNormal"><span class="MsoHyperlink"><a href= "https://youtu.be/axDxznQLBHY">Video demo</a></span> of using ActionQ to <b>call a REST API</b> (Twilio's SMS service).<br /> <span class="MsoHyperlink"><a href= "https://youtu.be/xFoh8JeyNa0">Video demo</a></span> of using <i>ActionQ</i> to <b>monitor the health of a SQL Server</b>.<br /> <br /> The software includes two programs:<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 1.<span style= 'font:7.0pt "Times New Roman"'> </span> <b><i>ActionQ_Service.exe</i></b> is a <b>service</b>, always running in the background. It responds to events by triggering dynamic SQL statements, emails, command lines, or RERST API calls. It can also move files, download email attachments, and download/delete processed emails from monitored inboxes.<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 2.<span style= 'font:7.0pt "Times New Roman"'> </span> <b><i>ActionQ_Manager.exe</i></b> is a GUI for managing and monitoring the service. The service facilitates monitoring by also sending you emails when starting/stopping or encountering failures.</p> <p class="MsoNormal"><a name="_Toc519529257"></a><a name= "_Toc509669392"></a><a name="_Toc506904356"></a><a name= "_Toc502988796"></a><a name="_Toc502915225"></a><a name= "_Toc502588209"></a><a name="_Toc502587267"></a><a name= "_Toc502510227"></a><a name="_Toc502508622"></a><a name= "_Toc502422876"></a><a name="_Toc502421958"></a><a name= "_Toc502335339"></a><a name="_Toc502334884"></a><a name= "_Toc502315908"></a><a name="_Toc502315690"></a><a name= "_Toc502315603"></a><a name="_Toc502315418"></a><a name= "_Toc501975018"></a><a name="_Toc501974949"></a><a name= "_Toc501974103"></a><a name="_Toc501973379"></a><a name= "_Toc501973288"></a><a name="_Toc501973153"></a><a name= "_Toc501970028"><br /> <br /></a></p> <p class="MsoNormal" align="center" style='text-align:center'> <img border="0" width="538" height="328" id="Picture 7" src= "ActionQ_User_Manual_files/image002.png" alt="image" name= "Picture 7" /><br /> <br /> <br /> <b><span style='font-size:14.0pt'><br /> <br /></span></b></p> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135440">Install</a>ation</h2> <p class="MsoNormal"><i> </i></p> <p class="MsoNormal">Follow the instruction received via email.<br /> <br /> After the install, use file explorer to locate: <br /> <b>C:\Program Files\Millet Software\ActionQ\ActionQ_Manager.exe</b><br /> Right-click this exe, Properties, Compatibility tab, and set the properties for all users to <b><br /> run this EXE as administrator</b>.<br /> If you forget to do so, a message box will remind you when you start the application.<br /> <br /> Right-click this exe and ‘<b><i>pin to taskbar</i></b>’ for easy access. <b><i><span style= 'font-size:24.0pt;color:#993300'><img border="0" width="31" height= "31" id="Picture 15" src="ActionQ_User_Manual_files/image003.png" alt="image" name="Picture 15" /></span></i></b></p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h2><a name="_Toc165135441">Launch</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">When you start ActionQ_Manager for the first time, it takes care of a) Copying the sample ActionQ.ini file from the installation folder to: <span style= 'background:yellow'>%APPDATA%</span>\MilletSoftware\ActionQ\ActionQ.ini<br /> Make sure users have MODIFY permissions on that folder.</p> <p class="MsoNormal"><br /> If you get an error about <b><i>ChilkatDotNet47.dll</i></b>, your machine is probably missing this C++ runtime:<span style= 'font-family:"Arial",sans-serif'><br /></span><span class= "MsoHyperlink"><a href= "https://go.microsoft.com/fwlink/?LinkId=746572">Microsoft Visual C++ Runtime 2017 64-bit</a></span> . Please download & install.<br /> <br /></p> <p class="MsoNormal">The initial Screen of ActionQ_Manager allows you to: <br /> <img border="0" width="33" height="32" id="Picture 51" src= "ActionQ_User_Manual_files/image004.png" alt="image" name= "Picture 51" /> <b>Manage Events</b> (create, edit, clone, delete).<br /> <img border="0" width="32" height="31" id="Picture 44" src= "ActionQ_User_Manual_files/image005.png" alt="image" name= "Picture 44" /> Manage global settings such as sleep interval.</p> <p class="MsoNormal"><img border="0" width="32" height="30" id= "Picture 53" src="ActionQ_User_Manual_files/image006.png" alt= "image" name="Picture 53" /> <b>Manage Encrypted String</b> (create and modify encrypted string for passwords and connection strings).<br /> <img border="0" width="28" height="25" id="Picture 56" src= "ActionQ_User_Manual_files/image007.png" alt="image" name= "Picture 56" /> <b>Manage Database Connections</b> (create, edit, clone, delete, and <b>test</b> connections).<br /> <img border="0" width="28" height="27" id="Picture 46" src= "ActionQ_User_Manual_files/image008.png" alt="image" name= "Picture 46" /> Manage Email Profiles (create, edit, clone, delete, and <b>test</b> email profiles).<br /> <img border="0" width="28" height="29" id="Picture 48" src= "ActionQ_User_Manual_files/image009.png" alt="image" name= "Picture 48" /> Manage Email Inbox (POP3) Settings<br /> <br /></p> <p class="MsoNormal"><b>Install/Uninstall</b> and <b>Start/Stop</b> the ActionQ Service.<br /> <img border="0" width="28" height="27" id="Picture 49" src= "ActionQ_User_Manual_files/image010.png" alt="image" name= "Picture 49" /> <b>Refresh the service log</b> (typically not needed since it auto-refreshes every few seconds).<br /> <img border="0" width="29" height="27" id="Picture 27" src= "ActionQ_User_Manual_files/image011.png" alt="image" name= "Picture 27" /> Open the ActionQ.ini file (typically, not needed)</p> <p class="MsoNormal">See <img border="0" width="33" height="27" id= "Picture 59" src="ActionQ_User_Manual_files/image012.png" alt= "image" name="Picture 59" /> <b>Version Information</b> and <img border="0" width="27" height="26" id="Picture 60" src= "ActionQ_User_Manual_files/image013.png" alt="image" name= "Picture 60" /><b>Open the user manual</b>.</p> <p class="MsoNormal" style='margin-left:.25in'> </p> <p class="MsoNormal"><img border="0" width="719" height="316" id= "Picture 23" src="ActionQ_User_Manual_files/image014.png" alt= "image" name="Picture 23" /></p> <p class="MsoNormal"><br /> <br /></p> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h1><a name="_Toc165135442"></a><a name= "_Initial_Setup"></a>Initial Setup</h1> <p class="MsoNormal"> </p> <p class="MsoNormal">Before creating events you should set up:<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 1.<span style= 'font:7.0pt "Times New Roman"'> </span> <img border="0" width="32" height="30" id="Picture 55" src= "ActionQ_User_Manual_files/image006.png" alt="image" name= "Picture 55" /><span class="MsoHyperlink"> <a href= "start.htm#_Encrypted_Strings_1">Encrypted Strings</a></span> to protect sensitive information (e.g. passwords).<br /> in particular, <b><i><span style= 'background:yellow'>ES_Email_Password</span></i></b> you should select as the password for '<b><i>Email</i></b>' (the mandatory email profile) used to communicate administrative information (service start/stop, and failures).<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 2.<span style= 'font:7.0pt "Times New Roman"'> </span> <img border="0" width="28" height="25" id="Picture 57" src= "ActionQ_User_Manual_files/image007.png" alt="image" name= "Picture 57" /><span class="MsoHyperlink"> <a href= "start.htm#_Database_Connections">Database Connections</a></span> to allow the service to connect to source/mirror databases (optional).<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 3.<span style= 'font:7.0pt "Times New Roman"'> </span> <img border="0" width="28" height="27" id="Picture 58" src= "ActionQ_User_Manual_files/image008.png" alt="image" name= "Picture 58" /><span class="MsoHyperlink"> <a href= "start.htm#_Email_Profiles">Email Profiles</a></span> for:</p> <p class="MsoListParagraph" style= 'margin-left:1.0in;text-indent:-.25in'>a.<span style= 'font:7.0pt "Times New Roman"'> </span> <b>'<span style='background:yellow'>Email</span>' -- the ActionQ service administrator</b> (so the service can communicate with you).</p> <p class="MsoListParagraph" style= 'margin-left:1.0in;text-indent:-.25in'>b.<span style= 'font:7.0pt "Times New Roman"'> </span> <b>Email_From_</b> accounts for events that send email (optional)<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 4.<span style= 'font:7.0pt "Times New Roman"'> </span> <img border="0" width="28" height="29" id="Picture 61" src= "ActionQ_User_Manual_files/image009.png" alt="image" name= "Picture 61" /> Optional: <span class="MsoHyperlink"><a href= "start.htm#_Email_Inbox_Settings">Email Inbox (POP3) Settings</a></span>, for events that monitor <b>incoming emails<br /> <br /></b></p> <p class="MsoListParagraph" style='text-indent:-.25in'><span class= "MsoHyperlink"><span style= 'color:windowtext;text-decoration:none'>5.<span style= 'font:7.0pt "Times New Roman"'> </span></span></span> <img border="0" width="27" height="26" id="Picture 64" src= "ActionQ_User_Manual_files/image015.png" alt="image" name= "Picture 64" /> Optional: <span class="MsoHyperlink"><a href= "start.htm#_Use_the_Global">Use the Global Settings Dialog</a></span>,<br /> including the option to <span class="MsoHyperlink"><a href= "start.htm#_Set_the_ActionQ_2">Set the ActionQ Service to Run Under a User Account</a></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><a name= "_Encrypted_Strings_1"></a><span style='background: white'><br /> <br /> <br clear="all" style='page-break-before:always' /></span></p> <h2><a name="_Toc165135443"><span style= 'background:white'>Encrypted Strings</span></a></h2> <p class="MsoNormal">In the ActionQ.ini, a section called [Encrypted_Strings] stores a set of named encrypted strings.<br /> Other sections can refer to these entries whose names always start with <span style='background:yellow'>ES_</span> as a prefix.<br /> For example, <span style='background:yellow'>ES_</span><span style= 'background: #E5DFEC'>Email_Password</span> protects a particular email password:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Encrypted_Strings]</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>ES_</span><span style= 'background:#E5DFEC'>Email_Password</span>="C95EA425116ADF35E951A9486FB1B39B40637242E00A2F16DACE67"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>ES_</span>ERP_DB="196994C9944EF7124D518634935B53378F7F439AD99E12AA91E629"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>ES_</span>AQ_Mirror_DB="196994CB6E0ED179C832B24B9E07AC55B5B580C16298C06C06F28"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>ES_</span>Service_Account_Password="A6949FC149F8CB8371063E9953E520A0354AACD32D624AE5"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>ES_</span>MS_Invoices_Password="D22E83F37BF870AB4BED33AE3AA0ABE4CD3D731E68C50"</p> </div> <h3><br /> <br /> <a name="_Toc165135444">Using the Encrypted Strings Manager</a></h3> <p class="MsoNormal"><br /> The <img border="0" width="37" height="37" id="Picture 19" src= "ActionQ_User_Manual_files/image016.png" alt="image" name= "Picture 19" /> button starts the dialog shown below. It allows you to create and modify named encrypted strings.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">In this example, an encrypted string called <b><i><span style= 'background:yellow'>ES_</span>Email_Password</i></b> being created for an email password.<br /> <br /> The <b><i>ES Name</i></b> drop-down allows you to select and change previously created named encrypted strings.<br /> <br /></p> <p class="MsoNormal"> <img border="0" width="642" height="248" id="Picture 52" src="ActionQ_User_Manual_files/image017.png" alt= "image" name="Picture 52" /> <br /> <br /> <br /></p> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135445">Database Connections</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">The service may need to connect to various databases to <b>detect</b> database events, <b>update</b> a database in response to an event, or <b>maintain a mirror table</b> to avoid duplicate processing. Connection properties within event settings simply name a connection. Those connection names are maintained in a [Connection_Strings] section like this:</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Connection_Strings]</p> <p class="MsoNormal" style='border:none;padding:0in'> ERP="ES_ERP_DB"</p> <p class="MsoNormal" style='border:none;padding:0in'> Mirror="dsn=ERP;uid=ixm7;pwd=ES_ERP_PW"</p> </div> <p class="MsoNormal">If you wish to encrypt the whole connection string, you may do so as demonstrated by the first example above. Otherwise, protect just the password as demonstrated by the 2<sup>nd</sup> example.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">You may edit that section manually using Notepad. But it is easier to use the dedicated connections manager.<br /> <br /></p> <h3><a name="_Toc165135446"></a><a name= "_Using_the_Connections"></a>Using the Connections Manager</h3> <p class="MsoNormal">Clicking <img border="0" width="35" height= "34" id="Picture 47" src="ActionQ_User_Manual_files/image018.png" alt="image" name="Picture 47" /> starts a connection manager:<br /> <br /> <img border="0" width="720" height="331" id="Picture 12" src= "ActionQ_User_Manual_files/image019.png" alt="image" name= "Picture 12" /></p> <p class="MsoNormal"><br /> The left panel lists the connections (Name and Connection String).<br /> The right panel is a property grid for a selected connection.<br /> <br /></p> <p class="MsoNormal">As shown in the image above, the connection string should refer to named encrypted strings instead of specifying sensitive information directly.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">The <b><i>Test Connection</i></b> button allows you to test the connection. If a problem is found, a detailed error message is provided.<br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135447">Using the Encrypted Strings Dialog (old method)</a></h3> <p class="MsoNormal"><br /> Note: In most cases, avoid this old method. Instead, create connections <span class="MsoHyperlink"><a href= "start.htm#_Using_the_Connections">Using the Connection Manager</a></span>.<br /> <br /> As a somewhat less intuitive option, you may use the <i>Encrypted Strings</i> dialog, to also take care of adding a connection string entry to the ini file (where the whole connection string is encrypted).<br /> <br /> If the <b><i>String to Encrypt</i></b> starts with ‘<b>dsn=</b>…’ ActionQ assumes it is for a connection string.<br /> A group box becomes visible and lists the named connections using that encrypted string, like this:<br /> <img border="0" width="642" height="248" id="Picture 20" src= "ActionQ_User_Manual_files/image020.png" alt="image" name= "Picture 20" /></p> <p class="MsoNormal">In the case above, the encrypted string is used by a connection called ERP.<br /> <br /> For a ‘<b>dsn=</b>…’ string that is not yet in use by a named connection, the group box becomes activated.<br /> You can then enter a name for the connection and click the ‘Create Connection’ button.<br /> That automatically creates the named connection and saves the encrypted string in the ActionQ.ini file:<br /> <img border="0" width="641" height="249" id="Picture 34" src= "ActionQ_User_Manual_files/image021.png" alt="image" name= "Picture 34" /> <br /> <br /> <br /></p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135448"></a><a name="_Email_Profiles"></a>Email Profiles</h2> <p class="MsoNormal">You need to set up one email profile called ‘<b><i>Email’</i></b> for notifying the administrator about the status of ActionQ. You can set up additional profiles (named as ‘<b><i>Email_From_???</i></b>’) to allow custom email responses to events.</p> <p class="MsoNormal"><br /> The user manual describes how these settings are saved as sections in the ini file.<br /> But instead of editing the ini file manually, you can simply use the <b><i>Email Profiles Manager</i></b>.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135449"></a><a name= "_Using_the_Email"></a>Using the Email Profiles Manager</h3> <p class="MsoNormal"><br /> Clicking <img border="0" width="28" height="28" id="Picture 50" src="ActionQ_User_Manual_files/image022.png" alt="image" name= "Picture 50" /> starts the Email Profiles Manager:<br /> <br /> <img border="0" width="720" height="465" id="Picture 74" src= "ActionQ_User_Manual_files/image023.jpg" alt="image" name= "Picture 74" /></p> <p class="MsoNormal"><br /> The left panel lists the email profiles.<br /> The right panel is a property grid for a selected profile.<br /> <br /></p> <p class="MsoNormal">The <b><i>Test Email Profile</i></b> button allows you to test the email. If a problem is found, a detailed error message is provided. If successful, a test message is sent to the addresses specified in the <b><i>Failure_Notices_To</i></b> property.<br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135450">Email Settings for the Service Administrator</a></h3> <p class="MsoNormal">The service needs to communicate with an administrator when it starts, stops, or encounters failures.<br /> Open the <span style= 'background:yellow'>%APPDATA%</span>\MilletSoftware\ActionQ\ActionQ.ini file in Notepad and modify the <b>[Email]</b> settings to match yours (note: it is much <span style='background:yellow'>easier to <b>use the GUI</b></span> to create/edit/clone these settings. See previous section.):</p> <p class="MsoNormal"> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> <b>[Email]</b></p> <p class="MsoNormal" style='border:none;padding:0in'> Email_SMTP_Server="mail.milletsoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_SMTP_Port="26"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_SMTP_Domain=""</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_User_ID="ido@milletsoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Password="<span style= 'background:#E5DFEC'>ES_Email_Password</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_StartTLS="True"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Connect_Timeout="10"</p> <p class="MsoNormal" style='border:none;padding:0in'>; Email_From=""ActionQ Service" <Email_Failure_Notices_From>"<br /> Email_Failure_Notices_From="ido@MilletSoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Failure_Notices_To="ido@MilletSoftware.com,ido.millet@gmail.com"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>Email_Signature</span>="<span style= 'background:aqua'><br><br></span>Ido Millet<span style= 'background:aqua'><br></span>www.MilletSoftware.com<span style='background:aqua'><br></span>(814) 825-6009"<br /> Email_Auth_JSON_PATH="C:\ProgramData\MilletSoftware\ActionQ\Client_Secret_SMTP_Office365.json"</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">Note how the <b>Email_Password</b> entry is referring to an Encrypted String called <span style= 'background:#E5DFEC'>ES_Email_Password</span>.<br /> The creation of Encrypted String entries is described in the previous section.<br /> <br /></p> <p class="MsoNormal">For the service administrator, the <b>Email_From</b> entry is ignored.<br /> Instead, it is set from this logic: <b>"ActionQ Service" <Email_Failure_Notices_From></b><br /> <br /></p> <p class="MsoNormal">The <span style= 'background:yellow'>Email_Signature</span> option allows you to override the default email signature. <br /> To insert line break, use <span style= 'background:aqua'><br></span> as shown in the example above.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">The <b><i>Email_Auth_JSON_PATH</i></b> is needed only when requiring <b>OAuth 2.0</b> via Gmail or Office365.<br /> <br /> <br /></p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif;background: white'><br clear="all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt;background:white'> </span></b></p> <h3><a name="_Toc165135451"><span style= 'background:white'>Email_From Accounts for Events as Senders</span></a></h3> <p class="MsoNormal"><a name="_Encrypted_Strings"></a> </p> <p class="MsoNormal">Each event that responds by sending an email message has an <b>Email_From_<span style= 'background:yellow'><Sender></span></b> property pointing at an ini section that defines email sending properties. Different events may use the same Email_From_<Sender> property but each event also has unique properties such as email to/cc/bcc, email subject and message.<br /> <br /> Here is an example of the ini section defining email sender properties for the Sales Department:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Email_From_<span style='background:yellow'>Sales</span>]</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_SMTP_Server="mail.milletsoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_SMTP_Port="26"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_SMTP_Domain=""</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_User_ID="ido@milletsoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Password="ES_Email_Password"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_StartTLS="True"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Connect_Timeout="10"</p> <p class="MsoNormal" style='border:none;padding:0in'> <b>Email_From=""Sales Department" <ido@MilletSoftware.com>"</b></p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Failure_Notices_From="ido@MilletSoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Failure_Notices_To="ido@MilletSoftware.com,ido.millet@gmail.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Signature="<br><br>VP of Sales<br>www.MilletSoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Auth_JSON_PATH=</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">Note that these settings follow the same structure as the email settings for the Service Administrator (as described in the previous section.<br /> <br /> The <span style='background:yellow'>Email_Signature</span> option allows you to specify an email signature. <br /> To insert line break, use <span style= 'background:aqua'><br></span> as shown in the example above.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">The <b><i>Email_Auth_JSON_PATH</i></b> is needed only when requiring <b><i>OAuth 2.0</i></b> via <i>Gmail</i> or <i>Office365</i>.<br /> <br /> Note how the <b>Email_Password</b> entry is referring to an Encrypted String called <span style= 'background:#E5DFEC'>ES_Email_Password</span>.<br /> The creation of Encrypted String entries is described in a previous section.<br /> <br /></p> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h2><a name="_Toc165135452"></a><a name= "_Database_Connections"></a><a name= "_Email_Inbox_Settings"></a>Email Inbox Settings</h2> <p class="MsoNormal"><b> </b></p> <p class="MsoNormal">Several events may monitor the same inbox. Each event may specify a different filter based on conditions such as the content of the email subject. This is why the general properties of each inbox are maintained in a centralized ini section called <b>[Email_Server_InBoxes]</b>.<br /> <br /> You need to set these entries only if you have events that monitor incoming emails.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of an inbox I monitor for invoice requests to trigger automated invoices via Visual CUT:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Email_Server_InBoxes]</p> <p class="MsoNormal" style='border:none;padding:0in'> MilletSoftware_Invoice=host4.hostmonster.com||invoice@MilletSoftware.com||<span style='background:#E5DFEC'>ES_MS_Password</span>||10</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">The 4 elements are: a) the POP3 server, b) the inbox email account, c) the encrypted password name,<br /> and d) the maximum number of emails to inspect in each scan cycle.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135453"></a><a name= "_Email_From_Settings"></a>Using the Email Inboxes (POP3) Manager</h3> <p class="MsoNormal"> </p> <p class="MsoNormal">Clicking <img border="0" width="35" height= "32" id="Picture 62" src="ActionQ_User_Manual_files/image024.png" alt="image" name="Picture 62" /> starts the Email Profiles Manager:<br /> <br /> <img border="0" width="720" height="315" id="Picture 65" src= "ActionQ_User_Manual_files/image025.png" alt="image" name= "Picture 65" /></p> <p class="MsoNormal"><br /> The left panel lists the inbox profiles.<br /> The right panel is a property grid for a selected profile.<br /> <br /> The <b><i>JSON_File</i></b> property is needed only when requiring <b><i>OAuth 2.0</i></b> via <i>Gmail</i> or <i>Office365</i>.<br /> <br /> The <b><i>Test Inbox</i></b> button allows you to test connection and authentication to the inbox. If a problem is found, a detailed error message is provided. If successful, a message box confirms it.<br /> <br /> <br /> <br clear="all" style='page-break-before:always' /></p> <h2><a name="_Toc165135454"></a><a name= "_Set_the_ActionQ_1"></a><a name="_Use_the_Global"></a>Use the Global Settings Dialog</h2> <p class="MsoNormal"> </p> <p class="MsoNormal">Clicking <img border="0" width="32" height= "31" id="Picture 66" src="ActionQ_User_Manual_files/image026.png" alt="image" name="Picture 66" /> starts the Global Settings Manager:<br /> <br /></p> <p class="MsoNormal"><img border="0" width="636" height="453" id= "Picture 4" src="ActionQ_User_Manual_files/image027.png" alt= "image" name="Picture 4" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">The bottom text area provides explanations for each property.<br /> <br /> A typical use for this dialog is to set the ActionQ service to run as a user account (instead of the default local SYSTEM account). This is discussed in more detail in the following section.<br clear="all" style='page-break-before: always' /></p> <h3><a name="_Toc165135455"></a><a name= "_Set_the_ActionQ_2"></a>Set the ActionQ Service to Run Under a User Account</h3> <p class="MsoNormal"> </p> <p class="MsoNormal">By default, the service will be running under the local SYSTEM account. That might mean that:</p> <p class="MsoListParagraph" style='text-indent:-.25in'> a)<span style= 'font:7.0pt "Times New Roman"'> </span> Access to network folders might be a problem. For example, rpt files located in shared folders may not be recognized when triggering a Visual CUT process.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> b)<span style= 'font:7.0pt "Times New Roman"'> </span> Allowing the SYSTEM account to use NT Authentication to SQL Server might require the procedure described in <span class= "MsoHyperlink"><a href="start.htm#_NT_Authentication">NT authentication</a></span>.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">To address such scenarios, you can elect to run the ActionQ Service under a user account.<br /> First, you need to add a Logon as a Service permission to that user account using the procedure described here:<br /> <span class="MsoHyperlink"><a href= "https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc794944(v=ws.10)?redirectedfrom=MSDN"> https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc794944(v=ws.10)?redirectedfrom=MSDN</a></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal">Here are the steps:</p> <p class="MsoListParagraph" style='text-indent:-.25in'> a)<span style= 'font:7.0pt "Times New Roman"'> </span> <strong><span style= 'font-family:"Segoe UI",sans-serif;color:#171717'>Start</span></strong>, <strong><span style= 'font-family:"Segoe UI",sans-serif;color:#171717'>Control Panel</span></strong>, <strong><span style= 'font-family:"Segoe UI",sans-serif; color:#171717'>Administrative Tools</span></strong>, <strong><span style= 'font-family:"Segoe UI",sans-serif;color:#171717'>Local Security Policy</span></strong>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> b)<span style= 'font:7.0pt "Times New Roman"'> </span> double-click <strong><span style= 'font-family:"Segoe UI",sans-serif; color:#171717'>Local Policies</span></strong>, and then click <strong><span style= 'font-family:"Segoe UI",sans-serif;color:#171717'>User Rights Assignment</span></strong>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> c)<span style= 'font:7.0pt "Times New Roman"'> </span> In the details pane, double-click <strong><span style= 'font-family: "Segoe UI",sans-serif;color:#171717'>Log on as a service</span></strong>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> d)<span style= 'font:7.0pt "Times New Roman"'> </span> Click <strong><span style= 'font-family:"Segoe UI",sans-serif; color:#171717'>Add User or Group</span></strong>, and<br /> add the user account to the list of accounts that possess the <strong><span style= 'font-family:"Segoe UI",sans-serif;color:#171717'>Log on as a service</span></strong> right.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> e)<span style= 'font:7.0pt "Times New Roman"'> </span> Click on the encrypt & save string button <img border="0" width="32" height="33" id="Picture 69" src= "ActionQ_User_Manual_files/image028.png" alt="image" name= "Picture 69" /> and<br /> set a <b><i><span style= 'background:yellow'>Service_Account_Password</span></i></b> entry to the user’s Windows login password.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="642" height="173" id= "Picture 70" src="ActionQ_User_Manual_files/image029.png" alt= "image" name="Picture 70" /></p> <p class="MsoNormal"><br /> <br /> Then, use the Global Setting dialog <img border="0" width="32" height="31" id="Picture 71" src= "ActionQ_User_Manual_files/image026.png" alt="image" name= "Picture 71" /> (as described in the previous section to set the User and Password for the service. These changes result in entries such as the example below in the ini file:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'>[Service]</p> <p class="MsoNormal" style='border:none;padding:0in'> User="MILLETSOFTWARE2\ixm7"</p> <p class="MsoNormal" style='border:none;padding:0in'> Password="ES_<span style= 'background:yellow'>Service_Account_Password</span>"</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <p class="MsoNormal"><a name="_Setting_Email_Options"></a><a name= "_Managing_Encrypted_Strings"></a> </p> <h1><a name="_Toc165135456">Setting Up Events</a></h1> <p class="MsoNormal"><br /> Clicking the <img border="0" width="39" height="38" id="Picture 28" src="ActionQ_User_Manual_files/image030.png" alt="image" name= "Picture 28" /> button launches a window that allows you to create, clone, delete, and modify events:</p> <p class="MsoNormal"> </p> <p class="MsoNormal">The <b>event grid</b> on the left lists all defined events and allows you to set event type, sleep multiplier, and include/exclude the event from scanning by the ActionQ service.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">The <b>Property Panel</b> on the right allows you to review/change properties for each event. The displayed properties adapt to the type of event. Common and unique event properties are discussed in the sections below.<br /> <br /> <img border="0" width="767" height="626" id="Picture 1" src= "ActionQ_User_Manual_files/image031.jpg" alt="image" name= "Picture 1" /></p> <p class="MsoNormal"><br /> <br /> <br /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135457">Global Properties</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">When the ActionQ service loads, it uses the following ini section in <b><i>ActionQ.ini</i></b> to detect the events to monitor and set its own sleep period after each monitor cycle.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">[Events]</p> <p class="MsoNormal">EventNames="VC_QFolder, Invoice_Overdue, Report_Request, Credit_Hold"</p> <p class="MsoNormal">Sleep="5000"<br /> Failure_Retry_Sleep_Multiplier="10"</p> <p class="MsoNormal"> </p> <p class="MsoNormal">In the example above, there are 4 events that the service will monitor. After each monitor cycle, the service will <b><i>sleep</i></b> for 5 seconds (5000 milliseconds).<br /> <br /> A value of 10 in <b><i>Failure_Retry_Sleep_Multiplier</i></b> tells the service that a failing event in a retry mode should be checked at a frequency 10 times lower than normal. For example, if <b><i>Failure_Retry_Sleep_Multiplier</i></b> is set to 10, global <b><i>Sleep</i></b> is set to 5 Seconds, and the process has a <b><i>Sleep_Multiplier</i></b> of 3, when that process enters failure retry mode, it would be checked every 150 seconds (5 x 3 x 10).<br /> If it recovers, it will immediately resume its normal frequency of every 15 seconds (5 x 3).</p> <p class="MsoNormal"> </p> <h2><a name="_Toc165135458">Individual Events Properties</a></h2> <p class="MsoNormal">Each event has an ini section with its name.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135459">Example</a></h3> <p class="MsoNormal">Common properties for all events include the following example:</p> <p class="MsoNormal"> </p> <p class="MsoNormal">[Event_Name]</p> <p class="MsoNormal"><span style= 'background:#92CDDC'>Event_Type</span>="DB_Flag"</p> <p class="MsoNormal"><span style= 'background:aqua'>Sleep_Multiplier</span>="3"<br /> <span style= 'background:yellow'>Failure_Retry_Minutes</span>="5"<br /> <span style= 'background:#DAEEF3'>Snapshot_Table_Connection</span>="Snapshot"<br /> <span style='background:lime'>SQL_After_Connection=""</span></p> <p class="MsoNormal"><span style= 'background:lime'>SQL_After=""<br /> SQL_When=”Each”</span></p> <p class="MsoNormal"><span style= 'background:#C2D69B'>EXE2Call</span>="C:\Program Files (x86)\Visual CUT 11\Visual CUT.exe"</p> <p class="MsoNormal"><span style= 'background:#C2D69B'>Arguments_Template</span>="-e "C:\Reports\Credit_Hold.rpt" "Parm1:<span style= 'background: #FFC000'>{Cust_ID}</span>""</p> <p class="MsoNormal"><span style= 'background:#C2D69B'>Call_When</span>="Once"</p> <p class="MsoNormal" style='background:#F2DBDB'> SMTP_Settings="Email_From_Sales"</p> <p class="MsoNormal" style='background:#F2DBDB'> Email_To=”ido@MilletSoftware.com”<br /> Email_Attachments=”c:\temp\Attendance_{Student_ID}.xlsx; c:\temp\Grades_{Sudent_ID}.pdf”</p> <p class="MsoNormal" style='background:#F2DBDB'>Email_To_BCC=""</p> <p class="MsoNormal" style='background:#F2DBDB'>Email_To_CC=""</p> <p class="MsoNormal" style='background:#F2DBDB'> Email_Subject="Invoice Request"</p> <p class="MsoNormal" style='background:#F2DBDB'> Email_Message="Invoice Request Received from {Email_From}"</p> <p class="MsoNormal" style='background:#F2DBDB'> Email_When="Each"</p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h3><a name="_Toc165135460">Supported Event Types</a></h3> <p class="MsoNormal">Currently, the supported <span style= 'background:#92CDDC'>Event Types</span> are:</p> <p class="MsoListParagraph" style= 'margin-left:.25in;text-indent:-.25in'>1.<span style= 'font:7.0pt "Times New Roman"'> </span> "<b>Folder_Not_Empty</b>" –detect files appearing in a local/cloud folder.</p> <p class="MsoListParagraph" style= 'margin-left:.25in;text-indent:-.25in'>2.<span style= 'font:7.0pt "Times New Roman"'> </span> “<b>DB_LastMaxN</b>” –detect new records based on an incrementing numeric column</p> <p class="MsoListParagraph" style= 'margin-left:.25in;text-indent:-.25in'>3.<span style= 'font:7.0pt "Times New Roman"'> </span> “<b>DB_Flag</b>” – detect records and delete or update them in the database to avoid duplication</p> <p class="MsoListParagraph" style= 'margin-left:.25in;text-indent:-.25in'>4.<span style= 'font:7.0pt "Times New Roman"'> </span> “<b>DB_Mirror_Skip_Remove_T1</b>” – detect records based on comparisons to a mirror table</p> <p class="MsoListParagraph" style= 'margin-left:.25in;text-indent:-.25in'>5.<span style= 'font:7.0pt "Times New Roman"'> </span> “<b>PS_Mirror_Skip_Remove_T1</b>” – same as above, using <i>PowerShell</i> script as the triggering event</p> <p class="MsoListParagraph" style= 'margin-left:.25in;text-indent:-.25in'>6.<span style= 'font:7.0pt "Times New Roman"'> </span> “<b>Email_POP3_T1</b>” – detect new emails matching a filter condition. Trigger command lines and database updates. Optionally download the email message and/or attachments, and delete the email from the server.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135461">Monitoring Frequency</a></h3> <p class="MsoNormal"><b><i><span style= 'background:aqua'>Sleep_Multiplier</span></i></b> tells the service to check that event only every Nth cycle. In the case above, a value of 3 indicates that the trigger condition for this event would be checked only every 3<sup>rd</sup> cycle.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135462">Failure Retry Period</a></h3> <p class="MsoNormal"><span style= 'background:yellow'>Failure_Retry_Minutes</span> (if > 0) is an optional setting available to all processes. It tells the service to retry monitoring this event even after a failure (e.g. connectivity to monitored database is down).<br /> For details, see <span class="MsoHyperlink"><a href= "start.htm#_Setting_Failure_Retry">Setting Failure Retry Period</a></span>.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135463">Automatic Snapshot Table</a></h3> <p class="MsoNormal"><span style= 'background:#DAEEF3'>Snapshot_Table_Connection</span> <span style= 'background:white'>(if specified) directs the service to load the event data (after removing cases due to any Mirror table logic) into a snapshot table. The table is created on the fly at the target database specified by the connection. It is named based on the event name like this: <b><span style= 'background:yellow'>aqt_</span>EventName</b>. (for example <span style='background:yellow'>aqt_</span>CreditHold).<br /> Besides facilitating debugging, a snapshot table can <b>expose the event data to downstream processes</b>.<br /> For example, ActionQ can trigger a Visual CUT process whereby a report consumes the data in the snapshot table. This can remove the need to pass parameters via dynamic tokens in the arguments template.<br /> <br /></span></p> <p class="MsoNormal"><br /> <br clear="all" style='page-break-before:always' /></p> <h2><a name="_Toc165135464">Response Properties</a></h2> <p class="MsoNormal">Each event can trigger EXE and/or SQL and/or Email responses. </p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135465">SQL Response</a></h3> <p class="MsoNormal"><span style= 'background:lime'>SQL_After_Connection</span> and <span style= 'background:lime'>SQL_After</span> specify the connection name and the SQL statement to call.<br /> <span style='background:lime'>SQL_When</span> specifies if the SQL response is called for <b>each</b> Record/File/Email in the event or only <b>once</b>.<br /> The SQL statement can use <b><span style= 'background:#FFC000'>dynamic tokens</span></b> to incorporate dynamic information from the event.<br /> In the example above, these options are left blank, indicating no SQL response is needed.<br /> <br /> If the SQL statement starts with SELECT, ActionQ assumed you wish to <b><u>add</u></b> <span style='background:#FFC000'>dynamic token</span> information for each column from the query. Make sure the SELECT statement returns only zero or one row. If zero rows are returned the dynamic tokens for each column name is set as blank (“”).<br /> <br /> The dialog to edit the SQL Response provides syntax highlighting:<br /> <br /> <img border="0" width="586" height="393" id="Picture 2" src= "ActionQ_User_Manual_files/image032.png" alt="image" name= "Picture 2" /> <br /> <br /></p> <p class="MsoNormal"><a name="_SQL_Response_as"></a><br /> <br clear="all" style='page-break-before:always' /></p> <h3><a name="_Toc165135466">EXE or CMD Response</a></h3> <p class="MsoNormal"><span style= 'background:#C2D69B'>EXE2Call</span> and <span style= 'background:#C2D69B'>Arguments_Template</span> specify the EXE, Batch, or CMD files to call and the arguments to pass. The arguments can use <b><span style='background:#FFC000'>dynamic tokens</span></b> (for example, "Parm1:<span style= 'background:#FFC000'>{Cust_ID}</span>") to incorporate dynamic information from the event.</p> <p class="MsoNormal"><span style='background:#C2D69B'><br /> Call_When</span> tells the service when to call the EXE2Call. A value of “Each” runs the EXE for each triggering event row (e.g. query row, email, file, PowerShell object). A value of “Once” triggers the response only once.<br /> <br /></p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135467"></a><a name= "_PowerShell_Response"></a>PowerShell Response</h3> <p class="MsoNormal">Note: for detailed technical explanations and examples, see <span class="MsoHyperlink"><a href= "https://blog.danskingdom.com/allow-others-to-run-your-powershell-scripts-from-a-batch-file-they-will-love-you-for-it/"> this blog</a></span>.<br /> Let's assume your script is at: <span style= 'background:aqua'>C:\PS\Script.ps1</span><br /> <br /> <span style='background:#C2D69B'>Call_When</span> tells the service when to call the PowerShell script. A value of “Each” runs the script for each triggering event row (e.g. query row, email, file, PowerShell object) matching the event filter conditions.<br /> A value of “Once” triggers the response only once.</p> <p class="MsoNormal"><br /> Set <span style='background:#C2D69B'>EXE2Call</span> to <b><span style='background:yellow'>Powershell.exe</span></b><br /> <br /> Set the <span style='background:#C2D69B'>Arguments_Template</span> to:<br /> <span style='background:yellow'>-NoProfile -ExecutionPolicy Bypass -Command "</span><span style= 'background:aqua'>C:\PS\Script.ps1</span><span style= 'background:yellow'>";</span></p> <p class="MsoNormal"> </p> <p class="MsoNormal">The <span style= 'background:#C2D69B'>Arguments_Template</span> can use <b><span style='background:#FFC000'>dynamic tokens</span></b> to incorporate dynamic information from the event.</p> <p class="MsoNormal">Typically, you would insert those dynamic tokens as parameters to the PowerShell Script, as discussed below:<br /> <br /></p> <h4><a name="node0" id="node0"></a>With Named Parameters:</h4> <p class="MsoNormal">If the script uses <span style= 'background:lime'>named parameters</span>, add parameter <span style='background:lime'>name</span> & <b><span style= 'background:#FFC000'>value</span></b> pairs to the end of the <span style='background:#C2D69B'>Arguments_Template</span> like this:<br /> <span style='background:yellow'>-NoProfile -ExecutionPolicy Bypass -Command "</span><span style= 'background:aqua'>C:\PS\RenameFile.ps1</span> <span style= 'background:lime'>-newName</span> <span style= 'background:#FFC000'>{FileName}</span><span style= 'background:yellow'>";</span><br /> <br /> In the example above, the <span style= 'background:#FFC000'>{FileName}</span> may have a dynamic value provided by <i>Folder_Not_Empty</i> event.<br /> </p> <h4><a name="node1" id="node1"></a>More Complex Scenarios:</h4> <p class="MsoNormal">For more complex scenarios, such as running the script with Admin permissions, or handling values with embedded spaces, please refer to <span class="MsoHyperlink"><a href= "https://blog.danskingdom.com/allow-others-to-run-your-powershell-scripts-from-a-batch-file-they-will-love-you-for-it/"> this blog</a></span>.</p> <p class="MsoNormal"><span style='background:#C2D69B'><br /> <br /></span></p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><a name="_REST_API_Call"></a><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135468">REST API Call Response</a></h3> <p class="MsoNormal">Set the EXE name as <span style= 'background:#C2D69B'>REST_API_Execute_Curl</span>. The <span style= 'background:#C2D69B'>Arguments_Template</span> specifies the <b>cURL command</b>. Most REST API providers offer examples and online help for constructing cURL commands.<br /> <br /> For example, here is an example of calling Twilio's REST API to send an SMS in response to an incoming email:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="715" height="427" id= "Picture 81" src="ActionQ_User_Manual_files/image033.png" alt= "image" name="Picture 81" /> <br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is the ActionQ dialog for <b>editing the CURL command</b>. Note the dynamic tokens. In this example, they provide information from the email message that triggered the event.<br /> <img border="0" width="743" height="156" id="Picture 78" src= "ActionQ_User_Manual_files/image034.jpg" alt="image" name= "Picture 78" /> </p> <p class="MsoNormal"><br /> <br /></p> <p class="MsoNormal">Here are the dynamic token values shown when you turn on the Preview option:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="751" height="156" id= "Picture 80" src="ActionQ_User_Manual_files/image035.jpg" alt= "image" name="Picture 80" /></p> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <p class="MsoNormal"><b><span style='font-size:13.0pt'>Note:</span> The JSON response is parsed into dynamic tokens that can be used in an email response.</b><b><span style='font-size:13.0pt'><br /> <br /> <br /></span></b></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135469">Email Response</a><br /> <br /></h3> <p class="MsoNormal"><span style= 'background:#F2DBDB'>SMTP_Settings</span> specifies the outgoing email profile that can be reused by multiple events to send emails as discussed in <span class="MsoHyperlink"><a href= "start.htm#_Email_From_Settings">Email_From Settings</a></span>.<br /> The rest of the event email properties control the unique aspects (to/cc/bcc/subject/attachments/message) for emails sent by the event.<br /> <br /></p> <p class="MsoNormal">These properties can refer to <b><span style= 'background: #FFC000'>dynamic tokens</span></b> to incorporate information from the event.<br /> For example, the <span style='background:#F2DBDB'>Email_To</span> property can be set to <span style= 'background:#FFC000'>{FromAddress}</span> in the case of an event triggered by an email or to <span style= 'background:#FFC000'>{Contact_Email}</span> in the case of an event triggered by SQL.<br /> <br /></p> <p class="MsoNormal"><br /> <br clear="all" style='page-break-before:always' /></p> <h2><a name="_Toc165135470">Viewing and Editing Properties</a><br /> <br /></h2> <p class="MsoNormal">When clicking the <img border="0" width="39" height="38" id="Picture 9" src= "ActionQ_User_Manual_files/image030.png" alt="image" name= "Picture 9" /> button the <b><span style= 'color:#E36C0A'>Common Properties</span></b> are in the property groups of:<br /> ‘<b><i>Event</i></b>’, ‘<b><i>Response_EXE</i></b>’, ‘<b><i>Response_SQL</i></b>’, and <b><i>‘Send_Email’</i></b> as shown below:<br /> <br /></p> <p class="MsoNormal"><img border="0" width="763" height="487" id= "Picture 31" src="ActionQ_User_Manual_files/image036.jpg" alt= "image" name="Picture 31" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">As you select a particular event row in the grid on the left, the Property Panel on the right updates to also reflect the unique properties for that event type. In the example above, the ‘<b><i>Triggered By SQL</i></b>’ property group reflects the unique <b><span style='color:#2215D1'>Trigger-Type</span></b> properties of the ‘DB_Flag’ event type. </p> <p class="MsoNormal"> </p> <p class="MsoNormal">As demonstrated by the image above, when selecting a property, an ellipsis button on the right edge provides access to a matching property editor. This can be a simple drop-down providing a choice of relevant values. Or it can be a text/html editor for easy editing and embedding dynamic tokens as described in the next sections.<br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><a name= "_Embed_Dynamic_Tokens_1"></a><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135471"></a><a name= "_Embed_Dynamic_Tokens_2"></a>Embed Dynamic Tokens in Response Properties</h3> <p class="MsoNormal"> </p> <p class="MsoNormal">The property grid associates a special editor for response properties that may reference dynamic tokens.</p> <p class="MsoNormal">You open the dialog by clicking the ellipsis button to the right of the text property. For example:</p> <p class="MsoNormal"><br /> <img border="0" width="704" height="79" id="Picture 39" src= "ActionQ_User_Manual_files/image037.png" alt="image" name= "Picture 39" /><br /> <img border="0" width="525" height="196" id="Picture 33" src= "ActionQ_User_Manual_files/image038.png" alt="image" name= "Picture 33" /></p> <p class="MsoNormal"><br /> The dialog provides several benefits:</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 1.<span style= 'font:7.0pt "Times New Roman"'> </span> It breaks the text into multiple lines using typical key words (such as “ Parm” “FROM” “WHERE”) to make it <b>easier to review and edit the text</b>. When the user clicks ‘OK’ the dialog re-assembles the content back to a single line.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 2.<span style= 'font:7.0pt "Times New Roman"'> </span> Available <b>dynamic tokens are listed in a panel</b> on the right with <b>tooltips revealing sample values</b>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 3.<span style= 'font:7.0pt "Times New Roman"'> </span> <b>Double-clicking a token on the right inserts it into the cursor location within the editing panel</b> on the left.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 4.<span style= 'font:7.0pt "Times New Roman"'> </span> <b>You can change the font size</b> using Ctrl-Scroll-Up or Ctrl-Scrolll-Down.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 5.<span style= 'font:7.0pt "Times New Roman"'> </span> Turning on the <b>‘Preview’ checkbox toggles a display of the text with token references substituted by their sample values</b>, like this:</p> <p class="MsoListParagraph"><img border="0" width="483" height= "193" id="Picture 40" src="ActionQ_User_Manual_files/image039.png" alt="image" name="Picture 40" /></p> <p class="MsoListParagraph"> </p> <p class="MsoNormal" style='margin-left:.25in'> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h3><a name="_Toc165135472">Edit Text for Non-Response Properties</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">Text properties that describe the triggering event (such as source SQL statement for DB events) cannot reference dynamic tokens. Because of this, when clicking the ellipsis button, they are edited in a simple text editor that looks like this:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="447" height="125" id= "Picture 6" src="ActionQ_User_Manual_files/image040.png" alt= "image" name="Picture 6" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">This simpler editor still provides several benefits:</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 1.<span style= 'font:7.0pt "Times New Roman"'> </span> It breaks the text into multiple lines using typical key words (such as “ Parm” “FROM” “WHERE”)<br /> to make it <b>easier to review and edit the text</b>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 2.<span style= 'font:7.0pt "Times New Roman"'> </span> When the user clicks ‘OK’ the dialog re-assembles the content back to a single line.</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 3.<span style= 'font:7.0pt "Times New Roman"'> </span> <b>You can change the font size</b> using Ctrl-Scroll-Up or Ctrl-Scrolll-Down. <b><br /> <br /></b></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135473"></a><a name="_HTML_Editor_for"></a>HTML Editor for Email Message Body</h3> <p class="MsoNormal"><br /> When editing email message body, you can elect to activate an HTML editor as shown below.<br /> This allows you to design and preview HTML email messages.<br /> In Windows 8 or higher, the HTML editor also provides a <span style='background: yellow'>spell checker</span> (that is why “Noot” is highlighted):<br /> <br /> <img border="0" width="734" height="330" id="Picture 41" src= "ActionQ_User_Manual_files/image041.png" alt="image" name= "Picture 41" /><br /> </p> <p class="MsoNormal"><a name="_View_Dynamic_Tokens_1"></a>Turning on the Preview checkbox shows a Preview with dynamic token values:<br /> <br /> <img border="0" width="731" height="329" id="Picture 43" src= "ActionQ_User_Manual_files/image042.png" alt="image" name= "Picture 43" /><br /> <br clear="all" style='page-break-before:always' /></p> <h3><a name="_Toc165135474"></a><a name= "_View_Dynamic_Tokens_2"></a><a name= "_Using_{aq_HTML_Table}_Token"></a>Using {aq_HTML_Table} Token in Email Responses</h3> <p class="MsoNormal"><br /> ActionQ automatically loads event data as an HTML table into a token called <span style= 'background:yellow'>{aq_HTML_Table}</span>.<br /> <img border="0" width="684" height="393" id="Picture 68" src= "ActionQ_User_Manual_files/image043.png" alt="image" name= "Picture 68" /><br /> <br /> Using the email message editor, you can place that token inside HTML email messages:<br /> <img border="0" width="682" height="270" id="Picture 72" src= "ActionQ_User_Manual_files/image044.png" alt="image" name= "Picture 72" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">Since the HTML table shows all event rows, it makes sense to use it in email responses that are designated to fire ONCE rather than for EACH event row.<br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <p class="MsoNormal">Clicking the <b><i>Preview</i></b> checkbox, replaces the token with its dynamic value, displaying a nicely formatted table:</p> <p class="MsoNormal"><br /> <img border="0" width="720" height="397" id="Picture 75" src= "ActionQ_User_Manual_files/image045.png" alt="image" name= "Picture 75" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal">ActionQ formats the HTML table using inline CSS to ensure it renders properly in email clients such as <i>Gmail</i>:<br /> <br /> <img border="0" width="734" height="265" id="Picture 76" src= "ActionQ_User_Manual_files/image046.png" alt="image" name= "Picture 76" /><br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135475">Using {aq_HTML_Table} Token in Email Responses</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135476">View Dynamic Tokens for Each Process</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">When a process is triggered for the first time after the ActionQ service is restarted, a text file is created to document the dynamic tokens for that process.<br /> The text file is named as: <b><span style= 'font-family:"Courier New"'>Tokens_<ProcessName>.txt<br /></span></b> It is created in the ProgramData folder (see next section).</p> <p class="MsoNormal"> </p> <p class="MsoNormal">You can open the tokens documentation file for each process by clicking the <b><i>Tokens</i></b> toolbar button:</p> <p class="MsoNormal"><br /> <img border="0" width="761" height="217" id="Picture 38" src= "ActionQ_User_Manual_files/image047.jpg" alt="image" name= "Picture 38" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal">Example for an event triggered by email:</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{EmailDT}</span></b> <=> Fri, 22 Jan 2021 14:09:06 -0500</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{BodyText}</span></b> <=> test</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Subject}</span></b> <=> Please Send Sales Report</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{ReplyTo}</span></b> <=></p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{FromAddress}</span></b> <=> ido.millet@gmail.com</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Attachments}</span></b> <=></p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">Example for an event triggered by SQL</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{How_Many}</span></b> <=> 1</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Cust_Name}</span></b> <=> Dwight Wyse</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Cust_ID}</span></b> <=> 1</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">Example for an event triggered by Folder event:</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Move2_Folder}</span></b> <=> C:\Visual CUT\vcQ\Queued</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Extension}</span></b> <=> .cmd</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{DateTimeStamp}</span></b> <=> 20210122135722</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{FileNameNoExtension}</span></b> <=> QFolder_Test</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{Watch_Folder}</span></b> <=> C:\Users\ixm7\OneDrive – MS\VC_QFolder</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{FileName}</span></b> <=> QFolder_Test.cmd</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{FileFullPath}</span></b> <=> C:\Users\ixm7\OneDrive - MS\VC_QFolder\QFolder_Test.cmd</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #FFC000'>{MovedFileFullPath}</span></b> <=> C:\Visual CUT\vcQ\Queued\QFolder_Test.cmd</p> </div> <p class="MsoNormal"><br /> <br /></p> <p class="MsoListParagraph"><span style= 'background:white'> </span></p> <p class="MsoListParagraph"><span style='background:white'><br /> <br /></span></p> <h1><a name="_Toc165135477"></a><a name= "_Monitoring_Snapshot_and"></a>Event Types</h1> <p class="MsoNormal"> </p> <h2><a name="_Toc165135478">"Folder_Not_Empty" Event Type</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of options section for this type of event:</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [VC_QFolder]</p> <p class="MsoNormal" style='border:none;padding:0in'> Event_Type="<b>Folder_Not_Empty</b>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Sleep_Multiplier="3"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: aqua'>Watch_Folder</span>="C:\Users\ixm7\OneDrive - The Pennsylvania State University\VC_QFolder\"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>Move2_Folder</span>="C:\Visual CUT\vcQ\Queued\"<br /> Target_Files="*.cmd;*.bat"<br /> Renamed_File=""<br /> SQL_After_Connection=""</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_After=""</p> <p class="MsoNormal" style='border:none;padding:0in'> <b>EXE2Call</b>="C:\Program Files (x86)\Visual CUT 11\Visual CUT.exe"</p> <p class="MsoNormal" style='border:none;padding:0in'> <b>Arguments_Template</b>=""Batch:QFolder_P1>>0>>""</p> <p class="MsoNormal" style='border:none;padding:0in'> Call_When="Once"</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">In the example above, ActionQ will move any <b>.cmd</b> or <b>.bat</b> files in the <span style= 'background:aqua'>Watch_Folder</span> to the <span style= 'background:yellow'>Move2_Folder</span> and then trigger Visual CUT with a command line argument requesting processing of all batch files in that folder.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="760" height="428" id= "Picture 5" src="ActionQ_User_Manual_files/image048.jpg" alt= "image" name="Picture 5" /></p> <p class="MsoNormal"><br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h3><a name="_Toc165135479">Dynamic Tokens for Response Logic</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">This event supports embedding these tokens in the response logic (SQL, App arguments, Email): Argument_Template: <span style='background: #FFC000'>{Watch_Folder}</span> <span style='background:#FFC000'>{Move2_Folder}</span> <span style= 'background:#FFC000'>{FileName}</span> <span style= 'background: #FFC000'>{FileNameNoExtension} {Extension} {FileFullPath}</span> <span style= 'background:#FFC000'>{MovedFileFullPath} {DateTimeStamp}<br /> <br /></span></p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135480"></a><a name= "_Dynamic_Tokens_for"></a>Dynamic Tokens for Renaming Files</h3> <p class="MsoNormal"> </p> <p class="MsoNormal">If the Mover2_folder already contains the target file, the event logs & emails a failure message. To avoid such failures, the Renamed_File property allows you to dynamically rename the incoming file:</p> <p class="MsoNormal"> </p> <p class="MsoListParagraph" style='text-indent:-.25in'> 1.<span style= 'font:7.0pt "Times New Roman"'> </span> You can inject into the Renamed_File property tokens such as:<br /> {FileNameNoExtension}, {Extension}, and {DateTimeStamp}<br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 2.<span style= 'font:7.0pt "Times New Roman"'> </span> You can inject current date/time with flexible formatting using {<span style= 'font-family:"Arial Black",sans-serif;background:yellow'>[fdt]</span><span style='background:aqua'>DateTimeFormatString</span>} tokens.<br /> <br /> The <span style= 'font-family:"Arial Black",sans-serif;background:yellow'>[fdt]</span> prefix instruct ActionQ to format the current date & time according to the formatting string.<br /> See Microsoft Date/Time formatting string documentation: <span class="MsoHyperlink"><a href= "https://bit.ly/3tOW7S0">https://bit.ly/3tOW7S0</a></span><br /> <br /> For example, if <b><i>Renamed_File</i></b> is: <b><span style= 'background:lime'>{FileNameNoExtension}</span>_{</b><b><span style= 'font-family:"Arial Black",sans-serif;background:yellow'>[fdt]</span><span style='background:aqua'>yyMMdd_HHmm</span>}<span style='background:fuchsia'>{Extension}</span></b><br /> an incoming <b><span style= 'background:lime'>Claims</span><span style= 'background:fuchsia'>.csv</span></b> file may be renamed to '<span style='background:lime'>Claims</span>_<span style= 'background:aqua'>210917_0445</span><span style= 'background:fuchsia'>.csv</span><br /> <br /></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 3.<span style= 'font:7.0pt "Times New Roman"'> </span> You Can add a counter, using a token such as <span style= 'font-family: "Arial Black",sans-serif;background:yellow'>{[V]N</span><span style='font-family: "Arial Black",sans-serif;background:aqua'>4</span><span style='font-family: "Arial Black",sans-serif;background:yellow'>}</span>, to ensure unique file name.<br /> This token would be replaced by 4 digits (right-padded with 0’s) and incremented to a number ensuring a unique file name.<br /> <br /> For example, if <b><i>Renamed_File</i></b> is: <b><span style= 'background:lime'>{FileNameNoExtension}</span>_</b><span style= 'font-family:"Arial Black",sans-serif;background:yellow'>{[V]N</span><span style='font-family:"Arial Black",sans-serif;background:aqua'>4</span><span style='font-family:"Arial Black",sans-serif;background:yellow'>}</span><b><span style='background:fuchsia'>{Extension}</span></b><br /> an incoming <b><span style= 'background:lime'>Claims</span><span style= 'background:fuchsia'>.csv</span></b> file may be renamed to '<span style='background:lime'>Claims</span>_<span style= 'background:aqua'>0001</span><span style= 'background:fuchsia'>.csv</span>‘<br /> If that file already exists, ActionQ will try '<span style= 'background:lime'>Claims</span>_<span style= 'background:aqua'>0002</span><span style= 'background:fuchsia'>.csv</span>‘ etc.<br /> <br /></p> <p class="MsoNormal" style='margin-left:.25in'> </p> <p class="MsoNormal" style='margin-left:.25in'> </p> <p class="MsoNormal"><br /> .<br /> <br /> <br clear="all" style='page-break-before:always' /></p> <h2><a name="_Toc165135481">Database Events</a></h2> <p class="MsoNormal">The choice between database event types depends on how you wish to avoid repeat responses:</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span class="MsoHyperlink"><b><i><a href= "start.htm#_"DB_LastMaxN"_Event_Type">DB_LastMaxN</a></i></b></span> events avoid repeat responses by tracking an auto-increment key and responding only to records a key larger than the max value seen before.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span class="MsoHyperlink"><b><i><a href= "start.htm#_"DB_Flag"_Event_Type">DB_Flag</a></i></b></span> events avoid repeat responses by updating the database. For example, they may set a ‘Processed’ column for the new record(s) to true.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span class="MsoHyperlink"><b><a href= "start.htm#_"DB_Mirror_Skip_Remove_T1"_Event_Ty">DB_Mirror_Skip_Remove_T1</a></b></span> events avoid repeat responses by automatically creating & maintaining a Mirror table. If you are not allowed to touch the source database (e.g. an ERP system), you can direct the mirror table to a different database.<br /> <br /></p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135482"></a><a name= "_Source_SQL_Template_Editor"></a>Source_SQL_Template Editor</h3> <p class="MsoNormal">All database events use a SQL statement (SELECT or, for stored procedures, EXEC) to identify new events.<br /> When you click to edit the Source_SQL_Template property, a special editor helps you test the SQL by displaying the result set.<br /> Upon a test, the editor also populates dynamic tokens based on the column names and values found in the first row. This facilitates constructing dynamic event responses incorporating these tokens.</p> <p class="MsoNormal"> <br /> <img border="0" width="632" height="393" id="Picture 36" src= "ActionQ_User_Manual_files/image049.png" alt="image" name= "Picture 36" /> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><a name= "_"DB_LastMaxN"_Event_Type"></a><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135483"></a><a name="_Using_a_Stored"></a>Using a Stored Procedure as Data Source</h3> <p class="MsoNormal">The image below demonstrates using a Stored Procedure as the data source for an event.<br /> This happens to be a <b><i>DB_Mirror_Skip_Remove_T1</i></b> event type. So, after populating the data, a button becomes visible, allowing you to display only rows that are not in the mirror table. See <span class="MsoHyperlink"><a href= "https://youtu.be/xFoh8JeyNa0">video demo</a></span>.<br /> <br /> <img border="0" width="728" height="442" id="Picture 67" src= "ActionQ_User_Manual_files/image050.png" alt="image" name= "Picture 67" /><br clear="all" style= 'page-break-before: always' /></p> <h3><a name="_Toc165135484">"DB_LastMaxN" Event Type</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of options section for this type of event:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Invoice_Overdue]</p> <p class="MsoNormal" style='border:none;padding:0in'> Event_Type="<b>DB_LastMaxN</b>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Sleep_Multiplier="6"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: #CCC0D9'>Source_Connection</span>="ERP"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: aqua'>Source_SQL_Template</span>="Select [Web_Request] From Command_Queued Where [ID] > <span style= 'background:#FFC000'>{LastMaxN}</span> ORDER BY [ID] ASC"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: fuchsia'>SQL_Statement_Subquery</span>=</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: lime'>LastMaxN</span>="1023"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>LastMaxN_ColumnName</span>="ID"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: #DBE5F1'>SQL_After_Connection</span>=""</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: #DBE5F1'>SQL_After</span>=""</p> <p class="MsoNormal" style='border:none;padding:0in'> <b>EXE2Call</b>="C:\Program Files (x86)\Visual CUT 11\Visual CUT.exe"</p> <p class="MsoNormal" style='border:none;padding:0in'> <b>Arguments_Template</b>="-e <span style= 'background:#FFC000'>{Web_Request}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Call_When="Each"</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal"><span style= 'background:#FFC000'>{LastMaxN}</span> <span style= 'background:white'>is a dynamic token replaced with the maximum value seen by ActionQ for the</span> <span style= 'background:yellow'>LastMaxN_ColumnName</span> in the query result set returned by the <span style= 'background:aqua'>Source_SQL_Template</span>.</p> <p class="MsoNormal">That maximum value is maintained for each event in memory as well as in the <span style= 'background:lime'>LastMaxN</span> entry in the event’s ini section. That is why it can be used in the SQL statement to restrict the returned rows to only new ones.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">The value in any column returned by the <span style='background:aqua'>source query</span>, <span style= 'background:fuchsia'>Subquery</span>, and <span style= 'background:#DBE5F1'>SQL_After</span> query can be used as a dynamic token in any later actions. In the example above, the argument template passed the value found in <span style= 'background:#FFC000'>{Web_Request}</span> to Visual CUT for processing. <b>This allows any application to trigger reports and emails by simply inserting a new record into a database table</b>.<br /> <br /> Notes:</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The <span style='background:lime'>LastMaxN</span> entry in <b>ActionQ.ini</b> is read and used only for initialization purposes. Once a new LastMaxN value is established, it is written to <b>ActionQ_Data.ini</b> file. From that point on, it is read and managed by the service only at that location. That ensures the ActionQ service never attempts to write to the ActionQ.ini file (which might be open for editing by you at the same time). So:<br /> <b>ActionQ.ini</b> is for you to change settings<br /> <b>ActionQ_Data.ini</b> is for the service to persist values in case the service gets stopped.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> You can use any column names in the SQL result set as dynamic tokens.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:#CCC0D9'>Source_Connection</span> <span style='background:white'>refers to a connection string entry in the [Connection_Strings] ini section. To protect passwords, those entries can refer to encrypted strings as explained in <span class="MsoHyperlink"><a href= "start.htm#_Managing_Encrypted_Strings">Managing Encrypted Strings</a></span>.</span></p> <p class="MsoNormal"><br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h3><a name="_Toc165135485"></a><a name= "_"DB_Flag"_Event_Type"></a>"DB_Flag" Event Type</h3> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of options section for this type of event:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Report_Request]</p> <p class="MsoNormal" style='border:none;padding:0in'> Event_Type="<b>DB_Flag</b>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Sleep_Multiplier="4"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: #CCC0D9'>Source_Connection</span>="ERP"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: aqua'>Source_SQL_Template</span> ="Select * From Command_Queued_Flag Where [Processed] = 0"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: fuchsia'>SQL_Statement_Subquery</span>=</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: #DBE5F1'>SQL_After_Connection</span>="ERP"</p> <p class="MsoNormal" style='border:none;padding:0in'> <b><span style='background: #DBE5F1'>SQL_After</span></b>="Update Command_Queued_Flag Set [Processed]=1 WHERE ID = <span style= 'background:#FFC000'>{ID}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> EXE2Call="C:\Program Files (x86)\Visual CUT 11\Visual CUT.exe"</p> <p class="MsoNormal" style='border:none;padding:0in'> Arguments_Template="-e <span style= 'background:#FFC000'>{Report}</span> <span style= 'background:#FFC000'>{Arguments}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Call_When="Each"</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal"><b><span style= 'background:#DBE5F1'>SQL_After</span></b> <span style= 'background:white'>is executed for each row in the result set. In this case, it uses a token of one of the columns in the result set (</span><span style='background:#FFC000'>{ID}</span><span style= 'background:white'>) to update a Status to ‘Processed.’ This avoids duplicate processing.<br /> In a similar way, it uses two other columns from the source query (</span><span style='background:#FFC000'>{Report}</span> and <span style='background:#FFC000'>{Arguments}</span><span style= 'background:white'>) to pass dynamic arguments to the called executable.</span></p> <p class="MsoNormal"><br /> Notes:</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> You can use any column names in the SQL result sets as dynamic tokens.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:#CCC0D9'>Source_Connection</span> <span style='background:white'>and</span> <span style= 'background:#DBE5F1'>SQL_After_Connection</span> <span style= 'background:white'>refer to a connection string entry in the [Connection_Strings] ini section. To protect passwords, those entries can refer to encrypted strings as explained in <span class= "MsoHyperlink"><a href= "start.htm#_Managing_Encrypted_Strings">Managing Encrypted Strings</a></span>.</span></p> <p class="MsoNormal"><br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h3><a name="_Toc165135486"></a><a name= "_"DB_Mirror_Skip_Remove_T1"_Event_Ty"></a>"DB_Mirror_Skip_Remove_T1" Event Type</h3> <p class="MsoNormal"> </p> <p class="MsoNormal"><span class="MsoHyperlink"><a href= "../../../../../../../../Documents/VBNET/ActionQ/ActionQ_Manager/Video%20demo"> Video demo</a></span> of using <b><i>ActionQ</i></b> to monitor the health of a SQL Server using this type of event.<br /> <br /> This diagram shows the general logic:<br /> <img border="0" width="659" height="269" id="Picture 22" src= "ActionQ_User_Manual_files/image051.png" alt="image" name= "Picture 22" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of options section for this type of event:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Credit_Hold]</p> <p class="MsoNormal" style='border:none;padding:0in'> Event_Type="<b>DB_Mirror_Skip_Remove_T1</b>"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: lime'>Mirror_Connection</span>="SQLExpress_Mirror"</p> <p class="MsoNormal" style='border:none;padding:0in'>; mirror table always named as 'aqm_<Event_Name>'. so for this event: aqm_Credit_Hold).</p> <p class="MsoNormal" style='border:none;padding:0in'> Sleep_Multiplier="4"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: #CCC0D9'>Source_Connection</span> ="ERP"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: aqua'>Source_SQL_Template</span> ="Select <span style= 'background:fuchsia'>Cust_ID</span> From Customer WHERE Credit_Hold = 1"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: fuchsia'>SQL_Statement_Subquery</span>= "Select Cust_ID,Date,Amount,Balance_After FROM Payments<br /> WHERE Cust_ID = <span style= 'background:fuchsia'>{Cust_ID}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> EXE2Call="C:\Program Files (x86)\Visual CUT 11\Visual CUT.exe"</p> <p class="MsoNormal" style='border:none;padding:0in'> Arguments_Template="-e "C:\Visual CUT\vcQ\Credit_Hold.rpt" "Parm1:{Cust_ID}""</p> <p class="MsoNormal" style='border:none;padding:0in'> Call_When="Each"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>Failure_Retry_Minutes</span>="5"</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">This type of event avoids duplicate processing by maintaining a mirror table with rows retrieved last time by the source Query. The mirror table is created automatically be ActionQ based on the column names and data types in the source query. It is names as <b><span style= 'background: lime'>aqm_</span><Event_Name></b>.<br /> so for the event above the mirror table name is <b><span style= 'background: lime'>aqm_</span></b><span style= 'background:lime'>Credit_Hold</span>.</p> <p class="MsoNormal"><br /> In the source query, any row that matches an existing row in the Mirror table gets <b>skipped</b>.<br /> <b>Column names starting with a space are not included in this logic</b>. That allows you to include extra data for event responses, but treat only some columns as keys in determining if a new event is a duplicate.</p> <p class="MsoNormal"><br /> In the Mirror table, any row that is no longer in the source query gets <b>removed</b>. For example, if the customer is no longer on credit hold, removing that row from the Mirror table allows ActionQ to recognize a case when the same customer is placed on a new credit Hold.<br /> <br clear="all" style='page-break-before:always' /></p> <p class="MsoNormal">This event type is particularly useful for cases where the source SQL comes from an ERP or Cloud database where you have no Modify permissions. Setting the <span style= 'background:lime'>Mirror_Connection</span> to another database where you have full permissions, allows you to maintain the Mirror table in the database of your choice.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">Besides using column names that start with a space to indicate they are not key columns for detecting new events, another option is to include only key columns that identify true duplicates. For example, in the case above, the source query returns just the Cust_ID column. The <span style= 'background:fuchsia'>SQL_Statement_Subquery</span> is used to access more database details. As demonstrated above, the <span style='background:fuchsia'>SQL_Statement_Subquery</span> can be <span style='background:yellow'>correlated</span> to the main query or the main event (File or email) by referencing tokens (e.g. <span style='background:fuchsia'>{Cust_ID}</span>) from the main event.<br /> <br /> The <span style='background:fuchsia'>SQL_Statement_Subquery</span> can also be used in cases where the event data has <span style= 'background:yellow'>one to many relationship to desired database information</span>. For example, in the case above, the database event identifies customers placed on hold. But for each such customer you wish to email a manager an HTML table containing that customer's payment and balance history.</p> <p class="MsoNormal"><br /> Notes:</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> ActionQ facilitates using any property name in the result set as a dynamic token in responses.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:#CCC0D9'>Source_Connection</span> <span style='background:white'>and</span> <span style= 'background:lime'>Mirror_Connection</span> <span style= 'background:white'>refer to a connection string entry in the [Connection_Strings] ini section. To protect passwords, those entries can refer to encrypted strings as explained in <span class= "MsoHyperlink"><a href= "start.htm#_Managing_Encrypted_Strings">Managing Encrypted Strings</a></span>.</span></p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:yellow'>Failure_Retry_Minutes</span> is an optional setting available to all processes. See <span class= "MsoHyperlink"><a href="start.htm#_Setting_Failure_Retry">Setting Failure Retry Period</a></span>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>Column names starting with a space</b> are not included in detecting new events by comparing to the mirror table. You can think of them as non-keys. To save space, increase speed, and improve security, only key columns are stored in the mirror table. This also improves resiliency because you can add/remove/change non-key columns to the event design without breaking the mirror table logic.<br /> <br /> <br /></p> <p class="MsoNormal"><br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h2><a name="_Toc165135487"></a><a name= "_PowerShell_"PS_Mirror_Skip_Remove_T"></a>PowerShell "PS_Mirror_Skip_Remove_T1" Event Type</h2> <p class="MsoNormal"> </p> <p class="MsoNormal">This is very similar to DB_Mirror_Skip_Remove_T1 except that the source event is a PowerShell script rather than an SQL statement. The PowerShell script (.ps1 file) returns a collection of PowerShell objects as a result. ActionQ parses that result into a data table, similar to how it parses the data returned by an SQL event.<br /> <br /></p> <h3><a name="_Toc165135488">Calling REST APIs such as RabbitMQ</a></h3> <p class="MsoNormal">PowerShell is very flexible and powerful. You can leverage this event type to get data from many types of data sources. For example, you can call any <b><i>REST API</i></b> and not only return data but also "shape" (filter columns/rows, rename columns, add columns). For a good introduction to how you can call REST APIs from PowerShell see <span class="MsoHyperlink"><a href= "https://adamtheautomator.com/invoke-restmethod/">this blog</a></span>. For discussion of how you can call <b><i>RabbitMQ</i></b> via PowerShell, see <span class= "MsoHyperlink"><a href= "https://ramblingcookiemonster.github.io/RabbitMQ-Intro/">this blog</a></span>.<br /> <br /></p> <h3><a name="_Toc165135489">Typical Properties</a></h3> <p class="MsoNormal">Here is an example of options section for this type of event:<br /> <br /></p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Disk_Full]</p> <p class="MsoNormal" style='border:none;padding:0in'> Event_Type="<b>PS_Mirror_Skip_Remove_T1</b>"<br /> <span style= 'background:aqua'>PS2Call</span>="C:\PS\Disks_Getting_Full.ps1"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: lime'>Mirror_Connection</span>="Mirror"</p> <p class="MsoNormal" style='border:none;padding:0in'> Sleep_Multiplier="5"</p> <p class="MsoNormal" style='border:none;padding:0in'> EXE2Call="PowerShell.exe" ; call any EXE, batch file, REST API, or PowerShell as in this example</p> <p class="MsoNormal" style='border:none;padding:0in'> Arguments_Template= "-NoProfile -ExecutionPolicy Bypass -Command "C:\PS\my.ps1 –log {Name}.txt";"</p> <p class="MsoNormal" style='border:none;padding:0in'> Call_When="Each"</p> <p class="MsoNormal" style='border:none;padding:0in'><span style= 'background: yellow'>Failure_Retry_Minutes</span>="0"<br /> SQL_After="Insert into [dbo].[ActionQ_PowerShell_Log] values (GetDate(), 'Low Disk Space', '{DeviceID}{VolumeName}, Size: {Size(GB)}GB, { FreeSpace(%)}% free.');"</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_When="Each"</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_After_Connection="ERP"<br /> SMTP_Settings="Email_From_IT"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_To="ido.millet@gmail.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Subject="Disk Full Alert "</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Message="<HTML> …disks are getting full<p>{ps_HTML_Table}</p> … </HTML>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_When="Once"</p> </div> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <h3><a name="_Toc165135490">Avoiding Duplicate Processing</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="571" height="209" id= "Picture 77" src="ActionQ_User_Manual_files/image052.png" alt= "image" name="Picture 77" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">This type of event avoids duplicate processing by maintaining a mirror table with rows of results returned last time by the triggering PowerShell script. The mirror table is created automatically be ActionQ based on the properties of the PowerShell objects collection returned by the script. It is names as <b><span style= 'background:lime'>aqm_</span><Event_Name></b>.<br /> so for the event above the mirror table name is <b><span style= 'background: lime'>aqm_Disk_Full</span></b>.<br /> <br /> In the source query, any row that matches an existing row in the Mirror table gets <b>skipped</b>.<br /> <b>Column names starting with a space are not included in this logic</b>. That allows you to include extra data for event responses, but treat only some columns as keys in determining if a new event is a duplicate.</p> <p class="MsoNormal">In the Mirror table, any row that is no longer in the source query gets <b>removed</b>. For example, if the disk is no longer full, removing that row from the Mirror table allows ActionQ to recognize a case when the same disk is again getting full.<br /> <br /></p> <p class="MsoNormal">Note: to allow ActionQ to parse the results of the PowerShell script, let the script return PowerShell's default objects. Do NOT pipe the results into text tables for display.<br /> <br /> Notes:</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> ActionQ facilitates using any property name in the result set as a dynamic token in responses.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:lime'>Mirror_Connection</span> <span style= 'background:white'>refer to a connection string entry in the [Connection_Strings] ini section. To protect passwords, those entries can refer to encrypted strings as explained in <span class= "MsoHyperlink"><a href= "start.htm#_Managing_Encrypted_Strings">Managing Encrypted Strings</a></span>.</span></p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:yellow'>Failure_Retry_Minutes</span> is an optional setting available to all processes. See <span class= "MsoHyperlink"><a href="start.htm#_Setting_Failure_Retry">Setting Failure Retry Period</a></span>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>Column names starting with a space</b> are not included in detecting new events by comparing to the mirror table. You can think of them as non-keys. To save space, increase speed, and improve security, only key columns are stored in the mirror table. This also improves resiliency because you can add/remove/change non-key columns to the event design without breaking the mirror table logic.<br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135491">"Email_POP3_T1" Event Type</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">This event type responds to incoming emails by triggering dynamic processes or database updates. It can detect and use text tokens within the email subject/body/attachments to trigger different actions.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135492">Typical Use Case:</a></h3> <p class="MsoNormal">Imagine a customer was placed on credit hold (Credit_Hold column set to True in the database):<br /> <br /></p> <p class="MsoNormal"><img border="0" width="688" height="46" id= "Picture 11" src="ActionQ_User_Manual_files/image053.png" alt= "image" name="Picture 11" /><br /> <br /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">A Database event in <b><i>ActionQ</i></b> detects this and uses <b><i>Visual CUT</i></b> to email the VP of Sales:<br /> <br /></p> <p class="MsoNormal"><img border="0" width="622" height="388" id= "Picture 21" src="ActionQ_User_Manual_files/image054.png" alt= "image" name="Picture 21" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">The manager can then manually reply and add the text <b><i>Reverse</i></b> or <b><i>Approve</i></b> in a designated text area.<br /> Or, better yet, the manager can simply click one of the decision buttons.<br /> Those buttons are just images with mailto hyperlinks.<br /> <br /></p> <p class="MsoNormal">You can use a <span style= 'background:white'>web site such as <span class= "MsoHyperlink"><a href= "http://buttonoptimizer.com/">this</a></span> to generate the <b>button images</b> and <span class="MsoHyperlink"><a href= "http://mailto.co.uk/">this</a></span> to generate <b>mailto</b> syntax as hyperlinks for these images.<br /> For example:</span></p> <p class="MsoNormal"><span style= 'font-family:"Courier New";background:white'><A href="<span style= 'background:yellow'>mailto:</span>invoice@milletsoftware.com?<span style='background:yellow'>subject=</span>Credit Hold Decision for {Customer.Cust_Name}&amp;<span style= 'background:yellow'>body=</span>[Cust_ID: <span style= 'background:aqua'>2</span>] [Decision: <span style= 'background: aqua'>Reverse</span>]"><br /> <<span style='background:yellow'>IMG src=</span>"file:///C:/Visual CUT/vcQ/<b>Reverse.png</b>"></A><br /> <br /></span></p> <p class="MsoNormal"><span style='background:white'><br /> <br /></span></p> <p class="MsoNormal">Clicking on the <b><i>Reverse</i></b> button triggers the following email message dialog.<br /> The manager can then simply click <b><i>Send</i></b>:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="685" height="269" id= "Picture 26" src="ActionQ_User_Manual_files/image055.png" alt= "image" name="Picture 26" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><br /> Another event in ActionQ (of type <b>Email_POP3_T1</b>) then:</p> <p class="MsoListParagraph" style= 'margin-left:39.0pt;text-indent:-.25in'>1.<span style= 'font:7.0pt "Times New Roman"'> </span> Detects that incoming email</p> <p class="MsoListParagraph" style= 'margin-left:39.0pt;text-indent:-.25in'>2.<span style= 'font:7.0pt "Times New Roman"'> </span> Collects data in tokens such as [Cust_ID: <b><span style= 'color:black;background:aqua'>1</span></b>] and [Decision: <b><span style= 'color:black;background:aqua'>Approve</span></b>].</p> <p class="MsoListParagraph" style= 'margin-left:39.0pt;text-indent:-.25in'>3.<span style= 'font:7.0pt "Times New Roman"'> </span> Responds by updating the database, so the customer record changes to:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="689" height="43" id= "Picture 16" src="ActionQ_User_Manual_files/image056.png" alt= "image" name="Picture 16" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal">If, for another case, the manager indicates <b><i>Reverse</i></b>, ActionQ would issue a <b>different SQL statement</b><br /> resulting in a customer record shown for Ken Hamady:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="687" height="64" id= "Picture 17" src="ActionQ_User_Manual_files/image057.png" alt= "image" name="Picture 17" /> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"><br /> This demonstrates the ability to <b>automate workflows by chaining multiple events</b>.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135493">Setting Default Email Client</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">When a user clicks a mailto link, if the wrong email client opens up (e.g. Outlook instead of Gmail), the user can change their default email client. <br /> In Windows, head to Settings > Apps > Default apps. Scroll down and pick <b><i>Choose default apps by protocol</i></b>. For ‘Mailto’, choose the client of your choice. For Gmil, select Google Chrome.</p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135494">Email Server and Inbox Settings</a></h3> <p class="MsoNormal">Multiple events can target the same inbox. Server/Inbox settings are specified like this:</p> <p class="MsoNormal"> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Email_Server_InBoxes]</p> <p class="MsoNormal" style='border:none;padding:0in'> MilletSoftware_Invoice=host4.hostmonster.com||invoice@MilletSoftware.com||ES_MS_Password||10</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">The 4 elements are: the server, the inbox email account, the encrypted password name, and the maximum number of emails to inspect in each scan cycle.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135495">Event Settings</a></h3> <p class="MsoNormal">Each <b><i>Email_POP3_T1</i></b> event has a section with settings such as these:</p> <p class="MsoNormal"> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Credit_Hold_Decision]</p> <p class="MsoNormal" style='border:none;padding:0in'> Event_Type="<b>Email_POP3_T1</b>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Email_Server_InBox="MilletSoftware_Invoice"</p> <p class="MsoNormal" style='border:none;padding:0in'> Sleep_Multiplier="10"</p> <p class="MsoNormal" style='border:none;padding:0in'> Filter="(Subject contains "Decision Needed: Credit Hold" AND From contains "ido@milletsoftware.com")"</p> <p class="MsoNormal" style='border:none;padding:0in'> Message_Sent_in_Last_N_Minutes="9000"</p> <p class="MsoNormal" style='border:none;padding:0in'> Save_As_EML_To_Folder="C:\Visual CUT\Invoice_Requests\eml\"</p> <p class="MsoNormal" style='border:none;padding:0in'> Save_Attachments_To_Folder=""</p> <p class="MsoNormal" style='border:none;padding:0in'> Save_Attachments_To_Unique_File_Names="true"<br /> Delete_Email_From_Server="true"</p> <p class="MsoNormal" style='border:none;padding:0in'> Parse_Expressions="Cust_ID:::\d{5,6}|||Cust_Email:::\S+@\S+\.([a-zA-Z0-9])+"</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_After_Connection="ERP"</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_After="SQL_IF_<span style= 'background:#FFC000'>{Decision}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_IF_<span style='background:yellow'>Reverse</span>="Update Customer Set Credit_Hold = <span style= 'background:#DBE5F1'>0</span>, Credit_Hold_Reversed_By='<span style='background:#FFC000'>{FromAddress}</span>', <br /> Credit_Hold_Decision_DT=GETDATE() WHERE Cust_ID = <span style= 'background:#FFC000'>{Cust_ID}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> SQL_IF_<span style='background:yellow'>Approve</span>="Update Customer Set Credit_Hold_Approved_By='<span style= 'background:#FFC000'>{FromAddress}</span>',<br /> Credit_Hold_Decision_DT=GETDATE() WHERE Cust_ID = <span style= 'background:#FFC000'>{Cust_ID}</span>"</p> <p class="MsoNormal" style='border:none;padding:0in'> Call_When="Each"<br /> EXE2Call=""<br /> Arguments_Template=""<br /> <br /></p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">The <b><i>Email_Server_InBox</i></b> entry points at the corresponding server and inbox this event monitors.</p> <p class="MsoNormal"><br /> The <b><i>Filter</i></b> entry specifies what email messages within that inbox are targeted. Here are some examples:<br /> Subject <span style='background:yellow'>like</span> "Re: Credit Hold<span style='background:yellow'>*</span>"<br /> Subject <span style='background:yellow'>contains</span> "Trip Cancelation" and From = "Cruises@Titanic.com"<br /> Any email header field name can be used, case is insensitive.</p> <p class="MsoNormal">The "*" wildcard matches 0 or more occurrences of any character.</p> <p class="MsoNormal">Parentheses can be used to group conditions.</p> <p class="MsoNormal">The logical operators are: AND, OR, NOT (case insensitive)</p> <p class="MsoNormal">Comparison operators are: =, <, >, <=, >=, <></p> <p class="MsoNormal">String comparison operators are: CONTAINS, LIKE (case insensitive)<br /> <br /> <br /></p> <b><i><span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span></i></b> <p class="MsoNormal"><b><i> </i></b></p> <p class="MsoNormal"><b><i>Message_Sent_in_Last_N_Minutes</i></b> entry allows only newer messages to be targeted.<br /> <br /> <b><i>Save_As_EML_To_Folder</i></b> entry, if populated, directs the process to download the messages as eml files.<br /> <br /> <b><i>Save_Attachments_To_Folder</i></b> and <b><i>Save_Attachments_To_Unique_File_Names</i></b> entries control if, how, and to what folder attachments are downloaded. If attachments are downloaded, ActionQ maintains an <span style= 'background:#FFC000'>{Attachments}</span> token with the list of downloaded files separated by ‘||’.</p> <p class="MsoNormal"><br /> <b><i>Delete_Email_From_Server</i></b> entry controls whether ActionQ deletes a targeted email message from the server after processing it. <b><span style= 'font-family:"Arial Black",sans-serif'>Important:</span></b> if this option is set to false, ActionQ avoids duplicate processing of old messages by tracking the maximum date & time found in the date header of already-processed messages.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is a screenshot showing the properties in the GUI:<br /> <img border="0" width="720" height="463" id="Picture 73" src= "ActionQ_User_Manual_files/image058.jpg" alt="image" name= "Picture 73" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <p class="MsoNormal">ActionQ parses dynamic tokens from each email message using two mechanisms:</p> <p class="MsoListParagraph" style='text-indent:-.25in'> 1.<span style= 'font:7.0pt "Times New Roman"'> </span> By Brackets (e.g. <span style= 'background:yellow'>[</span><span style= 'background:#FFC000'>Name</span><span style= 'background:yellow'>:</span> <span style= 'background:aqua'>Value</span><span style= 'background:yellow'>]</span> patterns located in message <b>subject</b> and <b>body</b></p> <p class="MsoListParagraph" style='text-indent:-.25in'> 2.<span style= 'font:7.0pt "Times New Roman"'> </span> By Regular Expressions matching text in message <b>subject</b>, <b>body</b>, and <b>attachments</b>.</p> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135496">Standard Dynamic Tokens</a></h3> <p class="MsoNormal">For email events, ActionQ populates these standard dynamic tokens:<br /> <span style='background:#FFC000'>{EmailDT}</span><span style= 'background:white'>,</span> <span style= 'background:#FFC000'>{FromAddress}</span><span style= 'background:white'>,</span> <span style= 'background:#FFC000'>{ReplyTo}</span>, <span style= 'background:#FFC000'>{Attachments}</span>,<span style= 'background: #FFC000'>{Subject}</span>, and <span style= 'background:#FFC000'>{BodyText}</span></p> <p class="MsoNormal">which can be referenced inside event responses (SQL statements, Command line arguments, Email messages):<br /> <br /></p> <h3><a name="_Toc165135497"></a><a name= "_Dynamic_Tokens_By"></a>Dynamic Tokens By Regular Expressions</h3> <p class="MsoNormal">Regular expressions allow you to extract values from text using very powerful and flexible expressions.<br /> You can specify multiple patterns using the Parse Expressions property of email events.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">For example:<br /> Parse_Expressions="<span style= 'background:#FFC000'>Cust_ID</span><span style= 'background:#92D050'>:::</span><span style= 'background:yellow'>\d{5,6}</span><span style= 'background:fuchsia'>|||</span><span style= 'background:#FFC000'>Cust_Email</span><span style= 'background:#92D050'>:::</span><span style= 'background:yellow'>\S+@\S+\.([a-zA-Z0-9])+</span>"<br /> tells ActionQ to parse the email message <b>subject</b>, <b>body</b>, as well as any <b>attachments</b> (with a file type that can be treated as text).<br /> If a pattern with 5-to-6 digits is found, it gets loaded into a <span style='background:#FFC000'>{Cust_ID}</span> token. <br /> If a pattern that looks like an email address is found, it gets loaded into a <span style='background:#FFC000'>{Cust_Email}</span> token. <br /> This use of such powerful patterns adds a lot of flexibility in automating responses to email messages based on message as well as attachments text.</p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135498">Dynamic Tokens By Brackets</a></h3> <p class="MsoNormal">In addition, ActionQ automatically scans the <b><i>subject</i></b> and <b><i>body</i></b> for tokens that look like this:<br /> <span style='background:yellow'>[</span><span style= 'background:#FFC000'>anyName</span><span style= 'background:yellow'>:</span> <span style= 'background:aqua'>anyValue</span><span style= 'background:yellow'>]</span> and loads them into tokens.<br /> For example, having the following text <b><span style= 'background:yellow'>[</span></b><span style= 'background:#FFC000'>Decision</span><b><span style= 'background:yellow'>: <span style= 'background:aqua'>Approve</span>]</span></b> anywhere within the <b><i>subject</i></b> or <b><i>body</i></b> of the email would result in a <span style='background: #FFC000'>{Decision}</span> token with a value of ‘<span style= 'background:aqua'>Approve</span>’.<br /> <br /> <br /></p> <h3><a name="_Toc165135499">SQL_After Logic</a></h3> <p class="MsoNormal">You can use the value of a dynamic token to control the SQL statement generated in response to the event.<br /> <br /></p> <p class="MsoNormal">For example, setting this event property: <b><i>SQL_After</i></b>="SQL_IF<span style= 'background:#FFC000'>_{Decision}</span>"</p> <p class="MsoNormal">indicates that the SQL statement to be triggered depends on the value of the <span style= 'background:#FFC000'>{Decision}</span> token.<br /> If the Decision value is <span style= 'background:aqua'>Reverse</span>, the statement specified by <b>SQL_IF_<span style='background:aqua'>Reverse</span></b> <span style='background:white'>is executed.<br /></span>If the Decision value is <span style='background:aqua'>Approve</span>, the statement specified by <b>SQL_IF_<span style= 'background:aqua'>Approve</span></b> <span style= 'background:white'>is executed.<br /> <br /></span></p> <p class="MsoNormal"><span style='background:white'>You can use any token(s) and any number of alternatives with this logic.<br /> If no matching ini entry is found, the SQL step is skipped.<br /> <br /> In the example above, the EXE2Call is left blank, but you are free to trigger just SQL, just EXE, both, or even none (for example, if you wish to use the process just for downloading targeted email attachments).</span></p> <p class="MsoNormal"><span style='background:white'><br /> <br /> <br /> <br /></span></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif;background: white'><br clear="all" style='page-break-before:always' /></span> <p class="MsoNormal"><span style= 'background:white'> </span></p> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h1><a name="_Toc165135500"></a><a name= "_Setting_Up_Alerts"></a>Setting Up Alerts for Windows Scheduled Task Failures</h1> <p class="MsoNormal"> </p> <p class="MsoNormal">ActionQ can alert you when <i>Windows Task Scheduler</i> fails a task. For example, when a scheduled task designed to trigger a batch file fails to locate the batch file.<br /> <br /> Simply add the following section to the ActionQ.ini file:</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'> [Scheduled_Tasks]</p> <p class="MsoNormal" style='border:none;padding:0in'> Monitor_Scheduled_Tasks=True</p> <p class="MsoNormal" style='border:none;padding:0in'> Every_N_Minutes=10</p> <p class="MsoNormal" style='border:none;padding:0in'> Ignore_Repeats_for_N_Minutes=1440</p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal">In the example above, ActionQ would check for failures every 10 minutes and would avoids duplicate alerts (same task name & error code) for 1440 minutes (24 hours). <br /> <br /> When failures are detected, the ActionQ administrator would receive an email alert such as this:<br /> <img border="0" width="734" height="240" id="Picture 42" src= "ActionQ_User_Manual_files/image059.png" alt="image" name= "Picture 42" /></p> <p class="MsoNormal"><br /> ActionQ monitors only <b>enabled</b> scheduled tasks under the <b>root folder</b> of task scheduler:<br /> <img border="0" width="634" height="204" id="Picture 45" src= "ActionQ_User_Manual_files/image060.png" alt="image" name= "Picture 45" /><br /> <br /> <br /> <br /> <br clear="all" style='page-break-before:always' /></p> <h1><a name="_Toc165135501">Monitoring Snapshot and Mirror Tables</a></h1> <p class="MsoNormal"> </p> <p class="MsoNormal">The <img border="0" width="75" height="24" id= "Picture 30" src="ActionQ_User_Manual_files/image061.png" alt= "image" name="Picture 30" /> button in the Action Manager menu launches a window displaying the <b><i>Snapshot</i></b> and/or <b><i>Mirror</i></b> tables for the currently selected event. Here is an example for an event that has both tables.<br /> <br /> This allows you to monitor that information for debugging and training purposes.</p> <p class="MsoNormal">Hit F5 to refresh the data in the grids.</p> <p class="MsoNormal"><img border="0" width="516" height="156" id= "Picture 10" src="ActionQ_User_Manual_files/image062.png" alt= "image" name="Picture 10" /><br /> <br /></p> <p class="MsoNormal"><img border="0" width="759" height="423" id= "Picture 37" src="ActionQ_User_Manual_files/image063.jpg" alt= "image" name="Picture 37" /><br /> <br /></p> <p class="MsoNormal"><span style= 'font-size:16.0pt;color:maroon'> </span></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h1><a name="_Toc165135502">Options</a></h1> <p class="MsoNormal"> </p> <h2><a name="_Toc165135503"></a><a name= "_Set_the_ActionQ"></a>Customizing About Window in ActionQ Manager</h2> <p class="MsoNormal"> </p> <p class="MsoNormal">Set the following lines in the ini file:</p> <p class="MsoNormal"> </p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style='border:none;padding:0in'>[Options]</p> <p class="MsoNormal" style='border:none;padding:0in'> About_Line1="email: ido@MilletSoftware.com"</p> <p class="MsoNormal" style='border:none;padding:0in'> About_Line2="Skype: ido_millet"</p> <p class="MsoNormal" style='border:none;padding:0in'> About_Line3=<span class="MsoHyperlink"><a href= "http://www.milletsoftware.com/">www.MilletSoftware.com</a></span><br /> <br /></p> </div> <p class="MsoNormal"> </p> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h1><a name="_Toc165135504">Handling Failures</a></h1> <p class="MsoNormal"> </p> <p class="MsoNormal">When a failure occurs, the service emails a message to the addresses specified in <b><i>Email_Failure_Notices_To</i></b> option as described in <span class="MsoHyperlink"><a href= "start.htm#_Setting_Email_Options">Setting Email Options</a></span>.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of such an email triggered when a database table used in a Source_SQL_Template is not found:<br /> <br /> <img border="0" width="577" height="433" id="Picture 24" src= "ActionQ_User_Manual_files/image064.png" alt="image" name= "Picture 24" /><br /> <br /></p> <p class="MsoNormal">As stated in the email message, once an event fails, the service will no longer monitor it.<br /> You need to fix the problem and restart the service.</p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><a name= "_Setting_Failure_Retry"></a><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135505">Setting Failure Retry Period</a></h2> <p class="MsoNormal"><br /> To handle transitory problems such as loss of connectivity to a database or to a cloud folder, you can set an optional entry in the specific event properties:<br /> <span style= 'background:yellow'>Failure_Retry_Minutes</span>="5"<br /> <br /> This would place a failing event in a Retry mode for 5 minutes.<br /> And the user would receive an email message such as this:<br /> <br /></p> <p class="MsoNormal"><img border="0" width="456" height="308" id= "Picture 25" src="ActionQ_User_Manual_files/image065.png" alt= "image" name="Picture 25" /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal">If after 5 minutes the process still fails, it is disabled and a final alert email is sent:<br /> <br /> <img border="0" width="470" height="271" id="Picture 3" src= "ActionQ_User_Manual_files/image066.png" alt="image" name= "Picture 3" /><br /> <br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"> </p> <p class="MsoNormal">The event recovers if, before getting disabled as above, it:<br /> a) experiences a success (triggering an EXE or moving a file)</p> <p class="MsoListParagraph">* Or *</p> <p class="MsoNormal">b) stops experiencing failures during one more retry period beyond the initial retry period.<br /> <br /> An email confirms the good news like this:</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="523" height="228" id= "Picture 29" src="ActionQ_User_Manual_files/image067.png" alt= "image" name="Picture 29" /></p> <p class="MsoNormal"><br /> <br /></p> <p class="MsoListParagraph"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h1><a name="_Toc165135506">Technical Notes</a></h1> <p class="MsoNormal"> </p> <h2><a name="_Toc165135507">Database Connectivity</a></h2> <p class="MsoNormal"> </p> <h3><a name="_Toc165135508">64 vs 32-Bit DSNs</a></h3> <p class="MsoNormal">The 64-bit version of ActionQ can only use 64-bit ODBC DSNs.<br /> A 32-bit version of ActionQ is available upon request if you can only use 32-bit ODBC DSNs.<br /> <br /></p> <p class="MsoNormal"> </p> <h3><a name="_Toc165135509"></a><a name="_NT_Authentication"></a>NT Authentication</h3> <p class="MsoNormal">If you are using SQL Server with NT Authentication, unless you <span class="MsoHyperlink"><a href= "start.htm#_Set_the_ActionQ">Set the ActionQ Service to Run Under a User Account</a></span> (and that user account has login permissions to SQL Server), you need to map the SYSTEM account to have Login permissions. Go to SQL Server >> Security >> Logins and set the User Mapping for NT AUTHORITY\NETWORK SERVICE or for NT AUTHORITY\SYSTEM as shown below:<a name= "_Toc519529313"></a><a name="_Toc509669447"></a><a name= "_Toc506904411"></a><a name="_Toc502988851"></a><a name= "_Toc502915280"></a><a name="_Toc502588263"></a><a name= "_Toc502587321"></a><a name="_Toc502510281"></a><a name= "_Toc502508675"></a><a name="_Toc502422928"></a><a name= "_Toc502422010"></a><a name="_Toc502335390"></a><a name= "_Toc502334935"></a><a name="_Toc502315959"></a><a name= "_Toc502315741"></a><a name="_Toc502315653"></a><a name= "_Toc502315469"></a><a name="_Toc501975066"></a><a name= "_Toc501974997"></a><a name="_Toc501974151"></a><a name= "_Toc501973431"></a><a name="_Toc501973340"></a><a name= "_Toc501973205"></a><a name="_Toc501970045"></a></p> <p class="MsoNormal"><img border="0" width="624" height="572" id= "Picture 8" src="ActionQ_User_Manual_files/image068.png" alt= "image" name="Picture 8" /></p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135510">SQL Statements</a></h2> <p class="MsoNormal"> </p> <h3><a name="_Toc165135511">SQL_After as SELECT Query</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">If the <b>SQL_After</b> is a SELECT statement, ActionQ adds extra <b>{<span style= 'background:yellow'>af_</span><columnName>}</b> tokens as well as <b><span style= 'background:yellow'>{aq_HTML_Table_After}</span></b> token for each row in the main event tokens.<br /> The information in <b>these extra dynamic tokens can be used in the Email or EXE responses</b> because those responses are always triggered AFTER the SQL response.</p> <p class="MsoNormal"><b><i> </i></b></p> <p class="MsoNormal"><b><i>SQL_After</i></b> statements are now (Version 2.0) allowed to return multiple rows. <b>{<span style= 'background:yellow'>af_</span><colName>}</b> tokens are generates from the first returned row. The <b><i><span style= 'background:yellow'>{aq_HTML_Table_After}</span></i> token</b> is generated from all the rows. Note: When set to run for <b><i><span style='background:aqua'>Each</span></i></b> row in the main event (rather than <b><i><span style= 'background:aqua'>Once</span></i></b>), the <b><i>SQL_After</i></b> logic fires and repopulates these tokens for each row in the main event.</p> <p class="MsoNormal"> </p> <p class="MsoNormal">Here is an example of an email from Visual CUT (EXE response) where information from a SELECT statement in the SQL response (how many customers are on credit hold) was used as a dynamic token in the command line arguments within the call to the Visual CUT EXE.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="643" height="481" id= "Picture 18" src="ActionQ_User_Manual_files/image069.png" alt= "image" name="Picture 18" /></p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <p class="MsoNormal"><a name= "_View_Dynamic_Tokens"></a><b><span style= 'font-size:14.0pt'> </span></b></p> <h3><a name="_Toc165135512"></a><a name= "_SQL_Statement_Subquery"></a>SQL Statement Subquery</h3> <p class="MsoNormal"> </p> <p class="MsoNormal">If the SQL Statement Subquery is a SELECT statement, ActionQ adds extra <b>{<span style= 'background:yellow'>sb_</span><columnName>}</b> tokens as well as <b><span style= 'background:yellow'>{aq_HTML_Table_Subquery}</span></b> token for each row in the main event. The information in these extra dynamic tokens can be used in any follow-up actions/responses, including in the <b>SQL_After</b> statement</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><img border="0" width="716" height="676" id= "Picture 79" src="ActionQ_User_Manual_files/image070.png" alt= "image" name="Picture 79" /></p> <p class="MsoNormal"><b><span style='font-size:13.0pt'><br /> <br /></span></b></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:13.0pt'> </span></b></p> <h3><a name="_Toc165135513">SQL Server (fully qualify table names)</a></h3> <p class="MsoNormal"> </p> <p class="MsoNormal">To avoid errors such as:</p> <p class="MsoNormal">[SQL Server]<span style= 'background:#FFC000'>Invalid object name</span> '<span style= 'background:#FDE9D9'>dbo.Email</span>' </p> <p class="MsoNormal">use the fully qualified table name (including the database name) in SQL statements.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><u>Good example (where <b>AQ</b> is the database name):</u></p> <p class="MsoNormal">INSERT INTO <b><span style= 'background:#D6E3BC'>AQ.</span></b><span style= 'background:#D6E3BC'>dbo.Email</span> ("Email_DT", "Email_From", "Email_Subject", "Email_BodyText", "Attachments", "Answer", "Note") Values ('{EmailDT}', '{FromAddress}', '{Subject}', '{BodyText}', '{Attachments}', '{Answer}', '{Note}');</p> <p class="MsoNormal"> </p> <p class="MsoNormal"><u>Bad example:</u></p> <p class="MsoNormal">INSERT INTO dbo.Email ("Email_DT", "Email_From", "Email_Subject", "Email_BodyText", "Attachments", "Answer", "Note") Values ('{EmailDT}', '{FromAddress}', '{Subject}', '{BodyText}', '{Attachments}', '{Answer}', '{Note}');</p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><a name= "_SQL_Response_as_1"></a><b><span style= 'font-size: 13.0pt'> </span></b></p> <h2><a name="_Toc165135514"></a><a name= "_Embed_Dynamic_Tokens"></a>ProgramData Folder</h2> <p class="MsoNormal"> </p> <p class="MsoNormal">The settings file (<b>ActionQ.ini</b>), the service private ini file (<b>ActionQ_Data.ini</b>) and the daily log files are maintained at:<br /> <span style= 'background:yellow'>%APPDATA%</span>\MilletSoftware\ActionQ\</p> <p class="MsoNormal"> </p> <p class="MsoNormal">For example, on a Windows 10 machine, the ActionQ.ini file is at: </p> <p class="MsoNormal"> C:\ProgramData\MilletSoftware\ActionQ<b>\</b>ActionQ.ini</p> <p class="MsoNormal"> </p> <h2><a name="_Toc165135515">Settings Files (ActionQ.ini and ActionQ_Data.ini)</a></h2> <p class="MsoNormal"><br /> All entry values (even numeric ones) must be enclosed in double quotes. For example:<br /> Sleep_Multiplier="4"</p> <p class="MsoNormal"> </p> <p class="MsoNormal">All comments in the ini file must start with a semi-colon: <b><span style= 'font-size:16.0pt'>;</span></b></p> <p class="MsoNormal"> </p> <p class="MsoNormal">While ActionQ Service is running it maintains an in-memory copy of the <b>ActionQ.ini</b> file as a Read Only version. It never attempts to write to that file. That makes it safe for you to make changes to the settings while the service runs.<br /> <br /> Values the service needs to “remember” even if it is stopped or uninstalled (such as LastMaxN) are saved by the service to <b>ActionQ_Data.ini</b> file. Typically, you should not open or edit that file.</p> <p class="MsoNormal"><span style='background:yellow'><br /> <br /></span></p> <h2><a name="_Toc165135516">UNC Paths rather than Mapped Drives</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">Use UNC paths rather than mapped drive letters when referring to resources such as Crystal Reports files in command line arguments.<br /> <br /> ActionQ automatically converts mapped drive to UNC paths for the following properties:<br /> <i>Watch_Folder</i>, <i>Move2_Folder</i>, <i>smtpQ_Folder</i> .</p> <h3><br /> <a name="_Toc165135517">Invisible Mapped Drives</a></h3> <p class="MsoNormal">ActionQ Manager <b>runs as administrator</b> and hence may not display mapped drive letters in folder selection dialogs unless you use one of the solutions discussed in this <a href= "https://docs.microsoft.com/en-us/troubleshoot/windows-client/networking/mapped-drives-not-available-from-elevated-command"> Microsoft Note</a>.<br /> You can copy & paste UNC paths manually into options for folder and file targets.</p> <h3><a name="_Batch_File_to"></a><br /> <a name="_Toc165135518">Batch File to Make Mapped Drives Visible</a></h3> <p class="MsoNormal">As a solution for the problem above, a batch file is provided in the ActionQ application folder:<br /> <b>C:\temp\Enable Mapped Drives in Elevated Apps (Right-Click and Run as admin).cmd</b><br /> Running that batch file sets a registry entry allowing elevated applications to see mapped drive paths.<br /> A machine restart is needed to apply the change.<br /> <br /></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><a name= "_Queuing_Emails_to"></a><b><span style= 'font-size: 14.0pt'> </span></b></p> <h2><a name="_Toc165135519">Queuing Emails to smtpQ Outgoing Folder</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">If you also have Visual CUT installed with smtpQ enabled, you can queue outgoing emails to the Outgoing folder by setting this entry in the ActionQ ini file under the [Events] section:</p> <p class="MsoNormal" style='margin-left:.5in'><br /> <span style='font-family:"Courier New"'>[Events]</span></p> <p class="MsoListParagraph"><b><span style= 'font-family:"Courier New"'>smtpQ_Folder</span></b><span style= 'font-family:"Courier New"'>="C:\Visual CUT\smtpQ\Outgoing"</span> </p> <p class="MsoNormal"><br /> <br /></p> <p class="MsoNormal"> </p> <h2><a name="_Toc165135520">ActionQ Service Fails to Start</a></h2> <p class="MsoNormal"> </p> <p class="MsoNormal">If you get the following error:<br /> <b><i><span style= 'font-family:"Helvetica",sans-serif;color:#1F1F1F;background: white'> Error 1053: the Service Did Not Respond to the Start or Control Request in a Timely Fashion</span></i></b></p> <p class="MsoNormal">Try to:</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:white'>Reboot the computer</span></p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:white'>Review the suggestions in this</span> <a href= "https://www.partitionwizard.com/clone-disk/windows-could-not-start-the-service-on-local-computer-error-1053.html"> <span style='background:white'>blog</span></a><span style= 'background:white'>.<br /> <br /></span></p> <p class="MsoNormal"><span style= 'background:white'> </span></p> <p class="MsoNormal"><span style='background:white'><br /> <br /></span></p> <h2><a name="_Toc165135521"></a><a name= "_Custom_Logging_(override"></a>Custom Logging (override appsettings.json)</h2> <p class="MsoNormal"><br /> To override the custom logging options, which by default are specified in the <b><i>appsettings.json</i></b> file,<br /> create a <b><i>logsettings.json</i></b> file and place it in the same folder.<br /> For example, this can easily allow you to use a cloud logging service such as <b><i>Seq</i></b>.</p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> <h1><a name="_Toc165135522">Update History</a><a name= "_Toc519529314"></a></h1> <p class="MsoNormal"> </p> <h2><a name="_Toc165135523">Version 3.0.4.10 (entered testing April 27, 2024):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:yellow'>New <b>event type</b> of PowerShell script</span> (PS_Mirror_Skip_Remove_T1).<br /> This is similar to the Database event, except that the data comes from a PowerShell script.<br /> For example, you may want to get data via <b><i>REST API</i></b> calls (e.g. <b><i>RabbitMQ</i></b>). Or monitor system health.<br /> Typical responses are email alerts and updating databases.<br /> For detail, see <a href= "start.htm#_PowerShell_"PS_Mirror_Skip_Remove_T">PowerShell "PS_Mirror_Skip_Remove_T1" Event Type</a>. </p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:yellow'>New <b>response type</b> of calling a PowerShell script</span>.<br /> You can pass dynamic tokens to the PowerShell script.<br /> For detail, see <a href="start.htm#_PowerShell_Response">PowerShell Response</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <span style='background:yellow'>Mirror Table logic now ignores column names that start with a space</span> (e.g. <span style= 'font-family: "Courier New"'>' Balance'</span>).<br /> This allows including useful data (e.g. balance of account placed on credit hold) in event data, yet <b>avoiding triggering another response when such non-key information changes</b>.<br /> For example, once a customer is placed on credit hold, we may not want to trigger another alert just because their balance changed.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Newly created <span style='background:yellow'>mirror tables <b>store only key columns</b></span> (column names that do not start with a space).<br /> This saves space, increases speed, and improves security. It also improves resilience because you can add/remove/change non-key columns to the event design without breaking the mirror table logic.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added <b>dynamic logging as an event response</b> (any <i>Serilog</i> sink, such as <i>Seq</i> can be targeted).<br /> This is not yet documented. Contact Millet Software for testing this new feature.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a batch file to automate the installation process (ActionQ_Install_RClick_Run_As_Admin.cmd).</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> When adding a database connection profile, a helpful text of <span style= 'font-family:Consolas;color:#A31515'>dsn=?;uid=?;pwd=ES_?</span> is provided.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added support for logging to Serilog Seq.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added support for <a href= "start.htm#_Custom_Logging_(override">custom logging</a> settings (<i>logsettings.json</i>)</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a problem in Mirror table handling of Boolean values.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a problem in how the 64-bit version shows the connection string for database connections.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>Fixed a problem with how the service handled OAUTH for SMTP via Office365</b>.<br /> <br /></p> <h2><a name="_Toc165135524">Version 2.0.8.01 (February 28, 2024):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added support for <b><span style= 'background:yellow'>OAuth2</span></b> when sending/receiving emails (SMTP & POP3) via Office365 and Gmail.Contact Millet Software for detailed instructions.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>Fixed multi-row SQL population of dynamic tokens.</b></p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>Fixed {aq_HTML_Table} bug (</b>introduced in V2.0.5, and remained in V2.0,6)</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Removed several CSS style defaults for tables in email messages (email clients require inline styling).</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed display of object properties (event, email, inbox, database connections) after cloning the object.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a bug in adding a new inbox profile.<br /> <br /></p> <h2><a name="_Toc165135525">Version 2.0.2.01 (August 1, 2023):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>ActionQ can now</b> <a href="start.htm#_REST_API_Call"><b>call a REST API</b></a> <b>as a response to an event</b>. Returned JSON is parsed to dynamic tokens that can be embedded in a follow-up email message.<br /> For example, an incoming email event can trigger an SMS message via Twilio's REST API.<br /> Twilio's JSON response is parsed into tokens that can be embedded in an email as another response.<br /> <br /></p> <h2><a name="_Toc165135526">Version 2.0.1.01 (July 04, 2023):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed sanitizing of connection strings when logging connection failures.</p> <p class="MsoNormal"> </p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135527">Version 2.0.0.01 (June 12, 2023):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b><span style='background:#F2DBDB'>Breaking Change!</span></b> <b><i>SQL After</i></b> statements tokens names are <b>{<span style= 'background:yellow'>af_</span><colName>}</b> instead of <b>{<colName>}</b>.<br /> For example, {<span style='background:yellow'>af_</span>ID} instead of {ID}<br /> This solves cases where other SQL statements for the same event have columns with the same name.<br /> If you have an event that uses tokens from an SQL After statement, be sure to update that event.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b><i>SQL After</i></b> statements are now allowed to return multiple rows. For SELECT statements, this provides a new <b><span style= 'background:yellow'>{aq_HTML_Table_SQL_After}</span></b> token for embedding in email responses.</p> <p class="MsoListParagraph">Note: When set to run for <b><i><span style='background:aqua'>Each</span></i></b> row in the main event (rather than <b><i><span style= 'background:aqua'>Once</span></i></b>), the <b><i>SQL_After</i></b> logic fires and repopulates these tokens for each row in the main event.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b>Added</b> <a href="start.htm#_SQL_Statement_Subquery"><b><i>SQL Statement Subquery</i></b></a> <b>property to database events</b>. <i>ActionQ</i> runs that correlated subquery for each row in the main query. For SELECT statement, it populates new <b><i><span style= 'background:yellow'>{aq_HTML_Table_Subquery}</span></i></b> and <b><span style='background:yellow'>{sb_<colName}</span></b> tokens. For example, a backorder event can easily embed line items detail as HTML table in an email response. Thanks to Corey Durthaler for the feature idea.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Dynamic tokens are now sorted alphabetically in the token panel.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed double-prompting for unsaved changes.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added green highlights for action descriptions (e.g. 'emailed to', 'Ran', 'Subquery') in the log display.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The SQL editor now starts Cast() expressions on new lines for improved readability.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The SQL editor's data grid now right-aligns date and number columns.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Auto-generated HTML tables now handle Date values as dates rather than DateTime.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The log display automatically abbreviates content of HTML tables to <table … </table>.<br /> <br /></p> <h2><a name="_Toc165135528">Version 1.1.97.02 (November 20, 2022):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Updated internal component to a later version.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Bug fix (null object reference).</p> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135529">Version 1.1.89.02 (July 10, 2022):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a problem in testing email profiles.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed an emailing problem from the service.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added debug option to review mirror table vs fresh data.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed Mirror Table comparisons for Decimals values with different number of trailing 0's. </p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed tooltip issue for the {aq_HTML_Table} token.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Updated the email message HTML editor. Preview scrollbars are now enabled.<br /> <br /></p> <h2><a name="_Toc165135530">Version 1.1.0.95 (March 2, 2022):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Email events can now <b>use Regular Expressions</b> to parse dynamic tokens from the email <b>subject</b>, message <b>body</b>, and even <b>file attachments</b>. See <a href= "start.htm#_Dynamic_Tokens_By">Dynamic Tokens By Regular Expressions</a>.<br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135531">Version 1.1.0.93 (January 6, 2022):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> ActionQ now automatically builds an HTML table token called {aq_HTML_Table}. You can place that token in email messages to display event data as a nicely formatted table.<br /> See <a href="start.htm#_Using_{aq_HTML_Table}_Token">Using {aq_HTML_Table} Token in Email Responses</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed handling of NULL values in Mirror table logic (‘DB_Mirror_Skip_Remove_T1’ event type).</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> SQL Query editor now provides a button (only for DB_Mirror_Skip_Remove_T1 event types) allowing you to display only new cases (rows that are not already in the Mirror table). See <a href="start.htm#_Using_a_Stored">example</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added an example for <a href="start.htm#_Using_a_Stored">Using a Stored Procedure as Data Source</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a <a href="https://youtu.be/xFoh8JeyNa0">video demo</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed bug in properties grid for email inboxes.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a bug in handling of encrypted strings.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added syntax highlighting to SQL editor.<br /> <br /></p> <h2><a name="_Toc165135532">Version 1.1.0.87 (November 6, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a 32-bit version of ActionQ (to support 32-bit ODBC drivers). Contact Millet Software for detail.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed support for HTML email signatures.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a special dialog for entering & testing Source_SQL_Template statements for database events. When ActionQ displays the result set from the SELECT statement, it also takes care of populating dynamic tokens to facilitate designing dynamic responses. See <a href= "start.htm#_Source_SQL_Template_Editor">Source_SQL_Template Editor</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> When saving a new Folder or Incoming Email event, ActionQ now automatically generates and saves sample tokens to facilitate designing dynamic responses even before the events get triggered.<br /> <br /></p> <h2><a name="_Toc165135533">Version 1.1.0.83 (September 19, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b><i>Folder_Not_Empty</i></b> events now support an optional <b><i>Renamed_File</i></b> property, allowing you to rename incoming files. For in-place renaming, you may leave the <b><i>Move2_Folder</i></b> blank.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b><i>Folder_Not_Empty</i></b> events now support flexible <b>DateTime</b> and <b>File Counter</b> tokens to ensure the Renamed_File is unique. See <a href= "start.htm#_Dynamic_Tokens_for">Dynamic Tokens for Renaming Files</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Email/SQL/App responses to <b><i>Folder_Not_Empty</i></b> events, which are set to fire ONCE (instead of for EACH incoming file) now indeed fire only once.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b><i>Ctrl-S</i></b> now acts as a Save hot key for event and global properties.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> A <b><span style= 'font-family:"Arial Black",sans-serif'>?</span></b> top-right menu button in various windows (or F1 key) now launches relevant online help.<br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135534">Version 1.1.0.82 (September 8, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a window for managing global settings via a property grid with help text.<br /> This avoids manual editing of the ini file to manage settings such as sleep interval and service account.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a blank option in SMTP_Settings drop-down to allow removing email response target.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Events can now use the admin email profile (“Email”) settings to send emails.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added right-click menu for the log window with menu options to Refresh (F5) and Clear (F12) the log.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Changing the ‘Included’ checkbox for an event saves the change (no need to click ‘Save Event’).</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added alert dialogs when a user is about to lose unsaved changes to property values due to closing a window or navigating to another event. The user can elect to save or discard the unsaved changes.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> A failure message is now logged & emailed when a <i>Folder_Not_Empty</i> event finds the file already exists in the <i>Move2_Folder</i>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a <a href="start.htm#_Batch_File_to">Batch File to Make Mapped Drives Visible</a> .</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added automatic conversion from mapped drive to UNC paths.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> <b><i>Folder_Not_Empty</i></b> events now support an optional <b><i>Target_Files</i></b> property, allowing you to target only specified file names or wildcard patterns. For example: <b><span style= 'font-family:"Courier New"'>*.xls;*.xlsx;Claims*.csv</span></b><br /> <br /></p> <h2><a name="_Toc165135535">Version 1.1.0.74 (August 17, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed handling of single quotes when populating Mirror and Snapshot tables</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed saving of Mirror Connection property.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed property grid initialization when saving a new event.<br /> <br /></p> <h2><a name="_Toc165135536">Version 1.1.0.71 (July 23, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added an <b><i>Email Profiles Manager</i></b>. Use it to add, edit, delete, clone, <b>and test</b> email profiles.</p> <p class="MsoListParagraph">See: <a href= "start.htm#_Using_the_Email">Using the Email Profiles Manager</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added an <b><i>Email Inbox (POP3) Manager</i></b>. Use it to add, edit, delete, clone, <b>and test</b> settings for email inboxes. See: <a href="start.htm#_Email_From_Settings">Using the Email Inboxes (POP3) Manager</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> For security reasons, the user can no longer opt to display unobscured encrypted strings.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Instead of encrypting the whole connection string, you can now refer to a named encrypted string from just the sensitive portions. For example: <span style= 'font-family:"Arial",sans-serif'>dsn=ERP;uid=jsmith;<span style= 'border:solid windowtext 1.0pt;padding:0in'>pwd=<b><span style= 'background:yellow'>ES_</span>ERP_PW</b></span><b><br /></b></span>This facilitates managing connection strings by making the non-sensitive parts visible.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Increased font size in property grids to improve readability.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed duplicate key bug in detecting failed schedules tasks.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed handling of dummy/blank encrypted strings</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed email profile test bug</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added tooltips to menu buttons</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Removed <i>Email_Bounce_Address</i> property (by definition, must be the <i>Email_From</i>).</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added to the main form a button <img border="0" width="29" height= "27" id="Picture 54" src="ActionQ_User_Manual_files/image071.png" alt="image" name="Picture 54" /> to open the ActionQ.ini file.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The User Manual button now opens the user manual in your browser.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The user manual now provides an <a href= "start.htm#_Initial_Setup"><i>Initial Setup</i></a> section with 3 required steps and 2 optional steps.<br /> <br /></p> <h2><a name="_Toc165135537">Version 1.1.0.63 (June 25, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Updated HTML editor for email messages.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a <b><i>Connections Manager</i></b>. Use it to add, delete, clone, <b>and test</b> named database connections.<br /> See <a href="start.htm#_Using_the_Connections">Using the Connections Manager</a>.<br /> <br /></p> <span style= 'font-size:12.0pt;font-family:"Times New Roman",serif'><br clear= "all" style='page-break-before:always' /></span> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135538">Version 1.1.0.61 (March 29, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> New Feature: see <a href="start.htm#_Setting_Up_Alerts">Setting Up Alerts for Windows Scheduled Task Failures</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> When saving an event that uses the LastMaxN property, a dialog allows the user to avoid overwriting the current value used by the service in a case where the value shown by the manager dialog is old.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed an issue with showing LastMaxN in event properties.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Updated HTML editor component for email messages.<br /> <br /></p> <h2><a name="_Toc165135539">Version 1.1.0.57 (February 9, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added <b><i>Attachments</i></b> property for email response. Separate multiple attachments with ‘<b>;</b>’.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Email responses can now have <b>HTML message bodies</b>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added an <b>HTML editor</b> (including inline spell-checker) for designing HTML email messages.<br /> See <a href="start.htm#_HTML_Editor_for">HTML Editor for Email Message Body</a>. <br /> <br /></p> <h2><a name="_Toc165135540">Version 1.1.0.52 (January 24, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> You can now use a SELECT statement in the SQL Response to add extra dynamic tokens for use in the Email or EXE response. For details, see <a href="start.htm#_SQL_Response_as_1">SQL Response as SELECT Query</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> For email events, if Delete_Email_From_Server entry is set to false, ActionQ now avoids duplicate processing of old messages by tracking the maximum date & time found in the date header of<br /> messages processed in previous scans.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Editor window for text properties now allows font size increment/decrement using Ctrl-Scroll Up/Down.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Editor window for text properties now adds a new line when pressing ‘Enter’ instead of closing.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added automated documentation of all dynamic tokens and sample values for each process.<br /> A new toolbar button allows you to view this documentation for a selected process.<br /> See <a href="start.htm#_View_Dynamic_Tokens_2">View Dynamic Tokens for Each Process</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added special dialog for editing response properties with dynamic tokens.<br /> See <a href="start.htm#_Embed_Dynamic_Tokens_2">Embed Dynamic Tokens in Response Properties</a>.<br /> <br /></p> <h2><a name="_Toc165135541">Version 1.1.0.47 (January 13, 2021):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> The encrypted string creation dialog now also allows creation of a named connection string referencing the encrypted string. This allows creation of named connection strings without manual editing of the ini file. See <a href= "start.htm#_Database_Connections">Database Connections</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added special handling for POP3 (incoming emails) from Gmail.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed error message when event triggers only an email (no exe and no SQL).</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed saving of SQL_After_Connection property from event properties editing window.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Improved layout (spacing between sections) and comments in Ini file.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Event properties grid now shows <b><i>Response SQL</i></b> properties before <b><i>Response_EXE</i></b> properties.<br /> This reflects the response sequence: SQL response occurs before EXE response.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed informational logging issue.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Improved handling of cases where user forgot to activate at least one event.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed SQL handling of single quotes inside email subject and body.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed dynamic tokens handling for multiple files in Folder events.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added more tokens for Folder events: <span style= 'font-size:9.5pt; font-family:Consolas;color:#A31515'>{FileNameNoExtension}</span><span style='font-size:9.5pt;font-family:Consolas'>, <span style='color:#A31515'>{Extension}</span>, <span style= 'color:#A31515'>{DateTimeStamp}</span></span><br /> <br /></p> <h2><a name="_Toc165135542">Version 1.1.0.34 (December 7, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Performance tweaks.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added message suggesting closing AQ Manager before manually editing the ini file in Notepad.<br /> <br /></p> <h2><a name="_Toc165135543">Version 1.1.0.33 (November 30, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> ActionQ can now trigger dynamic email messages in response to events.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added SQL_When (‘Once’ or ‘Each’) event property to support cases where the SQL response should be triggered only Once per event as well as for Each Record/File/Email detected within the event.<br /> <br /></p> <h2><a name="_Toc165135544">Version 1.1.0.31 (November 12, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> You can now queue outgoing emails using smtpQ. See <a href= "start.htm#_Queuing_Emails_to">Queuing Emails to smtpQ Outgoing Folder</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> ‘Pass These Arguments’ event property now offers a multi-line editor for easier viewing/editing.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a bug in saving setting for Move2_Folder</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a bug in handling dynamic tokens for SQL_After statements.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed a bug in some cases of reading Mirror database connection string.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed unhandled exception scenario.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed data type handling issue in creating snapshot/mirror tables.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Form for viewing snapshot and mirror tables now shows the DSN name used by their connections.<br /> <br /></p> <h2><a name="_Toc165135545">Version 1.1.0.22 (October 3, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added Snapshot_Table_Connection property to activate saving of event details to a table. This facilitates debugging and exposing the event data to downstream processes. For example, a Crystal report can use the snapshot table, removing the need to pass parameters via dynamic tokens in the arguments template. </p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added a <img border="0" width="75" height="24" id="Picture 32" src= "ActionQ_User_Manual_files/image061.png" alt="image" name= "Picture 32" /> button in ActionQ_Manager to display the Snapshot and/or Mirror tables for the selected event. See <a href= "start.htm#_Monitoring_Snapshot_and">Monitoring Snapshot and Mirror Tables</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Property Grid now provides a multi-line editor for pasting or viewing SQL statements.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Log file refreshes no longer change user’s clipboard.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Fixed <b><i>Email_POP3_T1</i></b> connection problem.</p> <p class="MsoNormal"><b><span style= 'font-size:14.0pt'> </span></b></p> <h2><a name="_Toc165135546">Version 1.1.0.21 (September 23, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added window for creating, cloning, and modifying events.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Merged Install and Uninstall buttons into a single Install/Uninstall button.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Merged Start and Stop buttons into a single Start/Stop button.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Tweaked service installation logic<br /> <br /></p> <h2><a name="_Toc165135547">Version 1.1.0.12 (September 7, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added <b>ActionQ_Data.ini</b> for the service to maintain values in case it is stopped. This ensures the service never writes to the <b>ActionQ.ini</b> file, making it safe for you to change settings while the service runs.<br /> <br /></p> <h2><a name="_Toc165135548">Version 1.1.0.10 (August 27, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Enhanced saving of error messages to log and to Status entry in ini file.<br /> <br /></p> <h2><a name="_Toc165135549">Version 1.1.0.9 (August 25, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added an event type of ‘<b><i>Email_POP3_T1</i></b>’ to detect incoming emails (matching filter criteria), and triggering SQL and/or EXE with dynamic command line arguments in response.<br /> This includes automatic extraction of data from [Answer: <…>] and [Note: <…>] tokens in the message subject or body, allowing managers to approve/reject email requests and trigger processes and database updates by responding to an email.<br /> <br /></p> <h2><a name="_Toc165135550">Version 1.0.0.8 (August 16, 2020):</a></h2> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added options to <a href="start.htm#_Set_the_ActionQ">Set the ActionQ Service to Run Under a User Account</a>.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Starting ActionQ_Manager for the first time takes care of copying the sample ini file to the AppData subfolder and setting Modify permissions for users.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Several enhancements to user interface (e.g. changing color for service status text)</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added support for running on older operating systems (e.g. Windows 2008 R2)</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added toolbar button to open user manual.</p> <p class="MsoListParagraph" style='text-indent:-.25in'><span style= 'font-family: Symbol'>·<span style= 'font:7.0pt "Times New Roman"'> </span></span> Added msi installer<br /> <br /></p> <h2><a name="_Toc165135551">Version 1.0.0.0 (August 2, 2020):</a></h2> <p class="MsoNormal"><b><span style= 'font-size:16.0pt;color:maroon'> </span></b></p> </div>
Contents
Topics
Search
Introduction
Installation
Launch
Initial Setup
Encrypted Strings
Using the Encrypted Strings Manager
Database Connections
Using the Connections Manager
Using the Encrypted Strings Dialog (old method)
Email Profiles
Using the Email Profiles Manager
Email Settings for the Service Administrator
Email_From Accounts for Events as Senders
Email Inbox Settings
Using the Email Inboxes (POP3) Manager
Use the Global Settings Dialog
Set the ActionQ Service to Run Under a User Account
Setting Up Events
Global Properties
Individual Events Properties
Example
Supported Event Types
Monitoring Frequency
Failure Retry Period
Automatic Snapshot Table
Response Properties
SQL Response
EXE or CMD Response
PowerShell Response
With Named Parameters:
More Complex Scenarios:
REST API Call Response
Email Response
Viewing and Editing Properties
Embed Dynamic Tokens in Response Properties
Edit Text for Non-Response Properties
HTML Editor for Email Message Body
Using {aq_HTML_Table} Token in Email Responses
Using {aq_HTML_Table} Token in Email Responses
View Dynamic Tokens for Each Process
Event Types
"Folder_Not_Empty" Event Type
Dynamic Tokens for Response Logic
Dynamic Tokens for Renaming Files
Database Events
Source_SQL_Template Editor
Using a Stored Procedure as Data Source
"DB_LastMaxN" Event Type
"DB_Flag" Event Type
"DB_Mirror_Skip_Remove_T1" Event Type
PowerShell "PS_Mirror_Skip_Remove_T1" Event Type
Calling REST APIs such as RabbitMQ
Typical Properties
Avoiding Duplicate Processing
"Email_POP3_T1" Event Type
Typical Use Case:
Setting Default Email Client
Email Server and Inbox Settings
Event Settings
Standard Dynamic Tokens
Dynamic Tokens By Regular Expressions
Dynamic Tokens By Brackets
SQL_After Logic
Setting Up Alerts for Windows Scheduled Task Failures
Monitoring Snapshot and Mirror Tables
Options
Customizing About Window in ActionQ Manager
Handling Failures
Setting Failure Retry Period
Technical Notes
Database Connectivity
64 vs 32-Bit DSNs
NT Authentication
SQL Statements
SQL_After as SELECT Query
SQL Statement Subquery
SQL Server (fully qualify table names)
ProgramData Folder
Settings Files (ActionQ.ini and ActionQ_Data.ini)
UNC Paths rather than Mapped Drives
Invisible Mapped Drives
Batch File to Make Mapped Drives Visible
Queuing Emails to smtpQ Outgoing Folder
ActionQ Service Fails to Start
Custom Logging (override appsettings.json)
Update History
Version 3.0.4.10 (entered testing April 27, 2024):
Version 2.0.8.01 (February 28, 2024):
Version 2.0.2.01 (August 1, 2023):
Version 2.0.1.01 (July 04, 2023):
Version 2.0.0.01 (June 12, 2023):
Version 1.1.97.02 (November 20, 2022):
Version 1.1.89.02 (July 10, 2022):
Version 1.1.0.95 (March 2, 2022):
Version 1.1.0.93 (January 6, 2022):
Version 1.1.0.87 (November 6, 2021):
Version 1.1.0.83 (September 19, 2021):
Version 1.1.0.82 (September 8, 2021):
Version 1.1.0.74 (August 17, 2021):
Version 1.1.0.71 (July 23, 2021):
Version 1.1.0.63 (June 25, 2021):
Version 1.1.0.61 (March 29, 2021):
Version 1.1.0.57 (February 9, 2021):
Version 1.1.0.52 (January 24, 2021):
Version 1.1.0.47 (January 13, 2021):
Version 1.1.0.34 (December 7, 2020):
Version 1.1.0.33 (November 30, 2020):
Version 1.1.0.31 (November 12, 2020):
Version 1.1.0.22 (October 3, 2020):
Version 1.1.0.21 (September 23, 2020):
Version 1.1.0.12 (September 7, 2020):
Version 1.1.0.10 (August 27, 2020):
Version 1.1.0.9 (August 25, 2020):
Version 1.0.0.8 (August 16, 2020):
Version 1.0.0.0 (August 2, 2020):
"DB_Flag" Event Type
"DB_LastMaxN" Event Type
"DB_Mirror_Skip_Remove_T1" Event Type
"Email_POP3_T1" Event Type
"Folder_Not_Empty" Event Type
64 vs 32-Bit DSNs
ActionQ Service Fails to Start
Automatic Snapshot Table
Avoiding Duplicate Processing
Batch File to Make Mapped Drives Visible
Calling REST APIs such as RabbitMQ
Custom Logging (override appsettings.json)
Customizing About Window in ActionQ Manager
Database Connections
Database Connectivity
Database Events
Dynamic Tokens for Renaming Files
Dynamic Tokens By Regular Expressions
Dynamic Tokens By Brackets
Dynamic Tokens for Response Logic
Edit Text for Non-Response Properties
Email Inbox Settings
Email Profiles
Email Response
Email Server and Inbox Settings
Email Settings for the Service Administrator
Email_From Accounts for Events as Senders
Embed Dynamic Tokens in Response Properties
Encrypted Strings
Event Types
Event Settings
Example
EXE or CMD Response
Failure Retry Period
Global Properties
Handling Failures
HTML Editor for Email Message Body
Individual Events Properties
Initial Setup
Installation
Introduction
Invisible Mapped Drives
Launch
Monitoring Frequency
Monitoring Snapshot and Mirror Tables
More Complex Scenarios:
NT Authentication
Options
PowerShell "PS_Mirror_Skip_Remove_T1" Event Type
PowerShell Response
ProgramData Folder
Queuing Emails to smtpQ Outgoing Folder
Response Properties
REST API Call Response
Set the ActionQ Service to Run Under a User Account
Setting Default Email Client
Setting Failure Retry Period
Setting Up Alerts for Windows Scheduled Task Failures
Setting Up Events
Settings Files (ActionQ.ini and ActionQ_Data.ini)
Source_SQL_Template Editor
SQL Statement Subquery
SQL Response
SQL Server (fully qualify table names)
SQL Statements
SQL_After as SELECT Query
SQL_After Logic
Standard Dynamic Tokens
Supported Event Types
Technical Notes
Typical Properties
Typical Use Case:
UNC Paths rather than Mapped Drives
Update History
Use the Global Settings Dialog
Using a Stored Procedure as Data Source
Using the Connections Manager
Using the Email Inboxes (POP3) Manager
Using the Email Profiles Manager
Using the Encrypted Strings Dialog (old method)
Using the Encrypted Strings Manager
Using {aq_HTML_Table} Token in Email Responses
Using {aq_HTML_Table} Token in Email Responses
Version 1.0.0.0 (August 2, 2020):
Version 1.0.0.8 (August 16, 2020):
Version 1.1.0.10 (August 27, 2020):
Version 1.1.0.12 (September 7, 2020):
Version 1.1.0.21 (September 23, 2020):
Version 1.1.0.22 (October 3, 2020):
Version 1.1.0.31 (November 12, 2020):
Version 1.1.0.33 (November 30, 2020):
Version 1.1.0.34 (December 7, 2020):
Version 1.1.0.47 (January 13, 2021):
Version 1.1.0.52 (January 24, 2021):
Version 1.1.0.57 (February 9, 2021):
Version 1.1.0.61 (March 29, 2021):
Version 1.1.0.63 (June 25, 2021):
Version 1.1.0.71 (July 23, 2021):
Version 1.1.0.74 (August 17, 2021):
Version 1.1.0.82 (September 8, 2021):
Version 1.1.0.83 (September 19, 2021):
Version 1.1.0.87 (November 6, 2021):
Version 1.1.0.9 (August 25, 2020):
Version 1.1.0.93 (January 6, 2022):
Version 1.1.0.95 (March 2, 2022):
Version 1.1.89.02 (July 10, 2022):
Version 1.1.97.02 (November 20, 2022):
Version 2.0.0.01 (June 12, 2023):
Version 2.0.1.01 (July 04, 2023):
Version 2.0.2.01 (August 1, 2023):
Version 2.0.8.01 (February 28, 2024):
Version 3.0.4.10 (entered testing April 27, 2024):
View Dynamic Tokens for Each Process
Viewing and Editing Properties
With Named Parameters:
ActionQ by
Millet Software
ActionQ by
Millet Software