Search - Joel Lipman .Com

1. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than ...; Created on 20 February 2023
2. ZohoCRM: Import Attachments: / Zoho /; ... "_") v_Ugly := RegExReplace(v_Ugly, "/^_+/", "") v_Ugly := RegExReplace(v_Ugly, "/_+$/", "") return v_Ugly } fn_MD5(string, case := False) ; by SKAN | rewritten by jNizM { o:="" ...; Created on 16 January 2023
3. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; ... How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number ...; Created on 27 July 2021
4. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Why? I've written this article as it took a while to achieve. The Zoho People application and its API are documented but there are problems with the documentation at the time that this article was ...; Created on 10 December 2020
5. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this ...; Created on 06 December 2020
6. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in ...; Created on 22 October 2020
7. Zoho Deluge - Update Creator from CRM: / Zoho /; What? This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where ...; Created on 18 February 2019
8. GDPR Privacy Policy: / Static Items /; ... modify it, or any portion of it, except with express written consent of MYCOMPANY. This license does not include any resale or commercial use of this site or its contents: any collection and use of any ...; Created on 14 February 2019
9. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining 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 ...; Created on 02 February 2019
10. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; ... of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following ...; Created on 30 January 2019
11. MySQL Updating a database table from another table: / MySQL /; ... all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` ...; Created on 22 October 2014
12. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article. Start "Android ...; Created on 10 October 2014
13. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... Search Search for "Free MySQL database manager" (preferably add the keyword "portable") Avoid links to MySQL Workbench and download an alternative. MySQL.com may in the time that I have written ...; Created on 28 July 2014
14. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
15. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...; Created on 14 May 2013
16. MS Excel - Sort pivottable column headings by date: / Excel /; ... with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? ...; Created on 12 April 2013
17. Change the default Joomla Error template: / Joomla /; What? This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, ...; Created on 04 April 2013
18. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... as we have different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not as an invite ...; Created on 04 March 2013
19. Preg_Replace all strings between two tags: / Personal Home Page /; ... shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to ...; Created on 07 February 2013
20. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but ...; Created on 22 August 2012