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

23 February 2014 A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only...

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

Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 give you an overview of the DOT, EOT, TOT, TIN, DIN run. Testing: No records are being processed despite relevant ones existing and all monitors run I would get this issue if I cloned an existing process (released an existing one, made changes, stored...

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

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

27 July 2021 in Creator; then re-style it to look like a button; then add a workflow on click of this field. Set the form to reload the existing record when it is submitted (either on "Successful form submission", or on properties "On Successful Submission" >...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 then enter the rates manually below: Rate Year 1.0, Rate Year 1.5,..."); } // update the fields (that were blank on the existing record - but now pulled from Opp or from set values) ZDK.Page.getForm().setValues({ 'Rate_Year_1_0': v_DealRate0 });...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 in a new tab. Drag a tab out of the tab strip. Opens the tab in a new window. Drag a tab out of the tab strip and into an existing window. Opens the tab in the existing window. Press Esc while dragging a tab. Returns the tab to its orginal position....

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 Please ask someone who does. -- IMPORTANT NOTES (to be included in SQL script): -- -- The script below is to migrate your existing Joomla! 1.5 database -- -- to an instance of Joomla! version 1.6.x or greater. -- -- You should have both sites up and...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 same time on the same monitor). Download Details: JoelLipman.Com is my repository for scripts, programs and extensions to existing web-development systems. I use it to store notes that other websites either do not have or have stopped providing, or just...

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

Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 is really that straightforward. Feel free to check for any dodgy code but I've simply added the clear button to the existing article modal file (Joomla 1.6.x to 2.5.x). Don't overwrite any existing core files with this one, it's completely unnecessary...

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

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

09 March 2015 changed in the back-end of the site (Joomla admin panel). The functionality and component are simply an extension to the existing Joomla Search. There are no changes to the existing component. Download You can download this module I made from my...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 date is not null if(v_BalanceDue.toDecimal() == 0.0 && v_PaymentDate != null) { m_UpdateInvoice = Map(); // // copy existing custom fields (not required but just in case) l_CustomFields = invoice.get("custom_fields"); l_NewCustomFields = List(); for...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 v_CountExists = v_CountExists + 1; break; } } } if(v_CountExists == 0) { // // prevent duplicates by updating record with existing name if exists v_Name = v_CandidateZohoID + "" + r_Data.get("id"); // // retrieve client's own candidate ref from...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 to a form called "Documents" linked by a bi-directional ticket lookup. The document form is a subform derived from an existing form (called "Document"). Mainly, because I don't know how to refer to the public URL of a subform row other than making the...

• 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 it hides itself and shows the button. Code for Onload of form: // // default to black on blank form, if loading an existing record, the value stored will be used. v_DefaultColor = if(isBlank(input.Hexadecimal), "#000000", input.Hexadecimal); // // a...

• 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 and validate these notifications. Why? As quoted from the page: https://developer.ebay.com/marketplace-account-deletion "Existing Developers: The August 31, 2021 deadline for existing developers to subscribe to or opt out of eBay marketplace account...

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

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 and submit to Client Apply chosen template Design and Layout Implementation Corporate Logo Create initial logo and replace existing template logo with this one Discuss suitability and variances Convert, format, or create vector-based version of the logo...

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 ; when finished COM_Release( pwb ) ; Always release COM objects COM_Term() ; Always Uninitialize COM How to access an existing IE object? - Sean's GetWebBrowser() function is great for this, and can be found here. Here is a function that accesses an IE...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 I wanted that didn't exist in the other systems. I wanted minimal code and leave the comments/videos/pdf to be handled by existing Joomla! CMS features. I also needed a component which isolated the download functions external to Joomla! for performance...

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

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 t0 WHERE [pretendField]='elephantastic' -- insert some empty rows to blank out later as separators (select from your existing table, needs to contain data to order by so that it's the last row of each day -- if grouping by day -- basically insert a row...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a...

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