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 Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... , it may get confused as to where the photo came from and will error when displaying it. I think it will be fine. Source(s) Joel's tired and inefficient brain The non-existent and plethora of foru ...; Created on 31 March 2022
4. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... all monitors are now connected to my home PC. The way to do this might be different for you depending on the components of your PC. So here's a list of what I used: TypeComponentQuantityPrice (GBP) Reused ...; Created on 12 March 2022
5. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator ...; Created on 11 March 2022
6. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up with something like this screenshot: * Some of these fields are unnecessary for this example but are used to accommodate ...; Created on 14 February 2022
7. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; What? So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. ...; Created on 11 February 2022
8. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... 12 Additional Note(s): You might ask why not use the built-in round() function? Well I admit that round() needs to be used for currencies. The issue is that round() only rounds up decimals to ...; Created on 08 February 2022
9. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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