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

09 October 2025 Thought I already had an article on this and I know my article Zoho Deluge - Connect to Xero API covered a quick query to pull some invoices but this one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I wanted a...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 box to proceed or cancel. Popup the email from CRM mailer with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to try it without a...

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

Using MetaMod to hide buttons from logged in usershttp://mail.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 Joomla 1.5.10 and the 'menu' module position.** 1. Create two menus, mine are named 'pubmenu' and 'regmenu'. (Assuming you already have a menu - easiest thing to do is make the new menu in menu manager for reg users. Next, go to the module mgr and...

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

Using K2 with jezReCaptcha plugin causing errorshttp://mail.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 ) in /public_html/components/com_k2/lib/recaptchalib.php on line 67 I've managed to fix this in my site. Because you already force the recaptcha feature in your registration form and contact form (on this website I just went recaptcha-happy), then there...

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

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 phpBB3 template (rt_affinity_phpbb3.zip) [ the template we're using in this example ] Install phpBB3: Hopefully you already have a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the...

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttp://mail.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 the LocalSettings.php file in the web root folder where your MediaWiki is installed: $wgFileExtensions[] = 'swf'; or if you already have an array, just add it to the end: $wgFileExtensions = array('png', 'gif', 'jpg', 'jpeg', 'doc', 'ppt', 'xls', 'mpp',...

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

Running Internet Explorer 6, 7, 8 as standaloneshttp://mail.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 program found in the IE6 download to run IE6. It will return v7 on the "about" dialog but I felt this was because I already had IE7 installed. Note that a lot of websites have reported that installing IE7 standalone breaks the IE6 standalone and none...

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

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 to what I googled (probably a bad sign but time is ticking and no one has forever). Situation: I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...

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

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 to your ORIGINAL site (live/production) Add the weblink on your ORIGINAL site. (you wont need the service as the image already exists...) Don't have a COPY of your Joomla site? (submitted by Webmaster de EDiSoPortal) Create a category for your weblinks...

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

SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 Maybe the answer could be in that mess of a Microsoft article but this I can already do and it didn't quite do what I wanted. I ran out of time (all MORNING!) so I went with solution #2 (above) and added the OR clause to all my dataset queries and...

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

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 query just to check with the end-user: Note that this an ordinary report as per usual. It will act as a confirmation page (already holds the parameter passed to it from the previous page and that it will pass to the next page which executes the stored...

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

List MediaWiki Articleshttp://mail.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list...

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

Stop Excel Row Height Self-Adjust on Refreshhttp://mail.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 the end-user would contact us and we would look up this error code. Instructions on setting up an Oracle Stored Procedure I already wrote an article on this so please refer to SSRS Parameters in Oracle Stored Procedure. Oracle: Grant another user...

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

How to change local folder for TFShttp://mail.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 (Tools > Options) but to no avail. How? The way to change this was: Connect to your Team Foundation Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO -- Create user defined function...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

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

20 August 2012 www.YourSite.com - Yeah note the URL to the mootools-core-uncompressed.js file, if you have this enabled in Joomla then you already have this and don't need to include it again (just view the source of your webpage that this form will be on). Does not...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the...

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