Making a CD copy with only one drivehttps://www.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 ALL > EDIT > COPY PASTE to a temporary folder Select all the files, right-click on them and select SEND TO > DIRECTCD Roxio Easy CD Creator instructions: Insert original CD in the drive Open Easy CD Creator From the dialog box, select CD COPIER Read the...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 Source: http://forum.joomla.org/viewtopic.php?f=431&t=401086&p=1693742#p1693742 It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without...

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

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 and phpBB3 will pick this up when you install it via the Administration Control Panel (ACP)... But for us, it wasn't that easy. Make a backup of your /phpBB3/styles folder. Make a copy of your /phpBB3/styles/prosilver folder You need to copy any files...

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

How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 Everyone loves chocolate chip cookies, and with VideoJug's special recipe, it's easy to make the perfect chocolate chip cookie every time. You Will Need: 150 g sugar 160 g brown sugar, , packed 220 g butter 2 eggs, , large 2 tsp vanilla extract 280 g...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets stored in... Resources...the one with...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to pull...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep! This is what I've...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a challenge. I have tried so many examples, testing different mootools libraries to...

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

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 to: Joomla 2.5.8 Yootheme Template 2012 What? For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates how to make this an option that your client can switch off/on using...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing with any empty rows. The best way I've seen that has worked in nearly all cases, is to use the...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 initial draft of the agreement. Feel free to query, change and suggest other actions or route to take. My pricing structure: Easy, my base rate is £20/hour. I use my own timesheet system, so if you have a 5 minute job, this will only be added to...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 "Security through Obscurity" is always ultimately fallible. This password checker can not guarantee the passwords will be easy to memorize or to type quickly. Companies using certain password systems can even send the login credentials to the remote...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only...

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

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

23 October 2015 Move the /administrator URL Create a folder in the root of your joomla website with a name that is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 reading any further and tell your boss it was always in hand. Other things I tried but to no avail The solution above was as easy as that. Here are a number of other things I tried first: mysql_set_charset(): No iconv(): No htmlentities(): No...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 and get the remainder from dividing it by 26 (modulus)... This is NOT to be used for Booking Retrieval Codes as it is easy to determine what code if you have the date/time of the booking as well as the customer's surname (method #1 would not be guessed...

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

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 or Setup) Under "Extensions", click on "Connections" Click on "Add Connection" Click on "Zoho Oauth" Give the connection an easy name (will be lowercased) but descriptive. For this test I will call it "myconnector". Ensure that as a minimum, the scope...

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

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 the plus icon to add new client. Fill in the new form to Create New Client: Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage URL: put our corporate...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 the parameter: Additional Note(s): I have found that adapting Widgets created for Zoho Creator to work in Zoho CRM is pretty easy to do. The only differences are the step where you select the type of project in the CLI, in particular the widget JS...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of...

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