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 SET `modified_user_id` = @v25_admin_id WHERE `modified_user_id` = @v34_admin_id; -- Contact Details: (you should clear this list as you will import them all!) -- DELETE FROM `v34_db`.`v34_contact_details` WHERE `v34_contact_details`.`id` >= 1 -- ALTER...

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

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

08 November 2018 How? I'm exploring various methods, so here's a couple using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date...

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

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

02 February 2019 the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 m_UpdateQuote.put("Grand_Total",round(v_GrandTotal ,2)); // // build up tax options l_TaxOptions = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","VAT"); m_TaxOption1.put("value",v_TotalTax);...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 + v_NewSoLineItemRate,r_NewLineItem.get("line_item_id")); } // // now loop through the invoice line items and rebuild the list l_UpdateLineItems = List(); for each r_OldLineItem in invoice.get("line_items") { m_LineItem = Map(); v_OldInvoiceItemID =...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 Author: Joel Lipman Date Created: 2020-03-17 */ // get all field names for the Invoices module via API l_FieldApiNames = List(); r_Fields = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/settings/fields?module=Invoices" type :GET...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 your first column (because "id" can be found in names like "David") it will work. Assume a Map specified in deluge: l_Data = List(); m_Data = Map(); m_Data.put("First_Name","Joel"); m_Data.put("Last_Name","Lipman"); m_Data.put("id","1");...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 € Euro currency 0128 ¥...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 { r_Row = Quotes.Line_Items(); r_Row.Product = m_LineItem.get("Product"); r_Row.Quantity = m_LineItem.get("Quantity"); r_Row.List_Price = m_LineItem.get("List_Price"); r_Row.Tax = m_LineItem.get("Tax"); r_Row.Discount = m_LineItem.get("Discount");...

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

Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

26 July 2021 or response from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, all...

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

Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

15 August 2021 it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" and the list of invoices to create: {"Invoices":[... list of invoices...]} If sending just the 1: {... invoice JSON...} But if sending...

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

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 r_Tax.get("tax_id")); } info m_Taxes; // // set Tax ID for a sales order line item l_LineItems = List(); r_SoDetails = zoho.crm.getRecordById("Sales_Orders",0123456789012345678); for each r_LineItem in r_SoDetails.get("Product_Details") { m_LineItem =...

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

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

08 October 2021 This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values...

• 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 in red - alternatively give it a unique name in the record). Then map the fields using the dot syntax, add these to a list, and then submit as the subform name, like in the following example (note I have applied a regex to use US/UK numbering format...

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

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

07 December 2021 "); input.Note_BookedTimeSelection = v_ResultInformation; Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of...

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

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 m_Response.put("status_code",v_ResponseCode); // // return return {"crmAPIResponse":m_Response}; Save this and return to the list of functions Hover over the function you just created, click on the 3 dots/ellipsis and select "REST API" Switch on the API...

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

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods listed here, the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of...

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

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 // get the Skills subform var l_SkillsSubform = ZDK.Page.getField('Skillset').getValue(); var l_AlreadyListed = Array(); // loop through subform rows and check if column "Skill" has unique values for (var i = 0; i...

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