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

08 August 2011 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 NULL Milliseconds spent retrieving the data. TimeProcessing...

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

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

05 December 2013 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 9:45 and finished...

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

Uninstalling AEC Central and installing Community Builderhttps://joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 to Extensions > Install/Uninstall 5. Install com_comprofiler.zip (remember to wait till it confirms it says "Installation finished") 6. Go back to Extensions > Install/Uninstall 7. Install mod_cblogin.zip 8. Install mod_comprofilerModerator.zip 9....

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

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

05 July 2011 True ) ; Make the IE object visible COM_Invoke( pwb, "Navigate", "www.AutoHotkey.com" ) ; Navigate to a webpage ; when finished COM_Release( pwb ) ; Always release COM objects COM_Term() ; Always Uninitialize COM How to access an existing IE object? -...

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

List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS PageID,...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• 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 install, right-click on End and select "Add Dialog". Select the "read me" dialog. Drag the "read Me" page to be above the "Finished" page.

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

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

12 September 2015 on the v2.5 system so that they can log in to the new system. -- TO ACTIVATE USERS (do NOT do this until after you have finished the migration): UPDATE `v34_db`.`v34_users` a, `jbuzzer_joellipman_live`.`jdlv2_users` b SET a.`block`=b.`block` WHERE...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 v_Css = v_Css + ""; input.Form_Css = v_Css; } But wait we're not finished as there are the chevrons / less-than greater-than signs options to program into. For this simply append the following: else if(input.Calendar_Day_Select == "<") { // // set...

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