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 Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created but it would only understand the questions I have programmed it to and respond with the...

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

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

06 March 2023 can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save" click on "Done" Now click on "Edit Function" under "Context Handler Function"...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both for outbound and inbound but local to the customer and we want...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 ensure this is the corresponding module API name in CRM v_BooksAPIBase = "https://books.zoho.eu/api/v3"; // // init v_OutputMessage = ""; v_CrmSoRef = ""; v_CrmSoID = 0; // // get books so name (sales order number) r_BooksSoDetails =...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 "; v_Cc = {"Joel Lipman Support Desk "}; v_Subject = "URGENT: Sync Between Zoho People and Zoho Analytics Failed!!!"; v_Message = "Hi there! This is an email to advise that the synchronization between your Zoho People and Zoho Analytics instances...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 = ifnull(m_Notification_Data.get("userId"),"-"); v_EiasToken = ifnull(m_Notification_Data.get("eiasToken"),"-"); // v_DebugMessage = crmAPIRequest + " " + m_Params + " " + v_ChallengeCode + " " + v_VerificationToken + " " + v_Endpoint + " " +...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 any previously generated ones. A code lasts between 1 to 10 minutes. {"code": "AUTHENTICATION_FAILURE","details": [],"message": "Authentication failed","status": "error"}: I have had this error with API v2 when I'm using PHP/cURL and not deluge to get a...

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

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 email with the permalink v_Subject = "Data for Export w/c: " + zoho.currentdate.toStartOfWeek().toString("yyyy-MM-dd"); v_Message = "To he who shall not be named, Re: " + v_Subject + " Please find attached the CSV export file containing the Data. "; //...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 // // send via Email v_CountRows = l_CsvFileRows.size() - 2; v_Subject = "Shopify Products Export & Comparison"; v_Message = "Please find attached a log of " + v_CountRows + " Product(s) from Shopify that had been updated on " +...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 v_TemplateID = 12345000000678901; v_Template = zoho.sign.getTemplateById(v_TemplateID); v_OutputMessage = ""; // // get the Action ID for SIGN v_SendActionID = 0; if(!isNull(v_Template) && !isNull(v_Template.get("templates"))) { // _...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 above to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 "2021-05-17T11:02:59+01:00", "id": "98498465735491156", "Created_By": { "name": "Joel Admin", "id": "123456" } }, "message": "record added", "status": "success" } ] } and if using code to capture the ID: v_ResultingQuoteID = 0;...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 l_DataRows.add(m_DataRow); } } else { l_HeaderColumns = List(); l_HeaderColumns.add({"key":"message","value":"Message"}); // if(v_ResponseCode == 3100) { m_DataRow = Map(); m_DataRow.put("message","No records found"); l_DataRows.add(m_DataRow); } else {...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 few years with this script, the version below migrates the following: Articles Banners Categories & Sections Menus * NEW Messages Newsfeeds Users * UPDATED Weblinks So this is fun. We've waited and waited and Joomla 1.6 is now stable... Exciting because...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my end-users to...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 A quick article on how to display a OK/Cancel popup which I use as a message to the user for debug purposes. Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an XML as...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 update any of the fields EXCEPT for "ApprovalStatus" and would get the following response when attempting: { "response": { "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7013, "message": "Field name...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 //info r_CreatePayment; if(r_CreatePayment.get("message") != null) { if(r_CreatePayment.get("message").contains("payment has been created")) { // // update the invoice (request by client to store last 4 digits on invoice) l_CustomFields = List();...

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