Regular Expression Basic Usage Exampleshttp://mail.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 the following string: abcdefghi Note that the character class must occur within a character list, so the character class is always nested within the brackets for the character list in the regular expression. POSIX Collating Sequence The POSIX collating...

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

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

15 November 2013 I often get told I may win the lottery or get run over by a bus, so I am used to needing a backup plan. My aim is always to hand over the project so that I am no longer required. Isn't that when we know we did our job best? When nobody knows you did...

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

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

03 January 2014 capability so I have restored it on my personal website. Security through Obscurity "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...

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

XML Schema Referencehttp://mail.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 the same target namespace to a document key Specifies an attribute or element value as a key (unique, non-nullable, and always present) within the containing element in an instance document keyref Specifies that an attribute or element value correspond...

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 the same XET code and that the "Active" checkbox is ticked. Store/save your EOR Setting up the Table Update Process (TUP) I always think of this as the trigger but it's required for your TOTs. Run TUP from the menu system Enter the relevant dictionary...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://mail.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 = simplexml_load_string( utf8_encode( $file_content ) ); // works! DONE! Stop 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...

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

CSS Printing - Page Break Inside with Headers and Footershttp://mail.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 me... I guess I'm special, this is what I had to do: @page { size: A4; margin: 0cm 0cm 0cm 0cm; } .page { page-break-after: always; width:21cm; height:29.7cm; margin:0mm 0mm 0mm 0mm; padding:3cm 1cm 2cm 1cm; display: table; }

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Convert Past Date to Time Ago in PHPhttp://mail.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 unit value to its label for($i=0;$i0 ? $a_UnitValues[$i].' '.$a_UnitLabels[$i] : ''; // grammar for plural/singular (should always be a positive number) $v_Str .= $a_UnitValues[$i]>1 ? 's' : ''; // only add to array if not empty/zero if($v_Str!='')...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 monitor setup (ie. more than 1 monitor), then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection: "joelconnector" ]; Additional I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 the page won't help either as you need to redirect the user to the specified report after submitting the form. How? Well as always, I'm going to cheat. My solution here was to simply repurpose a decision box field in Creator; then re-style it to look...

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

Zoho CRM: searchRecords with sorted resultshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttp://mail.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new computer... It's...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 are in data rows not individual columns. How? There may be ways of doing this using the GUI and a "Pivot View" report but I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to...

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

Added a Launcher and Unduplicaterhttp://mail.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

19 May 2010 Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...

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

Welcome to my website!http://mail.joellipman.com/articles/web-development/welcome-to-my-website.html

19 March 2011 you and your website then feel free to get in touch using my contact form. Thanks for visiting! I hope this website is, as always, of some use to you!

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

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the...

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

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following...

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

Convert Decimal (Person Days) to Time in Excelhttp://mail.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format...

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