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

  1. 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

    Country" } } However, if you try forcing the billing or shipping address in you should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    through'. Sending the address in the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after you have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    Oauth" Give the connection an easy name (will be lowercased) but descriptive. For this test I will call it "myconnector". Ensure that as a minimum, the scope ZohoBooks.salesorders.CREATE is ticked. Click on "Authorize" Read the notice saying Creator...

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

    unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    (might not be the same as CRM super admin!!!) Go to Setup » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  6. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    a unique MD5 for each file with the filename appended. Because of MS Windows 11 limitations (any MS OS really), you need to ensure that long hyphens (#151) and some other funny characters are replaced out as the OS won't allow the file to be sent to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Shared...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    the files generated to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  9. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    should get a version number for each of these as a response. Failing this you should check your security and privacy and ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line...

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

    with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data table in ZohoAnalytics to hold the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  11. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user"....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    The below will a) change the /administrator location and b) limit access to a single IP address. Note that you will need to ensure you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But just in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    sub-entities under the parent one (not used in this demo) and repeat the steps above to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  14. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    in the same column. Extra blank columns will not appear. Cause 2: Objects in the same column have different widths To ensure all the objects in the same column have the same width: Select all the objects (such as database fields, column header text...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  15. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    where to find the Corresponding Source. Regardless of what server hosts the Corresponding Source, you remain obligated to ensure that it is available for as long as needed to satisfy these requirements. e) Convey the object code using peer-to-peer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  16. 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

    > Forms > Leave Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  17. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    Ref"),""); // // start building addrecord request m_Create = Map(); // // specify unique name to ensure we don't duplicate these m_Create.put("Candidate x JobOpening Name",v_Name); // // specify the Zoho Recruit Candidate ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    is that we retrieve the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and Zoho is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    ideal. Instead, let's use a CRM function to store the conversation between ChatGPT and the CRM User. This way, we can also ensure that the data shared can be controlled/monitored. Create a CRM Module called "GPT Chats" (singular: GPT Chat) Modify the...

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

    create two writable subfolders: _origs/ — stores the original downloaded images _thmbs/ — stores the 75×75 thumbnail images Ensure both folders are writable by your web-server user (e.g. www-data). Client-Specific Subfolders The script automatically...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 1 - 20 of 57