Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 So in "Edit this application" > go to Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in this example, I...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

16 January 2023 folder containing the original files and will collapse any subfolders as well as rename the files to unique filenames. ; ; Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 http://www.mysite.com/phpBB3/includes/acp/info/acp_joomla.php http://www.mysite.com/phpBB3/language/en/mods/acp_joomla.php Log into the phpBB3 Administration Control Panel. Based on the phpBB3 installation instructions above, this should be something...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 [if exists] /modules/mod_moduletoupgrade/helper.php [if exists] /modules/mod_moduletoupgrade/tmpl/default.php /language/en-GB/en-GB.mod_moduletoupgrade.ini Upgrade XML File: Change open/close tags to (update attributes, eg. ) Change to Change to Change...

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

Things to Check if Joomla Password Reminder email not being senthttps://joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 How? A few things to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but don’t create a new one – we’re just checking something) In the...

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

Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/else/database/create-read-only-database-user-in-sql-server.html

09 November 2010 or change data in all user tables. db_ddladmin Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database. db_denydatareader Members of the db_denydatareader fixed database role cannot read any data...

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

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

22 October 2010 I wrote for Joomla! displayed funny characters. The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string(). The error I get is something...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=105&Itemid=165

07 September 2015 values. - Date Uploaded: Fri, 30th Jul 2010 1.1 - Separated all parameters to be configured in the Joomla admin panel - Language file created (English GB only) - Date Uploaded: Fri, 9th Jul 2010 1.0 - Added GNU/GPL License information to xml/php -...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://joellipman.com/component/content/article/travelport-universal-api-ping-request-with-php-curl.html?catid=109&Itemid=165

27 April 2015 standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a sub-component of PHP that allows you to send and receive requests as the server (as opposed to the client...

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

Change Regional Settings for your Reporthttps://joellipman.com/component/content/article/change-regional-settings-for-your-report.html?catid=75&Itemid=165

17 May 2010 this in the report by: Go to Design Select the View tab Check that the "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to en-GB Save the report and test.

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