Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 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 we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed document attached to the initial record (where the button was). Why? If anyone has the envious task of sending a...

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

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

28 September 2009 and FTP upload the files uncompressed, or if you have shell access, upload the zip and extract it to the styles folder. Now return to your phpBB3 Administration Control Panel (ACP), which should be located at something like...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 If you want to get an element(s) based on limited criteria, you can use the following 3 methods: getElementById(id) - returns a reference to the first object with the specified ID getElementsByName(name) - Returns a collection of objects with the...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query. The stored procedure compiles successfully and without any...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 ComponentMetaData.Name , String.Format(errorMsg1, input.InputColumnCollection[x].Name) , string.Empty , 0 , out pbCancel); return DTSValidationStatus.VS_ISCORRUPT; } // Check whether each usage type is READWRITE if...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 RETURN ; ********************************************************************************************************************************************************************** ; MAIN FUNCTIONS ;...

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

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

24 October 2014 API v0.9 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to country) rules are...

• 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 set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request to the server xhr.send(); // return contents of target file to JS variable var my_csv_file_contents = xhr.responseText; // split contents into array of rows //...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 CURLOPT_POST, 1); curl_setopt($ch1, CURLOPT_POSTFIELDS, file_get_contents($file)); curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: '.$mime_type, 'Content-Length: '....

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write. Why? As mentioned, it took me a...

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

Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/articles/automation/autohotkey/functions-to-convert-hex-2-rgb-and-vice-versa.html

27 September 2011 StringMid,B,HexString,5,2 R = % "0x"R G = % "0x"G B = % "0x"B R+=0 G+=0 B+=0 RGBString = % R Delimiter G Delimiter B Return RGBString } From RGB to Hexadecimal: RGB2HEX(RGBString,Delimiter="") { If Delimiter= Delimiter=,...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name ---------...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 field called "Vendor Contact Email" ZDK.Page.getField("Vendor_Contact_Email").setValue(v_ContactEmail); } } catch (e) { // return error (don't display it, just show it in the logs) log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 'xls', 'mpp', 'pdf', 'zip', 'flv', 'swf'); Online forums are saying this is it, but my system still didn't allow them and returned the above error... Secondly: Edit your /includes/specials/SpecialUpload.php file and add the following line shortly after...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 ); so.addParam( "allowScriptAccess", "always" ); so.addVariable( "autostart", "false" ); so.write("media"); // ]]> '; return $this->code; } function getViewPath($file) { $title = Title::makeTitleSafe("Image",$file); $img = new Image($title); $path =...

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

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 and Note in the details (will appear in each cell per day). Grouping by weeks: Now we finish with the report wizard and returned to the designer. Right-click on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week...

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

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

05 July 2011 Keys Const VK_LBUTTON = $01 Const VK_CANCEL = $03 Const VK_BACK = $08 Const VK_TAB = $09 Const VK_CLEAR = $0C Const VK_RETURN = $0D Const VK_SHIFT = $10 Const VK_CONTROL = $11 Const VK_MENU = $12 Const VK_CAPITAL = $14 Const VK_ESCAPE = $1B Const...

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

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 modify. In it's straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return Formattedtime } The following function is to convert a given SQL date or a European date formatted value: FormatDate(val) { ;...

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