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

29 May 2025 script automatically creates per-client subdirectories inside both _origs and _thmbs when you supply a client key in the request. You do not need to pre-create those. Secure Access via GET All calls must include: name — the output file name without the...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 the real Zoho Deluge function here as it would use my credentials but what you need to know is that it is passed the crmAPIRequest (string) variable and that the function itself had to have API Key and OAuth enabled (hover over function in CRM setup and...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather than requests. Sure it lists fields that are required in the request but not a sample request packaged to be sent. How? Let's assume that...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 } } } // // if there is reason to update it then let's update CRM API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 about third parties which we think you may find interesting if you tell us that you wish this to happen. You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 about third parties which we think you may find interesting if you tell us that you wish this to happen. You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 (response times) Critical - nothing works! Major - something important is broken Minor - less urgent but still broken Request - nice to have Support structure / maintenance rates agreed on (same as development - per hour) Instructions to include other...

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

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

14 January 2011 we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing"...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 you'll need to re-run the Help. The Help will tell you what to correct but it doesn't currently refresh its data until you request the Help page again. It only self-analyzes when the Help page loads, it isn't a persistent check. Just re-load the Help...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 thumbnails? The authorized group to generate new thumbnails USED TO BE Administrators or Super Admins/Users. Due to several requests, the module has been modified to accommodate any Joomla! group (specified in the parameters). It is NOT RECOMMENDED to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 WM_POWER = $0048 Const WM_COPYDATA = $004A Const WM_CANCELJOURNAL = $004B Const WM_NOTIFY = $004E Const WM_INPUTLANGCHANGEREQUEST = $0050 Const WM_INPUTLANGCHANGE = $0051 Const WM_TCARD = $0052 Const WM_HELP = $0053 Const WM_USERCHANGED = $0054 Const...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ReportID uniqueidentifier NULL The ID of the report (looks like a hexadecimal SSID). It's the...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request reference) number. The Report We start off with our detailed report page which lists all the details of a student. There is a...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 We didn't get this error as the problem was down to not having a "unattended user account" who could access the images. Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 function(e) { // Prevents the default submit event from loading a new page. e.stop(); // Set the options of the form's Request handler. // ("this" refers to the $('myForm') element). this.set('send', { onComplete: function(response) {...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 anything; but this is a production database I want to export for offline backup. I have to raise and log a formal change request and follow a workflow process in order to make a change on a live system to a service user account... Especially one used by...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 ToS - [1.8.0] News: include search words SUA, RPAs and UAVs - [1.8.0] News: disabled if offline - [1.8.0] Map: builds on request - [1.8.0] Map: disabled if offline - [1.8.0] Map: moved from app start - [1.8.0] App: actionbar changed to sidebar - [1.8.0]...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 following code to the .htaccess file in the root of your joomla website: # Admin Redirect RewriteEngine On RewriteCond %{REQUEST_URI} ^../administrator # note the .. to indicate parent directory for admin images (joomla 3.x) RewriteCond %{HTTP_COOKIE}...

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