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

15 July 2025 A quick article showing 2 ways of connecting to Shopify's REST API with a custom app. Note that this is not for an app embedded in the Shopify instance but for a third-party app, such as a Zoho Creator app, to connect to the data within Shopify. Why? At...

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

Joomla: Unable to find install packagehttp://mail.joellipman.com/articles/cms/joomla/joomla-unable-to-find-install-package.html

05 September 2009 This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and...

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

Ubuntu as a media serverhttp://mail.joellipman.com/articles/linux/ubuntu-as-a-media-server.html

19 September 2009 is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for doing this so the LMCE UI is never cropped off, but when the user switches back...

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

Migrate MediaWiki to another serverhttp://mail.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert,...

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

Splatter Logohttp://mail.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Sir James Dyson explains his bladeless fanhttp://mail.joellipman.com/articles/_other-misc/sir-james-dyson-explains-his-bladeless-fan.html

30 October 2009 I love technologies that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other...

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

After installing rokstories, get invalid argument 106http://mail.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 I found an unlikely solution which is becoming typical of Joomla. I hadn't switched the site to SEF friendly yet but I did this just to follow along with the solution. You need to make a menuitem to just one of the articles. I have a menu called "unused...

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

Add "Command prompt from here" to right-click context menuhttp://mail.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I...

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

Increment a column in MySQL using the UPDATE queryhttp://mail.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined with a PHP...

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

Windows 7 and Google Chrome incognito mode by defaulthttp://mail.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share...

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

Joomla - How to preview module positions in a given templatehttp://mail.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...

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

Change Regional Settings for your Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK...

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

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 Thought I'd put this error in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other...

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

Welcome to my website!http://mail.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 involved with anything related to computers. I've been writing websites and scripts commercially since 1997 and I'm using this website to store notes as I go along. I specialise in taking over incomplete and/or bespoke systems which have little or no...

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

The Sandpithttp://mail.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

MySQL Oracle equivalentshttp://mail.joellipman.com/articles/database/mysql-oracle-equivalents.html

27 September 2010 title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle...

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

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 I've started this list to make sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you...

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

Format Numbers in AutoHotkey with Commashttp://mail.joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

20 September 2011 a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

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

SSRS Repeat Headers in PDF Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to have any page breaks. When I run the report in BIDS, the...

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

Reminder on SSRS row separatorhttp://mail.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Notes Tuesday 04/10/2011 Main Office 09:00 17:00 Notes Tuesday 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2),...

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