ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 going to call this function "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products that are in your...

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

Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've covered this before in...

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

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 This is an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include photos of the faulty products. These display fine in a Zoho...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff can control that without the worry of updating an invoice and re-sending it.

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the tags of a contact and copies it over to the deal...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 the request. You do not need to pre-create those. Secure Access via GET All calls must include: name — the output file name without the extension url — the source image URL auth — your daily MD5 API key client — your lowercase alphanumeric client...

• 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 morning I had a "transcript.txt" file in the working directory. However, the outputted transcript file is all in lowercase without any punctuation so ChatGPT was not able to make much sense of it and reformat it. [Score: 1/10 for effort] I gave the...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 when viewing the output. Note that "Page Number" is my custom sorting mechanism so you would have to refer to the output without this column before modifying the query to include the page names of your survey. GENERAL was the first page asking for...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 { v_CrmAccountID = r_CreateAccount.get("id"); } } // create this contact as they filled in the survey without us sending it to them m_CreateContact = Map(); m_CreateContact.put("First_Name", m_SurveyBody.get("First_Name"));...

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

Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 where yourdomainname.com is your domain address and thetemplatename is the name of the template (without spaces). e.g. http://joellipman.com/index.php?tp=1&template=rt_affinity_j15 Or watch this boring video I made showing you how to do it:...

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html Personally I can sit there watching it without sound. Here's another video that shows how to build the camera: {module title="Youtube Embedded Video - Tilt-Shift...

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

Mouseover Links in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How? #NoEnv SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance Force ;...

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

Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 way I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":";...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/web-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

03 January 2013 2) . ' KB'; } elseif ($bytes > 1) { $bytes = $bytes . ' bytes'; } else { $bytes = '0 bytes'; } return $bytes; } Inline without a function Source: Joes Brain: http://www.joellipman.com if ($this_file_size >= 1073741824) $this_file_size =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

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 A quick reminder on how to disable user registration in Joomla! 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...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given....

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

SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some...

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

Joes Transmission Detector (JTD) Downloadshttps://www.joellipman.com/component/content/article/joes-transmission-detector-jtd-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.0- Read data packets without causing network traffic - Display program used to open port - Disallow program minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls...

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

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

23 July 2019 This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

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