Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; What? An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person ...; Created on 14 May 2024
3. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
4. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... or v_UnixSeconds = v_MyDate.unixEpoch(); info v_UnixSeconds; Error: Argument type mismatch -Found 'TEXT' but Expected 'Long' // Solution: Convert your string into a date. Source(s) toTime() ...; Created on 04 May 2020
5. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
6. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc..."). function getTimeAgo($p_Date) { ...; Created on 16 May 2019
7. Convert foreign characters to English alphabet: / MySQL /; What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm ...; Created on 13 June 2016
8. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
9. Excel: convert degrees minutes seconds to decimal: / Excel /; ... to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N 116°35′51″E Beijing Shahezhen ...; Created on 06 November 2014
10. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... 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 TABL ...; Created on 20 August 2014
11. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
12. MS Excel: Convert a text to a number: / Excel /; What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...; Created on 15 November 2013
13. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... process of packaging the script into a reusable component. Example #1: As an SSIS Script Task My solution so far: The following script will convert to lowercase and then capitalize the first ...; Created on 04 October 2013
14. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
15. SSIS Convert a string into a date: / SQL Server Integration Services /; ... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...; Created on 14 March 2013
16. Convert Decimal (Person Days) to Time in Excel: / Excel /; ... going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ...; Created on 13 February 2013
17. Php convert filesizes to bytes kb mb gb: / Personal Home Page /; What? Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays ...; Created on 03 January 2013
18. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
19. Convert seconds to total time in PHP: / Personal Home Page /; ... to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":"; $total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":"; $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // ...; Created on 31 January 2012
20. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal ...; Created on 27 September 2011