ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 portal website Click on the App you created Note the API Key by clicking on "Show Key" The deluge function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 List(); // // specify the maximum number of orders you think you have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than this but this is for pagination estimates...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken from...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 item, the staff can specify which Sales Order the item relates to. How? At time of print, adding the lookup to the line item will automatically display a related list on the Sales Order but does not associate any records... not sure why this is. So we...

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

ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 condition that the Mobile "is empty" > click on the "Next" button Set Mandatory FIelds > and select "Email" Caveat(s) You will get a warning that you are selecting a field that is already being used in a rule. Seems that I can't select the same field in...

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

Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't happened yet. Here's a function in...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 remove() is a void function, similar to the sort() function; in that if you try to assign this to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 to or opt out of eBay marketplace account deletion/closure notifications has passed. Failure to comply with this requirement will result in termination of your access to the Developer Tools, and/or reduced access to all or some APIs. New Developers: All...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 They're wrong in any case as they don't match the ZohoCRM... or both are just not matching... either way, your client will likely only accept the previous solution. I wanted to use a regex rather than treat the number as a string and truncate it that...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 How? First, I'll go through the steps of setting up the Zoho CRM function, we'll convert it to a REST API function which will give us a URL and then we'll configure the Zoho Survey to trigger a webhook when submitted. Pre-Amble Just need a few fields on...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 in other words, goes to the quote record, and clicks on the plus icon next to "Invoices" in the left sidebar? This script will map over the core fields, address, and line item. This took me a while to get the right syntax for writing to the invoice line...

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

Confucioushttps://www.joellipman.com/static-items/confucious.html

29 June 2014 a job you love, and you will never have to work a day in your life.

• Type: Article
• Author: Webmaster
• Category: Static Items
• Language: *

Advanced RokStories Stylinghttps://www.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

01 July 2009 The module adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features are also available in the standalone version. Lorem ipsum dolor sit amet, consectetur...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

404: Page Not Foundhttps://www.joellipman.com/static-items/404.html

11 February 2015 typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will have been moved about but all the content that was on the old site is still to be found on our new website at www.joellipman.com. The...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id. This will yield the following: body.bgstyle1 #main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0...

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

Restoring your WYSIWYG editor after upgrading Joomlahttps://www.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 it the best in the market IMO. Joomla FCK Editor You can download it for free from http://www.joomlafckeditor.com/ but you will need to register on their site first.

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Does Google Chrome Frame really improve performancehttps://www.joellipman.com/articles/google/does-google-chrome-frame-really-improve-performance.html

23 September 2009 The jury's still out on this one. I have noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame (or ChromiumBrowser) is quick to enable. Simply ask your...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details:...

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

How to put MediaWiki into Debug modehttps://www.joellipman.com/articles/cms/mediawiki/how-to-put-mediawiki-into-debug-mode.html

22 October 2009 By adding the following line to your LocalSettings.php file, you will be able to log everything that WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the...

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