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

27 March 2014 AS XML).value('(/STAFF/GENDER="MALE")[1]','VARCHAR(10)')='TRUE' AS Gender -- Returns records where GENDER = "Male" More Examples (Note that Event_XML is of datatype XML in the following examples): -- exist() returns 1 or 0 if node exists or not...

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

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

12 September 2015 -- using the the Joomla admin interface Web-GUI to add them. Ensure the -- aliases are the same in both systems. This is a more stable option. -- ********************************************************************* --...

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

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 header("Content-Type:text/xml"); // print result to page echo $output; } Advanced Example Here's a complete PHP script of a more complex example of 1) getting the agencies belonging to a company then 2) getting the properties for each agency: Other...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 the email of the user the service account will be impersonating. Browse to https://admin.google.com Go to Security > Show More > Advanced Settings > Manage API Client Access Enter the Client ID in the field Client Name (eg. 1000389324798977991) Enter...

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

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

18 May 2019 over the "Home" link: » Return to Home / Products / Lanterns // if I hover the mouse over the "Products" link: » Home / More Products / Lanterns // if I hover the mouse over the "Lanterns" link: » Home / Products / More Lanterns How? Given the following...

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

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

17 July 2019 access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to functionality and...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 ... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a function I find myself using more and more called equalsIgnoreCase() which could be used:... l_ProductDetails =...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 documentation leaves certain bits out. Just getting the syntax right and using the . setParamName is key. Let's make it even more interesting: I'm going to use a subform with the file upload field type so our record can have more than 1 file attached to...

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

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

10 December 2020 doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps,...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 not bother with Daylight Savings Time. The field is a text line field called Customers_Requested_Time and I have added a few more date time fields called GMT_Date_Time_Start, GMT_Date_Time_End, System_Date_Time_Start, System_Date_Time_End,...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 .choice-table-cell span label:nth-child(3){width:75px;} Then I format the value within the span to make the date more prominent: div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 go to Setup > Connections > Add Connection Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it,...

• 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 Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. 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...

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

ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment endings: eg. $100.00 == payment approved 00...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 reference and generate all the respective records in Zoho Inventory. We're using a ZohoCRM webhook, because CRM webhooks run more reliably then the ones we have found in ZohoBooks and other Zoho Apps. Prerequisites: Setup a connection called...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 Creator record ID of the order Outputs: - Date Created: 2023-03-06 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: Error 7008: There are no contact persons associated with this Invoice. - Encountered when trying to use the send an...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 it on my website. This was previously titled something along the lines of truncating to 2 decimals but finance is so much more complicated. Why? Playing around with VAT / Tax, inclusive /exclusive, but in this case it is the rate that gets rounded. The...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 field) which when a quote gets converted to an invoice, will map over the quote ID to the field "Converted From ID". Furthermore, fn_quotes_getquoteditems is a custom function (referred to in the code snippet below) in CRM that uses invokeURL to get the...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 from my article on how to download videos from a session on TrainerCentralSite.com. How? OpenAI's ChatGPT doesn't like more than a 500Mb file attachment; and no more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I...

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

$_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

19 October 2009 solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details:...

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