Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 "best_site_ever.bmp". Pros/Cons - Advantages/Disadvantages On-Demand: Run this program in the morning, in the afternoon, once, twice, however and whenever YOU want. Unlimited: You are only limited by the resources of your environment setup, in terms of...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Configuration Utility msconfig System File Checker Utility (Scan Immediately) sfc /scannow System File Checker Utility (Scan Once At The Next Boot) sfc /scanonce System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 file does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 The "clear" button is essential as some article_modal fields may not be required and are difficult to clear once set. How? Well don't quote me on this but I haven't needed to modify this script for any different component. Simply include this file in...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones. Eeek! A bit...

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 cannot be added. The component only accepts inputs", ComponentMetaData.Name), null); } // This method is called once at Run Time // It creates an array (inputBufferColumnIdx) containing the index in the pipeline buffer of each input column passed into...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 so if you aren't familiar with the system registry in MS Windows, you may need to find someone who is. How? As a proof of concept, let's see how to hide a specific drive. Note that this section applies to the currently logged-in user. To restrict other...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out: Open the Report in Design mode. Check that advanced...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 Pictures\byeBU\byeBU_byPChristopher.bmp" ; Background image to revert to once program ends DesktopBackgroundImage2:="\\bournemouth.ac.uk\data\Staff\Home\jlipman\My Pictures\Win7_ScrSvr\BU_Core_CMYKportraitbigwithborder.jpg" ; Default Message reference...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 Store: The google maps api will apparently NOT work if you downloaded the APK from another location. This wasn't the issue, once I had the right SHA1 registered in the Google APIs console other users could download the file from my website and see the...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 URL. Caveat: If you login to the administrator section on a shared computer, ensure you close the browser (and all tabs) once done or this cookie will remain on the computer and will be readable by other users who access the same computer (this is...

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 Browse to Pinterest Developer Tools - Widget Builder Include the javascript file '//assets.pinterest.com/js/pinit.js' once in the page Customize your feed and Copy & Paste the code where you want it to appear // example: replace myPinterestAccount with...

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

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have completed once copying the below scripts). Let's start with the first PHP file which I will call functions.php. Note that you will need to...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 and you have NOT authorized this service account via the G-Suite Administrator settings, then this script will break. Once you have authorized the service account, you can then put the email of the user the service account will be impersonating. Browse...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once the list count increased the number of digits (eg. 1.10) the text would be more indented (relative) to 1.1. I need all list...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once Name the workflow > Create Workflow Give it the code // // ********************************************************** // attach...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 am trying to assign the collection or list to the subform when I need to use "INSERT" method twice and not the equals sign: once to add the row to the collection, and the second time to add the collection to the subform. Syntax for inserting a row into...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 all the records held so far in this linking module which I'm guessing is called Quotes_X_Users (would appear in the popup once you start typing zoho.crm.getRecords. I'll get an array back of 2 records and I'll be looking for the 2 lookup fields...

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

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 view in CRM and filter by "Processed" is "Selected", check after each run of the function that the number has incremented. Once all records are done, return to the Module Layout and delete the "Processed" field. [Optional conditionally] Reactivate any...

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