Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote Management as I only want to export/import my database: Connected! Now click on Data Export in the left hand panel: In the screen that appears, select...

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

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range and NOT the first column of the...

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

Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 everytime someone installs the component, they would usually need to go into the admin panel and set the ACL permissions. I want my component to work out-of-the-box: // No direct access to this file defined('_JEXEC') or die; // com_XXX is your component...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE user_id= ORDER BY name Please Note: This article focuses on a front-end form dropdown. If you...

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 in comment form This step displays the ReCaptcha on the form (note this code may need to be reverted if the admin does not want to use recaptcha anymore) Open the file \components\com_jcomments\tpl\default\tpl_form.php (line 114) Replace the code

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Extracting the attribute: Here we want to extract an attribute value SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/CURRENT_EMPLOYEE/@financialyear)') AS...

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

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

08 April 2014 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 scrolling issue, the reverse was...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 the problem. When you read my workaround, you'll say that I haven't solved anything; but this is a production database I want to export for offline backup. I have to raise and log a formal change request and follow a workflow process in order to make a...

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

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 = RTRIM(LTRIM(@StringInput)) INSERT INTO @OutputTable ( StringValue ) VALUES ( @StringValue ) END RETURN END Now we want to modify this slightly so that it converts a string of words delimited by pipes to a table: CREATE FUNCTION...

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

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location....

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 dialog, int whichButton) { // Get the f !!! Dialog f = (Dialog) dialog; // this is the EditText that has the value I want EditText inputTemp = (EditText) f.findViewById(R.id.my_input_field); // this is the TextView to store the value in (not the...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 and phones. The app in a nutshell displays flight restrictions in a given area Description As a quadcopter flier myself, I wanted an app to show me a map of the area I was going to film or fly. I wanted it to display the flight restrictions of the area...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N...

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

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

09 March 2015 that are uploaded to a folder. The client also purchased OS PDF Indexer by OS Solutions and installed this. The client wanted restricted users to be able to search the PDF indexer but not to return any other Joomla articles from other categories. Public...

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

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 who is comfortable with making changes to the database Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already created along the way and then deleted. The system is still storing the offending...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 error with using either "SimpleXMLElement" or "simplexml_load_string". Returning the XML with cURL isn't a problem, but I want to convert it to JSON and I usually use a PHP function to load the data into an XML array and use the built-in PHP function:...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 across the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); //...

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

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be done on the respective social network's...

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

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...

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