Applies To:
  • Microsoft Windows 10 Pro v10.0.18362
What?
This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice.

Why?
I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click...

How?
To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it:

What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).

My Data:
Account ID,Name,Phone,Record ID
1457102000000135533,Joel,00441234567890,1457102000000165989
1457102000000135566,Stanley,01709123456,1457102000000167543
1457102000000135608,David,00331234567890,1457102000000166795
My Excel:
Account ID	Name	Phone	Record ID
1.4571E+18	Joel	4.41235E+11	1.4571E+18
1.4571E+18	Stanley	1709123456	1.4571E+18
1.4571E+18	David	3.31235E+11	1.4571E+18

How?
Firstly, save the CSV file as text file (*.TXT).

What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).

How?
So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.

What?
This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet.

Why?
The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx).

How?
In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created in the same folder.

Applies to:
  • Windows Live Mail 2012
What?
A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new account will have all your mail.

The error
Unable to send or receive messages for the Hotmail (someone) account.

Subject 'your Microsoft Issue'
Server Error: 3219
Windows Live Mail Error ID: 0x8DE00005
Unable to send or receive messages for the Hotmail (someone) account.

Server Error: 3219
Server: 'https://mail.services.live.com/DeltaSync_v2.0.0/Sync.aspx'
Windows Live Mail Error ID: 0x8DE00005

How?
I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of screenshots:

What I have:
A CSV file exported from Excel along with double-quotes
label1,label2
item1a,item2a
item1c,"item2c,c"
item1b,item2b

What I want:
To read the file (stored on the server) and convert to a JavaScript array of objects
var my_object_array = [
     { my_col1_val: 'item1a', my_col2_val: 'item2a' },
     { my_col1_val: 'item1b', my_col2_val: 'item2b' },
     { my_col1_val: 'item1c', my_col2_val: 'item2c,c' }
];
What I want again:
  • Read a CSV file already uploaded with JavaScript
  • Populate a JS array with each row
  • Account for strings containing double-quotes (and commas to ignore)
  • Sort the resulting object array

How?

Related Articles

Joes Revolver Map

Joes Word Cloud

server   database   select   table   added   website   name   windows   version   page   content   copy   user   error   where   solution   work   parameter   list   report   used   site   find   search   html   need   could   time   following   first   system   source   zoho   mysql   script   note   uploaded   value   license   display   using   files   google   joomla   would   data   code   file   program   date   JoelLipman.Com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate
© 2021 Joel Lipman .com. All Rights Reserved.