Assuming data is required, the following 229 results were found.
-
and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for each r_MessageData in r_ChatDetails.get("data") { v_Role = "user"; if(!isnull(r_MessageData.get("message_source"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
+ p_QuoteID + "?fields=Quoted_Items" type :GET connection:"j_crm" ]; // // should only be 1 record but respecting JSON data structure and parse l_Datas = ifnull(r_QuoteDetails.get("data"),Map()); for each m_Data in l_Datas { l_QuotedItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
(ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId =...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will look...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
shared libraries and dynamically linked subprograms that the work is specifically designed to require, such as by intimate data communication or control flow between those subprograms and other parts of the work. The Corresponding Source need not...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
add to the network traffic, this program adds NOTHING to the network traffic, and therefore is a much better measure of what data is being received/sent from your workstation. Download Available for download for FREE as OpenSource. Portable so no...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Click Create and Connect You will be prompted to allow permissions, so click on "Accept/Allow" 2. Determine the client datacenter Look at the URL (website address) of the CRM you are wanting to do this on. The part after Zoho is the top level domain...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So to give you a gist of what the following snippet of code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the following: // temporarily disable auto-update preview input.Update_Preview=false; // // do stuff here... eg getting data fields, generating a title and setting the title: input.Title = " Hello World "; // // output input.Note_Preview = input.Title;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the application so that any order is sent to a URL, specifically a CRM REST API function that will forward the payload data to Zoho Creator (Yes you will need CRM version Enterprise or Zoho One [that supports functions] for this process). So first off,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
and wanted a refresher for use in a client system. The usual error is something similar to the following: { "code": "INVALID_DATA", "details": { "expected_data_type": "datetime", "api_name": "Check_Date_Time" }, "message": "invalid data", "status":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *