SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 ABLANK solution. It took two of us the best part of two days to come up with the SRL syntax... Our XSLT can then do the following: -- for *LookupFailed* both code and name will be blank. -- possibly use "-1|*LookupFailed*" for the error to come through...

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

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 is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all...

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

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

24 October 2014 in your area. The restricted zone data is based on content found in Wikipedia.org. By using this app you agree to the following: JoelLipman.com shall not be responsible for any special, incidental, or consequential damages, including but not limited to...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java (readFeed) and replace with private List...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• 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 windows login and with the JKS file you used) Enter the password for the key store and you should get something like the following (don't use this one but it will look like this): myexampleapp, 27-Oct-2014, PrivateKeyEntry, Certificate fingerprint...

• 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 I tried replacing the new lines but just stopping the return key or trying to catch it is an obsolete method. How? The following example replaces the return key with a "GO" key: The XML The Java EditText location =...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 The ImageView exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java file and will display an AlertDialog with the 3 options to "take a photo", "choose...

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

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

08 March 2015 include `wp_postmeta` and `wp_posts` if you want images and attachments) Done Sample Configuration PHP Note that the following are sample values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get...

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

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 A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla...

• 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 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: Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: Entity: line 1: parser error : Document...

• 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 webpage You then add the icon to your webpage using a CSS reference: My facebook social icon Further examples are on the following site at https://fortawesome.github.io/Font-Awesome/examples/. The List This is a copy of the cheat sheet version 4.4. If...

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

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 'com_weblinks.category.%:|joe%' ) = a.id WHERE a2.`name` LIKE 'com_weblinks.category.%'; Pre-Release Go-Live Notes: The following is to enable any activated users on the v2.5 system so that they can log in to the new system. -- TO ACTIVATE USERS (do NOT...

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

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

13 June 2016 SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla administrators console with accents and all:...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the following XML node: 2 -> yields issue: PHP Warning: simplexml_load_string(): 2 in /home/public_html/my_folder/my_xml_processing_script.php on...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 and copy for commenters and viewers :: Set by "copyRequiresWriterPermission" = true To do this, set the metadata to the following in the above function: { "name": "'.$name.'", "parents": ["'.$folder.'"], "description": "'.$desc.'",...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 !file_exists($STORE_PATH)) $credentials = storeCredentials($STORE_PATH, $credentials); return $credentials; } Include the following at the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials =...

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

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 You have an access token, your service account can connect directly with its Google Drive. To get a file listing, try the following: // Get File List $url = $api['gapis']['drive']['files']; $header[] = 'Content-Type: application/x-www-form-urlencoded';...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 F5 to run the code. A separate file will be created for each sheet in the same folder. A combined all-in-one solution The following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then paste the below...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 where you enter your own email address and zoho password. Determine the EndPoint: Following the syntax: https://creator.zoho.com/api////form//record/update where ownername is the owner, format is the type (I prefer JSON), applicationName is the name of...

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