Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection: ERROR_invalid_operation_type Sounds rather straightforward,...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 but ended up with an error going on about "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available Values – Specify values" to =IIF(LTrim(Parameters!StudentADAccount.Value)="",...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Get report to see images hosted on an external URL Check if image exists to display alternative placeholding image. Solution #1: Image does not appear within SSRS Configure the Unattended Execution Account: According to Microsoft and Stack Overflow,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution as well so who copied off who is not my concern as this is not the solution to our problem. This is the solution that I...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 specified component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 and PC but I had a client using a Mac with admin privileges which would open the same popup link in the parent window. The solution however is to remove the base URL and only keep the URL as something like #Page:Notify. Do NOT add the base URL such as...

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

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

17 October 2021 to 400x400 (even with tweak to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and...

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

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

28 October 2010 comprise bug-tracking and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this solution unless we continue to pay for the subscription....

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

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

05 January 2011 I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...

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

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

28 June 2011 space. The program doesn't care what sites you've done or how many times you used it (no audit trail). Client-side: Server solutions take up processing power in order to convert/download these on-the-fly. Use this program to generate the thumbnails and...

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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...

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

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 problem as the stored procedure simply fails and discontinues processing the overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements (do they ever?). The...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that usually I could customize the receiving PHP script to receive a JSON request and process...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync but we couldn't find attachments, so our solution here is to create a data table and then to push the attachment from ZohoDesk to ZohoAnalytics using the API. The use-case here...

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

Deserialization and cannot checkout files in TFShttps://joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 Source: http://forum.joomla.org/viewtopic.php?f=431&t=401086&p=1693742#p1693742 It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without...

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

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my modifications...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1:...

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