Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 or adapt all or part of the work in a fashion requiring copyright permission, other than the making of an exact copy. The resulting work is called a “modified version” of the earlier work or a work “based on” the earlier work. A “covered work” means...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 value of "email" Single Row Result - loadRow() This type of query is for when you want any of the values from one resulting row. You will need to know the column order the results are returned in. $db = JFactory::getDbo(); $query = $db->getQuery(true);...

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

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

13 December 2023 Products Edit Page (Standard) > Page Event OnLoad Purpose: ZohoCRM only allows up to 6 decimals but some calculations are resulting in more than this which blocks users from saving a record without changing this. This script will round up decimal fields...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 "OK this should take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 empty text file (Type "ECHO > TEMP.TXT") Type "FC /N /LB 300 c:\original_file.txt c:\temp.txt > c:\results_file.txt" The resulting file will be "c:\results_file.txt", open it in your favorite text editor... ta-daa... Explanation: FC is a file comparison...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 seconds). How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ---------- -----------...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 will not cause injury to any person or entity, and that you will indemnify JoelLipman.com or its associates for all claims resulting from content you supply. JoelLipman.com has the right but not the obligation to monitor and edit or remove any activity...

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

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Type the part of a URL between 'www.' and '.com', then press Ctrl+Enter. Adds www. and .com to your input and open the resulting URL. Type a URL, then press Alt+Enter. Opens the URL in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 a WHERE a.state=1 UNION ALL SELECT `name` AS title, `description` AS intro FROM `jos_hp_items` b WHERE b.published=1 ) t1 Resulting in: title intro -------------------------------------------------------------------- Welcome This is Joomla Copyright...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- Tip: I copy & paste this code into a text editor, then do -- "Replace All" with these 3 values, then copy & paste the resulting -- SQL into a query against my new database. -- - Replace Step #1: 58 Occurrences -- - Replace Step #2: 169 Occurrences --...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A student always has a "Student Reference" but not necessarily a...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to having all parameters set to the dummy value. For...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 including but not limited to personal injuries, damage to property, injury to others, including that to life and health, resulting from any application and use of any of JoelLipman.com products. The Purchaser and any Pilot in Command (PIC) assumes full...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 hour'); $api['jwt']['claim_set']['iat'] = strtotime('now'); And finally the JWT signature (or assertion in this case resulting as a combination of the header, data and signature): Using the JWT header, and claim set above, along with the private key,...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 v_RedirectUri = "https://www.zoho.com/books"; // can be any endpoint that does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope =...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 barely fit the fans and when attached to the case, if they were tightened too much, they would go right through the gaps resulting in the fans falling... But the crystal looks nice. Link(s) / Source(s): Microsoft Store: Intel® Graphics Command Center...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 on a dataset, can that data be accessed by external sources? No, if you train OpenAI on a dataset, that dataset and the resulting model will not be accessible by external sources unless you choose to make it publicly available. OpenAI takes data privacy...

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

Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop =...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 the mouse over the ellipsis that appears and select "REST API" Then click on the API switch to enable it and copy the resulting URL to your clipboard Now login to ZohoSign In the left sidebar, go to > Settings > Developer Settings > Webhooks Copy and...

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