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

  1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    - Revamp and debug line by line - Switched email identifier back to StaticAlias rather than member Email - Possibly still an issue with delayed payment (check this is not holding status) Date Modified: 2023-03-17 (Joel Lipman) - Enhanced debug messages...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  2. Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-your-statement-execution-limit.html

    limit is 50000"; Additional Note(s): Observation #1: Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate statements; this is not true as the following counts 3 statements executed prior to the loop: //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    loading process where it will load the first few images and as the user scrolls down the dropdown, more are loaded. This still gets buggy on certain mobile devices as some images are over 1Mb. So I needed a tool that every time a new product is added, a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  4. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    */ // // -------------------------------------------------------------------- // using Analytics API v1.0 (suprisingly still works in September 2025) /* v_OwnerEmail = ""; v_WorkspaceName = "Zoho CRM Reports"; v_ViewName = "ZohoSurveys - Spider Chart";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  5. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    This message doesn’t necessarily mean a third-party app; it usually means the existing bank feed integration is still registered within Zoho’s system. Even if it’s no longer functioning, Zoho treats that integration as active and blocks you from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  6. View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

    can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You will still need to suffix the frontend URL with ?tp=1 Joomla 1.5.x This is another feature which took me a few years to notice in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    > Mailer settings). Alternate between PHPmail and sendmail just to check this isn't the problem. If the problem is still there then check the below: Tried both PHPmail and sendmail So if this happens irrespective of whether I have PHP mail or sendmail...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They experiment on their customer-facing website and in most...

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

    search, but the above files are enough to start adding your own code to make the "relevance" ordering more relevant.... ok still to come as I'm really happy with what the above already improves! Download the above modified files. The following ZIP file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    we would want entitled "about" or "about-us" but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The fix that I use involves a change to #__menu table in the database for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    1, INSTR(a.`name`, ':|joe')-1 ) WHERE a.`name` LIKE '%:|joe|:%'; Weblinks As helpful as they'll ever be. Still, I have a few I might want to keep, might as well migrate all of them: --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    '' post_mime_type, 0 comment_count FROM my_joomla_db.jos_content ORDER BY id Importing the joomla categories to Wordpress: (still to do: sections as parent categories?) SET @CountCategoriesAlreadyEntered:=(SELECT MAX(term_id) FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  13. 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

    into segments: ffmpeg -i output_audio.mp3 -f segment -segment_time 600 -c copy output_chunk_%03d.mp3 Install Python and PIP Still within the terminal: brew install python Upgrade to latest PIP: pip3 install --user --upgrade pip Install Numpy As user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  14. 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

    = floor($diff/60); } 6a. Use existing Access Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified earlier. if( $api['jwt']['token']['minutes'] > 5){ $access_token...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  15. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have the following fields that I also use related to Google Maps v2: Last Additional Ensure that when Google asks for your...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  16. Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    Note that this article is based on a new blank project which does not include code from the previous example but you can still build this over the previous example (as I did). Why? The previous article meant that the Google map was your main activity...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  17. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    will have a string of 8 characters long in the format DDMMYYYY and on other rows, this is blank with spaces instead, I still get the Error: The conditional operation failed. -- I've been given data as a Flat File with fixed columns (Ragged Right). --...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. 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

    in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How? My example is that I have an excel sheet where the first 10 rows are descriptions to the column,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  19. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    tablix has to be applied to both the textbox and tablix (as tablix doesn't show if resultset is empty by default anyway but still occupies a blank space which moves your textbox down...) Searches that got me nowhere ssrs display message if dataset rows...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    = :StudentReference OR table2.studentUsername = :StudentADAccount ) Now searching on the ID parameter ("@StudentReference") still works but when I type a Username ("@StudentADAccount"), it populates only the first dataset with results; the remaining...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 41 - 60 of 94