Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 spent 2 hours going down the rabbit hole of trying to use OAuth2 and following the usual steps: Grant Code, Refresh Token, Access Token. I also went down the rabbit hole of installing app-bridge and configuring a JWT which was an absolute waste of time...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the Excel spreadsheet can go and view the...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Shared DataSource Upload the report to the ReportServer. Hover the mouse...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 directory tree. /Z :: copy files in restartable mode. /B :: copy files in Backup mode. /ZB :: use restartable mode; if access denied use Backup mode. /EFSRAW :: copy all encrypted files in EFS RAW mode. /COPY:copyflag[s] :: what to COPY for files...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 registry editor, then restart the computer. Notes: Guest account will not see the drive in Windows Explorer but can still access it using the command prompt. All users can access the drive using the command prompt. To hide from specific users, you need...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Mon, 16th Sep 2013 2.4 SimonB- Fix Bug: Change for PHP v5.4 - Date Uploaded: Sun, 15th Dec 2013 2.3 EricG- Parameter: Use Access Levels - Enhancement: AutoDebug: Display module parameters. - Fix Bug: Removed check for "approved" column in weblinks. -...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit You should get...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 of entries per page, returns these in JSON as a Zoho Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings....

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

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 to your interests. Security We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 to the newly created 'regmenu' module or what ever you called yours.) Make sure both menu modules are enabled. 2. Set the "Access Level" to 'public' and "Menu Items" to 'none' for both of your menu modules. 3. In the modules list, locate the one named...

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

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

28 September 2009 web root folder and extract the zip to it (it should create a http://www.mysite.com/phpBB3 folder). If you don't have shell access, you can decompress the phpbb3 ZIP file to your computer and then upload the resulting files to the...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 2. Extensions > Plugin Manager 3. Go to the bottom and change the display # dropdown to ALL 4. Disable Authentication - AEC Access 5. Enable Authentication - Joomla 6. Re-enable any other authentication plugin you used to use. 7. Disable System - AEC...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 sites or £15/hour for e-commerce) Similar looking websites where layouts/colour schemes can be adapted Explain accessibility and usability industry standards. (includes iPhone compatibility and disabled access) Explain balance of scope, quality, time...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

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

19 September 2011 as domain). The first two of the above worked for us, which indicated an issue with the credentials we were using to access the the photos, so: Ensure the "Unattended User Account" can see the photos. - This solved the problem for us Some forums...

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

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared calendar if you don't...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 in the previous step. Copy the database of your main site to another database. Setup a database user account that can access the new database created in the previous step. Modify the configuration.php file in the root of the TEST site to reflect the...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 This results in a setup.exe and msi file which can be installed on Windows Servers run by accounts which do not have access or which do not have the full Windows SDK (ie. access to the global assembly cache). The process of registering the driver etc...

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

Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 the root folder of your component (ie. same as the XML installation file) Add the install script instructions: // No direct access to this file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite...

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