Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 at work. Instead I only have the one workstation :eek Still I've been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My office workstation setup for this is: HP CMT...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

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

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

28 October 2010 use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle of writing a component that will hopefully...

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

URL passed settings in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your...

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

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 ("000000-0000-..."), this worked perfectly for me as my report didn't compare the 2 remaining dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to...

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

Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What?...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 that supports equivalent copying facilities, provided you maintain clear directions next to the object code saying where to find the Corresponding Source. Regardless of what server hosts the Corresponding Source, you remain obligated to ensure that it...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line with other search systems. So here we go, hope this helps you. Why? I've created...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the following 3 lines of code : const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; const RECAPTCHA_API_SECURE_SERVER =...

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

Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article. Start "Android Studio" Go to...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 users should not be able to use this search or see the restricted documents. I've googled far and wide but as usual, I find myself to be the first to address this. How? The module I have made is very basic and not in an MVC structure but it has been...

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

Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales order to...

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

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

15 May 2020 uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 what datacenter your client is using Register the App Setup the Connector How do I determine what datacenter to use? To find out which datacenter your client/customer is using in Zoho, check the domain and specifically the top-level-domain (TLD) part....

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

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

17 November 2020 your domain): Setup your subdomain using the registrar's control panel, go through the process until this part is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" or...

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

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

28 April 2021 on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records relevant to this module: l_LinkedRecords = zoho.crm.searchRecords("Opportunities_X_Products","(Opportunity:equals:"...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 this article, but in the backend code, Zoho refer to Issues as "Bugs". Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of this article for you which we...

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

Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods listed here, the standard searchRecords()...

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