Migrate Joomla! 1.5.x to 2.5.x+http://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old Joomla database and writing to the new one. To run this script, your user needs SELECT, INSERT and UPDATE...

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

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Other apps I found only covered the USA, this one I wrote covers the world and can be added to really easily. It works by reading the weather data from api.openweathermap.org and the flight restriction details from api.joellipman.com (my own personal...

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

AutoHotkey: Check Windows Folder Sizeshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; Subroutine: LoopThrough: loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...") vTotalSize = 0 Loop, Files, %MyBaseDir%\*, F { vTotalSize := vTotalSize + A_LoopFileSize }...

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

Google Event Ilustrations aka Flairshttp://mail.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 bbq, barbecue, barbeque beer: beer, beers, Oktoberfest, October Fest, Octoberfest billiard: billiard bookclub: book club, reading bowling: bowling breakfast: breakfast, breakfasts, brunch, brunches camping: camping chinesenewyear: chinese new year,...

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

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is asking for an article on my own site. Besides this is how I did it and what worked for me... Set the default values for...

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

What's the problem? Amusing computer issueshttp://mail.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 If you're not an IT person, you may want to avoid reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in...

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

Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 I don't really understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list elements in different orders. If you haven't made a dropdown list yet There's other...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

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

SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 cannot be blank!". Before you ask, I have ticked both "Allow Blank" and "Allow NULL". How? This is the tough part. I was reading up on the MSDN page for the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to...

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

Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 an implementation available to the public in source code form), and must require no special password or key for unpacking, reading or copying. 7. Additional Terms. “Additional permissions” are terms that supplement the terms of this License by making...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

T-SQL Conversion failed when converting the varchar to data type inthttp://mail.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' +...

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

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 Why? I googled and binged and all I could find were people selling third party products... they don't get it. If you are reading this, it's likely you've paid for a commercial version of a Microsoft product which cannot possibly be cheap. MS SQL Server...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 data still hasn't been properly decoded from UTF-16 and encoded to UTF-8 Test writing to a file, re-encoding the file then reading from it. Helpful Links XML parsing in PHP convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this is...

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

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 an example MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix of database you are READING from (eg. `myuser_joellipmancom_mysitedb`.`lkdjf_content`) `v34_db`.`v34_tablename` -- with the database name and table...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 PHP functions. My database stored the foreign characters as they were so the fault was somewhere between PHP reading from MySQL to displaying the characters on the webpage.

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://mail.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 ); $file_xml = simplexml_load_string( utf8_encode( $file_content ) ); // works! DONE! Stop reading any further and tell your boss it was always in hand. Other things I tried but to no avail The solution above was as easy as that. Here are a number of...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttp://mail.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 How? So the way to push this value over to Creator is by converting the list to a string... notably comma delimited: // Reading CRM: l_MyMultiPicklist = List:String(); l_MyMultiPicklist.add("Option1"); l_MyMultiPicklist.add("Options 2, 3"); // Push to...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that the process would...

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