Assuming connect is required, the following 44 results were found.
-
Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API I won't go into detail on how to set up your own connection as I have elsewhere on my website,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. This message is somewhat out of date but follow the following instructions to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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: Log-in to your ZohoCRM Create a Connection Go to Setup > Developer Space > Connections > Add...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the merged template and attach it to the CRM contact record under "Attachments". As a quick outline of the below: Create a connection to Workdrive/Writer Get the Merged Template ID (hexadecimal) Create the all-in-one button and function to generate and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 Analytics
- Language: *
-
A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, a package slip/delivery note, a shipment order; as well as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Safe Details Trigger: On-Demand / Widget Purpose: Given an account ID returns the credit safe details from CreditSafe Connect API. This function is used by a JS Widget. Inputs: string crmAPIRequest (webhook request from Zoho CRM) Outputs: - Date...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Kinda pointless question but needs to be asked just in case this was never meant to work in the first place. When did the connection last work? Within ZohoBooks > Banking > Active Accounts > Account > Filter by "Matched Transactions" Bank Issue: Check...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
the SQL against your new database Open your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old Joomla database and writing to the new...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
decision. Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and database to connect to and the follow on link was enough as a solution. My seniors...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the link is no longer valid. Why? The problem happens because of the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website to open a program on your computer (opens Outlook). Confirm the prompt your Outlook instance...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to...
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only access (in...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those of us who...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
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 3511 not found; No message file...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
> Data Sources (ODBC) > System DSN (get technical help if you don't know how to do this)... Open Excel 2007 > New > "Blank" Connect to data source: > Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: > Add...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
into Settings > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming connections" Leave the boxes ticked EXCEPT for "Enable Stealth Mode" Settings Security and Privacy Firewall Firewall Options Note:...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a third-party API. The third-party only accepts requests from a static and permitted IP address. If the...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *