ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the pull from invoices article I wrote earlier but with quotes from Xero,...

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

A for loop within a for loop in MS-DOShttp://mail.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 is the one I make for other people to use. Explaining MS-DOS batch programs is a lot easier and colleagues trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 orders, invoices, purchase orders). The only way to update these are by using the API and deluge function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or zoho.crm.createRecord(). How? This is somewhere in the official...

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

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

04 February 2025 panel: UPDATE `#_users` SET `params`='{}' WHERE `params`='{"",""}'; Set User Group Mappings from old DB to new DB: Other than new admin (here new admin ID is 111, previous admin ID is 222, and general information desk account is 333), remove other super...

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

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 I'm only try catching a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [ url: v_EndpointServer1 type: POST parameters: m_Html headers:...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 of record return false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. user clicked on field in view mode and edited just one field). The only other event you...

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

Terms & Conditionshttp://mail.joellipman.com/static-items/terms-conditions.html

30 May 2009 includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions. All trade marks reproduced in this website...

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

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the data you choose to share with us. You can choose to accept or decline cookies. Most web browsers automatically accept...

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

Copyrighthttp://mail.joellipman.com/static-items/copyright.html

30 May 2009 2009. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: you may print or download to a local hard disk extracts for your personal and non-commercial use only you...

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

Applying a button and centering it in the RocketTheme Affinity templatehttp://mail.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot more to do than just that. Instructions Open the templates/rt_affinity_j15/index.php Look at the last few lines with the original code...

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

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

25 September 2009 with 1&1 (oneandone.co.uk) and I would strongly urge Joomla developers to avoid them like the plague. They have been less than helpful and when I only had one Joomla site with them, they still would block me thinking I was trying to hack into their...

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

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

28 September 2009 because I felt I had followed the instructions to the letter. I then played about, deleting the other templates other than the one I wanted (affinity) using the Styles tab in phpBB3's Administration Control Panel (eg. http://www.mysite.com/phpBB3/adm/)....

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

Mediawiki Extension for Camtasia Studio SWF videoshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 as I browsed the Internet and no one seemed to have done this before. Fortunately, MediaWiki extensions are easier to write than Joomla CMS ones :c) This article shows you how to get your MediaWiki system to display your Camtasia Studio SWF files in...

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

Windows 7: System Clock is constantly going out of synchttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything less than 4 hours worth, or your computer might get banned by the time servers. Change Your Firewall Settings Third party firewalls...

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

MySQL Data Type Reference Tablehttp://mail.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttp://mail.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 but as with a lot of showroom demo sites, "the picture that came with the picture frame you bought can often be nicer than the picture you put in". i.e. it's a showroom and you've got to complement the template with your own visuals. Had no trouble with...

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

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

12 July 2010 - Changed browsing code to loop through folder of files to REMOVE. - Changed code to loop through an array of files rather than the directory. - Added subtext to inform user at each stage of the process. - Added resize capabilities to the program. -...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttp://mail.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 the report to Excel and on extra blank columns will appear in the worksheet. NOTE: Fields formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest...

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 of the service. Cheque overpayment. A buyer, prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 local report within BIDS connecting to remote servers. If you want the report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the deployed report on the...

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