Joomla Component: Set default params on installationhttp://mail.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 // JSON format for the parameters $query->set($db->quoteName('params') . ' = ' . $db->quote($defaults)); $query->where($db->quoteName('name') . ' = ' . $db->quote('com_XXX')); $db->setQuery($query); $db->query(); } } } Additional: ACL during install My...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttp://mail.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 Method #2 If method #1 didn't work for you then if the following code works, it's because Google have changed where they're storing the API (again). This overrides the Core Joomla code for ReCaptcha: 1. Open the file:...

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

Copy a Wordpress Site for Developmenthttp://mail.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 in DEV Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com to dev1.myexample.com where `option_name`='home' change...

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

Warning: Save failed. Another menu item has the same aliashttp://mail.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The fix that I use involves a change to #__menu table in the database for that website. The example used here will be to...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 PUT, DELETE'); // open connection $ch = curl_init(); // set the cURL options curl_setopt($ch, CURLOPT_URL, $api_url); // where to send the variables to curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml')); // specify content type of...

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

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

05 October 2015 commas between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS error where results unmatched column_values = column_values || []; // ignore row if first item is blank (allows for blank excel lines)...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 Drive folder in your browser and note the last string in the URL. So in https://drive.google.com/drive/folders/, the value where "" sits will be your folder ID. $GAPIS = 'https://www.googleapis.com/'; function uploadFile($access_token, $file,...

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

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

02 February 2019 key should not be stored in a public folder that is accessible via the web but at least stored (eg. outside your web root) where this script can access it. The same goes for the access token, store it off the web but where this script can access it...

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

URL Alias uniqueness with PHP & MySQLhttp://mail.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...

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

MySQL: Count occurrences of words in a columnhttp://mail.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) b ORDER BY n ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value`...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 2. Setup your Domain/Subdomain The process here is dependent on your service provider or domain registrar (website where you registered your domain). I've listed some third-party providers' instructions on how to set up a CNAME record at the bottom of...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 = Map(); // // enter webhook key featured in the "settings > notifications > webhooks" section beneath the webhooks where it says // "All your webhooks will be signed with.... so you can verify their integrity" (obtained further below in this article)...

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

ZohoCRM: Process all records of a modulehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 mark it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 Again this example doesn't include the publish key but can be used across apps in Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of zoho.appuri, we are hardcoding the...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has to go to the CRM record, click on Mail Merge, which opens...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then...

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

Zoho Creator: Populate a Multi-Lookuphttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

18 August 2022 prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where you simply add an option to the picklist and then specify which of the options are selected. In this case, simply giving it...

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

Joel's Reference to MidJourney v4 Promptshttp://mail.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 an easy to remember word for this set of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this...

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

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

06 March 2023 on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you enter the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a...

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