Setting a rocket theme background to fixedhttp://mail.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 scroll about. Go to Extensions -> Template Manager> Edit the CSS for the template You should be given an option of css files, select styles.css and click on the Edit button Look for these lines: body.bgstyle1 #main-background {background:...

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

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

23 September 2009 update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information...

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

List of Font Awesomehttp://mail.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 set that has all the icons you would want in a modern website design. How? To use this list, you can either: Copy the font files to your template folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of...

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

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 in the v34 system other than the user who is installing it. Preparation: Backup your Joomla v2.5.x database and website files Note the CURRENT super user identification number "ID" and alias (name) Ensure all items are "checked-in" (Do a "Global Check...

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

Import Excel CSV file as JavaScript arrayhttp://mail.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 : new XMLHttpRequest(); // open the file // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request...

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

Foreign Characters create symbols in PHP and MySQLhttp://mail.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 ENT_COMPAT,'UTF-8', true), ENT_COMPAT, 'UTF-8') Other things to consider: Save all PHP files as UTF-8 and not ANSI Ensure all text fields in the database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8...

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

Zoho Deluge - Get distance between two coordinateshttp://mail.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.. the...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 = ifnull(m_ThisFile.get("download_Url"),"-"); v_ThisFileAttachmentID = ifnull(m_ThisFile.get("attachment_Id"),"-"); v_ThisFileSize = ifnull(m_ThisFile.get("file_Size"),"-"); v_ExpiryTime = zoho.currenttime.addMinutes(10).toString("dd-MMM-yyyy...

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

Windows OS: Alt Codes / Symbols / Special Charactershttp://mail.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark...

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

Zoho CRM: Upload a Product Photo using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 + v_CrmProductID + "/photo?restrict_triggers=workflow"; r_CrmPhoto = invokeurl [ url: v_Endpoint2 type: POST files: r_CreatorPhoto connection: "joels_crm" ]; info r_CrmPhoto; } } The above should yield something like:...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 "created_at": "2021-10-17T21:45:56+01:00", "updated_at": "2021-10-17T21:45:56+01:00", "src": "https://cdn.shopify.com/s/files/1/2345/6789/1234/products/aaaabbbbccccddddeeeeffff11112222.jpg?v=1234567890", "variant_ids": [], "admin_graphql_api_id":...

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

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

21 October 2021 Scopes: ZohoWriter.documentEditor.ALL and ZohoWriter.Merge.ALL For good measure, I'm going to include the scopes: WorkDrive.files.ALL, WorkDrive.workspace.ALL Click on Create and Connect > Accept Get the Template ID The following snippet is a separate...

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

Zoho Books: Generate Bank Text File for Downloadhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 invokeurl [ url: "https://www.zohoapis.com/books/v3/bills/" + v_BillID + "/attachment?organization_id=123456789" type: POST files: m_Attachment connection: "zbooks" ]; Open the file / Download via Browser We're going to use an openUrl() function here in...

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

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

23 June 2025 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 and ultimately used VOSK but I'm...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 file as Zoho_Analytics_Performance_Goals.xlsx Login to Zoho Analytics Select "Data Sources" then Add New Data Source Select "Files" (has the icon of MS Excel on it) Give it a table name. I've gone with Performance Objectives / Goals File Type I said was...

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

Making a CD copy with only one drivehttp://mail.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 Right-click on the CD drive and select OPEN Go to EDIT > SELECT ALL > EDIT > COPY PASTE to a temporary folder Select all the files, right-click on them and select SEND TO > DIRECTCD Roxio Easy CD Creator instructions: Insert original CD in the drive...

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

How to make your Joomla site use SEO friendly urlshttp://mail.joellipman.com/articles/cms/joomla/how-to-make-your-joomla-site-use-seo-friendly-urls.html

02 April 2010 ("htaccess.txt" to ".htaccess" in your website root folder). You'll need ftp access or a file manager with all your website files in). Do not continue if you ONLY have control of the Joomla CMS. Watch the youtube video below which shows you how to do it...

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

Added a Launcher and Unduplicaterhttp://mail.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you can run the AHK files and modify these to suit your needs. The new programs also read off a configuration file which you can modify in any text...

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

SSRS Templates in BIDS 2008http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-templates-in-bids-2008.html

01 April 2011 report and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the folder: "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject" Done!

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

Increase Recent Documents Number in Windows XPhttp://mail.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK...

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