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

01 March 2011 what it does. The developer had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 errors per use of a...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are provided over an authenticated URL (You shouldn't be having any...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing, about changing a production environment and doesn't need a hierarchical authorization workflow process (in other...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 MS Visual Studio Code v1.48.2 Prerequisites Download nodejs source code from https://nodejs.org/en/download/. Don't worry about knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 app page will ultimately timeout and when reloading the form it simply displays a blank page. Their only workaround is wait about 30 seconds or more for the loop to automatically cut out and then they can use the interface again only to find it may...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 is possibly all your data being mapped, associated, and imported... I personally had to refresh the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately will...

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

Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information,...

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

Sun-Dried Tomato Basil Couscous Recipehttps://www.joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 and freshly ground black pepper. Fluff again with a fork and serve hot or at room temperature. Source: http://homecooking.about.com/od/pastarecipes/r/blpasta17.htm

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 $file, $ext = true ) { return "application/x-shockwave-flash"; Of course this means that any mime types it's not sure about, it will return as shockwave files. This could be a security concern but as our MediaWiki is on our Intranet for Staff use only,...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 objects in the GUI, hovering the mouse over other objects will no longer cause the search button to flicker. More...? How about having the cursor change to hand when you hover the mouse over the image: /* IDC_ARROW := 32512 IDC_IBEAM := 32513 IDC_WAIT...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 is powerful enough to run these effects without affecting performance. If this is happening to you, and you don’t mind about a possible slight slow down on performance you can force enable them - Go to Control Panel -> System and Security -> System...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1:...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 An error has occurred during report processing. Cannot impersonate user for data source 'BUKB_Test'. For more information about this error navigate to the report server on the local server machine, or enable remote errors I fixed this by repeating...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Monday, June 15, 2009 =Format(Fields!myDateTime.Value, "ddd dd/MM/yyyy")... Mon 04/04/2011 European and Now: The above is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 The How And here is the dilemma. The 3 below SELECT statements were derived from a post to the Stack Overflow website about the best way to check for rows in one table which don't exist in another. -- STATEMENT2 SELECT PageID, PageTitle, PageContent...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 for was a calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be...

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