Search - Joel Lipman .Com

1. Infopath: / Category /; Created on 05 March 2020
2. UNC Paths in Sharepoint 2007 links: / SharePoint /; Applies to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. ...; Created on 08 November 2012
3. MediaWiki: MySQL to extract path to images: / MediaWiki /; ... name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename: select img_name, img_size, img_user_text, img_timestamp, CONCAT(SUBSTR(MD5(img_name), ...; Created on 06 December 2011
4. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just ...; Created on 21 July 2011
5. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 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: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... :zoho.loginuserid to:"Joel Lipman " subject :v_Subject message :v_Message Attachments :file:v_CSVFile ] } Error(s): ],"path":["query","productVariants","pageInfo","endCursor"],"extensions":}]} ...; Created on 20 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... := "Date Created|Date Modified|Foreign Key|Zoho CRM ID|Original File with Path|New File with Path|Original Filename|New Filename|Display Filename|KB File Size" ; add gui Gui, New, -MinimizeBox -MaximizeBox ...; Created on 16 January 2023
11. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); / ...; Created on 21 June 2022
12. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the public URL of the file on this record v_PublicUrl = "https://creatorapp.zohopublic.eu/file" + zoho.appuri + "Inventory_Photo_Report/" + input.ID + "/Creator_File/download/" + v_PublishKey + "?filepath=/" ...; Created on 31 March 2022
13. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; What? A super quick article on how to download an attachment from CRM and upload to a "file upload" field in Creator. Why? My use case here is that we are creating a Creator app that will show ...; Created on 11 March 2022
14. 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
15. Zoho CRM: Schedule a Call using Deluge: / Zoho /; What? This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to ...; Created on 18 November 2021
16. 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
17. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... tidy up the response so we can executeXPath x_Response = r_ResponseXML.executeXPath("/*/*").toXmlList(); for each x_Node in x_Response { if(x_Node.contains("").getPrefix(" 0) { v_AccessToke ...; Created on 20 September 2021
19. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... { if(!isnull(r_CreatorFile.File_Download)) { v_LinkToDownload = v_CreatorBaseUrl + "/file" + zoho.appuri + "Download_File_Report/" + r_CreatorFile.ID + "/File_Download/download/"+v_PublishKey+"?filepath=/" ...; Created on 02 February 2021
20. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... We asked Zoho for a solution that might work and were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were. The mai ...; Created on 10 December 2020