Search - Joel Lipman .Com

1. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; What? A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next ...; Created on 02 November 2021
2. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...; Created on 23 April 2013
3. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... CRM, then skip this if statement if(v_ZohoSign_DocumentType == "CreditApplication") { v_RequestID = ifnull(m_Body.get("requests").get("request_id"),"0").toLong(); l_SearchResults = zoho.crm.searchRecords("zohosign__ZohoSign_Documents","Request_ID:equals:" ...; Created on 06 August 2024
5. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Pre-amble Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section ...; Created on 25 July 2024
6. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... as well as from the system as it contains bank details. You can skip this step if you're not bothered about storing this file on the system. Note that if you use the endpoint to delete the attachment ...; Created on 02 October 2023
7. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... owner, and that it is unique for every Kindle device. Finding your Kindle email address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can skip this ...; Created on 29 June 2022
8. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... how to set up a connector as there is plenty of documentation on the Zoho Official Documentation and even on this website so we'll skip to the COQL query. This is what I have: // // build up COQL ...; Created on 08 October 2021
9. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... := SelectedDir "\*" Loop, Files, %v_FilesPath% { ; skip if file ext is not media if A_LoopFileExt not contains wav,mp3,avi,flv,mkv,mov,mp4,mpeg,mpg,wmv continue ...; Created on 08 July 2020
10. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, ...; Created on 21 November 2019
11. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... function that is skipping the SSL checks and returns a PHP array function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); ...; Created on 02 February 2019
12. Android: Keytool and Google Maps displaying grey: / AndroidOS /; ... In the above, if you have specified the correct bin folder in your PATH environment variable, then you can use the keytool from any folder, skipping the initial steps of navigating to the JDK folder. ...; Created on 31 October 2014
13. AHK Countdown Tooltip: / AutoHotkey /; ... #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. #SingleInstance Force ; Skips the prompt that a current instance is ...; Created on 17 July 2014
14. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... COPY NO file info (useful with /PURGE). /SECFIX :: FIX file SECurity on all files, even skipped files. /TIMFIX :: FIX file TIMes on all files, even skipped files. ...; Created on 23 February 2014
15. Split a row into multiple rows based on a column value: / Transact-SQL /; Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...; Created on 23 August 2013
16. Proposed Budget i3 PC under £200: / IT Support /; ... of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime ...; Created on 26 January 2013
17. The Mermaid: / Hobbies /; ... her hand. While the raging seas do roar, And the stormy winds do blow, And we jolly sailor boys were skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers ...; Created on 24 July 2012
18. Win32 Constants: / AutoHotkey /; ... = $8000 ;#End Region ;#Region Custom Draw Return Flags Const CDRF_DODEFAULT = $00000000 Const CDRF_NEWFONT = $00000002 Const CDRF_SKIPDEFAULT = $00000004 Const ...; Created on 05 July 2011
19. Upgrading a Joomla 1.5 module to Joomla 2.5: / Joomla /; What? So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I ...; Created on 11 February 2011
20. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... user) with most privileges on BOTH databases. -- -- To change the database names used in the below script to the ones you use!!! -- SKIP MIGRATION: -- -- Each section was written so that it could ...; Created on 30 January 2011