Assuming update is required, the following 117 results were found.
-
words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new system admin details with old (name, registration date, etc). Copy over Categories: It is recommended to do this via the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Admin interface, then the following code won't be able to check and restore them. The Code Snippets: The Shopify Order Update notification First create a CRM function called Shopify - Webhook - Order Notification. It's a standalone function but you'll...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
each record and do what it has to do. The workaround here is that we order this by modified time. When the checkbox gets updated, this modifies the record and puts it at the bottom of the list. In a nutshell: [Optional]: Deactivate any workflows that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
no Hello World Hello World 2 Article 2 yes no no Hello World Hello World 3 Article 3 yes no no Hello World Hello World Now update them SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; UPDATE `MYTABLE_content` SET `introtext` = REPLACE(`introtext`,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
interface again only to find it may crash again. In the background and from a developers understanding: field1 is told to update field2 when field1 is changed. When field2 is changed, it is told to update field1. This causes a recursive or endless loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently introduced...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined with a PHP script this could be a few lines for...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to the Internet and for some reason it doesn't display the right date/time. The Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
of the CMS. This error could have been caused by many things but in the case of one of my clients, the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Shopify Webhook Payloads Drag some fields onto the form, this 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
And then I started updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales order item id value. For our client's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM quote to a ZohoBooks estimate and a client...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? My use-case scenario here is that we have a Zoho Creator app...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *