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

  1. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/component/content/article/excel-convert-degrees-minutes-seconds-to-decimal.html?catid=110&Itemid=165

    116°42′30″E Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these don't automatically change when you copy the formula to other parts of the spreadsheet (ie. not relative). Sheet1!A1 is the cell to search for those...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    cable pulled further out (perhaps a bit too much) 3 plugs in. It came with heat shrinks to join the power cables but I may change this to a plug later. Hmm... maybe I should have painted my Phantom in chrome. My DJI Phantom FC40 repainted and gimballed....

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  4. Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

    "Maps the distributor/reseller from the opportunity into the account.". Category is Module, Page is Create Page (Standard) (change this depending on if you're using a canvas or not) Module is Quotes Type is Page Event Event is onLoad Click on the button...

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

    cog icon in the top-right Click Marketplace Select the Zoho tab Enable Advanced People Analytics Once enabled, the button changes to View Details Open the configuration panel and click Edit Configuration Review the sync schedule, hourly is within...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  6. Joomla: Unable to find install packagehttps://www.joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

    friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and double-checked the server...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html

    … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

    as $block) { $block = str_replace('-', '', $block); $this->module_row1 .= call_user_func($block, $this, $mClasses); } And change it to: foreach($this->horizontalCookie[$row] as $block) { if(!empty($block)) { $block = str_replace('-', '', $block);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  10. About 5 seconds worth of funhttps://www.joellipman.com/component/content/article/about-5-seconds-worth-of-fun.html?catid=77&Itemid=165

    (change all instances of MYDOMAIN, myusername and MY_SHAREPOINT_SITE accordingly). The moon to play with /_layouts/people.aspx?MembershipGroupId=# where # is the ID number of the group (will error on invalid IDs).

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  11. CSS Fieldsethttps://www.joellipman.com/articles/cms/website-development/css/css-fieldset.html

    horizontal space between label and fieldset fieldset label.inline { display: inline-block; margin-left: 2em; } Change color of fieldset grouping line fieldset { border: 2px ridge #7abcff; }

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  12. Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=100&Itemid=165

    is crude replacement to the quick launch toolbar which arranges your icons in a grid that you define (the default is 7x7). Change the links and icons by running the program, right-clicking on the icon in the system tray and select "Edit...

    • Type: Article
    • Author: Joel Lipman
    • Category: Products
    • Language: *
  13. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    this was due to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to a currency or two decimal places. Another suggestion was to alter the main...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 161 - 173 of 173