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. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer some consistency. Notes on the attribute: Criteria You can't compare a date time value ...; Created on 14 November 2023
16. 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
17. 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
18. 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
19. Zoho Deluge: Proper Case for Names: / Zoho /; ... other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended ...; Created on 13 July 2023
20. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023