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

12 January 2022 will then be shown a summary of your import: You can then setup a schedule for the import to automatically download the data file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings you may...

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

Amazon Kindle: Send PDFs to your Kindlehttp://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 This is an article taken from https://goodereader.com/blog/kindle/here-is-how-you-can-read-pdf-files-on-the-amazon-kindle which I wanted to take note of as it is a process that worked at time of print (6 June 2022) and I wanted to make sure it didn't...

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

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

18 September 2025 the fields that will be pulled from "Goals" and some records with data. Create the Zoho Analytics table Create a blank Excel file / spreadsheet / csv Copy the names of fields you want to store (I'm taking all of it), and paste them into the header of...

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

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

28 September 2009 not. I'm rewriting their instructions here so that I can I do this on other websites: Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation...

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

Joe's CSV Chart Generator (JCG)http://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can...

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

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

30 January 2011 table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open the SQL file in your favorite text-editor Rename any instance of "my_old_database.jos_" to the name of your old Joomla 1.5 database or a...

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

Could not instantiate mail functionhttp://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 that you add the A record for server.domain.com so that it resolves. 2) The hostname must be in the /etc/virtual/domains file. 3) The hostname must *not* be in the /etc/virtual/domainowners file. 4) The hostname must resolve. If not, add the required A...

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

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

05 July 2011 = $0229 Const WM_MDISETMENU = $0230 Const WM_ENTERSIZEMOVE = $0231 Const WM_EXITSIZEMOVE = $0232 Const WM_DROPFILES = $0233 Const WM_MDIREFRESHMENU = $0234 Const WM_IME_SETCONTEXT = $0281 Const WM_IME_NOTIFY = $0282 Const WM_IME_CONTROL = $0283 Const...

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

SSIS Convert a string into a datehttp://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow...

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

Joomla Component: Set default params on installationhttp://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as the XML installation file) Add the...

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

Zoho Creator: Sendmail a list of attachmentshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred to me that perhaps this isn't clearly documented. But there are...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 a widget in detail which I'll link to at the bottom of this page. What follows are the quick steps to create a widget.html file and how to get whatever the Zoho Deluge CRM function returns. Create a JS Widget on your device (MacOS) These steps are the...

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

Invalid arguments passed in router.php on line 325http://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file. Mine was generated by "http://www.notwebdesign.com/joomla-component-creator/". I don't need one because although I rely on...

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

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

04 February 2025 this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep getting complaints that my server wants to upgrade my PHP v7.x to PHP v8.x. I also get complaints (from my server...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 the site specified in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files Download the latest files from https://portal.areyouahuman.com/installation/php (If you want my cached download - v1.1.8:...

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

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

27 April 2014 the site specified in the AYAH dashboard should be "test.mycompany.com" and not "www.mycompany.com") STEP #2: Download AYAH files Download the latest files from https://portal.areyouahuman.com/installation/php (If you want my cached download - v1.1.8:...

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

Batch Process to rename multiple files using Windows DOShttp://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and...

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

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

20 March 2019 database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this database...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 of the fields this contains) Create a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is...

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

VBScript to retrieve Windows Product Keyhttp://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

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