T-SQL: Parse an XML valuehttp://mail.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER...

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

Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going to use a PHP script with the cURL...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Foreign Characters create symbols in PHP and MySQLhttp://mail.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 instead of the foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8');...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Get English Ordinalhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar = zoho.currentdate.toString("d").right(1).toLong(); v_EnglishOrdinal = if(v_ThisDayDateLastChar == 1...

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

Zoho Deluge: Loop through 30 Minute Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 the starting hour is found and stop adding when the closing hour is found. The picklist field is called "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and...

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

Excel - Check a column for values found in another columnhttp://mail.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow...

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

CSS Add Text to Breadcrumb Link with a Transitionhttp://mail.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 Products / Lanterns // if I hover the mouse over the "Lanterns" link: » Home / Products / More Lanterns How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge - Get distance between two coordinateshttp://mail.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.. the following is free albeit as-the-crow flies. This makes use of an undocumented function in...

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

Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 v2. How? Note that this is using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token, once we have a Refresh token we will...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 HH:mm:ss", "Europe/London"); Additional The reverse (date string to unix seconds) can be done using either of the following: v_MyDate = "2020-04-01 12:34:56"; v_UnixSeconds = v_MyDate.toTime().toLong(); info v_UnixSeconds; // or v_UnixSeconds =...

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

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

17 November 2020 or creator.cs.zohohost.eu depending on the value obtained step 1c above. Add another CNAME record with the following: name as .myparentdomain.com ("code" is 6-character code obtained in step 1c above) If allowed set the TTL (time to live) to 300 Set the...

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

Zoho Deluge: Sort a Map by a specific fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I...

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

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

02 February 2021 As you may already know, when you queried CRM for that field, you received a JSON response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url":...

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

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

28 April 2021 zoho.crm.getRecords then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT - USE ARROW KEYS OR MOUSE): As you can see from the screenshot above, there are modules concatenated with one...

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

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

27 July 2021 name "Account"; Then I have a workflow on user input of the field to save this directly to the record; You would think the following would work: r_Details = myForm[ID == 1234567890123456789]; r_Details.Account = input.Account; But it will return the...

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

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

27 July 2021 with the field link name as "Save_and_Close" (the field link name is important for the next step: CSS styling): Apply the following styling (this will depend on the theme you are using): .zc-Save_and_Close-group .decision-box-field label{ display:none...

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

Zoho CRM: Get Unique Values of a Text Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001" }, {...

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

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

21 October 2021 the scopes: WorkDrive.files.ALL, WorkDrive.workspace.ALL Click on Create and Connect > Accept Get the Template ID The following snippet is a separate function to run (standalone) and will return to you the templates and the field references: r_Templates...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every Friday at 08:00 in the morning and will create a task if time...

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