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

02 July 2024 Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data is incorrect in Zoho Analytics, and payroll gets run with these discrepancies, then they will have a fair few disgruntled employees...

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

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

23 June 2025 Create a Python Script to Transcribe from vosk import Model, KaldiRecognizer import wave import json # Use the correct audio filename wf = wave.open("output-audio.wav", "rb") model = Model("/Users//vosk-models/vosk-model-small-en-us-0.15") rec =...

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

ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 with Integration cannot be marked Inactive Summary In this case, the client’s bank account had previously been syncing correctly. After several weeks, however, the feed stopped updating, and the option to Refresh Feed was missing entirely from the...

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

SSRS Repeat Headers in PDF Reporthttps://joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to have any page breaks. When I run the report in BIDS, the whole report (despite...

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

UNC Paths in Sharepoint 2007 linkshttps://joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 2007 portal. How? Add a link with the prefix File:// and complete the rest of the path as per usual. Sharepoint will correct the link when you OK it if you are trying to enter a real UNC path: File://\\myServer\myShare\myFolder\myFile.doc -- yields...

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

Error 404 Component Not Found when enabling SEF URLshttps://joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 this was only affecting my subdomains where this template was installed. I installed some terrible 3rd-party SEF plugins to correct the situation but when I moved my test site to live at www.joellipman.com (instead of being on...

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

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

24 September 2015 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 same totals and will update this article when I...

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