Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this. Original Proper-Cased JOHN SMITH-JONES John Smith-Jones HEAD OF IT SERVICES Head of IT Services...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 following (the string to replace here is " (Copy)" without the quotes) - this is a READ-ONLY process if you leave the last line commented/remarked @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET...

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

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 totalDigits Specifies the maximum number of digits allowed. Must be greater than zero whiteSpace Specifies how white space (line feeds, tabs, spaces, and carriage returns) is handled Source(s): w3schools.com

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

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

07 September 2015 with Joomla v2.5.28 - Date Uploaded: Thu, 12th Mar 2015 Download 3.2.3 Wolfgang- Fixed Bug: Forced spaces between links for Line Breaks - Date Uploaded: Mon, 4th Aug 2014 3.2.2 MargeE- Fixed Bug: Correction if only one exclusion category selected - Date...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 and table prefix of database you are WRITING to (eg. `myuser_joellipmancom_mysitedb`.`ejf1r_content`) How? Here's a brief outline of the whole process: Backups Install Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less...

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

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 target file to JS variable var my_csv_file_contents = xhr.responseText; // split contents into array of rows // store each line of the CSV file into a JS array var my_csv_rows_array = my_csv_file_contents.split("\n"); // declare a blank array to store...

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

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

20 March 2019 web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT SELECT, LOCK TABLES, RELOAD, PROCESS, TRIGGER, SUPER, REPLICATION CLIENT, SHOW VIEW ON *.* TO...

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

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 = v_MyString.replaceAll(("([&'\"])"),"\\$1",false); // yields Joe\'s \"Amazing\" Skill \& \ Grunt Replace new lines in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working)...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 + " :: " + r_Org.get("id"); } } } Get Module MetaData m_Module = Map(); m_Module.put("module","Leads"); // omit this line to get metadata for all modules r_Module = zoho.crm.invokeConnector("crm.modulemetadata", m_Module);...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another...

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

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

24 October 2020 ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 because on application, the record doesn't properly exist in the system yet and the delay causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 in /home/thirdpartyapiorg/public_html/thirdpartyapi_controlpanel/user/addons/thirdpartyapi_webservice/Service/Format.php on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest =...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 name of the linking module: Go to setup > Developer Space > functions. Create a standalone function called "Test". Type in line 1: r_Record = zoho.crm.getRecords then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 is what I did: Event Type [Drop Down: with options "Order Update", "Inventory Update", "Product Update"] JSON Payload [Multi Line] 2. Joel's first Cheat: If your client has ZohoCRM, let's use a CRM REST Function Granted this only works if you have a CRM...

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

Zoho Creator: Assign an integration field value with an integration valuehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

27 July 2021 field or even the same integration field, it will return an error Unable to update the value to r_RecordDetails.Account. Line:(442) How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you...

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

ZohoCRM: Deluge: Map a custom field from user profilehttps://www.joellipman.com/articles/crm/zoho/zohocrm-deluge-map-a-custom-field-from-user-profile.html

01 September 2021 and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the Opportunity/Deal/Potential record details, then get the Owner frrom the CRM...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 terms and conditions", "customer_id": "234567890123456789", "payment_terms": 30, "salesperson_id": "345678901234567890", "line_items": [ { "item_id": "456789012345678901", "discount": 0, "quantity": 1, "description": "A test product description" } ],...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 on it will generate a PDF of the merged template and attach it to the CRM contact record under "Attachments". As a quick outline of the below: Create a connection to Workdrive/Writer Get the Merged Template ID (hexadecimal) Create the all-in-one button...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 ""; v_Css = v_Css + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + ".zc-Tabs-group .choice-table-row{display:inline-block !important;padding:0;}"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then I need to get rid of the circles...

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