Search - Joel Lipman .Com

1. ZohoCRM: Process all records of a module: / Zoho /; What? A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether ...; Created on 24 August 2021
2. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... times and run through a few, I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process ...; Created on 21 August 2014
3. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... on it. I'm going to use a short batch process but to save time on the different ways of doing this, the example below uses a command prompt to a) create a batch file b) use it to rename the files c) delete ...; Created on 09 August 2014
4. Parameters not being used in report processing: / SQL Server Reporting Services /; Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder ...; Created on 07 January 2011
5. Error during processing - Converting Date/Time: / Transact-SQL /; ... reports though. The error I'd get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. ...; Created on 13 July 2010
6. SSRS Report Builder 2.0 - Error during processing: / SQL Server Reporting Services /; The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred ...; Created on 06 May 2010
7. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All"; // // calculate from and till v_OrdersFrom = v_Year + "-01-01T00:00:00.000Z"; v_OrdersTill = v_Year + "-12-31T23:59:59.000Z"; // // ...; Created on 29 March 2023
8. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = ; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex ...; Created on 08 February 2023
9. 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
10. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... to the Deal record. How? The following is the process from registering the app to call on the full API (grant code > refresh token > access token) and then the code to attach the document to the ...; Created on 17 October 2022
11. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; What? This is an article taken from https://goodereader.com/blog/kindle/here-is-how-you-can-read-pdf-files-on-the-amazon-kindle which I wanted to take note of as it is a process that worked at time of ...; Created on 29 June 2022
12. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'l ...; Created on 07 April 2022
13. 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
14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... ID from Shopify. How? The below details on how we set up an access token in Shopify using the new process. Preparation: You don't have to do this, but I store all the keys in a Zoho Creator ...; Created on 14 February 2022
15. Zoho CRM: searchRecords with sorted results: / Zoho /; ... init l_Pages = ; v_PerPage = 200; m_SortCriteria = Map(); m_SortCriteria.put("sort_by","Created_Time"); m_SortCriteria.put("sort_order","asc"); // add in additional search criteria m_SortCriteria.put("Processed_by_Function","false"); // ...; Created on 10 February 2022
16. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... order record in Zoho Creator. We did the same for when Shopify would process an order. You can see my following articles for more information on these: Zoho Creator: Receive eBay Order Notifications ...; Created on 21 January 2022
17. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login ...; Created on 10 January 2022
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... REST API function that will forward the payload data to Zoho Creator (Yes you will need CRM version Enterprise or Zoho One [that supports functions] for this process). So first off, here's a reminder ...; Created on 20 September 2021
19. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... = v_DataCSV.toFile("test.csv"); // // read and process CSV file v_FileContent = f_CSVfile.getFileContent(); l_FileRows = List(); if(!isBlank(v_FileContent)) { l_FileRows = v_FileContent.toList("\n"); } // ...; Created on 26 August 2021
20. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list canno ...; Created on 30 July 2021