Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 v_CrmAccountID = r_CreateAccount.get("id"); } } // create this contact as they filled in the survey without us sending it to them m_CreateContact = Map(); m_CreateContact.put("First_Name", m_SurveyBody.get("First_Name"));...

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

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 Standalone / On-Demand / Callable Purpose: Function to get the first page of most recent invoices from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman)...

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

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 Trigger: Standalone / On-Demand / Callable Purpose: Function to get the first page of most recent quotes from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release - Parsing Xero Dates and Times to...

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

Making a CD copy with only one drivehttp://mail.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 drive and select OPEN Go to EDIT > SELECT ALL > EDIT > COPY PASTE to a temporary folder Select all the files, right-click on them and select SEND TO > DIRECTCD Roxio Easy CD Creator instructions: Insert original CD in the drive Open Easy CD Creator From...

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

Frontpage Item Orderinghttp://mail.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect. To set them, do this in your Joomla! Admin Panel (back-end). Choose Menu > Main Menu from the pulldown menus. Click on the Home item's...

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

Increase Recent Documents Number in Windows XPhttp://mail.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to...

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

Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong then just post a comment at the bottom of this page. Go...

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

Leap Motion and AR Dronehttp://mail.joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 with major platforms. The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as...

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 which stores the credentials, ie. A sql authenticated user with read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription section). The report...

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

SSRS Change Background Color of Imagehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 the Image Properties to specify the image to use. The image can be an expression as well (I embed these and then refer to them in the expression by name). For example: =IIF(Fields!SummaryStatus.Value="Success", "status_ok",...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages and then making them suitable for our new SQL Server 2012 instances. How? This applies to a workstation (hopefully you're not doing development...

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