Articles - Joel Lipman .Com

Generate a Timesheet in MySQL

: Joel Lipman; MySQL; 05 December 2013; Hits: 2856

What?
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet.

Why?
I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me.

What I want:

copy raw

ThisDate    ThisDay     StartTime  TimeOut  TimeIn  EndTime  TotalTimeToday TotalTimeWeek
----------- ----------- ---------- -------- ------- -------- -------------- -------------
2013-12-02  Monday      09:00      12:00    13:00   17:00    7:00           7:00
2013-12-03  Tuesday     08:45      12:00    13:30   17:45    7:30           14:30
2013-12-04  Wednesday   09:00      12:30    13:30   17:00    7:00           21:30
2013-12-05  Thursday    10:00      12:15    12:45   17:15    7:45           29:15
2013-12-06  Friday      07:00      12:00    13:00   16:30    8:30           37:45
2013-12-07  Saturday    -          -        -       -        0:00           37:45
2013-12-08  Sunday      03:00      04:00    -       -        4:00           41:45

ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday TotalTimeWeek
----------- ----------- ---------- -------- ------- -------- -------------- -------------
2013-12-02 Monday 09:00 12:00 13:00 17:00 7:00 7:00
2013-12-03 Tuesday 08:45 12:00 13:30 17:45 7:30 14:30
2013-12-04 Wednesday 09:00 12:30 13:30 17:00 7:00 21:30
2013-12-05 Thursday 10:00 12:15 12:45 17:15 7:45 29:15
2013-12-06 Friday 07:00 12:00 13:00 16:30 8:30 37:45
2013-12-07 Saturday - - - - 0:00 37:45
2013-12-08 Sunday 03:00 04:00 - - 4:00 41:45

Category: MySQL :: Article: 541

: Joel Lipman; Oracle PL/SQL; 05 December 2013; Hits: 15388

What?
A quick note on how I got round one this one.

Why?
Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue.

I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment.

How?
Consider the following:

: Joel Lipman; Joomla; 24 November 2013; Hits: 11744

What?
This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install.

How?
Source: Joomla! • View topic - Cannot get recaptcha to display on registration form...
There are two solutions I have found that fix the problem:

: Joel Lipman; SQL Server Reporting Services; 22 November 2013; Hits: 9608

Applies to:

Microsoft Business Intelligence Development Studio 2008 (BIDS)
Microsoft SQL Server 2008 R2

What?
This article describes solutions to the error:

Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

How?

: Joel Lipman; Joomla; 17 November 2013; Hits: 5414

What?
This is a quick note on one reason you may get the above error in a Joomla CMS environment.

copy raw

Call to a member function mark() on a non-object in /public_html/index.php

Call to a member function mark() on a non-object in /public_html/index.php

How?
Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was.

Category: Joomla :: Article: 536

: Joel Lipman; Excel; 15 November 2013; Hits: 5976

What?
This is a quick article on how to convert some cells in Microsoft Excel to number values...

Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was?

I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE!

How?
The problem is that I have a column which includes the currency symbol as per the following image:

: Joel Lipman; SQL Server Reporting Services; 11 November 2013; Hits: 4067

What?
A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following:

copy raw

Message from webpage

Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

Message from webpage
Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

Why?
The problem happens because of the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter.

How?

Category: SQL Server Reporting Services :: Article: 533

: Joel Lipman; SharePoint; 07 November 2013; Hits: 5487

What?
This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given.

Why?
Because I can

How?

: Joel Lipman; iOS; 03 November 2013; Hits: 10535

Applies to:

Apple iOS 7
Apple iTunes 11.1.3.8
Microsoft Windows 7 Professional

What?
Just so many articles out there that did not help me. This article is how I finally did mine.

Why?
I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun).

The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio).

How?
Note that the restore can be done when the new phone prompts you to set it up but you could do the below again at anytime (as I 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).

: Joel Lipman; Web-Development; 28 October 2013; Hits: 6150

What?
A quick reminder on basic regular expressions.

Match Any Character — Dot
The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the expression:

copy raw

a.c

This expression matches all of the following sequences:

copy raw

abc
adc
a1c
a&c

The expression does not match:

copy raw

abb

Category: Web-Development :: Article: 531

: Joel Lipman; Joomla; 25 October 2013; Hits: 15904

What?
I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables.

Why?
In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their own projects and not everyone's:

copy raw

SELECT * FROM #__projects ORDER BY name

-- yields all projects irrespective of which user is logged in

SELECT * FROM #__projects ORDER BY name
-- yields all projects irrespective of which user is logged in

What I want:

copy raw

SELECT * FROM #__projects WHERE user_id=<logged_in_user> ORDER BY name

SELECT * FROM #__projects WHERE user_id=<logged_in_user> ORDER BY name

Please Note: This article focuses on a front-end form dropdown. If you would like to see how to do modals for the admin panel, see my article Joomla article modal with clear button for Joomla article selection.

How?

Category: Joomla :: Article: 530

: Joel Lipman; Joomla; 24 October 2013; Hits: 5292

What?
I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything.

How?

Credit where Credit is Due:

RSS Feed

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Donate & Support