Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming work is required, the following 174 results were found.

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

    Admin Panel > Extensions > Template Manager > Styles > "Select the Background" > Save/Apply Done! Additional Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member to access these and I tend to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    - Applies to Joomla 2.5.x +, 3.4.x What? So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    the component, they would usually need to go into the admin panel and set the ACL permissions. I want my component to work out-of-the-box: // No direct access to this file defined('_JEXEC') or die; // com_XXX is your component name class...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    const RECAPTCHA_VERIFY_SERVER = "api-verify.recaptcha.net"; 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    amend the insert(s) into the new table `#_user_usergroup_map` Viewing Articles in the Administrator panel: INSERT INTO `#_workflow_associations` (`item_id`, `stage_id`, `extension`) SELECT `id`, 1, "com_content.article" FROM `#_content`; UPDATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving the instructions here in case it works for you. Pre-amble Requires Homebriew, FFMPEG, PIP, and Python: Open the "Terminal" app Type brew install ffmpeg Extract...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  9. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    URI being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET = ''; // expecting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    this script doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  11. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    programming solutions that seemed a bit over the top for something that should be so simple. Hey presto, I found a cheat/workaround: Click on the list to see your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  12. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    selected. View the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$"). Using the example above: Sheet1$A11:AL12 Selects all data from column A,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  16. SSRS / MDX Date Querieshttps://www.joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

    I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    second(s) This isn't what I want... It wasn't accurate enough and always saying 0 seconds was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    color the backgrounds based on whether they are the fastest or slowest in the set. Something like: The DataSet This should work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out: Open the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    it says the sync was successful, the problem could be that your computer is losing time because of a system clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
Results 101 - 120 of 174