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

  1. Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=53&Itemid=165

    Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  2. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    about 5 seconds till after this datetime to allow auto-updates to happen. This method is fine for 1 or 2 fields and if your workflows only trigger when the form first loads (especially on Edit as this populates each field and triggers their workflows)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    on the Sales Order in Zoho Books using the API The following is the code template I use but you will need to adapt it for your own system: // init (specify your own organization ID for Zoho Books) v_BooksOrgID = 20210922122; m_BooksCreateSO = Map(); //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  5. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    + "/My_Subform.My_File/download?filepath=/" + v_DocFileName; The API Solution The following solution requires that your target API accepts base64encoded images or that you can send these in a cURL request (same thing really): string...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    the code to list a ticket's attachments and push them to the ZohoAnalytics data table. Check that ZohoDesk is sync'ing with your ZohoAnalytics: Login to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of the workspace name that your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  7. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    + v_OrgId type :POST connection:"my_books_connection" ]; v_OutputResponse = "Thank you for accepting your quote! We'll be in touch soon to finalize the next steps and get everything ready."; } else if(v_Intent == "Decline") { b_ValidResponse = true; //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    quick steps to create a widget.html file and how to get whatever the Zoho Deluge CRM function returns. Create a JS Widget on your device (MacOS) These steps are the minimal amount of information I need to quickly set up a JS widget: Open a MacOS...

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

    so you would have to refer to the output without this column before modifying the query to include the page names of your survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration. Also note...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  10. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    it quite low priority. This is easier to tweak in the upgrade. The following will again maintain the functionality for your website visitors to change the order. If you want to change the default order of your weblinks in the front-end of your Joomla!...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options for your website members. If Joomlapolis ever complete the CB Subscription component then there is no need for AEC anymore. For this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important clear button. What I found was that no one posted this solution which I found is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

    of it and put it here with my minor revisions/adjustments to get it actually working. STEP #1: Check ReCaptcha API Check your recaptcha plugin is up-to-date as some Joomla 2.5.x systems will not have updated this: Open the file...

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

    Requires Homebriew, FFMPEG, PIP, and Python: Open the "Terminal" app Type brew install ffmpeg Extract audio: ffmpeg -i your_video.mp4 -vn -ar 16000 -ac 1 -b:a 64k output_audio.mp3 [Optional if using online version of OpenAI Whisper] Split audio into...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  15. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    The objective here is to upload a video file to my Google Drive. This assumes you have already "Enabled the Drive API" via your Google Developers console as well as gotten your OAuth 2.0 access/refresh tokens and specified the appropriate scopes. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    select "ConnectionString" In Expression, type @[User::SourceExtractFile] OK to save it Add the ForEach Loop Container to your "Control Flow" (NB: This did not exist in my data flow ssis toolbox - if you do not see it when you are under the "Control...

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

    Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your SQL Server Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    do this in the next screenshot. Note how all our variables are hidden and cannot be NULL. If you're unsure, right-click on your dataset and bring up its properties... Specify the query type as "Stored Procedure" and then browse the dropdown for the name...

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

    took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    OR @GivenSurname'' OR @GivenDOB'') -- The TOP 100 is what improved our performance. -- If you can't find the person in your database in the top 100 of your search -- then you must be limited on what you know about this person... Refine your search. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 101 - 120 of 352