Search - Joel Lipman .Com

1. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
2. MySQL: Find all non-alphanumeric rows: / MySQL /; What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...; Created on 09 September 2013
3. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...; Created on 28 January 2013
4. MySQL: Find records in one table that are not in another.: / MySQL /; The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) ...; Created on 25 February 2011
5. Joomla: Unable to find install package: / Joomla /; This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to ...; Created on 05 September 2009
6. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
7. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here is you'll find them in the settings; so check that ...; Created on 28 March 2023
8. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... // send via Email v_CountRows = l_CsvFileRows.size() - 2; v_Subject = "Shopify Products Export & Comparison"; v_Message = "Please find attached a log of " + v_CountRows + " Product(s) from Shopify ...; Created on 20 February 2023
10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
11. ZohoCRM: Import Attachments: / Zoho /; What? An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? ...; Created on 16 January 2023
12. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution. How? Disclaimer ...; Created on 03 November 2022
13. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
14. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... v_EmailMessage = "Hi " + v_ContactName + ", Please find attached your quote. Kind Regards, The Team"; // sendmail [ from :zoho.loginuserid to :v_EmailTo subjec ...; Created on 18 August 2022
15. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... print (6 June 2022) and I wanted to make sure it didn't just disappear or be difficult to find in future. How? The process of sending a PDF file to your Kindle device is also quite straightforward. ...; Created on 29 June 2022
16. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and scroll down to "Web Hosting" then click ...; Created on 07 April 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; What? This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world ...; Created on 31 March 2022
18. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... in a different CSS color, and which date to enter into the Selected_Date field: // creating map for offset (determine which CSS box was selected) m_Offset = Map(); v_StartDate = input.Starting_Date; v_RefIndex ...; Created on 09 March 2022
19. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? ...; Created on 02 March 2022
20. Zoho CRM: searchRecords with sorted results: / Zoho /; ... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods ...; Created on 10 February 2022