ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 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? I'm storing this here as a reference and taking the bits...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

What can MAGA’s do to stop Biden from cheating again?https://www.joellipman.com/articles/_other-misc/jokes/what-can-maga’s-do-to-stop-biden-from-cheating-again.html

28 August 2024 A guy goes to a bar and is served by a robot bartender. The robot says, "What'll you have?" and the guy says, "A martini." He then gets the best martini he's ever tasted. The robot says, "What's your IQ?" The guy says, "167." The robot proceeds to chat...

• Type: Article
• Author: Joel Lipman
• Category: Jokes
• Language: *

Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 What? Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

PHP - Remove newlines and spaces from StyleSheethttps://www.joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 }"; $v_AppStyleFormatted = preg_replace('/\s+/', ' ', $v_AppStyle); and a few str_replace arrays: // exceptions $a_ReplaceFrom1 = array("px ", "0 ", " a"); $a_ReplaceTo1 = array("px?", "0?", "?a"); $v_AppStyleFormatted = str_replace($a_ReplaceFrom1,...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 Ergonomic adjective "relating to or designed for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your SQL Server Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 other tutorials that helped me out, and inspired this tutorial can be found here: - COM Tutorial by tank - Study the basics from this; I will not be covering them. - W3Schools - Many links listed below will take you to this website, which is an...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 My example accepts an Active Directory (AD) username and returns the student ID: CREATE OR REPLACE FUNCTION fn_get_sref_from_adname (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); -- Create temporary table to hold results CREATE TABLE #ListDistinctValuesAndCounts (myValue...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 ReinitializeMetaData(); } // This method blocks the addition of new output column from Advanced Editor as none are permitted. Called during Design Time public override IDTSOutputColumn100 InsertOutputColumnAt(int outputID, int outputColumnIndex, string...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 are not in the non-matching character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular expression: [^abc] This expression matches characters 'd' and 'g' in the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 that no longer exist in source. /MIR :: MIRror a directory tree (equivalent to /E plus /PURGE). /MOV :: MOVe files (delete from source after copying). /MOVE :: MOVE files AND dirs (delete from source after copying). /A+:[RASHCNET] :: add the given...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 unicode value v_SearchName = v_SearchName.replaceAll("&","\u0026",true); // // build up COQL query v_CoqlQuery = "select id from Accounts where Account_Name='" + v_SearchName + "'"; // // build up parameters m_Params = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 obtained earlier v_Auth_Token = "1234567890aaaabbbbccccddddeeeeff"; // // set this to your Twilio number (dialing/texting from) v_OurTwilioNumber = "+15017122661"; // // set this to your customer's number (dialing/texting to) v_CustomerNumber =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 4 (the one you downloaded as a Zip) then return to this screen and click on "Upload Certificate" Return to the SSL/TLS page from your cPanel dashboard and click on "Manage SSL Sites" Click on "Browse Certificates" then select the certificate for the...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement upon ZohoZIA and we get a lot of requests around customizing...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *