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

01 April 2025 = v_QuoteID; o_Params.auth_type = "apikey"; o_Params.zapikey = "1003."; var r_QuotedRecord = ZDK.Apps.CRM.Connections.invoke("j_crm", "https://www.zohoapis.com/crm/v7/functions/fn_quotes_getquoteditems/actions/execute", "GET", 1, o_Params, o_Headers);...

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

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

18 September 2025 (eg. "123456789") Note this down for later use Create a connection to Zoho Analytics: Above the function in Zoho People > Connections > Create Connection Select Zoho Analytics and give the required scopes (I've cheated and gone for...

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

ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

16 October 2025 Older Zoho Books feeds in the UK were powered by Yodlee. From 2024 onward, Zoho migrated UK accounts to Open Banking connections handled by Plaid. The “via Plaid” or “via Yodlee” tags no longer appear in the UK interface; instead, you’ll see the bank...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

04 October 2013 on the Application folder and add the sub-folder you need to put your sample in (ie. Tasks, PipelineComponents, Connections) Right-click on the new folder, and add "Project Output" to the folder to place binaries from your sample. If you need to place...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

11 November 2013 link is no longer valid. Why? The problem happens because of the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter....

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 connection Open Business Intelligence Development Studio (BIDS) Click on "View" > "Server Explorer" Right-click on "Data Connections" > select "Add Connection" Click on "Change..." Select "Microsoft ODBC Data Source" > OK Select the data source from the...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using...

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

FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 into Settings > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming connections" Leave the boxes ticked EXCEPT for "Enable Stealth Mode" Settings Security and Privacy Firewall Firewall Options Note:...

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

Xero API: Send Multiple Invoiceshttps://joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

15 August 2021 is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was trying to send about 7 at a time (as in schedule created 7 Zoho invoices but only 5 Xero...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

30 September 2011 databases, both development and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see the username/password details (granted read-only access). One of the requirements was that only authorised...

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

Passwords: Did-you-knowhttps://joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

15 November 2010 the majority of webmail and email programs; passwords in remote desktop sessions; and any wifi keys used in your wireless connections. All the software can run off a USB key needing only a few seconds to connect to your computer and to automatically...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *