Search - Joel Lipman .Com

1. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... since go live and simply specified "All Leads". I'm calling my function fn_Leads_FollowUpNonConverted with the parameter being the Lead Record ID: /* ******************************************************************************* Function: ...; Created on 14 May 2024
2. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... the following instructions to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this ...; Created on 04 May 2023
3. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... create a list of pages (specifies the number of pages to try) l_Pages = ; for each v_Page in l_Pages { if(b_HasNextPage) { // // query using GraphQL v_UpdatedSince = zoho.currentdate.subDay(1).toString("yyyy-MM-dd'T'00:00:00+0000"); if(v_Page ...; Created on 20 February 2023
4. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
5. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
6. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice ...; Created on 12 October 2021
7. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums ...; Created on 03 February 2021
8. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... Some XML bits: v_MyRegEx = ""; v_MyString = ""; v_FormattedString = v_MyString.replaceAll(v_MyRegEx,"$1",false); // yields my_real_textual_data Additional Since writing this article ...; Created on 31 May 2019
9. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... until it is about to expire. Firstly, we need to check how many minutes are remaining since the access token file was last modified: // check minutes remaining $api['jwt']['token']['minutes']=0; if(file_exists($api['jwt']['token']['file'])){ ...; Created on 02 February 2019
10. Joes Google Map for Joomla (JGM): / Product Documentation /; ... got paid, and I've used it again and again since. I learnt how to do this because someone else taught me for free. Enjoy! Installation Go to your Control Panel > Extensions > Extension Manager ...; Created on 13 April 2015
11. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... /MAXLAD:n :: MAXimum Last Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n < 1900 then n = n days, ...; Created on 23 February 2014
12. MS Excel: Convert a text to a number: / Excel /; ... to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos ...; Created on 15 November 2013
13. Joomla article modal with clear button: / Joomla /; Applies to Joomla 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important ...; Created on 27 August 2012
14. Inline Labels in Form Fields using Javascript: / JavaScript /; ... still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're ...; Created on 21 August 2012
15. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
16. MediaWiki: MySQL to extract path to images: / MediaWiki /; ... I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image ...; Created on 06 December 2011
17. MySQL last year week month day trend periods: / MySQL /; ... since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM ...; Created on 31 October 2011
18. Migrate Joomla Users to WordPress: / Wordpress /; ... easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to change ...; Created on 03 October 2011
19. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... "row height" is beyond us. We have since simplified this so that only the person who knows how to hit the refresh button is the one to save as a PDF file and sends it to all customers. Training these people ...; Created on 30 September 2011
20. Unix Date Format Specifiers: / Linux /; ... Seconds %s seconds since 00:00:00 1970-01-01 UTC (Unix epoch) 1309785651 %S SS second 00–60 (The 60 is necessary to accommodate a leap second) %N nanoseconds ...; Created on 05 July 2011