Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 data using other sources and in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the level...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 v2.3.0 (JoomlaTune.com) What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an...

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

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

24 October 2014 incidental, or consequential damages, including but not limited to personal injuries, damage to property, injury to others, including that to life and health, resulting from any application and use of any of JoelLipman.com products. The Purchaser and...

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

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

31 October 2014 an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to the Google APIs console (there's so many)...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this is my stop. It's being several hours that for others could have taken a several minutes if you knew where to look. My aim was to convert UTF-16 received XML to UTF-8 in order to...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 my_db | gzip > /full-path-to/backups/my_db/backup_`date +"\%Y-\%m-\%d"`.sql.gz Additional Others around the web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders module but it wasn't...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 "GetNotificationPreferences"; // // build header m_Headers = Map(); // siteID 3=UK, 0=US, check API Explorer Test Tool for others m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion);...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 The file on the FTP server to download can be of type: CSV, TSV, Text, Excel, MS Access DB, HTML, JSON, XML and others: Supports server types of FTP, FTPS - File Transfer over Explicit TLS/SSL, FTPS - File Transfer Over Implicit TLS/SSL, and SFTP - SSH...

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

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 = 200; // // get other products with the same name (set in order of oldest first and keep only first one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by id limit...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Product Photography Real Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. Eye-Level Shot puts a massive eye on the picture???) Cinematic Still...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 v_KeepID = 0; // // get other products with the same name (set in order of oldest first and keep only first one, delete the others) m_SubParams = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as Notes, Attachments, Emails, and Timeline should remain. Code will be needed as a layout rule...

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

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

18 September 2025 Took us a while to find this and perhaps others would have a quicker way but here's the instructions on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and...

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

MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 able to use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is...

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

Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 already on, it will display a link such as: https://drive.google.com/open?id=, where is the file ID. If not the "Share with Others" dialog will popup and the file ID will be in the link: https://drive.google.com/file/d//view?usp=sharing, where is the...

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS...

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