Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at...

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

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 Recently, more and more people have been asking if I can take over a project that has been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an infinite number of...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 another dataset (using the same data source if you like): -- Oracle 10g: DataSet2 -- a quick dataset following the first (started before the first ends? hope not) SELECT TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportEndTime FROM DUAL This may be just...

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

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

04 October 2013 public class ScriptMain : UserComponent { // Method that will be started for each record in your dataflow public override void Input0_ProcessInputRow(Input0Buffer Row) { // C# alternative for VB.Net StrConv uses cultureinfo and threading // See:...

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

Mark Twainhttps://joellipman.com/articles/_other-misc/mark-twain.html

29 June 2014 secret of getting ahead is getting started.

• Type: Article
• Author: Webmaster
• Category: Hobbies
• Language: *

Language Codeshttps://joellipman.com/articles/cms/joomla/language-codes.html

13 September 2010 started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers...

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

SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 academic data. Unfortunately the developer wrote a system he felt would last the rest of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A function goes in with a normal calendar date and...

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 text := COM_Invoke(pwb, "document.documentElement.innerText") There you have it! These techniques should help get you started. Next, I would recommend the following: Try these Controls out on some of your favorite webpages. Find some more JavaScript...

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

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

21 July 2011 So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the...

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

The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report finished running? Need to check what finished? TimeDataRetrieval int NOT...

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

Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 is for Joomla 1.5.x sites! Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress....

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal...

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

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

24 September 2013 product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 :: MOnitor source; run again in m minutes Time, if changed. /RH:hhmm-hhmm :: Run Hours - times when new copies may be started. /PF :: check run hours on a Per File (not per pass) basis. /IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines....

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

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

25 January 2016 on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and paste their content into our...

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

Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks...

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

Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order...

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