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

22 September 2010 the 'Login' link, we want the system to automatically prompt them for their username/password. (Kerberos authenticated, as opposed to NTLM authenticated). Note: This article is displaying how to change the link and not how to setup these authentication...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables...

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

Newbies guide to be the local computer guyhttps://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..."...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We want to scramble sensitive data that we send to suppliers for support or analysis....

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 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 device). Why? Yes there's documentation online that TravelPort provide you with but it didn't help. The error I'm...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 some third-party providers' instructions on how to set up a CNAME record at the bottom of this page. A subdomain is FREE as opposed to paying for another domain. If you want to put the customer portal on a subdomain (eg. "customerportal.joellipman.com"...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 is that all multi-select lookup and multi-user lookup fields are held in temporary CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup >...

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

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

16 January 2023 I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 report that specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want...

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

Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 even when you have Search-engine-friendly website addresses enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL...

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