Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 Implicit TLS/SSL, and SFTP - SSH File Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: Schedule with...

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

Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

22 November 2012 Find the following piece of code around line 311: foreach($this->horizontalCookie[$row] as $block) { $block = str_replace('-', '', $block); $this->module_row1 .= call_user_func($block, $this, $mClasses); } And change it to:...

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

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

06 September 2009 $contact[0]->id .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs( 'index.php?option=com_contact&task=view&contact_id='. $contact[0]->id...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 echo "Stored in: " . "" . $_FILES["uploaded_file"]["name"]; chmod("" . $_FILES["uploaded_file"]["name"], 0755); } Obviously replace with your full path (eg. /var/www/html/images). My Full Snippet This is the code on the receiving PHP file: /** STUFF FOR...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 on overriding the MediaWiki system to allow SWF file uploads) Refer to it in an article using the syntax: Image:Example.swf(Replace the swf file name with the name of your SWF file). Download these files You can download these files by going to our...

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

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

15 November 2009 'title'); Now I've ordered my weblinks by title in this example, but here are some others that may be of interest (simply replace the word title with one of the bolded words below): id - by weblink identifying number catid - by category identifying...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 of each and submit to Client Apply chosen template Design and Layout Implementation Corporate Logo Create initial logo and replace existing template logo with this one Discuss suitability and variances Convert, format, or create vector-based version of...

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

Embed an FLV file into a web pagehttps://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both instances of the text "http://my.video.com/myVideo.flv" with the full url of your own FLV. Save the HTML page and...

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

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 + '/01/2009 01:30:00 PM', Note = 'Event 6' As you can see, these events were hard-coded into the script. I was asked to replace these with events from an actual database. So I just need a table returned with the "EventDate" and the "Note" variables from...

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

List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my...

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

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

19 September 2011 in future. Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " &...

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

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 user_url, user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename', a.email AS 'user_email', ' ' AS 'user_url', a.registerDate AS...

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

SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 oracle error code without the minus/hyphen in front. =IIF( Fields!ERROR_CODE.Value="SUCCESS", "Success", Right( "00000" & Replace( Fields!ERROR_CODE.Value.ToString, "-", ""), 5) )

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT...

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

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 DEFAULT ''; -- temporary string holder for query -- get length SET str_len=LENGTH(str); SET i = (LENGTH(str)-LENGTH(REPLACE(str, delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more...

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

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

19 January 2012 name=ssrs reference, field source=oracle sp field name) 1. Create a stored procedure using a cursor for SSRS CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 My Computer\HKEY_CLASSES_ROOT\Folder\shell Create a new key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key,...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 = 1; -- Determine if Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2...

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