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

23 February 2014 /SL :: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads (default 8). n must be at least 1 and not greater than 128. This option is incompatible with the /IPG and /EFSRAW options. Redirect output using /LOG option...

• 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 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to country) rules are currently...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 client. I use CNAME as I find it easier and it is a step we need for Zoho on their side. Important: You should now have at least 2 CNAME records against this domain/subdomain. I usually have 3: .joellipman.com (used in verification), .joellipman.com and...

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

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

02 February 2021 apparently you have to treat the field of type "File Upload" as an attachment despite it not being an attachment (or at 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...

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

ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 all workflows relating to the Contacts and Leads module. Lastly, I'm usually asked to update all records and there are at least 10 thousand if not 100 thousand records. The code I use is a for loop within a for loop or in other words 5 pages (as each...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator but have it as a blank form rather than a bidirectional form...

• 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 and prevent the save if (v_CalculatedNumberOfSkills...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 Our problem is that sometimes more than 100 products are modified in a day... We need to be able to do more than 100 or at least resume from a record... We need pagination. How? To resolve this, I'm building on top of my initial GraphQL query which will...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 A really quick article on how to hide these using CSS... at least until Zoho have this as a setting using the GUI. Why? Our use-case is that we have a subform which gets autopopulated with a list of services. The client does not want their operations...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttps://joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems = r_CrmProductLineItems.get("data").get(0).get("Quoted_Items"); for each...

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

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

16 October 2023 layout, let's simply create a new pipeline by clicking the button in the top right. For this demo, we ensure there are at least 2 pipelines: "Hire Pipeline", and "Sales Pipeline". Setup: the Client Script Login to ZohoCRM as a system administrator > Go...

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

Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 about it, and upload to it via the API. Why? The documentation is there but making sense of it, is somewhat difficult, at least for me. How? So when I was trying this, I would get either "URL rule not configured" or an unhelpful blank response. Getting...

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

ZohoCRM: Make either Mobile or Email mandatoryhttps://joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 OTP or 2FA or MFA or OTC is in effect however; so a contact email OR phone number is required. Both aren't required but at least one should be. How? We can do this without code and only using ZohoCRM layout rules. Let's take a contact record for demo...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 When the end customer clicks on either button in their email (at least in a web-based email client such as outlook or Gmail), they should get something like the following: Your staff will, of course, see the estimate status as accepted or declined in...

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

F_ck You. Pay Me.https://joellipman.com/articles/web-development/fck-you-pay-me.html

14 April 2011 title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco, CreativeMornings (creativemornings.com) was Mike Monteiro, Design Director, and...

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

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

13 September 2012 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 in the Use of...

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

List last modified files using FTP Command-linehttps://joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 to temp.txt in your local working folder. Additional Notes the switch "-S" does not work on certain systems (at least not accompanied with the command to output to a local file. Type dir . temp.txt to output the current remote directory list of files to...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *