Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 General Public License for most of our software; it applies also to any other work released this way by its authors. You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public...

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

Project Plan for Freelance Websitehttps://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: *

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

30 January 2011 new admin ID in J30 -- 3) Recover odduser's new ID in J30 and re-associate to content -- 4) Recover groups used in J15 and apply correct groups to users in J30 -- Affects: #__users, #__user_usergroup_map --...

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

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

04 October 2013 "Director of IT". "O'REILLY" should become "O'Reilly" and not "O'reilly". "MCDONALDS" should become "McDonalds" but do not apply for "MacDonalds" because of names like "MACK" and "MACHURA". " and ", "la", "le", " van ", " de ", " of " and similar should...

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

SITS: Export field code and namehttps://joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the exchange fields (or container) to apply this to Select the "Export Format" tab and click on the chevrons ("»") next to the field to apply this to Enter the...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // apply changes to any of the line items l_NewLineItems = List(); if(!isNull(m_RecordData.get("id"))) { for each m_LineItem in...

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

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

14 February 2019 county laws do not allow limitations on implied warranties or the exclusion or limitation of certain damages. If these laws apply to you, some or all of the above disclaimers, exclusions, or limitations may not apply to you, and you might have...

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

SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF(...

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

Batch Process to rename multiple files using Windows DOShttps://joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 rename the files c) delete the batch file. Open a command prompt: Method #1 Open windows explorer to the folder you want to apply this to Hold down the shift key and right-click on the folder Select "open command window here" Open a command prompt:...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 Save and Exit Press Control + O (write the file) Press Enter (confirm filename) Press Control + X (exit nano) Apply It source ~/.zshrc Test It whisper --help Run the whisper on the original MP3: whisper output_audio.mp3 --model small Error(s): PATH...

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

SSRS Border Problemhttps://joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click on...

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

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

31 May 2009 below it. Cheating the censor system is against the rules. If you break one of these rules, the following penalties will apply (first time, second time, third time...) with the exception of breaking the rule "No Hacking" which immediately results in a...

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

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

06 September 2009 file in the Joomla installation. If you update or reinstall Joomla you will possibly lose this modification and have to apply it again. The file that you will be editing is /components/com_contact/controller.php You can open it in Dreamweaver or other...

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

Windows 7 Aero Featureshttps://joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 the full range of Aero features. Select the custom option and then select all the effects from the list below it. Hit apply and ok and you should have all the Aero effects enabled. Now what are these Aero effects? Aero Peek: Aero Peek What this is it...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 hidden, the next textbox moves to fill up the space... There are some suggestions on the net but they didn't work or didn't apply for me. I had to insert a rectangle that separates the textboxes (so fills up the empty space with an object)... The...

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

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

07 July 2011 --- Display/Access based on User level --- Joomla! CMS check-in/check-out supported. --- Download count (read-only? - would apply to just this version - total showing on general page) --- Rating (read-only? - modified by front-end votes) ---...

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

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 MDX Expression This is to be applied to the "Fill" expression of the textbox with the field name changed for each cell you apply this to; note that in the following example, "Data_Retrieval" is the field to compare (of all "Data_Retrieval" values) and...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 procedure. I have a previous article describing a basic stored procedure in Oracle, this article aims to outline how to apply this to an SSRS 2008 R2 report. How? If you've googled this topic as much as I have, you'll note that everyone seems to be...

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