Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 is at 10am. How? So adding a datetime field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold the time zone they are set in (ZohoCreator > Settings > Date and Time Settings); so as...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

05 December 2023 webhook in ZohoDesk rather than on Ticket Edit) and creates a row in a ZohoCreator report instead of ZohoAnalytics. The reason being is that the client needed to export the report and send it to suppliers; in ZohoAnalytics, the photos will not display...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

22 July 2024 The bit that stumped me was making a call to the Events endpoint as it would just come back with a blank response... The reason it was blank was due to my parameters; the key item to remember is that status is a mandatory field and it can either be...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

04 February 2025 with that server, it tries a second server... We now want to add a third server to try if the first 2 fail for whatever reason. How? Admittedly, perhaps this maybe wasn't possible but as of February 2024; I have been able to test and implement this....

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

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

09 October 2025 worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to Sales Order (creates a new sales order) on the quote record, the fields auto-map. The...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 The reason I did this is because AEC is now a commercial package and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 I even deleted the router.php file from my installation zip file (I checked that nothing was referring to it). The reason I've fixed it the way I did is because I don't need a router.php. The router.php file supposedly holds the two functions to:...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

28 January 2010 their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right date/time. The Quick Fix First off, check there aren't any Update for Windows 7 releases at...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 Joomla! articles and not for this module? A. Think this is because that module is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior to the module being displayed.

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

SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

12 August 2014 Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however, for some reason the code does not exist the code lookup will fail: -- If CODE=0000 and 0000 does not exist in table to lookup name, -- Using...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

29 March 2016 the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo documentation and it...

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

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

17 September 2014 so I took a measure of about 3 people high and stood so I could see the height of our 1 marshall's head. To be honest, the reason I wasn't using my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through...

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

Convert a delimited string to tablehttps://www.joellipman.com/articles/else/database/convert-a-delimited-string-to-table.html

26 October 2012 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse =...

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