Migrate Joomla! 1.5.x to 2.5.x+http://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `note`, `description`, `published`, `access`, `params`, `metadata`, `created_user_id`, `created_time`, `language`) SELECT @new_jos_banners_parent_id AS parent_id,...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 Lipman) - Validated Webhook - Send email to client More Info: https://developer.ebay.com/marketplace-account-deletion metadata.topic topic of the notification metadata.schemaVersion schema version metadata.deprecated boolean to indicate deprecation...

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

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

12 September 2015 `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) SELECT a.`id`, ( SELECT x.`id` FROM `v34_db`.`v34_assets` x WHERE x.`name` LIKE...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 close first request handler curl_close($ch1); // now let's get the ID of the file we just created // and submit the file metadata $this_response_arr = json_decode($response, true); if(isset($this_response_arr['id'])){ $this_file_id =...

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

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 user " + _ApprovalUser.get("id"); info r_AssociateMultiUserLookup; Another method to check for API names is to query the metadata in the linking module: // // used for checking api names and the linking module (not visible via the interface) v_Endpoint...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync http://mail.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 at 1am in the morning every day. This will be added to the client's Zoho People instance which will check the datasource metadata via the Analytics API. Add a custom scheduler in Zoho People Login to ZohoPeople as a system administrator Click on the cog...

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

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

23 January 2020 for each r_Org in l_OrgDetails { info r_Org.get("company_name") + " :: " + 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 =...

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

Zoho Books: Get Invoice Payment Terms via APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 of an invoice but lots of my clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID =...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 "addIfNotExist" attribute Additional / Optional stuff to do but please don't waste your time. Out of sheer boredom: fn_GetMetaData_FormsFields v_NewLine = hexToText("0A"); l_CsvRows = List(); v_FormsEndpoint = "https://people.zoho.com/api/forms";...

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

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 Survey to trigger a webhook when submitted. Pre-Amble Just need a few fields on the CRM contact record to store the survey metadata Login to ZohoCRM with permissions to edit modules Go to Setup > Modules and Fields > Contacts > Layout > Standard Add the...

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