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

27 September 2009 things! After modifying tax rates and ensuring these were all the same, we also found that this was due to a country not being specified under the Store configuration within VirtueMart.

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

Mouseover Links in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 quick with their mouseovers and mouseouts, then the GUI will sometimes leave the link as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a...

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

Mootools - How to contain a menu sidebar between header and footerhttps://joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically resized in height. What? Basically I have a menu in a sidebar, I don't want it to overlap the header nor the...

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

Convert Decimal (Person Days) to Time in Excelhttps://joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 it would appear can book whatever time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why?...

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

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

22 November 2013 use the default values (from and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data...

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

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

08 April 2014 as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report...

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

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field. Why? At the moment,...

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

DJI Phantom FC40 - First Flighthttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-first-flight.html

28 August 2014 by YouTube Capture app (but includes stabilization): {youtube}jFJJY5uUT0E{/youtube} Secondly, the Hubsan Q4 Nano for $40 USD being filmed by the DJI FC40 Camera at 1280x720 30fps then reduced by YouTube Capture app: {youtube}LJBsexczqhU{/youtube} And...

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

Error 404 Component Not Found when enabling SEF URLshttps://joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 3rd-party SEF plugins to correct the situation but when I moved my test site to live at www.joellipman.com (instead of being on http://test1.joellipman.com), I found I could disable the third-party SEF extension and enable my Joomla SEF settings... ???...

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

Zoho Deluge - Get Current User IDhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer...

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

Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url =...

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

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 zoho.loginuserid to: zoho.adminuserid subject: v_Subject message: v_Message attachments:file:v_CSVFile ]; Issue(s): CSV being returned in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge: Inserting a new line...

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