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

17 July 2014 ; Platform: Win9x/XP ; Author: Joel Lipman ; Date Created: 15-July-2014 ; ; Script Function: ; Just a countdown for my last days at BU. ; ;...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 the following (the string to replace here is " (Copy)" without the quotes) - this is a READ-ONLY process if you leave the last line commented/remarked @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• 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 BEGIN DECLARE @StringValue VARCHAR(MAX) -- Trim and remove last pipe character SET @StringInput = LEFT(RTRIM(LTRIM(@StringInput)), LEN(RTRIM(LTRIM(@StringInput))) - 1) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput,...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 for confidentiality but nothing relating to the instructions will be hidden. We will run all three monitors (DOT, EOT, TOT) last and after setting up all the pre-requisites in SITS first: What changes will trigger the event? Find the screen you know...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 more distractions. This is my filming of some Radio Controlled cars at the Torch Racing, UK event last Sunday. The FPV latency isn't good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I...

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

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 provider = locationManager.getBestProvider(criteria, true); // Get Current Location Location myLocation = locationManager.getLastKnownLocation(provider); // set map type mMap.setMapType(GoogleMap.MAP_TYPE_NORMAL); // Get latitude of the current location...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 2/13/2013 10:37:24 PM Failure Incorrect Contact ID '; // Replace UTF-16 with UTF-8 $xml_string = preg_replace('/( urlencode($last_name), 'fname' => urlencode($first_name), 'title' => urlencode($title), 'company' => urlencode($institution), 'age' =>...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 2 but with specified folder To get the folder ID, simply browse to the Google Drive folder in your browser and note the last string in the URL. So in https://drive.google.com/drive/folders/, the value where "" sits will be your folder ID. $GAPIS =...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 I want to display to the user how much time is left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing...

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

Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 { English_Ordinal = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar =...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 mark, right to this particular link [Optional] */ ul.breadcrumb a.home:before { content:'\00bb'; margin-right:5px; } The last snippet is completely optional if you want to prefix the character » to your breadcrumbs. Unfortunately, this only deals with...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 one after the one you're using. You need to use the latest CODE as any new one expires any previously generated ones. A code lasts between 1 to 10 minutes. {"code": "AUTHENTICATION_FAILURE","details": [],"message": "Authentication failed","status":...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 desk and not in the order of left to right. So the above code tries to determine the leftmost monitor and rightmost with the last being in the centre. First of all here's the code to open a windows application on a non-default monitor: ; Get full screen...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We could have tried out some...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 == r_Quote.ID]; v_ContactFname = r_QuoteDetails.Contact_Name.first_name; v_ContactSname = r_QuoteDetails.Contact_Name.last_name; v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price =...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 to get the FetchToken. So first, I need a function to get me a Session ID. Once I've used this and signed in once, it will last a few seconds, long enough for me to do my Fetch Auth'n'auth token process: string...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 { // loop through active users if(r_User.get("status") == "active") { v_Email = ifnull(r_User.get("email"),""); v_LastName = ifnull(r_User.get("last_name"),""); // // single out this person (can be removed after testing)...

• 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 output port: I connected 1 DP to miniDP cable to the 1st monitor, then another cable from the 1st monitor to the 2nd, and lastly another cable from the 2nd monitor to the 3rd (in other words, a Daisy Chain). New Setup Diagram: The graphics card (RTX...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 that when downloading the certificate from GoDaddy and followed the steps above but it kept showing the certificate for last year. Chatted to GoDaddy who said use incognito mode and clear cached files - same result Downloaded the ZIP file from GoDaddy...

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

Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 We set the parameters of the form/report. Then this shows how to embed using a DIV layer which allows for CSS styling. The last part shows how to embed using an IFRAME tag which isn't great for CSS styling as you can't do cross-dom acoss child iframes;...

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