Search - Joel Lipman .Com

21. ZohoCRM: Process all records of a module: / Zoho /; ... I'm usually asked to update all records and there are at least 10 thousand if not 100 thousand records. The code I use is a for loop within a for loop or in other words 5 pages (as each page is limited ...; Created on 24 August 2021
22. Xero API: Send Multiple Invoices: / Xero /; What? A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more ...; Created on 15 August 2021
23. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
24. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value. // What I have in CRM: // What Creator understands: FAILS With workaround .toString() // ...; Created on 20 April 2020
25. MySQL: Count occurrences of words in a column: / MySQL /; ... ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I ...; Created on 12 March 2020
26. MS Excel - Open CSV with Long Numbers: / Excel /; ... each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers) ...; Created on 23 July 2019
27. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... 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 record editing when compared to API v2. How? Note that this is ...; Created on 17 July 2019
28. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( ...; Created on 03 June 2019
29. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; ...; Created on 06 May 2019
30. GDPR Privacy Policy: / Static Items /; ... sponsored by MYCOMPANY or its subsidiaries. LICENSE AND SITE ACCESS MYCOMPANY grants you a limited license to access and make personal use of this site and not to download (other than page caching) or ...; Created on 14 February 2019
31. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... a G-Suite Administrator (see 2b). Scope is a string of scope urls delimited by a space (in this example only one). ISS is the client email taken from the JSON key downloaded from Google. // Build ...; Created on 02 February 2019
32. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
33. Zoho Deluge - Get English Ordinal: / Zoho /; ... 2018". Why? Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number ...; Created on 08 November 2018
34. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with other profile settings) which you will have to be careful on ensuring this is NOT ...; Created on 31 October 2018
35. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... two requests (albeit in one function) especially with imposed limit requests. I can halve this so let's upgrade! Method #2: Mulitipart single request This is my recommended version. In this function, ...; Created on 29 October 2018
36. Trim values along with the tab: / MySQL /; ... Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to ...; Created on 13 June 2016
37. Protecting your Joomla Administrator Section: / Joomla /; ... and b) limit access to a single IP address. Note that you will need to ensure you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But just in ...; Created on 23 October 2015
38. Import Excel CSV file as JavaScript array: / Excel /; ... the file // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype xhr.setRequestHeader('Content-Type', ...; Created on 05 October 2015
39. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
40. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... FROM `v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.category.%' AND `title` = 'Uncategorised' LIMIT 0,1); INSERT INTO `v34_db`.`v34_assets` ( `parent_id`, `lft`, `rgt`, `level`, `name`, ...; Created on 12 September 2015