New: Added web-based Message Store viewer. Enabled on a per-solution basis. See: Web Message Store Viewer tab on Solution properties.
Improvement: Renamed the ChatGPT action to Ask AI. Since more AI providers are planned for upcoming updates.
Improvement: Added 'Extract And Save Unique Keywords For Messages Added In This Solution' option to Solution settings. If this option is enabled then ThinkAutomation will extract all unique words (from the body, subject from/to addresses) for each message added to the message store for all Message Sources in the solution. This will improve message store searching, but requires additional overhead when saving new messages. A new Keywords column has been added to the Message Store table.
Improvement: Increased the maximum message processor tasks to 24.
Improvement: Performance improvement for automation execution.
Fix: Fixed Full Text Search action to handle non alpha-numeric characters in search text.
Fix: Fixed issue with the Nuget package manager option on the Script editor showing an error when trying to add a package that has been downloaded more than 2.1 billion times.
Fix: Increased length of OpenAI API key text box to allow for longer API keys introduced by OpenAI.
5.0.1025 (2nd December 2024)
Improvement: You can now return files to a Web Form message source response via the local API. Previously this only worked when using the public API. To return a file, simply set the Return value of the Automation to a local file path (or a %variable% to a file created previously in the Automation). The file will be rendered depending on its content-type.
Improvement: Added not completed Captcha message text to Web Form message source. Will display the message if a user does not complete the Captcha when used on a web form.
Fix: Fixed issue with HTTP Get action not returning Json text when the endpoint returned a non-standard content-type header (eg: application/vnd.oracle.resource+json;)
5.0.1020 (19th November 2024)
Improvement: Added Custom tab to Web Form message source. Allows custom HTML/JavaScript to be added, which will be rendered before the closing body tag.
Improvement: Added option to delete Sent Items older than specified days (specified on Solution properties).
Improvement: Added %DB_Null% built-in variable. Can be used on database update action parameters to specify a DB null value. Will replace to a blank string if used on any other actions.
5.0.1016 (7th November 2024)
New Added support for OptimaGPT. OptimaGPT is Parker Software's on-premises or private-cloud hosted generative AI server. This allows you to use the ChatGPT action with a private AI server - removing the need to send private data to OpenAI. See: OptimaGPT for more information.
New: Added Append To PDF Document action. Appends document files or any text to an existing PDF document.
New: Added new built-in variables %Msg_ViewUrl% and %Msg_ViewUrlLocal%. These provide public and local URLs for viewing the current message in a browser. The URL's contain a secure hash.
New: Added Search Message Store operation to the Message Store Operation action. This allows you to search the ThinkAutomation Message Store and return the search results as Json, Markdown, CSV or a HTML table. The results include a URL to view the full message.
New: Added Full Text Search action. This action can be used to update and search a built-in full text search database.
New: Added Convert CSV To Html action. Provides more control than the Set variable Convert CSV To HTML Table operation. Useful for returning data queries to web form results.
Fix: Fixed issue with Move Incoming Message action not working when using an Exchange Message Source.
Fix: Fixed issue with Create Document action not rendering document contents on newly created actions.
Fix: Message Store searches are now case-insensitive when using PostgreSQL as the message store type.
Improvement: Added GPT-4o-mini model to the available models list for the ChatGPT action.
Improvement: Added option in server settings to define available ChatGPT models. This allows you to use new OpenAI models without waiting for a ThinkAutomation update.
Improvement: Added Force Remote Path To option to FTP Upload action. This allows you to use a fixed or variable remote path even if it doesn't exist on the remote server. An option to create any missing path has been added.
Improvement: The Web Form message source - File upload input type now allows mime types to be specified in the file types. The value in the 'File Types' entry for the file upload field will be set to the accept value for the HTML form field. You can also also specify a blank value for the 'File Types' - this will allow files of any type to be submitted.
Improvement: The Web Form message source now has a Show Side Pane option. This allows custom text/HTML to be displayed on the left or right of the form.
Improvement: The Web Form message source now has a Do Not Hide Form After Confirmation option. If enabled, the web form will not be hidden on submit. This allows dynamic forms that can be resubmitted to view new results.
Improvement: The Save As PDF action now allows you to use raw HTML (or %variable% containing HTML text) when rendering. Previously this needed to be a filename or URL.
Improvement: The Search option in the Message Store viewer will now work with multiple search terms by using the + character. For example: sales+orders - would search for messages containing 'sales' AND 'orders'. If a search term itself should contain a + character then enclose it in double-quotes.
5.0.1000 (4th June 2024)
Fix: Fixed issue with Find feature in Studio not selecting the correct line on an Automation from the find results where multiple lines in the same Automation were found.
Fix: Fixed issue with FTP Upload/Download actions. If the port number is changed from the default, the port number reverted back to the default if the action was opened again and re-saved.
Fix: Fixed issue with Extract Field action not extracting negative numbers where the field type was set to Decimal.
Fix: Fixed issue with File Operations action (copy/rename) where the file name contained a '$' character.
Fix: Fixed issue with Twilio Call action not speaking text due to change in Twilio Webhook authentication.
Fix: Fixed issue with Database Pull message source removing trailing bracket from column names when column name ended with a ) character.
Improvement: Added Delete option for Cloud Storage action.
Improvement: Added GTP-4-Turbo and GPT-4o to the available models list for ChatGPT action.
Improvement: The Create Outlook MSG File action will now attempt to convert MIME to an Outlook MSG file using a 2nd conversion method when the MIME text is invalid.
Updated expired oauth login info for Microsoft Dynamics CRM actions.
Known Issue: When using scripts with the NuGet Package manager in the script editor - an error message will show when adding a package where the nuget package has been downloaded more than 4 billion times. This only affects a very small number of nuget packages. Note: If you want to use newtonsoft.json in your script you do not need to add a nuget package since this dll is already used by ThinkAutomation. Simply add a reference to it directly from the ThinkAutomation program files folder.
5.0.992 (8th January 2024)
Fix: Fixed issue with Create Outlook MSG File action not working on some mime text.
Fix: Fixed Automation right-click popup menu showing wrong shortcut-key labels.
Fix: Fixed issue with web form & web chat file upload where the file name contained none-ascii characters.
Fix: Fixed issue with %variable% replacement inside Json, if value was empty Json array being incorrectly escaped.
Improvement: Added option to delete read messages when using the Azure Queue Message Source type.
Improvement: The Save As PDF action now supports rendering image files as PDF documents. The image is first embedded in HTML and the HTML is then converted to PDF.
Improvement: Improved the quick-access option when editing Automations. When editing an Automation, start typing an action name. Select an action from the popup based on the characters typed. Press enter to select.
Improvement: Updated MongoDB driver to latest. Now supports MongoDB version 7.
Improvement: For API Message Sources you can now explicitly disable the Public API endpoint for individual Message Sources. Any HTTP POST or GET to the public API endpoint will receive a 404 response.
New: Added Message Store Copy option to the Server Settings - Message Store tab. This allows you to make a copy of your current Message Store database.
New: Added %LastActionExecutionMs% built-in variable. Holds the number of milliseconds that the last action took to execute.
New: Added Current Utilization button to Logs tab in Studio. This shows the current ThinkAutomation Server CPU, Memory and Queue utilization.