Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 either the TFS or my target deploy location. I found a quicker fix than rebooting your computer which is to open a command prompt and to type "ipconfig /flushdns" then "ipconfig /registerdns" and the connections would have been restored. As I love...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 1: The first line of my code 2: The second line of my code 3: The third line of my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 right-click on an object). The following is a method of adding this as a single command similar to how we add the "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 on Actions Select Connect to Outlook Allow the website to open a program on your computer (opens Outlook). Confirm the prompt your Outlook instance generates as a result. You now have a new calendar under Other Calendars, you can open another calendar...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 Folder := fso.GetFolder(Folder) return fso.GetFolder(Folder).Files.Count } Method #5: MS-DOS Command Prompt dir c:\*.* /os /s -- bear with me as i try to create a for loop one to omit all the header info

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

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 Note: Currently SSIS/BIDS only supporting assemblies compiled with .Net 3.5 Take it to the GAC Run a command prompt as Administrator Change working directory to location of GACUtil CD C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin Run the GAC and add...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. #SingleInstance Force ; Skips the prompt that a current instance is running and overwrites this one with a fresh instance of this program SendMode Input ;...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 $REDIRECT_URI, $SCOPES; $url = sprintf($GOAUTH . 'auth?scope=%s&redirect_uri=%s&response_type=code&client_id=%s&approval_prompt=force&access_type=offline', urlencode(implode(' ', $SCOPES)), urlencode($REDIRECT_URI), urlencode($CLIENT_ID) );...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using PHP/cURL... In that this one doesn't prompt for a user. Again this script doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of...

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

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 Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press F5 to run the code. This will prompt you twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000). You are then prompted for the...

• 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 -------------------------------------------------------------------------------------- ; SubRoutine: BrowseFolders: Open a prompt to change the folder to scan BrowseFolders: FileSelectFolder, SelectedFolder , *%A_ScriptDir%, 0, Select a folder to...

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

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 to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit You should get prompted for the Mac/Admin password which you type in the terminal (will not display, just type away and press the Return key). The...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 on it, enable it and select "Update Driver" Either via the device manager or just from pure frustration, you should get a prompt to download the Intel Graphics Command Center app from the Microsoft Store (if you don't get prompted, just go get it and...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 // // build params of request m_Params = Map(); m_Params.put("model", "text-davinci-003"); m_Params.put("prompt", v_Question); m_Params.put("temperature", 0.9); m_Params.put("max_tokens", 256); m_Params.put("top_p", 1); m_Params.put("frequency_penalty",...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 2 invoice types selected if ((v_InvoiceType == "Deposit" || v_InvoiceType == "Final Balance") && v_QuoteID != null) { // prompt with a confirmation box var b_Proceed = ZDK.Client.showConfirmation('Changing Invoice Type to '+v_InvoiceType+' will re-write...

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

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify...

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