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

25 February 2010 I could apply the PRINCE2 (Projects in a controlled environment) methodology to website projects but most people find this overwhelming. It's in business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 } } } } Allowing me to simply tick columns to apply this to (note that some of the images have been censored due to this project containing sensitive data): Script Component Task: Select Type Script Component Task: Transformation: Data Viewers Script...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 to Joomla! for performance purposes. What makes this one different to others, is that it it treats each file like a project. Combining all file versions, descriptions, statistics, documentation and changelog under each project. This means you only...

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

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

15 November 2013 you have been directed to this page, this is a draft article on a standard development project. The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline...

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

Enterprise Project Managementhttps://www.joellipman.com/articles/microsoft/enterprise-project-management.html

• Type: Category
• Language: *

Some milestones for a website projecthttps://www.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 The concept - typically drawings, words, models, code and basic prototypes that describe the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 CLI installation by typing: zet –v This should return the version of the Zoho Extension Toolkit (eg. 0.23.6) Create a project In the terminal, type zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar to when trying to enter a time against a project Task but...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 MySQLDriverCS Type: .NET Framework Class Library Usage: MySQLDriverCS.MySQLConnection Manufacturer: MySQLDriverCS project team Standard Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 JOPTION_OPTIONAL JDISABLED JOPTION_REQUIRED JOPTION_OPTIONAL JDISABLED ./profile5/en-GB.plg_user_profile5.ini ; Joomla! Project ; Copyright (C) 2011 JoelLipman.com. All rights reserved. ; License http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL, see...

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

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

31 October 2014 (note that setting the variable via the command prompt will NOT work!) To get the Test SHA1 code: Creating a Google Maps project in Android Studio (v0.8.6 beta) "creates" a SHA1 along with the project name: something similar to:...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was making a call to the Events endpoint as it would just come back with a blank...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 npm install -g zoho-extension-toolkit (this also updates existing install) sudo zet init select Zoho CRM enter a unique Project Name cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file in...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather than requests. Sure it lists fields that are required in the...

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

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 05/2008) 1 in 700 people choose 'qwerty' as their password (source: Modernlifeisrubbish.co.uk 08/2007) Distributed.net's Project Bovine RC5-64, one of the fastest computers on earth, recently reached a speed of 76.1 billion passwords per second!...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 to work in one browser only: Internet Explorer version 7. The marketing web-gurus were simply using different browsers. The project leader was on IE7, while their designer was on an Apple Mac using Safari, and a third was using Mozilla Firefox. We told...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats,...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging....

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