Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 on 3.1.x and 3.2.x) - Fixed Bug: Support for German, Chinese, French, Arabic, Hebrew and Slovak - Enhancement: Update server added (for when Joomla supports this) - Date Uploaded: Wed, 15th Jan 2014 3.0- Enhancement: Hardcoded DS value for Joomla 3.x...

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

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

24 October 2014 I might need to take into account. Other apps I found only covered the USA, this one I wrote covers the world and can be added to really easily. It works by reading the weather data from api.openweathermap.org and the flight restriction details from...

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

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

07 September 2015 VersionPlatform ChangeLogOptions3.1.1 Artur- Enhancement: Added parameter: Weblink separator height. - Enhancement: Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 --- paypal, google, --- order ref, --- download limit, --- download period, --- thank you message v0.1 (06/07/2011) - Added Admin Section: Settings/Configuration --- Component landing page customization (add note to see Component Style). --- Storage...

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

Joes Google Map (JGM) Downloadshttps://www.joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.1- Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added parameters:...

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

Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...

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

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 HTML5 - Enhancement: Compatible with Joomla v3.x - Parameters: Flash option removed - Date Uploaded: Thu, 15th Jan 2015 1.4- Added Module Parameter: Custom Background Color - Added Module Parameter: CSS3 Rounded Corners - Added Module Parameter:...

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

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 near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my transform part) added as a data flow transformation held in an assembly Custom Component Script with debug logging:...

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

Joes Youtube Plugin (JYP) Downloadshttps://www.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Tested for compatibility with Joomla! CMS v2.5.8 - Modified description. - Date Uploaded: Tue, 1st Jan 2013 1.0.3v1.0.3 - Added Joomla Admin Panel option: Plugin Class Suffix - Added Joomla Admin Panel option: Border Color - Added Joomla Admin Panel...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 check which ones have already been converted and can now be deleted. Or run this program. CHANGELOG: v1.1 (12/07/2010) - Added option to ignore prefixes and suffixes to the filename. - Colored the folder to keep in Green and the one to delete in Red. -...

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

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

28 June 2011 formats. v0.2 (29/06/2011) - Resize GUI feature enabled - "Take a picture" now only takes a screenshot of the inner GUI. - Added credits: Sean (ScreenCapture.ahk) v0.1 (28/06/2011) - Added documentation and help 2.0 (auto-troubleshoot). - Added update...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 > 0) { r_NewDocumentRecord = Document[ID == r_CheckIfDocumentAlreadyExists.ID]; v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 It is recommended you skip the menu migration and do this manually. -- -> Doing this manually takes me too long so I have added this section. -- -> Migrating menus with this script preserves SEF Joomla 1.5.x URLs. -- -> the Joomla Menu was the most...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... This is the problem. For example, if the year dropdown has a list of 2010, 2011, 2013; then if...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 ** ** 11/10/2012 Jlipman 1.0 Created ** ** 12/10/2012 Jlipman 1.1 Merged into one query. ** ** Added schema to column_source. ** ** 15/10/2012 Jlipman 1.2 Added count column to final results. ** ** Added minStrLen and maxStrLen for more accurate...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 on each copy an appropriate copyright notice; keep intact all notices stating that this License and any non-permissive terms added in accord with section 7 apply to the code; keep intact all notices of the absence of any warranty; and give all...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 A quick article on some code added to a button in ZohoBooks off the invoice module to initiate your Stripe terminal to take a payment. Why? Just to make it easy on the staff at a counter or on the phone. They bring up the invoie in ZohoBooks, click on...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 ticket field on the subform so that I get the popup to enable bi-directional rather than via the tickbox. The below code is added to a trigger whenever the ticket form is submitted either on creation or modification. The function to rule-them-all This...

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

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 Document record in CRM Date Created: 2024-08-06 (Joel Lipman) - Initial release - Tidied up, removed commented code - Added Email and Account mapping to ZohoSign Document record Date Modified: 2024-08-21 (Joel Lipman) - Creates a recipient and event...

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