Search - Joel Lipman .Com

1. File Transfer Protocol: / Category /; Created on 05 March 2020
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a ...; Created on 25 March 2024
3. Zoho Books: Generate Bank Text File for Download: / Zoho /; What? This is an article to document how we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? ...; Created on 02 October 2023
4. 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
5. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; What? So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. ...; Created on 11 February 2022
6. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; What? A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called ...; Created on 01 September 2021
7. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; What? This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went ...; Created on 02 February 2021
8. 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
9. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; What? This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it ...; Created on 15 May 2020
10. 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
11. 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
12. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; What? So this is supposed to be a quick article detailing how I used a PHP function to upload a video file to Google Drive. Note that this example does not involve installing the Google Client Library ...; Created on 29 October 2018
13. Import Excel CSV file as JavaScript array: / Excel /; What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and ...; Created on 05 October 2015
14. 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
15. 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
16. 301 Redirect using htaccess file: / Web-Development /; ... and true to form Google have removed it. Not sure why nobody believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .htaccess file: Upload a text file ...; Created on 03 April 2014
17. 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
18. SharePoint 2007: Change profile picture with minimal permissions: / SharePoint /; What? This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user ...; Created on 07 November 2013
19. Disable User Registration in Joomla 1.5 - Configuration File: / Joomla /; ... using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database ...; Created on 08 October 2013
20. 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