Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 7 (both 32-bit) Tested with: MS Internet Explorer 7 libraries System Requirements: Used ~55Mb RAM on 1.6Ghz PC Free Disk space to store your pictures Installed MS Internet Explorer (only uses libraries) Program Size: 1,190Kb (fits on a floppy disk)...

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

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

04 October 2013 taking into account punctuation symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ValueToConvert = ValueToConvert + " "; // tranformation exceptions: words...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 images, word documents, etc) We can accept most formats except for those exclusive to the Apple Mac operating systems. Webspace Setup For JoelLipman.Com to do: Assess allocated server space - expected size of website including all uploaded files. Add...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile of useless info, at least I'm not just copying and pasting from other sites to add content to my own. And I'm not just...

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

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ( StringValue...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 anyway). The TRIM() function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious space which had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 cursor { Loop, Parse, SystemCursors, `, { CursorName := SubStr( A_Loopfield, 6, 15 ) ; get the cursor name, no trailing space with substr CursorID := SubStr( A_Loopfield, 1, 5 ) ; get the cursor id SystemCursor = 1 If ( CursorName = Cursor ) {...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 requires a 400 MHz Pentium-compatible processor (1.0 GHz or faster recommended), and requires approximately 35 MB of disk space. It runs on Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Windows XP Professional, Windows XP...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $0D Const VK_SHIFT = $10 Const VK_CONTROL = $11 Const VK_MENU = $12 Const VK_CAPITAL = $14 Const VK_ESCAPE = $1B Const VK_SPACE = $20 Const VK_PRIOR = $21 Const VK_NEXT = $22 Const VK_END = $23 Const VK_HOME = $24 Const VK_LEFT = $25 Const VK_UP = $26...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 % Chr(25) ; downwards arrow, unstable Generate list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch of others that may work: Some others that may work: Dec Hex Unicode Char...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before the carriage return otherwise the column will return as one word (ie. there has to be a space in...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 1) In column G put the formula: =MID(B1, FIND(F1, B1)+1, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 1) // if there is a space between the two =MID(B1, FIND(F1, B1)+2, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 2) In column H put the formula:...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 v_ThisFileName := StrReplace( A_LoopFileName, "." A_LoopFileExt, "") a_ThisFileName := StrSplit( v_ThisFileName, A_Space, ".") ; remove converter comments from file name v_NewName := "" Loop % a_ThisFileName.MaxIndex() { v_FoundUnderScore := InStr(...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 works if you have a CRM connected to your Zoho Creator: Log-in to your ZohoCRM Create a Connection Go to Setup > Developer Space > Connections > Add Connection Select the Zoho Creator connection, give it a Connection Name, I'm going with joels_creator...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 // or if you subscribe you can have a private conversation with the MidJourney Bot Type the word /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 is sync'ing with your ZohoAnalytics: Login to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next"...

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

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 click and hold either the Back or Forward arrow in the browser toolbar. Displays your browsing history in the tab. Press Backspace, or Alt and the left arrow together. Goes to the previous page in your browsing history for the tab. Press...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 through and I have found a utility that actually works on my pen!!! It said “repaired USB pen” and when I go to check the space, my 30Gb has returned!!! It’s called Urescue and it’s become my favourite program (despite the fact that I want to need to...

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

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 or with the actual code and you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a definitive answer!

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