Search - Joel Lipman .Com

1. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... upload the file to this folder if(v_WorkdriveFolderID != "") { v_PermaLink = ""; // // generate a test CSV v_NewLineChar = hextoText("0A"); l_Csv_File = ; v_UploadFilename = " Test Upload ...; Created on 11 September 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... " + m_Action.get("recipient_email")); for each m_Contact in l_ContactResults { if(m_Contact.get("Email").equalsIgnoreCase(m_Action.get("recipient_email"))) { r_ZS_Download = zoho.sign.downloadDocument(v_RequestID); r_ZS_Download.setFileName(m_Requests.get("request_name ...; Created on 06 August 2024
3. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... the file You may note that this generates a text file rather than a CSV, this is because our JS widget won't pack a CSV but it will pack text files. // // generate a CSV or TXT v_CSVFilename ...; Created on 25 March 2024
4. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... image cache reference so it is exportable to PDF c_Document = Document[ID == v_UploadFileID]; // // publish key of "Documents" report v_PublishKey = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"; v_DocFileName ...; Created on 26 January 2024
5. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
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 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
8. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... systems: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // ...; Created on 01 March 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... not b_HasNextPage = r_GetProductVariants.get("data").get("productVariants").get("pageInfo").get("hasNextPage"); } } } } } // // generate a CSV list for monitoring purposes v_CSVFilename ...; Created on 20 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
11. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... if this doesn't work, enable one of the following 2 lines //r_File.setParamName("attachment"); //r_File.setParamName("file"); r_File.setFileName(v_DocumentName); r_Attach = zoho.crm.attachFile("Deals",v_DealID,r_File); info ...; Created on 17 October 2022
12. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... type :GET connection:"zcrm" ]; f_FileRequest.setParamName("file"); f_FileRequest.setFileName(r_QuoteDetails.get("Subject") + ".pdf"); // // get a greeting name ...; Created on 18 August 2022
13. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = v_FileDetected.indexOf("_"); v_FilenameDetected = v_FileDetected.subString(v_SubstringStart + 1); v_FilenameFormatted = v_FilenameDetected.replaceAll("_"," "); row.Document_Name=v_FilenameFormatted; } } ...; Created on 11 March 2022
14. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... ) +". "; } // // return response to user return v_OutputMessage; Additional Change Name of file // // to generate and attach r_DownloadResponse = zoho.writer.mergeAndDownload(v_TemplateID,"pdf",m_MergedData,"ab_writer"); v_Filena ...; Created on 21 October 2021
15. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey + "?filepath=/" + v_Filename; URL Syntax #2 // works in eBay v_ImageSrc = "https://creator.zohopublic.com" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" ...; Created on 17 October 2021
16. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... commas v_NewCSVline = "\"" + v_ThisEventTime.toString("yyyy-MM-dd HH:mm:ss") + "\",\"" + v_ThisEventNote + "\""; l_NewCSVrows.add(v_NewCSVline); } // // generate CSV v_CSVFilename = "audit-log-" ...; Created on 16 June 2021
17. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... v_ThisFileName = ifnull(m_ThisFile.get("file_Name"),"-"); v_ThisFileUrl = ifnull(m_ThisFile.get("download_Url"),"-"); v_ThisFileAttachmentID = ifnull(m_ThisFile.get("attachment_Id"),"-"); ...; Created on 02 February 2021
18. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... com.cn (China), ... v_TLD = "eu"; // my creator form f_MyImages = MyImages[Name == "Logo"]; v_Filename = f_MyImages.MyImage.getSuffix("/image/").getPrefix("\""); // specify publish key of published ...; Created on 14 July 2020
19. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; ...; Created on 08 July 2020
20. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... xWs.Copy Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls", FileFormat:=-4143 Application.ActiveWorkbook.Close False Next Application.DisplayAlerts ...; Created on 11 February 2019