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

20 October 2014 view) { // get current value for hint TextView currentName = (TextView) findViewById(R.id.hangar_aircraft_001_header); hangar_aircraft_name = currentName.getText().toString(); // get the AlertDialog XML layout file final View v =...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8'); mb_http_output('UTF-8');...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• 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 to several sheets within the same workbook. Inserts a blank row at the top of each of the created sheets. Copies the header from the first sheet into the top row of each created sheet. Splits each sheet to a separate XLS file. ' Purpose: In the Excel...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 with a background image and the logo floating over it at the center of the page as well as a logo fixed to the header of every page. The logo image was quite a big image at 2501x805 pixels. By resizing it to the final output size (464x99 pixels),...

• 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 I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 characters with an underscore. eg. "the_joel_lipman_app" Authentication Type: set this to "oauth2" Param Type: set this to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field....

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 m_Data.put("data",m_RecordData); r_RecordUpdate = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type :PUT headers: m_Header parameters:m_Data.toString() ]; when you should have done this (note that a list is submitted to data / could use...

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

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 "Tax" you will see both options available to be ticked, the same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this article, even having customized the tax...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 V_StripeLocationsEndpoint = " https://api.stripe.com/v1/terminal/locations"; // // set Stripe header m_Headers = Map(); m_Headers.put("Authorization","Bearer " + v_StripeCustomerKey); // // default to balance due on this Invoice v_AmountToPay =...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 R2), then yes, you won't need to use the database level solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group" then "Parent Group..." Specify the "Group by" (in my case "Day"),...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 a name, I'm calling mine "Products - Correct Decimals" Give it a description, I'm giving it the one I have in the function header below Category is "Module" Page is "Edit Page (Standard)" Module is "Products" Layout is "Standard" Event Type is "Page...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 enabled. Now return to the "General" tab of the top-left. There should be a new section in the menu further down with the header RokBB3 and two links: "Affinity" and "Global Configuration". You can set these to whatever, I found it has no bearing as to...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 the user to be able to select a date and then the report to return the month containing that date: I'm going to change the header from "Reinventing the wheel" to the Month and Year based on this parameter: Note that I've asked it to return the full date...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings (header&footer). Resolved this by clearing my web-browser's temporary files. Do we instruct all users viewing the reports to do...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 } Method #5: MS-DOS Command Prompt dir c:\*.* /os /s -- bear with me as i try to create a for loop one to omit all the header info

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 to LOG file as UNICODE (append to existing log). /TEE :: output to console window, as well as the log file. /NJH :: No Job Header. /NJS :: No Job Summary. /UNICODE :: output status as UNICODE. :: :: Job Options : :: /JOB:jobname :: take parameters from...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 '') AND (@GivenRef'' OR @GivenForenames'' OR @GivenSurname'' OR @GivenDOB'') For usability, we put a message just below the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit to 100 records...

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

Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request to the server xhr.send(); // return...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 urlencode(implode(' ', $SCOPES)), urlencode($REDIRECT_URI), urlencode($CLIENT_ID) ); header('Location:' . $url); } // request access token function requestAccessToken($access_code) { global $GAPIS, $CLIENT_ID, $CLIENT_SECRET, $REDIRECT_URI; $url =...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 Some of you may be asking why not use openUrl with a popup parameter, such as: openUrl("#Form:My_Confirmation_Popup?zc_Header=false","popup window","height=144,width=555"); The reason being, is that the top solution offers a very generic popup box that...

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