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 necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's the shortened version where the system chooses the color...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 identifier of the eBay user notification.data.eiasToken this string is the eBay user's EIAS token; another identifier used for an eBay user ******************************************************************************* */ m_Payload =...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 An article on a client script used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write. Why?...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 p_DealID) Label: Fn - Deals - Retrieve Pipeline Trigger: Standalone / REST API Purpose: Function used by a client script to retrieve the pipeline given a deal record id Inputs: Deal Record ID Outputs: the value of the pipeline Date Created: 2025-05-06...

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

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

23 June 2025 more than 10 files at a time. I have a 1.5 Gb video which has a duration of 5.5 hours. I struggled with this and ultimately used VOSK but I'm leaving the instructions here in case it works for you. Pre-amble Requires Homebriew, FFMPEG, PIP, and Python:...

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

Zoho Deluge: Connect to Shopifyhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 a JWT which was an absolute waste of time with regards to what I was attempting to do. How? Let me show you how we used to connect and then what the new code will be. The preamble to both of these is how to get the values to include in the invokeURL...

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

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

18 September 2025 [ url: v_Endpoint2 type: POST parameters: m_Params headers: m_Header connection: "zanalytics" ]; info r_AddRow; } } // // used while debugging / remove once in production if(v_CountTotal >= 3) { break; } } return "Processed " + v_CountTotal + "...

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

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

25 September 2025 Then I'll write the SQL to sum up the responses per page per survey attempt. Finally, I'll see if analytics can be used to generate the radar chart. ZohoSurveys - Individual Responses Query (if using CRM to send surveys) If using the CRM integration,...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 string standalone.fn_Xero_MapTaxRates() Label: Fn - Xero - Map Tax Rates Trigger: Standalone / On-Demand Purpose: Function used to map Xero tax rates to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Ascent Business - Joel Lipman) - Initial...

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

On Gui Resize Eventhttp://mail.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 you resize the app. Syntax: GuiSize: GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image...

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

Increment a column in MySQL using the UPDATE queryhttp://mail.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to...

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

Change Regional Settings for your Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View tab Check...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Comparing two mediawiki siteshttp://mail.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have...

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

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service last worked? Suggestions by Wikipedia...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 ) AS xmlval FROM DUAL) x, TABLE (XMLSEQUENCE (EXTRACT (x.xmlval, '/rows/row'))) d Yields: 1 2 3 4 5 6 Note that I actually used text in the example above and this worked. Obviously don't get the commas mixed up.

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

Strip HTML in MySQLhttp://mail.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that...

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

Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL DROP TABLE [dbo].[myUserTable]; GO Types for sys.objects (less used by me) AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint FN =...

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Android Background Image Resolutionshttp://mail.joellipman.com/articles/google/androidos/android-background-image-resolutions.html

01 December 2014 960x1440 res/drawable-xxxhdpi // for launcher only 640dpi res/drawable-tvdpi 1.33*mdpi // not needed as mdpi or hdpi is used xlarge screens are at least 960dp x 720dp large screens are at least 640dp x 480dp normal screens are at least 470dp x 320dp...

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

CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of,...

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