Search - Joel Lipman .Com

1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ...; Created on 04 October 2013
2. Add the website name to the page title in Joomla!: / Joomla /; Change Page Title in Website Here are some instructions on changing the page title in Joomla! CMS to display both the actual page title and other stuff. As I like doing this for this particular website ...; Created on 06 September 2009
3. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... build the update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU); m_CreateBooksItem.put("rate",v_ItemPrice.toDecimal()); // // ...; Created on 04 May 2023
4. 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
5. 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
6. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... select which fields to return l_OutputFields = List(); l_OutputFields.add("ItemID"); l_OutputFields.add("Title"); l_OutputFields.add("SKU"); l_OutputFields.add("QuantityAvailable"); l_OutputFields.add("SellingStatus"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // / ...; Created on 01 March 2023
7. 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
8. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... title handle status createdAt publishedAt updatedAt } updatedAt } cursor } pageInfo { hasNextPage ...; Created on 20 February 2023
9. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; What? So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct ...; Created on 11 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... := "Joel Lipman .Com" v_CompanyKey := StrReplace( v_Company, " ", "_" ) v_Title := v_Company " - Generate ZCRM Attachments" v_SubTitle := "Generate ZCRM Attachments" v_Desc := "This ...; Created on 16 January 2023
11. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... (in this example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call ...; Created on 02 March 2022
12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... "sku": "ABC123456", "title": "Default Title", "barcode": "0000012345", "inventoryItem": { "id": "gid://shopify/InventoryItem/23456789123456" ...; 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. Zoho Creator: Change Radio into Tabs: / Zoho /; ... the tabs group) and then a negative margin on another notes field called Note_Title which contains my header to place it above the tabs group: v_Css = ""; v_Css = v_Css + ".zc-Tabs-group .choice-table-row"; v_Css ...; Created on 22 October 2021
15. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... b_CreateProduct = false; } // // title and HTML m_Product.put("title",input.Listing_Title); if(!isNull(input.Full_Shopify_HTML_Code)) { m_Product.put("body_html",input.Full_Shopify_HTML_Code); } m_Product.put("vendor",input.Brand); m_Product.put("product_type",input.Item_Type); // / ...; Created on 17 October 2021
16. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... like: input.Audit_Change = "Title: " + input.Title; Method #1: (do not use) Previously I have tried adding a field called "DateTime form was loaded" which would have the currenttime when the form ...; Created on 19 September 2021
17. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... I've titled this article as multi-dimensional but I found that this code doesn't support an array nested more than 2 levels deep. In other words, the above solution will not work if I wanted to post the ...; Created on 03 February 2021
18. 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
19. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- Title ...; Created on 08 July 2020
20. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... Set program Defaults ; -------------------------------------------------------------------------------------- Title := "Joes Chrome Profile Opener" Desc := "This program will list all the Google ...; Created on 07 January 2020