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 /; ... "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears ...; Created on 28 July 2014
2. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... to change by going to Settings > Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address Format either under "Customers and Vendors" (although this applies ...; Created on 07 October 2021
3. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... r_CreateRecord; Save the function While still on the CRM functions page, hover your mouse over the function name you just created and click on the ellipsis/three dots icon Select REST API and enable ...; Created on 20 September 2021
4. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... stuff here ... eg getting data fields, generating a title and setting the title: input.Title = "Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To ...; Created on 19 September 2021
5. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; ... Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and ...; Created on 02 September 2021
6. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... in the last name field and creating a contact called "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in ...; Created on 01 September 2021
7. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar) ...; Created on 03 June 2021
8. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... + ":" + v_ThisFrom + "-" + v_ThisTill; } } } Note: Play around with the Status, there are "Pending", "Cancelled" (UK spelling), "Approval Not Enabled" and I think "Approved", "Rejected". We' ...; Created on 10 December 2020
9. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... want to do that, just click on the "Edit Access" tab at the top next to "Email" and then click on the "Enable Edit Access" button: Advise Zoho Creator Partner Support (This email address is being protected from spambots. You need JavaScript enabled to view it. ...; Created on 17 November 2020
10. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet at https://127.0.0.1:5000 along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. ...; Created on 24 October 2020
11. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there' ...; Created on 30 July 2020
12. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... Additional Note Just as a note to do the reverse: upload an image given a URL to an image field (prerequisite: enable the field to allow Image as "Link" not just "Local Computer" or "Camera"): for ...; Created on 14 July 2020
13. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; ... With URL rewriting enabled www.joellipman.com/index.php/4-category-alias/123-article-alias.html // What I want www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF ...; Created on 14 March 2020
14. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid ...; Created on 21 November 2019
15. Zoho Deluge - Update Creator from CRM: / Zoho /; ... (might not be the same as CRM super admin!!!) Go to Setup » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it ...; Created on 18 February 2019
16. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng ...; Created on 11 February 2019
17. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... and compatibility with future AutoHotkey releases. #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir ...; Created on 28 January 2019
18. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; ... it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting ...; Created on 30 November 2018
19. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... "Enabled the Drive API" via your Google Developers console as well as gotten your OAuth 2.0 access/refresh tokens and specified the appropriate scopes. The scopes I chose were to do with getting a ...; Created on 29 October 2018
20. FTP on Mac: Failed to retrieve directory listing: / File Transfer Protocol /; Applies to: FileZilla for Mac macOS High Sierra A quick note to remind me how to enable FTP directory listing as it was working on my Windows PC but not on my Mac. The error I was getting was Error: ...; Created on 06 October 2018