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

20 March 2025 } It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this but the truth is that I do not have a...

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

Hide Menu Item from Registered and Special https://joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title...

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

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

30 September 2009 do the same. It's just so complicated in Photoshop when web-developers need to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the selection on Create a new...

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

Joomla banners not rotatinghttps://joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 > Banner... What I do is I don't select a client but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display, consider setting categories as vertical, horizontal and square banners. This means...

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

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

03 August 2010 been switched to SEF in the global configuration (where all SEO settings are set to "Yes") and works fine irrespectively. In time, if I ever learn to use it properly, I may change my opinion but why complicate things...?

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

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

23 February 2011 want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget to tick the option "display can be toggled by this report...

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

Border settings not saving in SSRShttps://joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...

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

SSRS - Lost window with datasetshttps://joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report...

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

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

03 June 2011 Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service last worked? Suggestions by Wikipedia...

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

First and Last Entry on a Page using Modulus Remainderhttps://joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Free Translator API using Googlehttps://joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 So this is a quick article to get your Google Translation services working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. Microsoft's Bing has added itself to the fray pretending to...

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

Live WebCam feed of Bournemouthhttps://joellipman.com/articles/web-development/live-webcam-feed-of-bournemouth.html

30 January 2013 is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's clock is seriously off. Otherwise it's a picture from the future (see photo timestamps).

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

MS Excel: Convert a text to a numberhttps://joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 an error?!?!?!? The answer on the Microsoft website is as helpful as the Microsoft paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the VALUE() function.......

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

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

22 November 2013 this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string" parameter to "shared datasource" parameter where the user can select which...

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

SSRS Border Problemhttps://joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or...

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

VBScript to retrieve Windows Product Keyhttps://joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 to Windows 7 Professional. Why? With the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to...

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

Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to...

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

Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF extension that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding... Pre-amble To allow...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200,...

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