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

23 February 2014 c:\Sourcepath c:\Destpath /E /XC /XN /XO -- /E makes Robocopy recursively copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the copy in...

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

ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 m_ActiveList.put("ListingType","FixedPriceItem"); m_ActiveList.put("Sort","ItemID"); // // exclude other lists m_Exclude = Map(); m_Exclude.put("Include", false); m_Params.put("DeletedFromSoldList",m_Exclude);...

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

Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 m_ActiveList.put("Sort","ItemID"); m_Params.put("ActiveList",m_ActiveList); // // exclude sold items m_SoldList = Map(); m_SoldList.put("Include","false"); m_Params.put("SoldList",m_SoldList); // // exclude unsold items (ended before purchase)...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Folder -> Global Assembly Cache folder. It will now show up as an additional folder, and you can add project output to it. Exclude all dependencies by highlighting all of the files under the Detected Dependencies folder and selecting "Exclude". If you'd...

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

Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Display Debug Mode (was "display SQL query") - Enhancement: Debug Mode: Advanced Troubleshoot - Enhancement: Integration: Exclude Joomla Articles. - Date Uploaded: Sun, 12th May 2013 2.1- Enhancement: Debug Mode: Check List - Enhancement: Code...

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

Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

30 May 2009 particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law. Your use of any information or...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName AND _SMDBA_.Incident.[Assigned To Full Name] '' Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your...

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

List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of...

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

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

09 May 2013 search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes): “Hello,\n\nA request has been made to reset your %s account password. To reset your password, you...

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

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 do not want to match. Characters that are not in the non-matching character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular expression: [^abc] This expression...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 go to the start of that month, subtract 1 day. .toEndOfMonth() used to work but appears to be deprecated. Invoice_Ref_ID is excluded from being copied as it was an autonumber in our example. zohoapis.eu is used in the above example for a client on the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 l_CustomFields = invoice.get("custom_fields"); l_NewCustomFields = List(); for each m_CustomField in l_CustomFields { // exclude existing custom field payment mode and date l_DontCopyFields = {"cf_payment_method","cf_payment_date","cf_last_4_digits"};...

• 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 rows (not been deleted) var l_existingSubformRows = ZDK.Page.getField('Deployment_Rate_Log').getValue(); // loop through to exclude any rows we don't want based on criteria l_NewSubformRows = new Array(); for (i = 0; i...

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

Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where...

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