Joes Youtube Plugin (JYP) Downloadshttps://www.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Tested for compatibility with Joomla! CMS v3.4.0 - Included instructions in description - Included license file - Date Uploaded: Thu, 12th Mar 2015 Download 1.0.4- Tested for compatibility with Joomla! CMS v2.5.8 - Modified description. - Date Uploaded:...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new system admin details with old (name, registration date, etc). Copy over Categories: It is recommended to do this via the...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the month is before the current date, then set it to the last...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: 2020-03-17 */ // get all field names for the Invoices module via API l_FieldApiNames = List(); r_Fields = invokeurl...

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

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 v_MaxCount = ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with datetime criteria: NB: You can't compare a date time value to a field that is simply of datatype: date v_PerPage = 200;...

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

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm...

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

Transact-SQL Date Format Conversionshttps://www.joellipman.com/articles/database/t-sql/transact-sql-date-format-conversions.html

19 November 2010 Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 sid => ? dunno title => by web link title alias => sort by alias title url => sort by url description => sort by description date => sort by date added (most recent or oldest first) hits => sort by hits (number of times clicked on) published =>...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team members) who...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 Trigger: On button click Purpose: Preps stripe terminal to take payment for balance of invoice. Inputs: invoice Outputs: - Date Created: 2023-02-24 - Initial release - Reads Books Invoice and sends the amount to the reader for a payment atempt Date...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 users from saving a record without changing this. This script will round up decimal fields onload. Inputs: - Outputs: - Date Created: 2023-12-13 (Joel Lipman) - Initial release - Correctly rounds any decimal fields to their maximum decimal place. Date...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your...

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

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 entered via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests,...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 site using an Agile framework based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available for download 24/7 so...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value to when you leave, compile the code into an executable, and schedule it as a...

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