Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication feature for leads and contacts but not for products. How? There may...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 NOT match how ZohoBooks does it. ZohoBooks rounds the .545 to .55 and .544 to .54... so let's abandon the truncating and simply deduct 1/10th of a cent/penny: // ------------------------- // Make .545 = .54 and .546 = .55 // CRM rounding v_RateCrm =...

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

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

23 June 2025 the Python Script to Transcribe python3 transcribe_vosk.py I left the script running overnight so I'm not sure whether it simply played it for 5.5 hours and transcribed it or whether it did it in a shorter amount of time; but the next morning I had a...

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

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title and...

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

Does Google Chrome Frame really improve performancehttps://www.joellipman.com/articles/google/does-google-chrome-frame-really-improve-performance.html

23 September 2009 proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame (or ChromiumBrowser) is quick to enable. Simply ask your webmaster to put the following meta tag in between the head tags of the page: For Joomla v1.5.x Administrators:...

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

Splatter Logohttps://www.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 web-developers need to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the selection on Create a new layer beneath Go to Selection > Modify > Expand > 10 px...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

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

26 October 2011 when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of...

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

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

08 November 2012 suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our...

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

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 or print output, it will save to this folder on your computer). Can type lcd if you want to change this (leave blank to simply display what current local working directory is). Type dir -S . temp.txt which will output all files including subdirectories...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Disable User Registration in Joomla 1.5 - Configuration Filehttps://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php...

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

Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 . (dot) - (dash) BASE64 Forces the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value to...

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

SSRS Change Background Color of Imagehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 circles with the background being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has...

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

SSRS Display question mark when date is blankhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type: =IIF(CStr(Fields!MyCompletionTime.Value)"",...

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their...

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

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 1.4571E+18 David 3.31235E+11 1.4571E+18 How? Firstly, save the CSV file as text file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt...

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