Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 For obvious reasons, these cannot be hardcoded. What? Any developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data...

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

Adding a selectable background to a Yootheme templatehttps://joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 off/on using the Joomla Admin Panel. How? For demo purposes, I'm going to add the background "Ambient Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file and add some files that this will select. Modify...

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

Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 StringSplit,ReturnedHTMLTableCols,ReturnedHTMLTableColString,| } LV_ModifyCol() Method #2 This method only uses two columns with the label being a concatenation of the value of the first column and the column heading....

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

Joes Syntax Styler (JSS)https://joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the...

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

Things to Check if Joomla Password Reminder email not being senthttps://joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 you just made. Send a test message. Test your email server can message: Send an email using the server that the “Site Email” uses. If this is web-based, then ensure you are using a separate instance of the browser to your Joomla one. Check that your...

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

Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 the week that date occurs in. How? The example below shows how to do this when your weeks being/commence on Monday. It also uses the current date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates...

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

Batch Process to rename multiple files using Windows DOShttps://joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 count on it. I'm going to use a short batch process but to save time on the different ways of doing this, the example below uses a command prompt to a) create a batch file b) use it to rename the files c) delete the batch file. Open a command prompt:...

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

A quick run through of setting up an export process in SITShttps://joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 the same as the the XET and EOR codes) Specify the Message Group that the monitors will run. In our demo, the link value uses all three primary keys of the CAP entity. They can be separated by double hashes/pound signs or a single tilda with the keys...

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

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

24 October 2014 products. The Purchaser and any Pilot in Command (PIC) assumes full and unlimited responsibility for all applications and uses of any products sold by JoelLipman.com. JoelLipman.com agents, representatives and employees are to be held harmless from any...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 one area, but you can include multiple components by separating these with a comma. This parameter is a text field which uses the alias of the component (eg. "doc_indexer"), you would need to modify this to the component you want it to search. More than...

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

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

05 October 2015 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 row and splits by commas (not within quotes) - Sorts the...

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

AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option) ; decimalPlaces is the number of decimal places to round ; -------------------------------------------------------------------------------------- autoByteFormat(size, decimalPlaces =...

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

CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an alert message, it popups a div at the centre of its...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 https://zoho.com.cn/ then use the endpoint https://www.zohoapis.com.cn/crm/v2/coql 3. The Deluge Code - Uses the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0;...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in functionality of Zoho Creator and could be seen as a 'Pure CSS' feature. I'm aiming to make a list of...

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

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

10 December 2020 2 sets of documentation and the other is that the majority of the documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process was....

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 trial and error will resolve this or use our examples above. // fields required if submitting time log without start time (uses current time and adds hours to it) - date (in US format irrespective of your datacenter: MM-dd-yyyy) - bill_status (either...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho Creator:...

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

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run them once, store them as a map on your function if you don't want to use up these 2 every...

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