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

08 July 2020 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 GUI and display what it will name them. The app needs to rename files but append an...

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

ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 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 level or stock check of all the products that are currently listed...

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

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

06 August 2024 { // get the actions l_Actions = v_Template.get("templates").get("actions").toList(); for each m_Action in l_Actions { if(m_Action.get("action_type") == "SIGN") { v_SendActionId = m_Action.get("action_id").toLong(); } } } } if(v_SendActionID == 0) {...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 says to use remove() to remove a key from a map. In this case, the ID key and value pair. It would then tell me the list was null when I thought I was adding the map with the ID removed back into a list. The map itself was null. How? We are using an API...

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

List MediaWiki Articleshttp://mail.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS PageID, CONVERT(p.page_title USING latin1) AS...

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

Zoho Creator: Sendmail a list of attachmentshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 from a Creator form, no InvokeURL needed c_Form = Form[ID == 1234]; r_Download1 = c_Form.myFieldWithFile; ***/ l_Downloads = List(); r_Download1 = invokeUrl [ url: "https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdf" type: GET ];...

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

JDatabase: using the Joomla database with exampleshttp://mail.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 ASC'); // Reset the query using our new query object $db->setQuery($query); // Load the results as a list of stdClass objects (see later for more options on retrieving data). $rows = $db->loadObjectList(); // Retrieve each value in the ObjectList...

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

Zoho Creator / Shopify: Get all Active Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every active product and list their IDs. How? So here's the function I came up with. It loops through a maximum of 2500 products sorted in order of ID...

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

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 + v_Day3_Ordinal + " " + v_NextDay.toString("EEEE") + " " + v_NextDay.toString("MMMM") + " "; Generate a list of working dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7...

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

Zoho Deluge: Get All Orders from eBayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 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 of Zoho Inventory. In this task, we are simply getting a CSV...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 third-party APIs. How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the list of unique ones from the "all" list to be left...

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

RokDownloads Manager does not list fileshttp://mail.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle of writing a component that will hopefully comprise bug-tracking and download...

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

Stored Procedure to List Distinct Values and Countshttp://mail.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Oracle SQL - Convert given list (CSV) into Rowshttp://mail.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 ftp my_ftp_host (where "my_ftp_host" is the hostname or IP of the server holding my site) Enter login credentials Type dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website to change directory to the root folder...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 you to do: How many email accounts? What will these be primarily used for (restricted on space allocation - usually ~100Mb)? List all email addresses please (limited as these include reply-from - eg. info@mydomain.com) Webmail or do you have standalone...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 So I need a FREE program that simply takes pictures of some websites my website links to (about 153) for an extension (Quicklist Weblinks) I wrote for an OpenSource CMS. Could also be of some use if your portfolio is a bunch of online websites and you...

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

XML Schema Referencehttp://mail.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 document keyref Specifies that an attribute or element value correspond to those of the specified key or unique element list Defines a simple type element as a list of values notation Describes the format of non-XML data within an XML document redefine...

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

List all cron jobs for all usershttp://mail.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 Amazing little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 taken from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is also referred to as the pricelist... and vice-versa. And in this use-case, my...

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