This file contains HTML or script code that may be erroneously interpreted by a web browserhttp://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 The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making some minor changes to the MediaWiki LocalSettings.php...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account....

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

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

02 February 2019 the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using...

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

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

24 October 2020 you are doing in the Safari browser, there will be a log in the terminal: Editing the Widget So let’s modify the widget.html file in this app by opening a finder/file explorer window and browsing to the app folder: Then open the file “widget.html” in...

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

Print Directory Contents to a Filehttp://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

SSIS: How to loop through multiple flat files as data sourceshttp://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not...

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

Display a thumbnail of a Google Drive videohttp://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below...

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

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

11 February 2019 This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the...

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

Connection Strings for SQL Serverhttp://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Note that the charset option works from version 3.51.17 of the driver. Specifying socket This one specifies the Unix socket file or Windows named pipe to connect to. Used only for local client connections. Driver={MySQL ODBC 3.51...

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

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

19 December 2012 error and hopefully risk-free. How? Here's one method I used based on the services available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of...

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

Zoho CRM/Creator - Common Errors & Gotchashttp://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 a string with the escape character/backslash character Trying to split a string into a list by the backslash character: v_File = "C:\Documents\My_File.txt"; // want to extract My_File.txt l_FileParts = v_File.toList("\\"); info...

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

How to run a .RUN filehttp://www.joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...

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

Outputting PHP files into different file formatshttp://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Workdrive: Getting Team Folder IDhttp://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 in workdrive and check the URL: https://workdrive.zoho.com/home/{dunno_id}/teams/{dunno_id}/ws/{team_folder_id}/folders/files or https://workdrive.zoho.com/home/{dunno_id}/teams/{dunno_id}/ws/{team_folder_id}/folders/{team_subfolder_id} Getting the team...

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

Joe's Unduplicater (JUD)http://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS:...

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

Run commands for Windowshttp://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 control color Dr. Watson System Troubleshooting Utility drwtsn32 Driver Verifier Utility verifier Event Viewer eventvwr.msc Files and Settings Transfer Tool migwiz File Signature Verification Tool sigverif Findfast findfast.cpl Firefox (if installed)...

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

Basic Joomla 2.5 Mootools Formhttp://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 (ie. running in the background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving file that sends back the data, in my case, I've called it ajax.form.php and the contents...

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

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

04 October 2013 emptyBytes); } } } Example #2: Refreshing a DLL This has to be repeated every time the code changes in the script: Build CS file in solution Check-in file/change Build Project Check you have a compatible Global Assembly Cache (GAC) Utility C:\Program...

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

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

28 March 2014 user account (the Guest account): Open the registry editor with administrative privileges Select HKEY_USERS Go to the menu File and select Load Hive Navigate to that user's profile folder, usually C:\users\username in this case Users > Guest Enter...

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