Search - Joel Lipman .Com

1. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
2. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
3. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
4. Can't play music after Firmware Update Version 3.: / IT Support /; Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System ...; Created on 21 September 2009
5. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... based on its identifying number (allows other attachments to remain intact) Generate the file The code here is a cut down version just to demonstrate generating a text file and storing this into ...; Created on 02 October 2023
6. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a ...; Created on 06 July 2023
7. Zoho CRM: Change System Field Length: / Zoho /; ... out-of-the-box differ in length so they do not list the postal code on the deal record to be listed in the "Lead Conversion Mapping" page. In the Leads module, the Zip field is 30 characters; in the ...; Created on 19 June 2023
8. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... " + v_AccessToken); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCal ...; Created on 27 April 2023
9. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 29 March 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Previous Models/Versions Based on the documentation: In the above code, you would change the model value to one of the following code-davinci-002 (optimized for code-completion tasks) text-davinci-002 text-davinci-003 gpt-3.5-turbo ...; Created on 06 March 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = List(); l_CsvFileRows.add(v_ReportCSV); // // get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... get access token (you will need your own function here as documented in my article v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // ...; Created on 28 February 2023
13. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... on Shopify,Modified on Shopify,Published on Shopify"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // app specific v_ShopID ="joels-awesome-shop"; v_ShopifyApiVersion = "2022-01"; v_AccessToken ...; Created on 20 February 2023
14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... browsing to https://platform.openai.com/account/billing/overview. At time of print, the paid plan is a pay as you go or pay as you use. Previous Models/Versions Based on the documentation: In ...; Created on 13 February 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean Attachments.zip and its Attachments.csv to upload ...; Created on 16 January 2023
16. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; ... you are using the Google Chrome web browser. In this case version 100 and is correct at time of print. Open Chrome Web Browser Click on the vertical ellipsis/3 dots icon int the top right Click ...; Created on 20 July 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... record that holds my API connection details v_IntegrationRecordID = 123456789012345678; r_CrmRecord = zoho.crm.getRecordById("Integrations",v_IntegrationRecordID); v_TradingAPIVersion = r_CrmRecord.get("Compatibility_Version"); // / ...; Created on 31 March 2022
18. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... from MacOSX to Final Cut Pro (latest version 2022) and I don't have to pay for each year's software version as I do with MS Windows builds. Saying that, there are a lot of automations and applications I ...; Created on 12 March 2022
19. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? ...; Created on 14 February 2022
20. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... "$1", false); // yields -123.4567 Awesome! Recap on the Creator version: v_Test8 = 12.000; info v_Test8.toString().replaceAll("^(^-?\d+\.\d*[1-9])(0+$)|(\.0+$)", "$1", false); // yields ...; Created on 08 February 2022