This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 we can fix this. For demo purposes, I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the LocalSettings.php file in the web root folder where your MediaWiki is installed:...

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

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 to store the finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 last for 60 minutes, in this example, we are going to store the token value so it is reused until it is about to expire. Firstly, we need to check how many minutes are remaining since the access token file was last modified: // check minutes remaining...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created...

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

CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 the next, covering the footer and header... How? By spending a lot of time spinning on my chair and twiddling my thumbs... Firstly, set the page CSS: This will allow 3cm from the top for a header and 2cm from the bottom for a footer. @page { size: A4;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Invalid arguments passed in router.php on line 325https://www.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: *

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 Joel 4.41235E+11 1.4571E+18 1.4571E+18 Stanley 1709123456 1.4571E+18 1.4571E+18 David 3.31235E+11 1.4571E+18 How? Firstly, save the CSV file as text file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It...

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