Search - Joel Lipman .Com

21. 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
22. 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
23. 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
24. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... need to give the full path of the custom domain (eg. https://mysubdomain.joellipman.com), I include the app owner and app name. Then you need to give them edit access by doing the following: Go to your ...; Created on 17 November 2020
25. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... folder. Index File: put here the root html file along with the path (do not forget the leading slash or your widget will error) Click on "Create" (bottom-right of your screen) Now go to a Creator ...; Created on 24 October 2020
26. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist( sFile:=A_LoopFileLongPath ) { ...; Created on 07 August 2020
27. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... + zoho.appuri + "MyImages_Report/"; v_ImageSrc = v_ImageSrc + f_MyImages.ID + "/MyImage/image-download/" + v_PublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; // yields something like ...; Created on 14 July 2020
28. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GenerateList: Generate/Populate list of files and their proposed new names GenerateList: SB_SetText("Generating...") LV_Delete() v_RowCount := 0 GuiControlGet, SelectedDir v_FilesPath ...; Created on 08 July 2020
29. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... + "." + v_FieldName); l_BuildUrl.add("download"); l_BuildUrl.add(v_PermalinkCode); v_DownloadUrl = l_BuildUrl.toString("/"); v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // ...; Created on 15 May 2020
30. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... %MarginX%, %MarginY% Gui, Add, ListView, w396 h775 gOpenProfile -Hdr +Grid, Profile|Client ProfilePath := "C:\Users\" A_UserName "\AppData\Local\Google\Chrome\User Data\Profile*" Loop, Files, %ProfilePath%, ...; Created on 07 January 2020
31. Zoho Deluge - Get Current User ID: / Zoho /; ... = userResp.executeXPath("/users/user"); if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); ...; Created on 08 April 2019
32. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended: using credentials stored in external ...; Created on 20 March 2019
33. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... Splitbook() Dim xPath As String xPath = Application.ActiveWorkbook.Path Application.ScreenUpdating = False Application.DisplayAlerts = False For Each xWs In ThisWorkbook.Sheets ...; Created on 11 February 2019
34. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... private key and token file Here you need to enter the relative or absolute path to your private key, this should be the JSON file that you generated at Google's developer console - service accounts section. ...; Created on 02 February 2019
35. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
36. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... https://autohotkey.com/board/topic/67917-get-folder-size/ ; function to loop through files/subfolders and total the file sizes GetFileFolderSize(fPath="") { FolderSize := 0 if InStr(FileExist(fPath), ...; Created on 28 January 2019
37. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email', $GAPIS_AUTH . 'userinfo.profile'); ...; Created on 31 October 2018
38. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... } // close second request handler curl_close($ch2); } return $output; } Usage: $mime_type = 'video/mp4'; // could be 'image/jpeg', etc. $new_name = 'My Video'; $the_file_and_path ...; Created on 29 October 2018
39. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... c1 JOIN `v25_db`.`v25_content` c2 ON c2.`introtext`=c1.`introtext` JOIN `v25_db`.`v25_categories` t2 ON c2.`catid`=t2.`id` JOIN `v34_db`.`v34_categories` t1 ON t2.`alias`=t1.`alias` AND t1.`path`=t2.`path` ...; Created on 12 September 2015
40. Joes Word Cloud (JWC) Download: / Downloads /; ... to 1. - Now includes absolute path for word link (JURL::base()).- Date Uploaded: Sat, 14th May 2011 1.6.2 - Modified core script for PHP4 compatibility.- Date Uploaded: Mon, 14th Mar 2011 1.6.1 ...; Created on 07 September 2015