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 & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one ...; Created on 10 January 2022
4. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; What? A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both ...; Created on 16 December 2021
5. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use ...; Created on 07 December 2021
6. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... 01-Nov-21 // Tuesday 02-Nov-21 Note that Sunday is day of week 1. Here's the English ordinal bit I used: m_Ordinals = ; v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); ...; Created on 02 November 2021
7. Zoho Creator: Change Radio into Tabs: / Zoho /; ... Deluge Script: // assuming my sections are called "Tab_Section_1", and so on ... [these can be named as you want, the names I've used here are for demo purposes] hide Tab_Section_1; hide Tab_Section_2; hide ...; Created on 22 October 2021
8. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
9. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... for every photo uploaded, an API call is used up. If you have low limits, even 2000, this means you can only upload 100 products a day if they each have 20 photos (even less products then that as the ...; Created on 17 October 2021
10. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
11. Zoho Creator / Shopify: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021
12. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... only used for wireless applications? m_EventProperty=Map(); m_EventProperty.put("EventType","FixedPriceTransaction"); m_Params.put("EventProperty",m_EventProperty); */ // include the Use ...; Created on 20 September 2021
13. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next ...; Created on 30 August 2021
14. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & ...; Created on 30 July 2021
15. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... Zoho Creator! Having used this for a while, we average about 5 seconds from when the Order is updated (with payment?) in Shopify to when it gets parsed and created in the Creator system. Alternative ...; Created on 15 July 2021
16. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... equivalent Creator record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? ...; Created on 16 June 2021
17. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; .joellipman-alt-code-table{ width:100%; max-width:400px; margin:0 auto; border:1px; } .joellipman-alt-code-table td:first-child{ width:40px; } .joellipman-alt-code-table td:nth-child(2){ width:300px; } What? ...; Created on 03 June 2021
18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... to update the field with label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // ...; Created on 17 May 2021
19. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the ...; Created on 30 April 2021
20. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such as adding a tickbox that would be used ...; Created on 10 December 2020