Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 https://www.zoho.com/analytics/api/v2/bulk-api/export-data.html https://www.zoho.com/crm/developer/docs/api/v8/upload-files-to-zfs.html https://www.zoho.com/crm/developer/docs/api/v8/update-records.html...

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

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 database? Matched the datatypes received/returned by functions, classes and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the...

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

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 Extract the folder "Template Name" into this directory ^ If in the package the folder "lib" contains, extract the files in the directory \components\com_kunena\lib\

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

Docman - Uploaded a document and can't see ithttps://www.joellipman.com/articles/cms/joomla/docman-uploaded-a-document-and-cant-see-it.html

29 June 2009 As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why a developer has to refresh the...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 file in your web root folder (you may find a .heder.php file as well in your webroot as well as some strange index files with strange naming conventions (eg. xzcseifs_kdiek.html) which shouldn't be there either). You'll need to remove these and restore...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv). Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen. BTW I don't use the "remove device safely" rubbish as...

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

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

26 May 2010 have suggestions I don't see the need to release service packs and updates. OTHER NOTES: This program does not install other files nor is a setup. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't...

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

Language Codeshttps://www.joellipman.com/articles/cms/joomla/language-codes.html

13 September 2010 components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers will use Joomla! CMS. The below...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 it will retain the previously deployed report settings (header&footer). Resolved this by clearing my web-browser's temporary files. Do we instruct all users viewing the reports to do this? When does this report automatically expire? Reminder on Paper...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 control color Dr. Watson System Troubleshooting Utility drwtsn32 Driver Verifier Utility verifier Event Viewer eventvwr.msc Files and Settings Transfer Tool migwiz File Signature Verification Tool sigverif Findfast findfast.cpl Firefox (if installed)...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Some sources are specific saying that the account will need to be able to logon to the external server holding the files. MSDN Quote: When the report is previewed in Report Designer, preview uses the credentials of the user to display the image. When...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 the comment fields at the bottom of this page to ask a question. Additional I'm pretty sure you don't need all the require files and my solution may be crude, but this script works perfectly for what I had in mind. Important! There are a few concealed...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 I work for use JQuery as well as MooTools, I needed this for a component that I was building and only wanted to use the files that Joomla versions 1.6 to 2.5 included in their basic install (vanilla/out-of-the-box). Will not work with Joomla 1.5 or less...

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

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 simply added the clear button to the existing article modal file (Joomla 1.6.x to 2.5.x). Don't overwrite any existing core files with this one, it's completely unnecessary as this is a 3.24Kb file. Step #1 of 1: Create and include the following PHP...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 you're upgrading and follow the below instructions. I'm also going on the basis tha. Basic Checklist Download all J1.5 files to one folder: /modules/mod_moduletoupgrade/mod_moduletoupgrade.xml /modules/mod_moduletoupgrade/mod_moduletoupgrade.php [if...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Add arguments in format /c start "Task Name" "Full Path of Program", for example: /c start "VisualStudio2010" "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" for Start In..., I leave this blank but you could specify a working...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

14 March 2013 || (LTRIM(ContributionValue) == "") ? "0.0000" : TRIM(REPLACE(ContributionValue,",","")) My Most Frequent Fix: The data files I have to work with are rarely consistent. On some rows the date column will have a string of 8 characters long in the format...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 This gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma Seperated Values...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 A quick article on how to remove the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from PCWorld.com. I adapted this to read a google news rss feed and...

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