AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; Create Icons ImageListID := IL_Create(5) Loop 5 IL_Add(ImageListID, "shell32.dll", A_Index) ; -------------------------------------------------------------------------------------- ; Create GUI Gui, New, %Options%, %Title% Gui, Color, %BgColor% Gui,...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Or via cPanel...

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

Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 the product "123456789012345678" with the product "987654321098765432" and p_InvoiceID is the ID of the invoice record: v_Index = 0; m_Update = Map(); l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails =...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 benefits of “External” could be for development updates (untested). Widget File: upload the ZIP file from your dist 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...

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

Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 - Initial release More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation:...

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

Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 - Initial release More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetItemTransactions Documentation:...

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

Zoho Deluge: a HTML Entity Decoderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 l_HtmlEntityChars.add("\""); l_HtmlEntityChars.add("'"); // // build a map m_HtmlEntity = Map(); for each index v_EntityIndex in l_HtmlEntityNames { m_HtmlEntity.put("&" + l_HtmlEntityNames.get(v_EntityIndex) + ";",...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation:...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 is not created. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation:...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 that has to be run weekly and include all the orders of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE")...

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

Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 = v_LastNamePart.proper(); // // if exception prefixes for each v_Prefix in l_ExceptionPrefixes { if(v_LastNamePart.indexOf(v_Prefix)==0) { v_LastNamePart = v_LastNamePart.replaceFirst(v_Prefix,v_Prefix + " :|JOEL|: ", true).proper(); v_LastNamePart =...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 on New Widget, give it a name and set hosting to Zoho Click on File Upload and upload the zip file that was just created the Index Page is /widget.html Hit Save then find the one you just created in the list and click on Install Select the profile(s)...

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

Zoho People: Get Performance Records over APIhttps://joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 Record Data: " + m_ThisGoal; if(!isNull(m_ThisGoal.get("Zoho_ID"))) { m_OutputRecord = Map(); m_OutputRecord.put("Record Index", v_CountTotal); for each v_Field in m_ThisGoal.keys() { m_OutputRecord.put(v_Field, m_ThisGoal.get(v_Field)); //info "Field:...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 = ifnull(m_JobData.get("jobId"),""); if(v_JobID != "") { l_CheckJob = " ".leftPad(5).replaceAll(" ",",").toList(); for each index v_CheckJob in l_CheckJob { // // delay for 10 seconds r_Delay1 = invokeurl [ url :"https://httpbin.org/delay/10" type :PUT...

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

Joes WebGL Experimenthttps://joellipman.com/component/content/article/joes-webgl-experiment.html?catid=40

06 April 2013 though: Demo It's still in development and a somewhat stable beta version is demo'd at http://demo.joellipman.com/joomla16/index.php/joes-infographic-for-joomla Limitations Does not work in MS Internet Explorer Is not working on iOS and certain...

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