ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 info v_Endpoint; // // upload the file m_Params = Map(); m_Params.put("file", f_TestFile); // // this will work r_Upload = invokeurl [ url :v_Endpoint type :POST parameters: m_Params content-type: "multipart/form-data" connection:"zcreator" ]; // //...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 include the namespace) var v_FuncName = "fn_Accounts_GetCreditSafe"; // Prepare the parameters for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) }; ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then(...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom =...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 SET `checked_out`=NULL, `checked_out_time`=NULL; Viewing Users in the Administrator panel: UPDATE `#_users` SET `params`='{}' WHERE `params`='{"",""}'; Set User Group Mappings from old DB to new DB: Other than new admin (here new admin ID is 111,...

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

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 I don't like it and nor do u if you've been trawling the web for this solution. archived => is or not approved => again params => what params? I couldn't find any A little more to change A-Z or Z-A change ASC (ascending) to DESC (descending) in the last...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source,...

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

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

10 February 2022 // // get other products with the same name (set in order of oldest first and keep only first one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by id limit " +...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 type :GET ]; // // set the data type r_DownloadedPhoto.setParamName("image"); // // build up request to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url = "https://books.zoho.eu/v3/items/" + v_InventoryId +...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 m_QuoteRecord.put("Name.last_name",v_SellerName_Lastname); m_QuoteRecord.put("Email",v_SellerEmail); // // other params m_Blank = Map(); // // send the request r_Create = zoho.creator.createRecord(zoho.adminuser, zoho.appname, "Quote", m_QuoteRecord,...

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

Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by...

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

Disable User Registration in Joomla 1.5 - Configuration Filehttps://joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for AllowUserRegistration allowUserRegistration=0 to disable it. allowUserRegistration=1 to enable it. Not Working? Are you sure...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 Levels (does not exist in J15) - Date Uploaded: Sun, 3rd Jul 2011 1.3.0- Restructured to MVC model for Joomla! CMS. - All params prefixed with JQW to avoid conflicts. - Parameter: Use preview images (name format is LinkID.fileExtension where LinkID is...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• 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 change these if you need a different scope or if the APIs get upgraded. $api['gapis']['oauth']['grant_type'] = 'urn:ietf:params:oauth:grant-type:jwt-bearer'; $api['gapis']['oauth']['token'] = 'https://www.googleapis.com/oauth2/v4/token';...

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

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 : -1, Error due to - 'Internal Exception'': Problem with your parameter format, ensure these are passed as a string (eg m_Params.toString()). {"code":33003,"message":"Receipt not attached."}: So close, are you sending attachment as a parameter with a...

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