Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 type: GET connection: "my_projects_connection" ]; info r_Portals; // // once we check the JSON, we can select a portal name and ID, this avoids the need of using up an API request to get the portal v_PortalName = "my_portal"; v_PortalID = "789456123";...

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

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

15 July 2025 Creator app, to connect to the data within Shopify. Why? At time of print, we have woken up to the news that including a username and password, or a client and secret in the endpoint of a URL will no longer be supported in the Zoho Deluge invokeURL...

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

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 Make sure that the \components\com_kunena\template folder is on your local disk Make a copy of the default folder inside Rename this to the name of your new template (avoid any spaces) Download the new template for the Kunena forum This is what the...

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

How to use download managers with Google Chromehttps://www.joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want (eg. Download YouTube). Use the following code as the URL: javascript:window.location.href =...

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

Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider...

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages...

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

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 Let's assume that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 and returned their super admin status. Sorted by group_id desc and changed 8 to 2. SELECT m.`user_id`, m.`group_id`, u.`username`, u.`email` FROM `#_user_usergroup_map` m JOIN `#_users` u ON u.id = m.user_id ORDER BY `group_id` DESC; UPDATE...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 a client script which runs when the product page is being modified: Login to ZohoCRM as a system administrator Give it a name, I'm calling mine "Products - Correct Decimals" Give it a description, I'm giving it the one I have in the function header...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 Contacts doesn't seem to appear in Client Script IDE. Didn't for me but then it isn't too hard to guess what the module name is.

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 REGISTRATION Joel Lipman .Com reserves the right to change the username you choose upon registration. This is to help other registered users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 changes. This policy is effective from the 1st of January 2009. What we collect We may collect the following information: name and job title contact information including email address demographic information such as postcode, preferences and interests...

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

Setting up your store to use SSLhttps://www.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 option to buy a "Dedicated SSL" certificate. Shared SSL means that your store will run using two domains your master domain name and shared secure domain which may be used by other customers of your hosting company. Dedicated SSL means that you will...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 hack. Watch for users signing up with the .ru top-level domain as they love playing this about and giving all russians a bad name on the net. If you visit your site and receive either the above error or the alert that a malware was detected:...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 else on the Internet who doesn’t use the “remove device safely” blab and he got the same error. He (unless Andy is a girls name) posted to a forum which was even more useless asking him about a write-protect switch (physical). The user then said...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: OK, it's not the best name for a program and I might be infringing on copyright... Basically this is the third time I wrote this program, simply...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 & Run the setup.exe Go to Start > Programs > Microsoft Virtual PC In the wizard, select "Create a virtual machine" > Next Name it (eg. Test VirtualPC 001) > Next Select the Operating System (eg. Windows XP) > Next Use the recommended RAM > Next Select...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *