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

13 February 2023 v_Message = message.trim(); l_Messages = List(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime =...

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

Inserting incremental weeks in MySQLhttp://mail.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 so that all the weeks correspond to the rest of the academic data. Unfortunately the developer wrote a system he felt would last the rest of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A...

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

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week ------------------ ----------------- ------------------- Report 001 5 2 Report 002 11 47 Report 003 7 61...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID doesn't exist in our...

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

Zoho Creator / Shopify: Get all Active Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL +...

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

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

16 March 2023 :v_CaptureIntentEndpoint type :POST parameters:m_CaptureParams headers:m_Headers ]; // // get card details (we need to store last 4 digits) v_StripeReference = ""; v_Last4Digits = ""; v_ZB_InvoiceID = 0; m_Charges =...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 "_Global". At the same level, create another folder called "Profile Photos". Navigate into the "_Global" folder and note the last hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as...

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

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How?...

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

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 m_SurveyBody.get("Number_of_Employees")); m_CreateAccount.put("Turnover", m_SurveyBody.get("Last_Years_Turnover")); r_CreateAccount = zoho.crm.createRecord("Accounts", m_CreateAccount); info "Creating CRM Account: " + r_CreateAccount;...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: --...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 ---------------- -------------- 04/03/2011 Tweedle Dee 10:00 12:00 2.00 08/03/2011 Tweedle Dum 23:30 00:30 -23.00 Note the last row is obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Checklist for the local computer repairshttp://mail.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 hours, holidays and emergencies, added 20/hour Add 20 for restore disk Questions for customers: What do you need to do? Last time it worked? Emails received since? Programs installed since? Alternative documents/programs to do this? Same errors on...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This...

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

JDatabase: using the Joomla database with exampleshttp://mail.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 array($db->quote('Joe'), $db->quote('jlipman')) )); $db->setQuery($query); $result = $db->query(); -- retrieve last inserted ID $last_inserted_id = $db->insertid(); UPDATE using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of...

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

Parse a HTML Table into a ListViewhttp://mail.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 ; split into an array StringSplit,ReturnedHTMLTableCols,ReturnedHTMLTableColString,| ; add to last found listview LV_Add("", RowIndex, ReturnedHTMLTableCols1, ReturnedHTMLTableCols2, ReturnedHTMLTableCols3, ReturnedHTMLTableCols4,...

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

MS-DOS: Copy folders without overwriting fileshttp://mail.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 files older than n days/date. /MINAGE:n :: MINimum file AGE - exclude files newer than n days/date. /MAXLAD:n :: MAXimum Last Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...

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

T-SQL: Parse an XML valuehttp://mail.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[position()=1]') FROM [dbo].[XML_EVENTS] -- to get employee node at last position from root node SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER[last()]') FROM [dbo].[XML_EVENTS] -- to return...

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

Sort an associative array by values in Javascripthttp://mail.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); // removes last row which is undefined (ie. "]") myRecords.pop(); // loop through array for (i=0; i

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttp://mail.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 = json_decode($response, true); return $output; } 5. Get Minutes Remaining on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token value so it is reused until it is about to expire. Firstly,...

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

Zoho Creator: Add a subform while creating a recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 v_ContactFname = r_ContactDetails.get("First_Name"); v_ContactSname = r_ContactDetails.get("Last_Name"); v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State");...

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