Search - Joel Lipman .Com

1. Content Management Systems: / Category /; Created on 05 March 2020
2. JComments errors in PHP 7: plgContentJComments and JCommentsACL: / Joomla /; ... How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJComments has a deprecated ...; Created on 13 March 2020
3. Change div height to fit content: / Cascading Stylesheets /; Applies to: CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this ...; Created on 19 December 2016
4. Quickly update all content in mySQL database replacing a string: / MySQL /; ... that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me ...; Created on 03 February 2013
5. Print Directory Contents to a File: / Windows OS /; Why? A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? ...; Created on 19 July 2012
6. Merge the content of two similar tables in MySQL: / MySQL /; In standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). ...; Created on 11 January 2011
7. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... = Map(); m_Thread.put("role","user"); m_Thread.put("content",v_Message); l_Messages.add(m_Thread); // // if the message is not blank nor the trigger, send to OpenAI ChatGPT API if(!isBlank(v_Message) ...; Created on 06 March 2023
8. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "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2222"; v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token",v_AccessToken); // // ...; Created on 20 February 2023
9. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... build header of request m_Header = Map(); m_Header.put("Authorization","Bearer " + v_Token); m_Header.put("Content-Type","application/json"); // // build params of request m_Params = Map(); m_Params.put("model", ...; Created on 13 February 2023
10. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and content > Manage Devices. You will get to see the list ...; Created on 29 June 2022
11. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; ... you only want part of the page to display different content dynamically or on click of a button: // embeds using DIV: allows for CSS styling // embed a form loading ... // embed a report loading ...; Created on 05 May 2022
12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = r_ShopifyAPI.API_Version; v_AccessToken = r_ShopifyAPI.Access_Token; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token", ...; Created on 14 February 2022
13. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
15. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID ...; Created on 17 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
17. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... >= r_Api.Access_Token_Expiry) { v_Base64Auth = zoho.encryption.base64encode(r_Api.Client_ID + ":" + r_Api.Client_Secret); v_TokenEndpoint = r_Api.Token_Endpoint; m_Headers = Map(); m_Headers.put("Content-Type","application/x-www-form-urlencoded"); m_Headers.put("Authorization","Basic ...; Created on 20 September 2021
18. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... = v_DataCSV.toFile("test.csv"); // // read and process CSV file v_FileContent = f_CSVfile.getFileContent(); l_FileRows = List(); if(!isBlank(v_FileContent)) { l_FileRows = v_FileContent.toList("\n"); } // ...; Created on 26 August 2021
19. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... call it "Notify". Add the 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page with the following: /* optional: hide some of the wrapper div boxes: ...; Created on 06 November 2020
20. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... which I’m referring to over the web (Content Delivery Network – CDN) Recap So as a recap, this is how it looks so far: The HTML: The CSS: The JavaScript: The Preview in Browser: ...; Created on 24 October 2020