Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" + v_ListingPublishKey + "?filepath=/" + v_Filename; URL Syntax #2 // works in eBay v_ImageSrc = "https://creator.zohopublic.com" + zoho.appuri + "Portal_Listing_Report/" + input.ID +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 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" which is the file name as it is to be displayed in ZohoCRM). For...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 v_ImageToDownload = 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 :v_ImageToDownload type :GET...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 { r_ZS_Download = zoho.sign.downloadDocument(v_RequestID); r_ZS_Download.setFileName(m_Requests.get("request_name") + "_SIGNED.pdf"); r_AttachFile = zoho.crm.attachFile("Contacts",m_Contact.get("id"),r_ZS_Download);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 the files into MP3 format and store these in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check the original folder for the same filename (BUT NOT necessarily with the same extension) Delete the original file...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 = False Application.DisplayAlerts = False For Each xWs In ThisWorkbook.Sheets xWs.Copy Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls", FileFormat:=-4143 Application.ActiveWorkbook.Close False Next Application.DisplayAlerts =...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; Language: English ; Platform: Microsoft Windows 7 Professional ; AutoHotkey: v1.33.02 ; Author: - ; Description: This...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 to eu (Europe), com (US), 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 report (not the form)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 to generate and attach r_DownloadResponse = zoho.writer.mergeAndDownload(v_TemplateID,"pdf",m_MergedData,"ab_writer"); v_Filename = "My Test Document"; r_DownloadResponse.setFileName(v_Filename + ".pdf"); r_AttachResponse =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 PATH="$PATH:/Users/yourname/Library/Python/3.9/bin" Save and Exit Press Control + O (write the file) Press Enter (confirm filename) Press Control + X (exit nano) Apply It source ~/.zshrc Test It whisper --help Run the whisper on the original MP3:...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

Outputting PHP files into different file formatshttps://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8'); header('Content-Disposition: attachment; filename=foo.txt'); echo 'contents of file'; PHP to XLS $export_file = "my_name.xls"; ob_end_clean();...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 level --- Free-Text Changelog or Auto-generate - Added Admin Section: Manage Files (each version is a separate file) --- Filename (as it is on disk) --- Title (friendly title of this download) --- Version (to override auto-versioning) --- Version status...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 Squares Mosaic Turquoise Color Ambient Turquoise Add a \templates\\css\background\ambientturquoise.css file. Note the same filename as in the option value of the previous step. body#page { background: #f4f5f5...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 below use the command prompt are because the default setting for computers running MS Windows are set up to hide filename extensions. So you can do this quickly on a friend's PC and it's a bit geeky. Type the following NOTEPAD rename.bat and answer Yes...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 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 = "applicable_products.txt"; f_CSVFile = l_CsvLines.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 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), 1, 1), '/', SUBSTR(MD5(img_name), 1,...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB