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

30 January 2011 -- Yeh well you've been warned BACKUP BACKUP BACKUP! -- I have several databases and websites setup with exact copies of the -- data so I can risk this one not working. You need as a minimum, at -- least 2 databases to use the queries in this script...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 button so that you can define the query parameters. 4c. Add a dataset: the "Parameter Names" Under "Parameter Name" type the exact same name for the input variable used in your Oracle stored procedure (in my example: p_STUDENT_ADNAME). Under "Parameter...

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

Regular Expression Basic Usage Exampleshttp://mail.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 expression matches all of the following sequences: ac abc abbc abbbbc The expression does not match: adc Interval — Exact Count The exact-count interval operator is specified with a single digit enclosed in braces. You use this operator to search...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

XML Schema Referencehttp://mail.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for...

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

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 menu item for the page you created. Click on that link to view your page. We are doing this because you need to find out the exact URL of the page you created. Make sure to copy the URL as we will need some of it in step 3. After you copy the URL you...

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

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 ruler as little arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and Position..." Paste the same height value as the one...

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

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 dummy index to track row numbers. Copies structure (column_name, data_type, character_maximum_length) Copies data (should be exact copy)

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

Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 means to copy from or adapt all or part of the work in a fashion requiring copyright permission, other than the making of an exact copy. The resulting work is called a “modified version” of the earlier work or a work “based on” the earlier work. A...

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 QA - for clients who need to test enhancements that you've developed. (referred to with the customers as TEST). BACKUP - an exact copy of LIVE (preferably from a daily refresh - and inaccessible to non-administrator users) DEV1 - a copy of LIVE and for...

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

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 Email (check this is “Site Email”) Then go under Global Configuration > Server > Mail Settings > From email (has to be the exact sender email address (check uppercase&lowercase, etc)). Check Plugin Settings: Login to your Joomla Admin Panel Navigate to...

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

SSRS Stop Scrolling Behindhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 ever display, the top rows of the dataset. Why? A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a...

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

SSIS Multiple Lookups in onehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to...

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

Copy a Wordpress Site for Developmenthttp://mail.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 Wordpress CMS site. Why? I have a website sitting at a domain (eg. www.myexample.com), and I want to create an exact copy at a subdomain entitled "dev1" (eg. dev1.myexample.com). How? A quick copy from copy 1 (LIVE) to copy 2 (DEV): Backup all files in...

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

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

09 March 2015 a search module form (same as the default install) only with the additional hidden fields: limit, search phrase (all, any, exact), ordering, and areas (set to doc_indexer by default as per the component). The parameters are changed in the back-end of...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to...

• 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 receiving the unique challenge code, the endpoint must hash the challengeCode, verificationToken, and endpoint URL (in that exact order), and respond to eBay with an HTTP 200 OK status, including the hashed result in JSON format within the...

• 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 Note the result for the next command, eg. #!/Library/Developer/CommandLineTools/usr/bin/python3 Install NumPy for That Exact Python /Library/Developer/CommandLineTools/usr/bin/python3 -m pip install --user numpy Alternative: Using VOSK RuntimeError:...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• 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 (we want an image back) m_Config = Map(); m_Config.put("responseFormat","image"); // // for the criteria, we need to get the exact survey we want to chart on // we also want the respondent to match the email on the contact record // note the labels...

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

How to put MediaWiki into Debug modehttp://mail.joellipman.com/articles/cms/mediawiki/how-to-put-mediawiki-into-debug-mode.html

22 October 2009 WikiMedia does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the wiki directory under your account.

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

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

22 November 2013 more complicated then this, but it isn't. This is one of those rare situations when the Microsoft error is describing the exact problem. If you include linked images in the report (as in images not in the report itself but referring to other systems...

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