Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 "OK this should take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme...

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

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

24 October 2020 to move it to trash/bin. Open the terminal app on your Mac and type the following to test the install: node –v npm –v You should get a version number for each of these as a response. Failing this you should check your security and privacy and ensure...

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

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

04 October 2013 to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and "Director of IT". "O'REILLY" should become "O'Reilly" and not "O'reilly"....

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 will copy over each table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last step of this migration. Rename admin ID in the UPGRADE database We want to make sure that the new user ID...

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

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

28 June 2011 best site ever As long as the page loads in a browser of yours (it will look at it like MS Windows Internet Explorer) it should be ok. Output names for the thumbnails follow the same restrictions as the MS Windows filesystem (so no colons, back/forward...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 proper default values IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10, (LENGTH(p_original_value)-1)); -- should yield eg. 100000 ELSE v_rand_param1 := p_original_range_1; END IF; IF p_original_range_2 IS NULL THEN v_rand_param2 := POWER(10,...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 be for my staging process as well as seeing what fields I will be bringing through. Run XET from the menu system and you should be presented with a cleared/new record Complete the form noting the name of your XET Code and then selecting the appropriate...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

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

11 September 2009 have dedicated SSL simply go to your master doman and store directory using your browser. http://www.example.com/store You should now be presented with your store. If not, you have either typed the wrong URL or it has not been installed properly. To...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 3.0 database (note that we're reflecting the prefix to use but also the database name - by this step, "my_new_database" should have been renamed). Save the SQL file, this is now unique to your website and this process. It does not contain usernames or...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 { r_AttachFile = zoho.crm.attachFile("CustomModule5004",v_CrmSoID, row.myUpload); } } // r_AttachFile should yield SUCCESS and if you check your CRM record it will have these under "attachments" Setup a Zoho Oauth Connection So that we can use invokeUrl...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type :POST parameters: m_CreateQuote connection:"myconnection" ]; when you should have done this (send the payload as the value to the key "data"): l_RecordsToSend = List();...

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

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

30 May 2009 give Joel Lipman .Com when you use this website. Joel Lipman .Com is committed to ensuring that your privacy is protected. Should we ask you to provide certain information by which you can be identified when using this website, then you can be assured...

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

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

05 January 2011 Tools > Data Sources (ODBC) Click on the System DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 MS Outlook to store these kind of things until the company implemented a software to deal with room bookings and said we shouldn't use Outlook for this... The DataSet The script I used to generate the dates comes from...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 somewhat popular and the services that offer FREE thumbnail screenshots are getting stricter with their terms of use. You should only enable thumbnail refreshes at the time of install. Also note, this module will NOT generate thumbnails if you select...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 users to be able to search the PDF indexer but not to return any other Joomla articles from other categories. Public users should not be able to use this search or see the restricted documents. I've googled far and wide but as usual, I find myself to be...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 creator.cs.zohohost.eu (depending on if you access zoho.com or zoho.eu) Back in Zoho Creator, click on "Verify Now" and you should get a response saying "Domain Verified Successfully": There are other ways to verify your custom domain such as TXT, which...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 Then let's work on that Windows OS: Login to your Windows > Go to Search > Device Manager > Expand "Display Adapters" You should see your Graphics Card listed but as well as a Windows Integrated Graphics or Intel Integrated Graphics option which is...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 (yours will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" The question can be asked by clicking the...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 estimates in Zoho Books; such as product image, product name, product description. Granted that in some cases, the design should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More than often, however,...

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