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

05 February 2013 Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already...

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

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system. What we have: SELECT EmployeeNo , DaysOffSick , DateOfSickness...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 out so that it could be used in other SSIS packages. If we included an SSIS Script in each package, any change to the script would need to be repeated across the board. The following example is an isolated Script held in a separate solution which other...

• 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 install My component is editable by registered users only. This meant that 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...

• 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 * FROM #__projects WHERE user_id= ORDER BY name Please Note: This article focuses on a front-end form dropdown. If you would like to see how to do modals for the admin panel, see my article Joomla article modal with clear button for Joomla article...

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

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

28 October 2013 locale. This operator lets you use a multicharacter collating sequence in your regular expression where only one character would otherwise be allowed. For example, you can use this operator to ensure that the collating sequence 'ch', when defined in a...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 is simply to Update the Joomla Core separately and prior to any 3rd-party extensions If you didn't have a backup, then I would simply take a Joomla install (preferably NOT the most recent version - so that you can force it to update later on) and copy...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 app). Why? Something to do... How? The following code is using AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time....

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

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 authorization workflow process (in other words, you don't have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) their...

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

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

05 August 2014 0987654 MAJ Big Bird M 771 771 771 15 The one lookup task: Changing the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the source database which was not the...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a place to introduce it. On strings this has little worth,...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

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 DOT, EOT, TOT, TIN, DIN run. Testing: No records are being processed despite relevant ones existing and all monitors run I would get this issue if I cloned an existing process (released an existing one, made changes, stored it as a new one) Check the...

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

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

24 October 2014 to see a brief description, click on the button to view the full article in your browser. Hangar New to the app I thought it would be really cool if I could change the equipment by virtual means. Tap on any equipment, photo or detail to change it. I...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 This tells me the alias is "myexampleapp" for this keystore and the SHA1 to add to google which would be: B4:52:80:2B:A0:52:97:FC:6E:66:FF:61:1E:79:20:AD:4A:60:DA:FD;com.mydomain.myappname * In the above, if you have specified the correct bin folder in...

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just stopping the return key or trying to...

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

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 accepts requests from a static and permitted IP address. If the end-user were to make the request, then their own IP address would be the one checked against, and it just wouldn't be manageable to add every new user's IP address to their service. The...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• 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 administrator 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...

• 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 notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load the received XML with SimpleXML and use the built-in PHP JSON_encode function. I ran into the following errors:...

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

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 color without compromising on image quality or overhead maintenance. It's basically a font set that has all the icons you would want in a modern website design. How? To use this list, you can either: Copy the font files to your template folder (my...

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