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

  1. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    me out!"; } // // add the answer text to the response map m_Response.put("text", v_Answer); // // output return m_Response; Even in test mode or simply starting a Cliq conversation will now yield something like the following: Additional For every chat...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  2. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records...

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

    specify the size of the image as well (16x16 is a tad small). Caveat(s): A bit work needs to be done to the code above to prevent attachments from going in twice. You would need to record the attachment ID and only push it to Analytics if Analytics...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  4. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    field properties, as soon as the staff user tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    as: f_CSVFile.setParamName("file"); 3700: Unable to upload a file. Please check and try again. If I test my connection or even change how I upload the file, this error no longer appears. This error seems to be at the end of a function which has already...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    // // store the record in ZohoCreator // I have a custom form in ZC with the fields "Event_Type" (single-line) and "JSON_Payload" (multi-line) m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order Update");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  7. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    on the "ZohoAnalytics Image URL" value to copy it into the textbox: Great! Now the next step makes the value into an image. Even if this is filled with URLs for images stored on remote websites, it helps to preview the images. Right-click on the header...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  8. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    line items as well as setting the value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to Sales...

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

    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 deactivating or deleting the account...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  10. Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    Google Safe Browsing diagnostic page for this address I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder (v1.2) and Joomla (v1.0.14) then you're vulnerable to a hack. Watch for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    a category of weblinks, the default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by title in ascending order without installing any 3rd-party...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    and not customizable. I fixed this by removing the reference to router.php within the installation XML file. (router.php). I even deleted the router.php file from my installation zip file (I checked that nothing was referring to it). The reason I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  13. RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this solution unless we continue to pay for the subscription. Understandable to some extent,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  15. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the...

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

    it down to a specific IP address. The below does not involve installing any third-party extensions and will remain in place even if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more...

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

    A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. Parameters not being used in report processinghttps://www.joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    tt.[SiteId] AS 'Site', tt.[StartTime] AS 'Start', tt.[FinishTime] AS 'Finish', tt.[RoomId] AS 'Room', sd.[Descrip] AS 'Event Type', sd.[Notes] AS 'Booking Notes', c.[Name] AS 'Contact', c.[Company] AS 'Dept', c.[Phone] AS 'Phone' FROM...

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

    the range (change based on slot times) SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  20. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to having all parameters...

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