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 dialog, int which) { dialog.cancel(); } }); b.setView(inflater.inflate(R.layout.dialog_edititem_photo, null)); b.create().show(); } @Override protected void onActivityResult(int requestCode, int resultCode, Intent data) { // if taking if (requestCode ==...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 */ public class MapFragment extends Fragment { MapView mMapView; private GoogleMap googleMap; @Override public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { // inflate and return the layout View v =...

• 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 A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• 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 curl_close($ch); // convert the response to xml $xml_result = simplexml_load_string($ch_result) or die("Error: Cannot create object"); // convert the xml to json $json_result = json_encode($xml_result); // print the json echo $json_result; // [OPTIONAL]...

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

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 JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your Joomla v2.5.x database and website...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 You should find your code now previews at a normal font size. Step #2 Create your template without uploading images and style with your CSS. Step #3 Resize the images with a separate program that you want to use in the template and try to set them to...

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

CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image filling the page with a logo floating at the centre) and the next...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the database accessible only by root and and this...

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

Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal...

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

PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first thing I did was to create the logic: // default $author_name_disp=$author_name; // check and transform if(strpos($author_name, ' ')!==false){...

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

Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://www.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

06 February 2015 I know This is based on if you have another user account (registered or administrator, any) with a password known to you (create a new joomla user if necessary). The gist: Login to your Joomla database Go to the #__users database table (where #_ is the...

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

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 is unique in the database. Ok that's a long sentence; let me try this: When I save a record in JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I want that Why? These are used as inputs to server-side scripts for the sake of...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Quit trying to generate an authtoken v1 (CRM Deprecation Sunset Date: 31st December 2019). Go to the Zoho Developer Console Create a Zoho Client ID Either use self-client for a code or use the below to generate one. Code Here you will need your own...

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

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 m_Accounts = Map(); m_Products = Map(); // // loop through each row for each r_StockRecord in Stock_Upload[ID != 0] { // // create map entry for account if(m_Accounts.get(v_Email) == null) { m_Products.put(v_SKU,0); m_Accounts.put(v_Email,m_Products); }...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 Creator record into Zoho Inventory via an invokeURL with API v2 rather than a connector. If you use POST then this adds/creates a record and if it already exists you will get a {"code":1001,"message":"Item \"...\" already exists."}. Documentation...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 DefltDir:= A_ScriptDir ; -------------------------------------------------------------------------------------- ; Create GUI Gui, New, %Options%, %Title% v%Version% Gui, Color, %BgColor% Gui, Font, s8, Verdana Gui, Add, Button, Default w110 h30 x10 y10...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 methods. Method #1: Display and access without login So the quickest is to have a form that has an image upload field. Create an entry with one image. Then... Go to Settings Publish Publish Component > Select your report Copy the embed code it pops up...

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