A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 but nothing relating to the instructions will be hidden. We will run all three monitors (DOT, EOT, TOT) last and after setting up all the pre-requisites in SITS first: What changes will trigger the event? Find the screen you know contains the field to...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id. This will yield the following: body.bgstyle1...

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

Setting up your store to use SSLhttps://www.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 about 46pt and everything was over 3000px in width but this is not good for a final solution. I thought maybe there was a setting for the default font size or where I've accidentally zoomed out in the browser... but these were red herrings as I have...

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

Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime...

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

Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 I update this article, Joomla seems to come out with a new version. If you have installed Joomla 2.5, this is now a setting in the global configuration... The only problem is that your landing page becomes "HOME - SITENAME.COM" which is ridiculous and...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an...

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

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

19 July 2011 (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection avoids the hassle of having to generate access/refresh tokens using OAuth2.0. Usually used with an...

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

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 a contact called "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in Zoho Bookings as documented in the official documentation. Not sure why anyone would want to...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 me a while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What I had: ${CONTACT.CONTACT_DISPLAYNAME} ${CONTACT.CONTACT_ADDRESS}...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 on "My Apps". Select the app you are going to setup a webhook for (see my Zoho Deluge - Connect to Xero API article for setting up an app) Select "Webhooks" in the left sidebar menu Tick "Contacts" and "Invoices" and enter the Delivery URL as the REST...

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

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

20 October 2009 the Joomla banner module only supports alternating between banners of either the same client OR the same category. The setting is in your Joomla > Module Manager > Banner... What I do is I don't select a client but instead just select a category. Set it...

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

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 to accept or decline cookies. Most web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. This may prevent you from taking full advantage of the website. Links to other websites Our...

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

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 still get hacked with viagra emails and what have you (eg. JoomlaBook). If you don't want to go through the logs, try setting up a test joomla site with a different database and user and see if that behaves the same way. Virtual Hosts I used to have an...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 "OK this should take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 use to sort by this) checked_out_time => just cos this value exists, don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't like it and nor do u if you've been trawling the web for this...

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

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

18 May 2010 with Windows7 but my customers are on XP and I have to emulate their environment as accurately as I can which I can do by setting up my work computer to be just like theirs (using the same image, etc). Programs which I would NOT recommend I've put a...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 guideline(s). Set the object’s size and position by right-clicking the field, selecting Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY...

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