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. ZohoBooks: 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
4. 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
5. 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
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
7. 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
8. 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
9. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a character but is a new line... Used ...; Created on 01 March 2023
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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