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

23 June 2025 python Upgrade to latest PIP: pip3 install --user --upgrade pip Install Numpy As user (safest): pip3 install --user numpy Check numpy version python3 -c "import numpy; print(numpy.__version__)" Use OpenAI Whisper Install Whisper using PIP: pip3 install...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then( function( r_SubData ){ console.log("Raw response:", r_SubData); // Check if the response contains the expected structure let output = r_SubData?.details?.output; // If the output is JSON text,...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 for each m_XeroContact in l_XeroContacts { if(!isNull(m_XeroContact.get("ContactID"))) { // // to check if we want to update the CRM record for the account v_XeroTime = m_XeroContact.get("UpdatedDateUTC"); d_XeroAccountLastUpdated =...

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

Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html

06 September 2009 the gist of http://docs.joomla.org/Security_Checkli … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and...

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

How to run a .RUN filehttps://www.joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 a terminal by going to Application > Accessories > Terminal Type 'CD Desktop' to go to your desktop folder Type 'LS' just to check the .RUN file is in this one Type 'sudo sh nameoffile.run' Through the Gnome GUI Right-click on the file you downloaded...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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

Change Regional Settings for your Reporthttps://www.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View tab Check that the "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to en-GB Save the...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Now select the column that has just been created (usually "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again...

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

Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...

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