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 and type rename.bat (This does the actual renaming of the files). Type the following DELETE rename.bat (removes it from the users computer) Exit the command prompt and we are Done Other Links: DOS - String Manipulation DosTips.com - Forums SS64.com

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 - [1.7.0] Help: details on what the app will store and where - [1.7.0] Help: details on what data is shared with other users - [1.7.0] Help: details on what joellipman.com stores - [1.7.0] All: internet connection status v1.6.x [5 Nov 2014] - [1.6.2]...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 you will need to put either. Or your request is missing a field that is required by your CRM (is set to mandatory for users to enter data). Otherwise: m_Data = Map(); m_Data.put("JSONString",m_RecordData.toJSONList()); // change JSONString to data...

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

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

18 July 2019 this is to right-click and drag to the desktop (or wherever you want to store shortcuts) then run the shortcut: RunWait, "C:\Users\Joel\Documents\_shortcuts\Mail - Shortcut.lnk" Without a shortcut, the command to run is: RunWait,...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 Gui, Margin, %MarginX%, %MarginY% Gui, Add, ListView, w396 h775 gOpenProfile -Hdr +Grid, Profile|Client ProfilePath := "C:\Users\" A_UserName "\AppData\Local\Google\Chrome\User Data\Profile*" Loop, Files, %ProfilePath%, D { FullPathArray :=...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" Under "Users and Control" click on "Publish" On the same row as your report, click on "Get embed Code" (ensure this report is published)...

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

Windows 10: Shortcut Apps to Settingshttps://joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I...

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

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

24 October 2020 (without the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask you to type the following commands; to change...

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

Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://joellipman.com/articles/crm/zoho/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html

20 July 2022 you will get the popup to enable Desktop Notification Click on “Enable” Then click on “Allow” (browser popup prompt) For Mac Users: Sequoia 15.1.1: System Settings > Notifications > Google Chrome > Allow Notifications.

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 ID", '-')))) AS "Sales Person ID" FROM "Customers" c LEFT JOIN "Accounts" a ON a."Account ID" = c."Customer ID" LEFT JOIN "Users" u ON u."User ID" = if_null(c."Account Owner", c."Created By") LEFT JOIN "Sales Persons" sp ON sp."Name" LIKE...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 it if it does. You might want to add to the code to only push valid image file types as files. The report will work for Zoho Users... didn't really test on permissions and sharing the report, I was logged in as the super admin on both ZohoDesk and...

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

Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 eBay allows users to request the deletion of their personal data from eBay's own systems, as well as from the systems of all partners who store or display that data, including third-party developers integrated with eBay APIs through the eBay Developers...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 few pages of Google, all the online tools that did the same had a pricing page. I can understand why you would need to limit users so I don't blame them. But if you can, why not make your own? How? So you will need a webserver of your own running PHP 8....

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

Hide Menu Item from Registered and Special https://joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 that is set to only show when the visitor is not logged in e.g. Code: Joomla extension disable menu link for registered users but not for public More Information: not so great, lot of text: http://help.joomla.org/content/view/476/146/

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

Can't play music after Firmware Update Version 3.0https://joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 use anything else anymore. I can still play some games and select my own music... but they're dumbass PSN games that iPhone users would have got for a pound or what have you...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 that value, you should add a double-quote character to the beginning and end of the location of chrome.exe (for example: "C:\Users\My User Name\AppData\Local\Google\Chrome\Application\chrome.exe" -incognito) Additional Note 201004201256: The shortcut...

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

The greatest invention in IThttps://joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)." Source: Behavioral Issues...

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

UNC Paths in Sharepoint 2007 linkshttps://joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they won't be able to use the link. Why? As soon as someone suggested I setup WebDAV to do...

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