ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1:...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 project, and data confidentiality is somewhat important, some of the images will be censored or data changed in the example below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 To: Microsoft Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 searches as I see from Google searches that this does not exist as yet. Comments/Questions Please use the comment box below to add any questions (you can even post anonymously) or suggestions you might have. Thank you for your time! « DOWNLOAD ݏ

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

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 have only copied over some of the entire directory (the icons I want to use). Note, change the width of your browser if the below list is not displaying nicely. 4.4  fa-500px []  fa-adjust []  fa-adn []  fa-align-center...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 somewhat 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, I would have used cURL but for some reason, I...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 sign. Add your account and tick 'Manually configure server settings'. Configure server settings complete as per the image below (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• 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 https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile How? I've listed below 3 methods, the first follows the manual (or the logic thereof as I don't use the client library) and is a function sending two...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you could get your values from anywhere: On page load, the seconds remaining and elapsed are specified JS then...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 > 5 Close off this if else statement (if time remaining > 5 minutes) here if you are not using the full script below. 8. Done That's it! You have an access token, your service account can connect directly with its Google Drive. To get a file listing,...

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

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames =...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 for this particular app. For this reason, we are going to use a function by Skan called Filexpro() which is copied in the below: Filexpro( sFile := "", Kind := "", P* ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ;...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 because info can only be displayed to an admin and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup using the...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in this department/team: To determine the total...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API expecting nested arrays (not sure if...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my form is called "Quotes" and my subform is called "Line_Items": // initialize variables //... this is a demo so...

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

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 field to update In your code, sort a list by "Modified_Time", loop through and update each iterated record. (see sample code below). Go to the list view in CRM and filter by "Processed" is "Selected", check after each run of the function that the number...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 use-case was that I wanted to retrieve a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho Map...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 generate a PDF of the merged template and attach it to the CRM contact record under "Attachments". As a quick outline of the below: Create a connection to Workdrive/Writer Get the Merged Template ID (hexadecimal) Create the all-in-one button and...

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