Search - Joel Lipman .Com

1. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; Applies to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey ...; Created on 08 July 2020
2. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... application which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google ever update their Chrome browser to list ...; Created on 07 January 2020
3. MS Excel - Split Workbook into separate files per sheet: / Excel /; What? This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file ...; Created on 11 February 2019
4. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...; Created on 09 August 2014
5. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...; Created on 13 June 2014
6. MS-DOS: Copy folders without overwriting files: / MS-DOS /; What? A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal ...; Created on 23 February 2014
7. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; What? So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- ...; Created on 04 June 2013
8. Php convert filesizes to bytes kb mb gb: / Personal Home Page /; What? Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays ...; Created on 03 January 2013
9. Deserialization and cannot checkout files in TFS: / Team Foundation Server /; Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those ...; Created on 03 January 2013
10. List last modified files using FTP Command-line: / File Transfer Protocol /; Why? So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how ...; Created on 20 November 2012
11. RokDownloads Manager does not list files: / Joomla /; Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager ...; Created on 28 October 2010
12. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to ...; Created on 12 February 2010
13. 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
14. 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
15. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... + v_InventoryId + "/image?organization_id=" + v_BooksOrgId; // // updload the photo r_UploadPhoto = invokeurl [ url :v_Url type :POST files:r_DownloadedPhoto connection:"joel_books" ]; // ...; Created on 21 June 2022
16. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... section to hold a notes field. A notes field called "Note_Attachments" (this will display a HTML table with click-to-download files) A blank subform callled "Attachments" (links to a form called "Documents") ...; Created on 11 March 2022
17. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... = ""; l_DisallowedProfiles = List(); l_DisallowedOptions = List(); // // capture event m_Webhook = crmAPIRequest.toMap(); // // check if user info is provided if(!isnull(m_Webhook.get("user_info"))) { // // ...; Created on 11 February 2022
18. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... and ZohoWriter.Merge.ALL For good measure, I'm going to include the scopes: WorkDrive.files.ALL, WorkDrive.workspace.ALL Click on Create and Connect > Accept Get the Template ID The following ...; Created on 21 October 2021
19. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... "product_id": 9876543210987, "created_at": "2021-10-17T21:45:56+01:00", "updated_at": "2021-10-17T21:45:56+01:00", "src": "https://cdn.shopify.com/s/files/1/2345/6789/1234/products/aaaabbbbccccddddeeeeffff11112222.jpg?v=1234567890", ...; Created on 17 October 2021
20. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... + v_CrmProductID + "/photo?restrict_triggers=workflow"; r_CrmPhoto = invokeurl [ url: v_Endpoint2 type: POST files: r_CreatorPhoto connection: "joels_crm" ]; info r_CrmPhoto; } } ...; Created on 27 September 2021