Search - Joel Lipman .Com

1. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which ...; Created on 28 July 2014
2. Parameters not being used in report processing: / SQL Server Reporting Services /; ... declare the parameters used by the software within the SQL script... So the above should look more like this: -- =============================================================================== -- ...; Created on 07 January 2011
3. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... void automation.fn_Quotes_OnEdit(int p_QuoteID) Label: Fn - Quotes - On Edit Trigger: Used in a workflow when a quote is modified Purpose: Actions when a quote is modified Inputs: ...; Created on 18 December 2024
4. Zoho Creator: Input Color Picker: / Zoho /; ... on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system ...; Created on 14 October 2024
5. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; ... on a Zoho CRM contact record is used to authenticate the contact on a Wordpress portal. OTP or 2FA or MFA or OTC is in effect however; so a contact email OR phone number is required. Both aren't required ...; Created on 03 October 2024
6. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... String fn_SendCreditApplication(Int p_ContactID) Label: Fn - Contact - Send Credit Application Trigger: Off a button on the contact record Purpose: Function used by a button ...; Created on 06 August 2024
7. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Pre-amble Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section ...; Created on 25 July 2024
8. Zoho Projects: Get All Events: / Zoho /; ... the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. ...; Created on 22 July 2024
9. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... and then wait for it to finish building the table. If you want the Zoho SQL (Ansi-SQL?) used to link the purchase order items with the sales order items based on the custom lookup field: SELECT ...; Created on 09 July 2024
10. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data ...; Created on 02 July 2024
11. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... but according to documentation (to be taken with a grain of salt), the scope should be ZohoInventory.settings.READ. I have another connection called "zinventory" which is used here to retrieve the item/product ...; Created on 23 May 2024
12. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... y: this is because the system manager who initially set up CRM is used by default. By creating a connection as a system user with the necessary scopes to this CRM instance, untick use credentials of logged ...; Created on 14 May 2024
13. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email ...; Created on 07 May 2024
14. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... than 1 second m_Payload = crmAPIRequest.toMap(); m_Blank = Map(); // // you created an app that generated a client ID and a client secret and resulted in an access token // the client secret used ...; Created on 22 April 2024
15. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added all the layers of complexity, I want to have ...; Created on 14 March 2024
16. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... function to rule-them-all This code was used for testing, then for correcting any historical records, and then when given just one ticket reference; will create or update the images associated in the ...; Created on 26 January 2024
17. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... do as it did work if the criteria were encoded... The criteria is in the same syntax format as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer ...; Created on 14 November 2023
18. Zoho Books: System Values Maps: / Zoho /; ... Map fn_GetSystemValues() Trigger: Snippet to be used at beginning of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: ...; Created on 07 November 2023
19. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... = v_CSVString.tofile("PaymentRun.txt"); Attach the file Attach this to any record. Here we'll use the last record used initally to generate this CSV/Text file; which happens to be a bill: // // ...; Created on 02 October 2023
20. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... This is the code used in a workflow triggered within ZohoCRM when a Quote is created or modified: // // initialize v_BooksOrgID = 123456789; v_BooksCustomerID = 0; m_CreateEstimate = Map(); l_CrmBillingAddress ...; Created on 18 September 2023