Search - Joel Lipman .Com

1. Google Event Ilustrations aka Flairs: / Google /; ... brunch, brunches camping: camping chinesenewyear: chinese new year, chinese new years, chinese new year's cinema: cinema, movies clean: cleaning, clean the house, clean the apartment, clean house, tidy ...; Created on 05 December 2024
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken ...; Created on 23 May 2024
3. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'l ...; Created on 07 April 2022
4. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... really a hardware kind of guy. My skillset is really around software (see my other articles) and I've been using Mac alongside my PCs for the past 7 years. My MacBook is from 2015 and still runs everythin ...; Created on 12 March 2022
5. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time ...; Created on 11 February 2022
6. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very ...; Created on 24 October 2020
7. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... Get the file URL (ie. the PermaLink) So if you've been googling how to download a file that was uploaded into a Creator form, you may have come across forums that are over 10 years old; URLs tha ...; Created on 15 May 2020
8. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
9. Client Services: Website Development Agreement: / Static Items /; ... it took to setup a website previously, and will plan the same again). My 15 years of web-development experience allow me to reduce the risk of nasty surprises and also allows me not have to Google search ...; Created on 15 November 2013
10. Access MySQL databases using Oracle SQL Developer: / MySQL /; What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, ...; Created on 01 February 2013
11. Setup a copy of your Joomla website: / Joomla /; What? More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across ...; Created on 19 December 2012
12. DataScramble - Randomizing data rows: / Transact-SQL /; ... -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ...; Created on 07 December 2012
13. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ...; Created on 01 August 2012
14. MySQL last year week month day trend periods: / MySQL /; Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count ...; Created on 31 October 2011
15. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; ... ThisSecs:=SubStr(ThisSecs, 1, InStr(ThisSecs, ".")-1) If ThisDays>0 { If ThisDays>365 { ThisYears:=ThisDays/365 IfInString, ThisYears, . ThisYears:=SubStr(ThisYears, ...; Created on 20 September 2011
16. Joes Bug Tracker (JBT): / Product Documentation /; ... and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very plain and basic, needed tweaking to get rid of adverts and to integrate with a website' ...; Created on 07 July 2011
17. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... computer. I've specified that that's all it scans for, it's not interested in your personal details or what you had for breakfast, it's my years as IT support that push me to make software self-analyze in ...; Created on 28 June 2011
18. Creating a Profile Plugin for Joomla 1.6: / Joomla /; ... than 6 months" JOELLIPMAN_ALLERGYTIMEOPTION1="Less than a year" JOELLIPMAN_ALLERGYTIMEOPTION2="1 year" JOELLIPMAN_ALLERGYTIMEOPTION3="5 years" JOELLIPMAN_ALLERGYTIMEOPTION4="10 years+" PLG_USER_PROFILE5_FIELD_ALLERGYTIMEDISP_DESC="Choos ...; Created on 27 April 2011
19. Inserting incremental weeks in MySQL: / MySQL /; Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...; Created on 15 April 2011
20. Developer's Checklist: Taking over a projec: / Web-Development /; ... had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error logs... some 20000 ...; Created on 01 March 2011