Search - Joel Lipman .Com

1. Quickly update all content in mySQL database replacing a string: / MySQL /; What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin ...; Created on 03 February 2013
2. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, ...; Created on 11 October 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... 1: Credit Application: Template exists in ZohoSign Very quickly, let's go over the implementation plan for this scenario (where you have the template in ZohoSign with fields for the end user to complete): Add ...; Created on 06 August 2024
4. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the ...; Created on 22 January 2022
5. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; What? A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho ...; Created on 24 September 2021
6. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; What? A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" ...; Created on 01 September 2021
7. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
8. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... such as: openUrl("#Form:My_Confirmation_Popup?zc_Header=false","popup window","height=144,width=555"); The reason being, is that the top solution offers a very generic popup box that can be quickly ...; Created on 06 November 2020
9. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... 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 ...; Created on 07 August 2020
10. Accessing Apimo WebService API: / API Miscellaneous /; ... vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, ...; Created on 29 March 2016
11. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
12. CSV Chart Generator: / Product Documentation /; Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate ...; Created on 04 September 2015
13. Copy a Wordpress Site for Development: / Wordpress /; ... values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', ...; Created on 08 March 2015
14. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... So you can do this quickly on a friend's PC and it's a bit geeky. Type the following NOTEPAD rename.bat and answer Yes to if you want to create it. Copy & Paste the following (the string to replace ...; Created on 09 August 2014
15. Joes Password Analyzer (JPA): / Product Documentation /; What is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in ...; Created on 03 January 2014
16. Improve Default Joomla Search: / Joomla /; - Applies to Joomla 2.5.x +, 3.4.x What? So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently ...; Created on 07 May 2013
17. AwStats Data Parser (ADP): / Product Documentation /; ... finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data ...; Created on 03 April 2013
18. Restore MSSQL Error: Database is in use: / Databases /; ... is quickly forgotten. How? You need to set the database to single-user mode. In SSMS, connect to an instance of the SQL Server Database Engine, and then expand that instance. Right-click ...; Created on 08 March 2013
19. Setup a copy of your Joomla website: / Joomla /; ... usernames/passwords created in the previous steps. $sitename - I would suffix this with "TEST" so as to quickly distinguish this from your main website. $db, $user and $password - these are the database ...; Created on 19 December 2012
20. Generate Academic Calendar using MySQL: / MySQL /; ... is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID ...; Created on 27 November 2012