PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory with simplexml_load_string(). I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

GoDaddy Apache cPanel: Install SSL Certificatehttp://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 alongside the domain you want to install the SSL certificate for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and scroll down to "Web Hosting" then click on...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttp://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 r_Document.get("document_name"); v_ThisDocumentId = r_Document.get("document_id"); if(v_ThisDocumentId == v_DocumentId) { r_File = invokeurl [ url :"https://sign.zoho."+v_TLD+"/api/v1/requests/" + v_RequestId + "/documents/" + v_DocumentId + "/pdf" type...

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

SSIS Skip Rows in Excel Source filehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...

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

301 Redirect using htaccess filehttp://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add...

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

Zoho CRM: Make Upload File Field Mandatoryhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through...

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

List all cron jobs for all usershttp://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab file and cron job directory. Change these for your system. CRONTAB='/etc/crontab' CRONDIR='/etc/cron.d' # Single tab character....

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

Joomla article modal with clear buttonhttp://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 How? Well don't quote me on this but I haven't needed to modify this script for any different component. Simply include this file in the fields folder/directory of your component (/my_component/administrator/models/fields/article.php). It's based on two...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 Merge; then has to click on "execute function after merge" and select the function to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttp://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 on how to download videos from a session on TrainerCentralSite.com. How? OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I struggled with this...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 CRM contact record ID that will take the survey they completed, generate a radar/spider/web chart, and attaches it as a PNG file on the CRM record. string standalone.fn_Analytics_ExportChart(int p_ContactID) { /*...

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

Embed an FLV file into a web pagehttp://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 This is if you have an FLV file and you don't want any fancy management system, you just want your FLV to play on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: *

Disable User Registration in Joomla 1.5 - Configuration Filehttp://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database to the Joomla 1.5.x website Browse the table "jos_components"...

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

Add Image Mouseover effect in AutoHotkey GUIhttp://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 RemoveToolTip, Off ToolTip return } SetSystemCursor( Cursor = "", cx = 0, cy = 0 ) { BlankCursor := 0, SystemCursor := 0, FileCursor := 0 ; init SystemCursors = 32512IDC_ARROW, 32513IDC_IBEAM, 32514IDC_WAIT, 32515IDC_CROSS, 32516IDC_UPARROW,...

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

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

19 September 2011 and we only want one location to upload the photos. These images are provided via a website address (http) or network share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for product=NETWORK, facility=TNSMessage 3513 n ot...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

07 May 2013 In the case of Joomla, we'll use the article ID. Pre-Notes: This article consists of instructions to hard-code some core files in Joomla. As a precaution, you may want to back up all your website files and its database. Or, if space is limited, you can...

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

Android: Keytool and Google Maps displaying greyhttp://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 to the PATH environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir jdk* and append the \bin. Note this for later. Right-click on the "Computer" icon/label...

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

AutoHotkey: Get Media Information and Displayhttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)http://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were...

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