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. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; 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 22 January 2022
19. 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
20. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later ...; Created on 19 October 2021