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 CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
8. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How? The key trick to use here the ability for Zoho ...; Created on 25 July 2024
9. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... that Shopify would intermittently remove our webhooks. This would make the entire synchronization of the system go out of whack and some records would slip through the net while every day, the process ...; Created on 22 April 2024
10. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: ...; Created on 25 March 2024
11. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... How? So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer visits website to ...; Created on 26 January 2024
12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; What? This is an article to show you how to, using Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has ...; Created on 05 December 2023
13. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... :DELETE connection:"zbooks" ]; Caveat(s) The delete process may need to be in a schedule: you can use a custom module in ZohoBooks to store the necessary information of what to delete. Undocumented ...; Created on 02 October 2023
14. 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
15. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = ifnull(r_CreatePaymentIntent.get("amount"),"-"); // // Process Payment Intent if(v_CheckObject == "payment_intent") { v_PaymentIntentID = r_CreatePaymentIntent.get("id"); info "Payment Intent Create ...; Created on 16 March 2023
16. 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
17. 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
18. 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
19. 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
20. 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