Search - Joel Lipman .Com

1. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What ...; Created on 08 July 2020
2. 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
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ct = Map(); if(v_FullName.contains(" ")) { v_Forenames = v_FullName.subString(0,v_FullName.lastIndexOf(" ")); v_LastName = v_FullName.subString(v_FullName.lastIndexOf(" ")); m_CreateContact.put("First_Name",v_Forenames); m_CreateContact.put("Last_Name",v_LastName); } else { m_CreateContact.put("First_Name",v_FullName); } m_CreateContact.put("Email",m_Notification.get("beneficiary_email")); m_CreateContact.put("Account_Name",v_ZCRM_DocRecordAccountID); m_CreateContact.put("Contact_Status","Active"); m_CreateContact.put("Lead_Source_Detail","Cre ...; Created on 06 August 2024
4. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... s rename the file the name of the staff member along with the file type v_FileName = m_User.get("full_name"); v_FileExtension = m_SignatureImage.get("extn"); v_FileNameFull = v_FileName + " ...; Created on 05 December 2023
5. ZohoCRM: Import Attachments: / Zoho /; ... B contains the foreign key/id from the 3rd-party database. It then prompts for a folder containing the original files and will collapse any subfolders as well as rename the files to unique filenames. ; ; ...; Created on 16 January 2023
6. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("ExternalPictureURL",v_PublicUrl); m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // / ...; Created on 31 March 2022
7. Zoho Creator: Change Radio into Tabs: / Zoho /; ... First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need ...; Created on 22 October 2021
8. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; ... manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients) Find the file htaccess.txt and rename it to ...; Created on 14 March 2020
9. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? ...; Created on 07 February 2020
10. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
11. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... on its contents or embedded code specific to the template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in ...; Created on 12 September 2015
12. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... Grid Mode - pagination, auto-scroll. - Modified Parameter: renamed "STOP Thumbnail Generation" to "Enable Service" (switch round yes no) - Enhancement: Cross-browser coding / optimization / commenting - ...; Created on 07 September 2015
13. Joes Word Cloud (JWC) Download: / Downloads /; ... Date Uploaded: Thu, 11th Nov 2010 1.2.3 - Fixed bug: counts international characters rather than bytes. - Fixed bug: renamed functions so as not to conflict with any pre-existing ones (eg. utf8_strlen)- ...; Created on 07 September 2015
14. 301 Redirect using htaccess file: / Web-Development /; ... to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend ...; Created on 03 April 2014
15. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
16. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference ...; Created on 07 March 2014
17. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... is to remove any non-alphanumeric characters... In your component, create a PHP file in /administrator/models/fields/ (eg. "userprojects.php"). Rename "userprojects" with the name of your field ty ...; Created on 25 October 2013
18. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...; Created on 14 May 2013
19. 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
20. Inline Labels in Form Fields using Javascript: / JavaScript /; ... giving it the label value to indicate to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves their cursor into the field or clicks on it. In this specific ...; Created on 21 August 2012