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 apply is required, the following 54 results were found.

  1. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    General Public License for most of our software; it applies also to any other work released this way by its authors. You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  2. Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

    A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  4. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    new admin ID in J30 -- 3) Recover odduser's new ID in J30 and re-associate to content -- 4) Recover groups used in J15 and apply correct groups to users in J30 -- Affects: #__users, #__user_usergroup_map --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    "Director of IT". "O'REILLY" should become "O'Reilly" and not "O'reilly". "MCDONALDS" should become "McDonalds" but do not apply for "MacDonalds" because of names like "MACK" and "MACHURA". " and ", "la", "le", " van ", " de ", " of " and similar should...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  6. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    I could apply the PRINCE2 (Projects in a controlled environment) methodology to website projects but most people find this overwhelming. It's in business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the exchange fields (or container) to apply this to Select the "Export Format" tab and click on the chevrons ("»") next to the field to apply this to Enter the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  8. Zoho People Analytics Regional Configurationhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-analytics-regional-configuration.html

    Open the Employee Dashboard Click Share, then Share this View Click on “Pick Users / Groups” Select the Group: “APAC” Click Apply Permissions & Filters Grant: Read Options View underlying data Export Data (if required) Drill Down and Drill Through Do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  9. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  10. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    rename the files c) delete the batch file. Open a command prompt: Method #1 Open windows explorer to the folder you want to apply this to Hold down the shift key and right-click on the folder Select "open command window here" Open a command prompt:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  11. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // apply changes to any of the line items l_NewLineItems = List(); if(!isNull(m_RecordData.get("id"))) { for each m_LineItem in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. 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

    Save and Exit Press Control + O (write the file) Press Enter (confirm filename) Press Control + X (exit nano) Apply It source ~/.zshrc Test It whisper --help Run the whisper on the original MP3: whisper output_audio.mp3 --model small Error(s): PATH...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  13. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF(...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. SSRS Border Problemhttps://www.joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

    then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Add default to a picture buttonhttps://www.joellipman.com/component/content/article/add-default-to-a-picture-button.html?catid=48&Itemid=165

    Well there's a lot of autohotkey sites saying that you can apply a transparency and then capture special mouse events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  16. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    below it. Cheating the censor system is against the rules. If you break one of these rules, the following penalties will apply (first time, second time, third time...) with the exception of breaking the rule "No Hacking" which immediately results in a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  17. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    --- Display/Access based on User level --- Joomla! CMS check-in/check-out supported. --- Download count (read-only? - would apply to just this version - total showing on general page) --- Rating (read-only? - modified by front-end votes) ---...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    property or product arising from or in connection with any products sold or supplied by JoelLipman.com. This indemnity shall apply without regard to whether the claim, damage, liability or expense is based on breach of contract, breach of warranty,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-apiv2-using-php-curl.html

    this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: en-GB
  20. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 1 - 20 of 54