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

05 December 2023 want to add to the code to only push valid image file types as files. The report will work for Zoho Users... didn't really test on permissions and sharing the report, I was logged in as the super admin on both ZohoDesk and ZohoAnalytics for the above...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 = ifnull(r_FutureEvents.get("events"),List()); Additional: Code to get a single event: The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to...

• 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 600 -c copy output_chunk_%03d.mp3 Install Python and PIP Still within the terminal: brew install python Upgrade to latest PIP: pip3 install --user --upgrade pip Install Numpy As user (safest): pip3 install --user numpy Check numpy version python3 -c...

• 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 click on Install Select the profile(s) that will have access to this button and click on Save Go to a CRM account record and test the button works. Go back to your Zoho CRM function and simply include HTML and CSS in the output of the function... done....

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

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 Select 'Parameters' and click on the duplicated field Click on the 'Delete' button and you should be left with just: Test and run your report :c)

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

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

17 May 2010 "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to en-GB Save the report and test.

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

MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 -- next Friday -- 2012-05-04 -- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both saturday and sunday returned week ending...

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

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will look like so that my post-staging phase can be developed as it...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://www.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the text there. Test by logging in as the forgotten user Done

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

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

02 September 2015 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 http://test1.joellipman.com), I found I could disable the third-party...

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

Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 false, "proxy": false } List of Free APIs with GeoLocation services: Just append the IP address to the end of these to test. https://extreme-ip-lookup.com/json/ http://ip-api.com/json/ http://ipinfo.io/json/ http://api.db-ip.com/v2/free/

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