Print Directory Contents to a Filehttp://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have a...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

03 April 2009 or use pieces of it in new free programs, and that you know you can do these things. To protect your rights, we need to prevent others from denying you these rights or asking you to surrender the rights. Therefore, you have certain responsibilities if...

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

Export/Import Database using MySQL Workbenchhttp://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Restore MSSQL Error: Database is in usehttp://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and...

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

SSIS Skip Rows in Excel Source filehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...

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

Things to Check if Joomla Password Reminder email not being senthttp://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on...

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

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

03 January 2014 can not guarantee the passwords will be easy to memorize or to type quickly. Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my...

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

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

26 February 2014 in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the...

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

Joes Search Module (JSM)http://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 searches that this does not exist as yet. Comments/Questions Please use the comment box below to add any questions (you can even post anonymously) or suggestions you might have. Thank you for your time! « DOWNLOAD ݏ

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

Protecting your Joomla Administrator Sectionhttp://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 it down to a specific IP address. The below does not involve installing any third-party extensions and will remain in place even if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more...

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

AutoHotkey: Check Windows Folder Sizeshttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the...

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

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

18 July 2019 "shell:AppsFolder\microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.mail" Google Chrome Profiles Even more final than lastly: Suppose you didn't opt to create a desktop shortcut when creating a specific user profile in Google...

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

CSS Center an iFrame Horizontally and Verticallyhttp://www.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 and modify the height of the iframe then click on 'Run'. The iframe is always centered even if the top is off screen.

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 holidays) or to say the last Tuesday of the month. How? Quite easily. For the first Monday of the month, it is likely that even if today was the first day of the month and coincidentally a Monday, then we would want to specify the field date to be the...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttp://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 but a page). Why? This is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in functionality of Zoho...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 from any of your code. How? As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much...

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

Zoho Creator: info/alert/modal/popup notification for any userhttp://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 a load of a form, on a change of a field or on the validate process. And because info can only be displayed to an admin and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a...

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

Zoho Creator: Assign an integration field value with an integration valuehttp://www.joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

27 July 2021 value to the record immediately. Why? If you try to update an integration field via deluge with another integration field or even the same integration field, it will return an error Unable to update the value to r_RecordDetails.Account. Line:(442) How?...

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