Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a dropdown list. Add a button to upload an avatar (and sync with 3rd party avatar). Not riveting stuff but something that all my clients...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 List: Car Notebook Mini-USB mouse (wired) Norton Ghost USB Drive for storage (backing up clients pc) USB Drive with drivers/software/portable apps USB Dongle connecting to an Internet Provider OS disks Document Templates: Service Agreement Template...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 Connection refused 111 Can't open SMTP stream. One common problem people have is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues:...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable Generate list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

• 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 latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 "Stored Procedure" Click on the radio button when adding your dataset and then select the stored procedure from the dropdown list. 4b. Add a dataset: the "Refresh fields..." button Click on the "Refresh fields..." button so that you can define the query...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 the contents to a text file called "directory_printout.txt". This file will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data...

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

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

19 November 2012 some files that this will select. Modify \templates\\config.xml add the select option "Ambient Turquoise" to the end of the list: Grey Dots Tartan Lines Dark Squares Light Squares Mosaic Turquoise Color Ambient Turquoise Add a...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma Seperated Values (CSV) list of all data from an Advanced Web Statistics [AwStats] v7.0 (build 1.971) report. The data file is used by my infographic script which...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...

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

Compare two databases using T-SQLhttps://www.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT *...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I want to use &G[] and get both the code and the lookup value:...

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

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

09 March 2015 There should be several additional options to your search that will be displayed under the "Search Only:" heading and then a list of components. Find the value of the checkbox by viewing the HTML source and you should see something like the following:...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 your endpoints as appropriate. #2945 MORE_THAN_MAX_OCCURRENCE: Ensure your params are submitted as a JSON string (not a JSON list). Update Success: Not updating creator: This is a permissions issue. Ensure the owner or SuperAdmin of creator is the one...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 A4 sheet... Additional Notes I found that some classes are reserved words used by the Zoho built-in renderer. I am making a list here to see if that helps: Wrapping all your HTML in : Ok it's used in bootstrap and few other frameworks so this should be...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible...

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