Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot...

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 } if (queryParams.p_ShopifyID !== undefined) { v_ShopifyID = queryParams.p_ShopifyID; } // Setup a config to find this record (use a custom report that only has the 2 searchable fields) var config = { appName : "joes_quote_builder", reportName :...

• 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 denoted by double-quotes and a value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" + v_SalesOrderID + "'"); m_Config = Map(); // sometimes parameters need to be a string... but this is working m_Config.put("CONFIG",m_Params); v_Endpoint =...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 the fields hoping they had the same API name in both modules) o_NewLineItem.CUSTOM = o_ThisLineItem.CUSTOM; o_NewLineItem.Config = o_ThisLineItem.Config; o_NewLineItem.Cost_Line_Item_Total = o_ThisLineItem.Cost_Line_Item_Total; o_NewLineItem.Description...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 in /plugins/content/jcomments/jcomments.php on line 25 Fix: // change on line 27 function plgContentJComments(&$subject, $config) // to function __construct(&$subject, $config) ERROR: JCommentsACL Deprecated: Methods with the same name as their class...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 URL Check if image exists to display alternative placeholding image. Solution #1: Image does not appear within SSRS Configure the Unattended Execution Account: According to Microsoft and Stack Overflow, your reporting server needs to have the...

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

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 uses CSS files to do this so we'll need to modify the XML file and add some files that this will select. Modify \templates\\config.xml add the select option "Ambient Turquoise" to the end of the list: Grey Dots Tartan Lines Dark Squares Light Squares...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 cached download - v1.1.8: click here) Extract the ZIP file to a folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher and scoring key given to you. > Save Upload the files to \components\com_jcomments\libraries\ayah...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 cached download - v1.1.8: click here) Extract the ZIP file to a folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher and scoring key given to you. > Save Upload the files to \components\com_jcomments\libraries\ayah...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 p_QuoteID, int p_SoID) { v_CreatorQuoteID = ifnull(p_QuoteID,0); v_BooksSoID = ifnull(p_SoID,0); // // config v_BooksOrgID = "1234567890"; // put here your client's own Books Organization ID v_CrmSoModule = "CustomModule5004"; // ensure this is the...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 m_Columns = Map(); m_Columns.put("columns", m_Data); m_Params = Map(); m_Params.put("CONFIG", m_Columns.toString()); // // in analytics, browse to the "Attachments" table and note the URL IDs after workspace and view v_WorkspaceID =...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config Set the recycle time to 0: 0 Restart the SSRS service Source(s) Microsoft: RSReportServer Configuration File MSSQLTips:...

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