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

13 February 2023 but it would only understand the questions I have programmed it to and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 my support team consists of me, myself and I. Saying this I'm in discussion with commercial solutions that still haven't answered some of my questions or even raised as issues. I'm not them; add as a comment to this article or email me and that will be...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

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

06 March 2023 will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" The question can be asked by clicking the button...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData =...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 and want all the data to stay aligned. Using only DIV layers can cause a few unexpected layouts in ZohoCreator. The Quick Answer: the page margins Tackling the page margin on render, I wrap the whole lot inside a DIV layer with the key attribute...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the searchRecords function requiring it's 5th parameter which defaults to "not...

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

Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://www.joellipman.com/articles/crm/zoho/zoho-finance-suite-schedule-pattern-not-matched.html

12 June 2023 type of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name of the schedule. The longer answer is demonstrated in the following screenshots: Error:...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 site so they just refuse the connnection after a while. Obviously something is not right. I am searching the forums for an answer and if I don't find one I'll repost. I just thought I'd share this with you in case this your problem too. Source: Joomla...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 which was even more useless asking him about a write-protect switch (physical). The user then said nevermind and found the answer himself. The discussion is on the page http://www.hardwareanalysis.com/content/topic/46202/. The chap went to...

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

Change the login link in MediaWikihttps://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are...

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

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a definitive answer!

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick....

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 an hour or so I came across "Cascading Parameters" (http://technet.microsoft.com/en-us/library/dd255197.aspx). Maybe the answer could be in that mess of a Microsoft article but this I can already do and it didn't quite do what I wanted. I ran out of...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 as part of the aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME) CAST(CONVERT(CHAR, DATEADD(millisecond,...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where...

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

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 and I tend to piggyback on my client's subscriptions. This information does not come from Yootheme forums. I am too lazy to answer/update my solutions in 3rd-party forums.

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects. Developers will have told the system what to do when...

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

Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 specific tables but not all Simply don't refer to the table after the DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to do this in the name of the column heading, the answer is a much simpler one, in your SQL statement, simply place your cursor where you want the carriage return and press...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *