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 How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count on it. I'm going to use a short batch process but to save time on the different ways of doing this, the example below uses a command prompt to a) create a batch...

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

Search and Replace in a MySQL Databasehttps://joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set...

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

Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value, DateFormat.GeneralDate)...

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

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

23 February 2014 exist in destination. /K Copies attributes. Normal Xcopy will reset read-only attributes. /N Copies using the generated short names. /O Copies file ownership and ACL information. /X Copies file audit settings (implies /O). /Y Suppresses prompting to...

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

Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables Prefix It should be a short alphanumeric value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 to use gold characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however, for some reason the code does not exist the code...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

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

21 August 2014 to this and allow you to specify the related SMG Run SMG from the menu system Enter a CODE (in our demo "CAPCHG") Enter a Short Name (unsure of how this is used) Enter a descriptive "Full Name" as it will automatically display alongside any reference to...

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

Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 Color - Added Module Parameter: CSS3 Rounded Corners - Added Module Parameter: Revolvermaps URL (rc.* or jc.*) - Corrected short form PHP tags (ie. removed these). - Date Uploaded: Fri, 11th Jan 2013 1.3- Upgraded to work with Joomla 2.5.x - Date...

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

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

22 February 2019 page with a logo floating at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit on one...

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

Zoho Deluge - Counting in a Map dataTypehttps://joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with the name "Joels Image Library". I think I closed it and...

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

Zoho Deluge: Convert Hex to RGBhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4);...

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

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

19 March 2011 I tend to write about issues that the rest of the crowd so easily give up on. I am usually available for consultation and short term projects. If you think I can help you and your website then feel free to get in touch using my contact form. Thanks for...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have...

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