Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 marketing brochure. For JoelLipman.Com to discuss: Target Audience implications (Internally Centered? / Customer Focused?) Explain Domain Registration process (for client to do so they retain overall control of the company) Who will be working on this...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I will skip ahead to the next step in the penalty list. Muting - This is where you...

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

How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 it, or if you wanted to change the default text that is displayed "Thank you for your e-mail" to something else I will explain how in this guide. I cannot be 100% sure this guide will work for people who have certain extensions installed or who have SEO...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your SQL Server Reporting Service (SSRS) report. I am guessing that Series1 is the...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 into admin panel. 2012-03-25: Changed instructions regarding changing table prefixes. 2012-03-21: Added "Update 2012" to explain compatibility with Joomla version 2.5.6. 2011-01-30: First draft of this script Still To Do Add intro script to...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code The second line of my code The third line...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 fibre but notice some jello instances so will spend time balancing the props: I posted this for a friend on facebook to explain what a gimbal was for: {youtube}B_24vcZ7nTA{/youtube} Oh and a really helpful video if you don't have GPS and IOC (and just...

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

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 This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended: Google...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the...

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

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 quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...

• 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 I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 How? This was achieved using some CSS and then some Deluge for the functionality. Let's dig into the CSS and then I'll explain how we made this functional. To prepare for this, I created the following Creator form: The fields: Calendar Day Select (link...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 info c_ExistingDocument.Document_File; I have all of the above in the same function. I've split it out to explain parts but otherwise it is intended to be all in the same function as there are references to some variables in earlier snippets of code on...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add an alias to the field: -- Note the alias for the field SELECT COUNT( DISTINCT...

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