Search - Joel Lipman .Com

1. Microsoft: / Category /; Created on 05 March 2020
2. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; ... "Extensions". No MSDN website said this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, ...; Created on 03 June 2014
3. Select unique values in Microsoft Excel column: / Excel /; ... This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the ...; Created on 03 July 2012
4. ZohoCRM: Import Attachments: / Zoho /; ... Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean Attachments.zip and its Attachments.csv to upload ...; Created on 16 January 2023
5. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Cooler Master V750 SFX Gold White Edition 1 £120.00 AIO ID-Cooling Zoomflow 240X Snow CPU Water Cooler 1 £74.99 O/S Microsoft Windows 11 Pro 64-bit 1 £219.99 Case Fans CoolMoon 3 Pack 120mm Crystal ...; Created on 12 March 2022
6. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", ...; Created on 16 June 2021
7. AutoHotkey: Get Media Information and Display: / AutoHotkey /; Applies To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar ...; Created on 07 August 2020
8. Windows 10: Shortcut Apps to Settings: / Windows OS /; Applies To: Microsoft Windows 10 Pro v10.0.18362 What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such ...; Created on 30 July 2020
9. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; Applies to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey ...; Created on 08 July 2020
10. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... above will work. Currently this only appears to accept Microsoft Word Documents and Adobe PDF files! Applicable to Zoho Books. If the user attaches text files (TXT) these will only attach to the Sale ...; Created on 15 May 2020
11. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; Applies to: Microsoft Windows 10 AutoHotkey 1.1.30 What? Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux ...; Created on 18 July 2019
12. Windows Live Mail Error ID: 0x8DE00005: / Windows OS /; Applies to: Windows Live Mail 2012 What? A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new ...; Created on 14 December 2016
13. Import Excel CSV file as JavaScript array: / Excel /; ... XMLHttpRequest to read file // (works at time of print (2015-10-05)) var xhr = !window.XMLHttpRequest ? new ActiveXObject('Microsoft.XMLHTTP') : new XMLHttpRequest(); // open ...; Created on 05 October 2015
14. VBScript to retrieve Windows Product Key: / Windows OS /; ... called read_product_id.vbs Copy the following code to the file: Set wshShell = CreateObject("Wscript.Shell") MsgBox ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DigitalProductId")) Function ...; Created on 23 September 2015
15. Android: Function to let user take photo or choose existing: / AndroidOS /; What? A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available ...; Created on 04 November 2014
16. Android: Keytool and Google Maps displaying grey: / AndroidOS /; Applies To: Microsoft Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays ...; Created on 31 October 2014
17. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; Applies to SITS:Vision v8.7.0 Uniface v9.6.03 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized ...; Created on 21 August 2014
18. T-SQL functions to convert Strings to Tables: / Transact-SQL /; Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let' ...; Created on 20 August 2014
19. SITS: Export field code and name: / Extensible Markup Language /; Applies to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the ...; Created on 12 August 2014
20. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...; Created on 09 August 2014