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

  1. Connection Strings for SQL Serverhttps://joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Specifying socket This one specifies the Unix socket file or Windows named pipe to connect to. Used only for local client connections. Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername;...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  2. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    From within books (or inventory, subscriptions as these are simillar), go to edit a custom function and click on the "Connections" link to the top right of a function: If this is your first connection, simply click on the "Go To Connections" button...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Run commands for Windowshttps://joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    ipconfig /displaydns IP Configuration (Delete DNS Cache Contents) ipconfig /flushdns IP Configuration (Release All Connections) ipconfig /release IP Configuration (Renew All Connections) ipconfig /renew IP Configuration (Refreshes DHCP & Re-Registers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  4. Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    such as Zoho Projects and the originating app (in this example, Zoho Creator). 1. Setup up Zoho Oauth Connection: Go to connections (in creator this is icon in top-left > Setup > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this application mode) Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some more if you're...

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

    unique records The connection Within any syntax editor of ZohoRecruit (where you type the deluge code), there will be a "Connections" in the top grey bar that you should click on and create a connection with the scopes that you want (I select nearly all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  7. Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes. Restoring in SSMS, Right-click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    Total: £2,059.65 Not Used Case Fans 2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: "it's a poor workman who blames his tools". Let's make do with what we have. The 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  9. Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    your computer which is to open a command prompt and to type "ipconfig /flushdns" then "ipconfig /registerdns" and the connections would have been restored. As I love automation and reducing processes to single-click fixes, I made this teeny tiny program...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    to ZohoCRM as the creator super admin/owner (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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  11. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    ERROR_invalid_operation_type Sounds rather straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    here's how you do it in CRM: Login to Zoho CRM as an administrator and go to Setup Under Developer Space click on "Connections" Under Pick your Service click on "Zoho OAuth" (NOT "Zoho" - there are 2 Zoho options) Give the connection a name such as...

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

    horizontal lines in top left if in edit mode » pops up the side bar to go to Home or Setup) Under "Extensions", click on "Connections" Click on "Add Connection" Click on "Zoho Oauth" Give the connection an easy name (will be lowercased) but descriptive....

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

    I have elsewhere on my website, but to use in an invokeUrl here's a quick overview: ZohoCRM > Setup > Developer Space > Connections Click on Get Started / Add New Connection Click on the "Zoho OAuth" icon Enter a Connection name (for this example I will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    of staff who already booked the requested dates as leave. [Warning: red herring ahead] For this process, we setup connections choosing to make use of the Zoho People API and we could update any of the fields EXCEPT for "ApprovalStatus" and would get the...

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

    you have a CRM connected to your Zoho Creator: Log-in to your ZohoCRM Create a Connection Go to Setup > Developer Space > Connections > Add Connection Select the Zoho Creator connection, give it a Connection Name, I'm going with joels_creator Give it a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    reduce the scopes permissions afterwards when locking it down for security: Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth Give your connection a name, I'm calling mine "Joels Connector" Select the Scopes:...

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

    field called "Email" Return to the Context Handler Function IDE (page where you enter the deluge code): Click on "Manage Connections" Click on Create Connection Select Service "Zoho OAuth" Give it a name, I'm calling mine "ChatGPT CRM" Untick "Use...

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

    "20012345678") Note this down for later use Create a connection to Zoho Analytics: ZohoDesk > Setup > Developer Space > Connections > Create Connection Select Zoho Analytics and give the required scopes (I've cheated and gone for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  20. Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure you setup a Connection that does NOT use the credentials of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
Results 1 - 20 of 32