PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 we're going to query it and push it to Zoho Analytics. Find the form link name: Putting this here as it should be what we first did! This is with reference to the Zoho People version 5: Login to Zoho People as an administrator (don't have to be super...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 one may be referred to separately. I want a Zoho Survey when submitted to be parsed by a Zoho CRM REST API function. How? First, I'll go through the steps of setting up the Zoho CRM function, we'll convert it to a REST API function which will give us a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 auto-map. The client script below does the same for invoice as the quote lookup is a custom field on the invoice. How? First, we'll setup a client script specifying what triggers it (on load of the page when creating an invoice) then I'll just put the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 means that the Cx business halts. In order to add a bit of clustering, we have added a bit of code for it to try one server first, if there is any kind of an error with that server, it tries a second server... We now want to add a third server to try if...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 "Install", set as default and that's it.... Well at least if everything went well for you it is.... Install RokBB3 for the first time (fresh install) Upload all the necessary files to your server. I uploaded the ROKBB3.ZIP file to...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Write a Calendar in Autohotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 we want 01 to equal 1 StringSplit, DaysPerMonth, DaysInMonth, `, DaysInThisMonth:=DaysPerMonth%ThisMonthNum% ; get the first day-of-week of this month FormatTime, firstDayBlankNum, %A_YYYY%%A_MM%1, WDay ; add blank spaces in front of this first day...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Windows 7: System Clock is constantly going out of synchttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 (time.windows.com) when connected to the Internet and for some reason it doesn't display the right date/time. The Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Webdeveloper-Speakhttp://mail.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the page first loads is described as being ‘above-the-fold’. "belt-and-suspenders" Just like the UK's idiom "belt-and-braces",...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 DECLARE @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate)...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Alternate row background colour in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 report to be white (=#ffffff) in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rc:BookMarkID=1 Provide search criteria and find the first instance http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:FindString=foo Note: I have no idea what this is for. Render a snapshot...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Unix Date Format Specifiershttp://mail.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 with Monday (1), i.e. mtwtfss 1 %w day of week starting with Sunday (0), i.e. smtwtfs 1 Week %U week number Sunday as first day of week 01–53 %W week number Monday as first day of week 01–53 %V week of the year 01–53 Month %m mm month 07 %h Mon Jul %b...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 I think this pretty much answered my question: SELECT Catalog.Name AS ReportName , MIN(ExecutionLogStorage.TimeStart) AS [First] , MAX(ExecutionLogStorage.TimeStart) AS [Last] , CAST(CONVERT(CHAR, DATEADD(millisecond, MAX(DATEDIFF(MILLISECOND,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Search a database with SOUNDEXhttp://mail.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 Will pick up variations with trailing spaces but this is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has two rows, both...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Quickly update all content in mySQL database replacing a stringhttp://mail.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; SELECT `id` , `title`...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

htaccess Rewrites SEF URL and submits to PHPhttp://mail.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Generate a Timesheet in MySQL http://mail.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 on Monday. It also uses the current date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates and days: SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS ThisDate, DAYNAME(...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *