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

07 December 2021 "America/Los_Angeles" (-08:00). And our customer is in "Europe/Luxembourg" (+01:00). We want to tell our customer they have an appointment at 4pm their time in Luxembourg; tell the agent/salesperson to call the customer at 7am in Los Angeles; and tell...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are:...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? My use-case scenario here is that we have a Zoho Creator app which comprises of...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 (different per user) at the bottom of the email message. How? So there are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM signatures seem to...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://mail.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 Upload the generated file to the record Note that this is overwriting the existing record and associated file. We have no intention of creating a new record per file... Saying that, the file name will change every time it is updated as you will see....

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 product categories. We need this to get the count of all products (if there's another way, I'd love to hear it). We don't have more than 100 product categories so we'll just to page 1 but specifying 100 per page as the default is only 10. // // API keys...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 conversion. This has been applied for my client, but I'm awaiting feedback (UAT = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code...

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

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

20 March 2025 of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the immediate solution I have applied now until Zoho enable an option to round via API with a 10th of a penny/cent or less. After creating or updating the...

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

404: Page Not Foundhttp://mail.joellipman.com/static-items/404.html

11 February 2015 Sorry, but the content you requested could not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will...

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

Docman - Uploaded a document and can't see ithttp://mail.joellipman.com/articles/cms/joomla/docman-uploaded-a-document-and-cant-see-it.html

29 June 2009 As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...

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

MS Excel: Convert a text to a numberhttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 we connect to the datasource directly using our Windows Credentials. For the SSRS server holding our report, we do NOT have an unattended service account. The report uses a shared data source which stores the credentials, ie. A sql authenticated user...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttp://mail.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with...

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

Community Builder in Joomla Vulnerabilityhttp://mail.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 forum (source: http://forum.joomla.org/viewtopic.php?t=84436) . In fact, there are quite a few vulnerabilities my scanners have picked up on and so I'll be posting solutions for those who need to keep Community Builder as their user manager. There are...

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

Anti-Spam override for all submitted datahttp://mail.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the captcha...

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

MySQL Data Type Reference Tablehttp://mail.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 4294967295 characters (4GB of text) Length of string + 4 bytes String Enum ('value','value2',...) String object that can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or many values of...

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

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

06 May 2010 Name] LIKE @GroupName AND _SMDBA_.Incident.[Assigned To Full Name] '' Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team...

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