ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds confusing?...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a reasonable name of your choice Under Collection, select as Enumerator the "Foreach File Enumerator" Select the source folder which contains all the files...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 annotation) attribute Defines an attribute attributeGroup Defines an attribute group to be used in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice. Why? I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2 double-quotes to a string of your choice v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); info v_FormattedString; //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *