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

  1. Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

    Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is...

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

    line text field Candidate x JobOpening Name: Mandatory name field that we will use so as to create 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...

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

    service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

    information Use the team_folder_ID or if it is a subfolder, then use the team_subfolder_id Ensure the scope for your connection includes WorkDrive.teamfolders.READ and note that header has to be added otherwise you get a blank response: m_Header =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

    all portals v_EndpointPortals = v_BaseURL + "/restapi/portals/"; r_Portals = invokeUrl [ url: v_EndpointPortals type: GET connection: "my_projects_connection" ]; info r_Portals; // // once we check the JSON, we can select a portal name and ID, this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Click on "Connector ODBC" Download a version suitable to your system Install it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC) Click on the System DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name...

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

    page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection: ERROR_invalid_operation_type Sounds rather straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space >...

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

    should yield SUCCESS and if you check your CRM record it will have these under "attachments" Setup a Zoho Oauth Connection So that we can use invokeUrl and attempt the REST via API (see what I did there?), we need a Zoho Oauth2 connection in Zoho Books....

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

    of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  10. Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

    import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. How? Well, let's setup the FTP connection first in Zoho Analytics: Login to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this application mode) Then go to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    only 1 image is accepted at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory v_InventoryId = 123456789012345678;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

    the Top Level Domain (or Zoho DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a connection called "zbooks" and the v_BooksOrgID is the ID of the instance in ZohoBooks; so for multiple instances of ZohoBooks for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

    = "https://www.zohoapis.com/crm/v7/Quotes/" + p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // apply changes to...

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

    and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator super admin/owner (might not be the same as CRM super admin!!!) Go to Setup »...

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

    then push the creator record to Zoho Projects. How? For the following example, you will need to have setup a Zoho Oauth Connection with the appropriate authorized scopes and have access to all related systems such as Zoho Projects and the originating...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    r_CreateCrmQuote = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type :POST parameters:m_Data.toString() connection:"myconnection" ]; or if converted to JSON, the request would read as: { "data": { "Subject": "My Test Quote",...

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

    REST Function Granted this only works if 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox Mode"; } else { r_Api = API_Integration[Connection_Name == "eBay API...

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

Please publish modules in offcanvas position.