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. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023
4. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... "Role" with the options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line field called "Title" (used as a multi-line cannot be used in the listview). Add ...; Created on 06 March 2023
5. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
6. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... and should not be used in a commercial setting. Afro Samurai (Takashi Okazaki) Akira (Katsuhiro Otomo) Batman Charlie Brown (Charles Schulz) the Dark Crystal Dragonball (Akira Toriyama) Gankutsuou ...; Created on 11 February 2023
7. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"jl_recruit"); //info r_Create; } } } } For historica ...; Created on 08 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023
9. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the ...; Created on 09 December 2022
10. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... There may be many ways of doing this, this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or ...; Created on 03 November 2022
11. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging ...; Created on 19 October 2022
12. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... can only be the admin or the logged-in user (user who clicks on the button). There might be an easier way to get the template ID used in CRM, but we did this by Login to ZohoCRM > Settings > Template ...; Created on 18 August 2022
13. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... Error(s: Previously my code below was used and it wouldn't work. The difference to the above is that I was trying to add to the multi-lookup directly: // for each v_PackageRef in l_PackageRefs { // // ...; Created on 18 August 2022
14. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... = r_CreateShipment.get("shipment_order").get("shipment_id"); } } } // // maybe one is either used or created if(v_ShipmentID != "") { v_Url = "https://inventory.zoho.com/api/v1/shipmentorders/" ...; Created on 14 July 2022
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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