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

23 February 2014 :: add the given Attributes to copied files. /A-:[RASHCNET] :: remove the given Attributes from copied files. /CREATE :: CREATE directory tree and zero-length files only. /FAT :: create destination files using 8.3 FAT file names only. /256 :: turn off...

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

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ( StringValue VARCHAR(10) ) AS...

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

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 using the tools I had (Android Studio) which is why I've written this article. Start "Android Studio" Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a relatively old version of the Android OS: Add an...

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

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

23 October 2015 as larger corporations). But just in case you don't have one, let me do this in two stages. Move the /administrator URL Create a folder in the root of your joomla website with a name that is difficult to guess but easy to memorise. Create a file called...

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

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

28 January 2019 BaseDir := "C:\Windows\Temp" ; -------------------------------------------------------------------------------------- ; Create Icons ImageListID := IL_Create(5) Loop 5 IL_Add(ImageListID, "shell32.dll", A_Index) ;...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 the creator super admin/owner (might not be the same as CRM super admin!!!) Go to Setup » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case...

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

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

15 May 2020 Orders, Invoices, Purchase Orders) and integrated your Zoho CRM with your Zoho Books. Why? Because then Zoho Books will create 3 custom modules in your CRM under the tab "Zoho Finance". There is a lag/delay in the synchronization of Zoho Books to Zoho...

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

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

06 November 2020 form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup using the built-in popup of Zoho creator and gives you the freedom to style the notification as any modal would. 1....

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 least not found in the "Attachments" section of the CRM module). The Solution So as a quick overview, this is what I did: Create a ZohoCreator form (I'm calling mine in this example: Download File to hold the file and some other fields Owner Email...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line items. You may have tried code where you add a record first and...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 from additional apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps created before February 2022 won't be deprecated? Because the previous version was limited by our ability to search by product SKU. The...

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

Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 Zoho Deluge. Why? Because at time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? Similar to how to create a...

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

Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is...

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

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically pre-selected based on the user. How? So there's a bit of a...

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want a solution which sits on an external website and which talks...

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

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

14 February 2019 the permission or license granted by JoelLipman.com. You are granted a limited, revocable, and nonexclusive right to create a hyperlink to the home page of JoelLipman.com so long as the link does not portray JoelLipman.com, its associates, or their...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 **In this example I'm using Joomla 1.5.10 and the 'menu' module position.** 1. Create two menus, mine are named 'pubmenu' and 'regmenu'. (Assuming you already have a menu - easiest thing to do is make the new menu in menu manager for reg users. Next, go...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 32645IDC_SIZENS, 32646IDC_SIZEALL, 32648IDC_NO, 32649IDC_HAND, 32650IDC_APPSTARTING, 32651IDC_HELP If Cursor = ; empty, so create blank cursor { VarSetCapacity( AndMask, 32*4, 0xFF ), VarSetCapacity( XorMask, 32*4, 0 ) BlankCursor = 1 ; flag for later }...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 > standalone > ie6eolas_nt.zip Download the ZIP file Scan for threats Decompress/Extract to a folder (by default it will create one separate to the default C:\Program Files\Internet Explorer). Scan for threats Run "C:\Program Files\Internet...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 (and sync with 3rd party avatar). Not riveting stuff but something that all my clients want. Fortunately for me, I just created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to...

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