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

11 March 2022 Document Name (a single line that will be the name of the file including its extension) Document (the file upload field) Downloaded (a picklist with the options "Downloaded" and "Pending Upload") Here's the code for the parent form to download the...

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

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

07 July 2011 Administrator Panel. Go to "Extensions" > "Install/Uninstall". Click on the "Upload" button and select the file you downloaded in step #1. GLOSSARY/TERMS/DEFINITIONS - File = A file which is available for download from your site, each version is its own...

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

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

28 June 2011 that other websites either do not have or have stopped providing, or just because it's easier for me. This program can be downloaded by visiting www.joellipman.com and selecting "Features", then "Downloads", then "Standalone programs" (or click here)....

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory with simplexml_load_string(). I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 under the "Upload a new certificate" section > Then select the certificate file noted earlier in step 4 (the one you downloaded as a Zip) then return to this screen and click on "Upload Certificate" Return to the SSL/TLS page from your cPanel dashboard...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same...

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

Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 then having it emailed to anyone is an easy task but here we cannot have that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All...

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

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

29 May 2025 in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few images and as the user scrolls down the dropdown,...

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

How to run a .RUN filehttps://joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 Set up a new database on the same server as my previous database. New db user and password added to the new database. Downloaded and uploaded the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production...

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

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

28 September 2009 empty". I backed up my local copy of the prosilver folder as well as my local copy of the Affinity for phpBB3 template. I downloaded the /phpBB3/styles/prosilver folder and copied all the files to my local copy of Affinity without overwriting if...

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

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

12 July 2010 (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all legitimately :) and stored them in my music folder. I then run my MP3 software to convert all the...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 Developer, go Tools > Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and...

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

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

17 March 2013 to tell me the country that is allocated a given IP address, this is what I use. The scripts in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use:...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://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 MySQL.com may in the time that I have written this article, release a newer version that corrects this. I personally downloaded HeidiSQL, setup a connection and exported the database. Job done without making any changes to the LIVE environment!

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

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

31 October 2014 I found when debugging this issue: Download from the Play Store: The google maps api will apparently NOT work if you downloaded the APK from another location. This wasn't the issue, once I had the right SHA1 registered in the Google APIs console other...

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

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

02 February 2019 a string of scope urls delimited by a space (in this example only one). ISS is the client email taken from the JSON key downloaded from Google. // Build token payload for a JSON string $api['jwt']['claim_set']['iss'] =...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 This is an article to document how I downloaded an image held in a Zoho Creator form, and sent it to an API wanting the publicly accessible link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources"...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 eBay. Out-of-the-box, and at-time-of-print, Zoho Inventory only syncs eBay one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 file where column A contains the key/ID of the Contact in the 3rd-party database and column B contains the filename as downloaded from the 3rd-party database. And an internal file where column A is the ZCRM Record ID (eg. if Contacts module then the CRM...

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