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

  1. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    Applies to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Submit form as a server and not the client with cURLhttps://joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...

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

    This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...

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

    URL and which both generates and outputs a thumbnail image and makes it downloadable via URL. Why? Performance. I have a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  5. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  6. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://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

    I used a PHP function to upload a video file to Google Drive. Note that this example does not involve installing the Google Client Library for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that are uploaded to a folder. The client also purchased OS PDF Indexer by OS Solutions...

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

    to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and the below is how I achieved...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single Line) Location ID (Single Line) API Version (Single Line)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    you been a developer? And this is new?). Can the developer be contacted? Yes! Questions to ask the developer The original client's brief for the project? (project mandate/charter/initiation document - the spec) Details on the Development Environment (is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    URL parameter zc_LoadIn=dialog: Click Here to Popup my Notification Dialog Additional This is optional but it allows your client/users to edit the text of any notification without knowing any code and without needing to use your creator knowledge. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-change-radio-into-tabs.html

    a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The scenario is that my client has quite...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

    issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain for the client. Who owns the domain (eg. mycompany.com) So this setup involves creating the TXT records on the DNS. Ideally, we would not want...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  14. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    which has the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties involved, plus the documentation online...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Creator: Receive JSON via a Shopify Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-json-via-a-shopify-webhook.html

    with options "Order Update", "Inventory Update", "Product Update"] JSON Payload [Multi Line] 2. Joel's first Cheat: If your client has ZohoCRM, let's use a CRM REST Function Granted this only works if you have a CRM connected to your Zoho Creator:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...

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

    update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM quote to a ZohoBooks estimate and a client asked that the address on the CRM record 'pulls through'. Sending the address in the same request however gives me the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  19. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has a rather rich HTML email signature with a profile photo included. When sending an email from CRM, they want CRM...

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

    a data table and then to push the attachment from ZohoDesk to ZohoAnalytics using the API. The use-case here is that a client wants customers to submit ZohoDesk tickets and upload photos of the problematic product to the ticket. They then want an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
Results 21 - 40 of 113