Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes29 results
ZohoBooks: Broken UK Banking Feed
... and Plaid labels. Follow the prompts to log in securely via your online banking and authorise Zoho Books. Once redirected back, link the feed to the existing account (rather than creating a new one) so previous transactions remain associate ...
Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages
... ies that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey. Apparently this will be done in Zoho Analytics. Th ...
Zoho People: Get Performance Records over API
... ance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and the documentation seems to have gaps; or simply modules are so custom/bespoke the documentation has started to genericize. My c ...
MacOs: Transcribe Training Video using OpenAI Whisper
... -vn -ar 16000 -ac 1 -b:a 64k output_audio.mp3 [Optional if using online version of OpenAI Whisper] Split audio into segments: ffmpeg -i output_audio.mp3 -f segment -segment_time 600 -c copy output_chunk_%03d.mp3 Install Python and PIP Still ...
PHP Script: Make your own Thumbnail Generator via API
What? Looking for an online tool that will take an image and make a thumbnail copy? This article is for me if I ever want to recreate an online tool capable of receiving an image URL and which both generates and outputs a thumbnail image an ...
Zoho Deluge: Determine your Statement Execution Limit
... ikely to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of statement execution limit exceed Line:( ...
Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON
What? A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted ...
ZohoDeluge: Get All eBay Orders Given a From and Till Date
... ")); m_Order.put("Shipping",m_Shipping); // m_Buyer = Map(); l_JsonLineItems = List(); l_LineItems = x_Order.executeXPath("/" + v_OrderNodePart + "/TransactionArray/Transaction").toXmlList(); for each x_OrderLineItem in l_LineItems { m_Line ...
ZohoCRM: Import Attachments
What? An article for myself really as I couldn't find much online to address the errors I encountered 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 ...
Zoho CRM: Schedule a Meeting using Deluge
... ing"); // // the meeting location m_ScheduleMeeting.put("Venue","Online Meeting"); // // the start time m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // // t ...
Zoho Creator: Set Up Custom Domain for Customer Portal
... s possible of the third-parties involved, plus the documentation online was in parts and requires going to several pages across the Internet. Here I have 1 page and 1 article documenting the process. How? I'm breaking this down into 3 stage ...
Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books
... n after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. How? So the trick is, go over the official documentation, but don't take it as gospel. Yo ...