Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 send this quote."; } return v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this article: Invoice: https://books.zoho.com/api/v3/invoices/pdf?organization_id=&invoice_ids= Invoice...

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

ZohoDeluge: Inserting a new line character in a CSVhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 to your code. This will not display a character but is a new line... Used in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference: f_CSVFile.setCharSet("UTF-8");...

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

ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 products you have in your shop, it will stop when it's reached the end of the list as per eBay and not what you might have thought it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date Created: 2023-03-01...

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

Zoho Deluge: Proper Case for Nameshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 of a HR system. This is intended to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 SO" = so."Sales order ID" LEFT JOIN "Sales Order Items" soi ON so."Sales order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 to remove a key from a map. In this case, the ID key and value pair. It would then tell me the list was null when I thought I was adding the map with the ID removed back into a list. The map itself was null. How? We are using an API action called...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 A frustrated article about an issue that took me a fair few hours to resolve. So I'm putting it here as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 me a while to get the right syntax for writing to the invoice line items as well as setting the value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025),...

• 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 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: *

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 - 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, things...

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

Prices get rounded up in Virtuemarthttp://mail.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to...

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

Splatter Logohttp://mail.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

$_SERVER['http_referer'] returns blank in Internet Explorerhttp://mail.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...

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

Sir James Dyson explains his bladeless fanhttp://mail.joellipman.com/articles/_other-misc/sir-james-dyson-explains-his-bladeless-fan.html

30 October 2009 I love technologies that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, we may not need air conditioning as much as other...

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

On Gui Resize Eventhttp://mail.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 Thought I'd put this down as it took me ages to search the Internet for this solution. In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your...

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

Add "Command prompt from here" to right-click context menuhttp://mail.joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click on the File Types tab...

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

Windows 7 and Google Chrome incognito mode by defaulthttp://mail.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share one for windows 7 here. I'm actually only saving you a click as you can just right-click on the google chrome icon...

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

Change Regional Settings for your Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

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

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

03 August 2010 Thought I'd put this error in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other...

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

SSRS Expand specific drilldown by defaulthttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

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