Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 */ // // init v_CountTotal = 0; // // the zoho analytics org ID noted earlier v_AnalyticsOrgID = "123456879"; // // query goals endpoint v_Endpoint_Goals = "https://people.zoho.com/api/forms/P_Goals/getRecords"; r_GoalsData = invokeurl [ url...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 */ l_Attachments = List(); // // the zoho desk org ID noted earlier v_DeskOrgID = 12345678901; // // the zoho analytics org ID noted earlier v_AnalyticsOrgID = 23456789012; // // let's get the ticket details r_TicketDetails =...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 is 111, previous admin ID is 222, and general information desk account is 333), remove other super admins (optional) I also noted the previous admin's ID and returned their super admin status. Sorted by group_id desc and changed 8 to 2. SELECT...

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

Add the website name to the page title in Joomla!http://mail.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some differences that I've noted down below. Specific Joomla Template Providers Everytime I update this article, Joomla seems to come out with a new version. If you...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Script Component Task: Transformation: Data Viewers Script Transformation Editor: Input Columns Additional "Features" I have noted that letters immediately following a punctuation symbol, have the UPPERCASE applied: eg. "Andrew Lloyd-Webber", "Marketing...

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

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 Click on the Environment Variables... button Under "System variables" find the PATH variable and add the JDK bin folder you noted earlier: Click on OK and close the respective dialogs (note that setting the variable via the command prompt will NOT...

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

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

12 October 2021 } 2 Which results in a map that I can give a Product SKU to and it will return the Shopify Product ID to me. You may have noted also the precarious method in retrieving the product variant SKU (this will error/fail over if a product doesn't have a...

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

Zoho Creator: Change Radio into Tabshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 to the note CSS input.Note_CSS = v_Css; Yields All of me Now we have the tabs looking close to what we want, you will have noted that I have done this code in-line of the form. If you were to embed the form on to a page, you would be free to use some...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 "Webhooks" in the left sidebar menu Tick "Contacts" and "Invoices" and enter the Delivery URL as the REST API Function you noted above: Copy the Webhooks key on the Xero page into your CRM function replacing the value in Line 2 of my code snippet above....

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

GoDaddy Apache cPanel: Install SSL Certificatehttp://mail.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 down and click on "Choose File" button under the "Upload a new certificate" section > Then select the certificate file noted earlier in step 4 (the one you downloaded as a Zip) then return to this screen and click on "Upload Certificate" Return to the...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttp://mail.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 or eu depending on whether you access zoho.com or zoho.eu v_TLD = "com"; // // enter client ID, secret and refresh token as noted from above steps (the below are sample ones and will not work) v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234";...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 3" FROM "Contacts" c LEFT JOIN "Contacts vs Campaigns Pivot" cp ON cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can only...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttp://mail.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 name as this gets appended automatically: so just 1522905495316._domainkey will do. Set the TXT Value to the DKIM Value you noted earlier ZohoCRM: Get IT to do the SPF The following are steps as to what to add in the TXT record. How to add the TXT...

• 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 v_FileNameFull = v_FileName + "." + v_FileExtension; // // upload to profile photos folder (enter the workdrive last hash noted earlier) v_StaticFolder = "abcdefghijklmnopqrstuvwxyz12345678901"; // // upload file to workdrive r_WorkdriveUpload =...

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

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

06 August 2024 check on this and would rather see it directly in ZohoCRM on the relevant record. So the more observant among you will have noted that I'm recording the module name and module record ID on the ZohoSign Document record. Doing this at the point of the...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the link noted from the URL made earlier (the one to the CRM REST API function): // should be something like...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttp://mail.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...

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

The greatest invention in IThttp://mail.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some...

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

Leap Motion and AR Dronehttp://mail.joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 in 3 dimensions. Available July 2013 for public release (you can pre-order if you like @ https://www.leapmotion.com/). It's noted for it's accuracy and response to finger gestures and it's compatibility with major platforms. The following videos were...

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