Search - Joel Lipman .Com

1. DataScramble - Randomizing data rows: / Transact-SQL /; What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts ...; Created on 07 December 2012
2. DataTumble - Randomize Data Rows: / Transact-SQL /; ... ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled ...; Created on 07 December 2012
3. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original ...; Created on 22 August 2012
4. DBMS Random Reference: / Oracle PL/SQL /; What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...; Created on 21 August 2012
5. 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
6. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl ...; Created on 28 March 2023
7. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ChatGPT Plus possibly exposing email addresses that belong to random users] 2023-03-20 Like my previous article, this needs to be fed contextual data to continue a conversation Done 2023-03-11 ...; Created on 06 March 2023
8. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Kelly Ernst Haeckel Eugène Atget Frank Frazetta Garth Williams Garry Winogrand Georges Braque Georgia O’Keeffe Grayson Perry Gustav Klimt H.R. Giger Hayao Miyazaki Henri Matisse Henri Rousseau Hieronymus ...; Created on 11 February 2023
9. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... Island (GMT-6:00) Galapagos (GMT-5:00) Bogota (GMT-5:00) Cayman (GMT-4:00) Grand Turk (GMT-5:00) Guayaquil (GMT-4:00) Havana (GMT-4:00) Eastern Time - Iqaluit (GMT-5:00) Jamaica (GMT-5:00) Lima (GMT-5:00) ...; Created on 19 October 2021
10. 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
11. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; ... Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, ...; Created on 26 July 2021
12. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... Sort the list of keys in ascending/descending order. Loop through the list of keys, retrieving each record // // build up sample map in random order l_MyListUnsorted = List:Map(); m_Record ...; Created on 29 January 2021
13. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... ms-settings:easeofaccess-audio Closed captions ms-settings:easeofaccess-closedcaptioning Color filters ms-settings:easeofaccess-colorfilter Cursor & pointer size ms-settings:easeofaccess-cursorandpointersize ...; Created on 30 July 2020
14. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... 0.2; v_GrandTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 1.2; v_TotalTax = v_GrandTotal * 0.2; m_UpdateQuote.put("Tax",round(v_TotalTax,2)); m_UpdateQuote.put("Grand_Total",round(v_GrandTotal ...; Created on 20 August 2019
15. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
16. GDPR Privacy Policy: / Static Items /; ... a new opportunity for marketers to strengthen their brand loyalty by focusing on consumer privacy while delivering amazing experiences. Think of it as experiential privacy — having privacy be a key part ...; Created on 14 February 2019
17. Accessing Apimo WebService API: / API Miscellaneous /; ... ID $company_id_1_agency_id = ''; $company_id_1_brand_id = ''; // specify target url and version $apimo_url = 'https://api.apimo.com/api/call'; $apimo_version = 2; // specify data output $apimo_method ...; Created on 29 March 2016
18. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... two systems running JComments version 3.x The MySQL scripts will copy over each table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should ...; Created on 12 September 2015
19. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... / Random. - Parameters: Module Width / Height / Font-size Override. - Parameters: Show Descriptions / Images/ Dates / Hits. - Parameters: Get Titles + Descriptions (Local / Remote) - Parameters: CSS3 ...; Created on 07 September 2015
20. List of Font Awesome: / Web-Development /; ... fa-random [] 4.1  fa-rebel [] 4.1  fa-recycle [] ...; Created on 04 September 2015