Google Drive – Google Sheets – Pasting Tables

 

Background

We all take for granted how seamlessly Microsoft Products work together.

Take for instance, I use Microsoft SQL Server Management Studio to run a query and I will like to prepare a document from the query’s result.

I simply copy the Output Grid’s content, launch Microsoft Word or Excel, and pasted it.

Through the magic of OLE or whatever they call it these days, the data is well received and formatted in the receiving Office App.

 

Google Drive

These days my main sharing tool is WordPress for public consumption and Google Docs for private data.

 

Here is the genesis of our Problem

SQL Server Management Studio ( SSMS )

Grid

Here is output of a query I ran in SSSM

ssms

Explanation

  1. Nice and visually appealing for an Engineer

 

Google Drive – Google Docs

Here is what things look like when pasted into Google Docs..

copiedintogoogledocs-20170120-1031am

 

What to do

  1. Looked for Convert to Table
  2. Insert Text as table
  3. Import Text

 

Nothing helpful.

 

Solution – 01

Google Drive – Google Sheets

Created a new file, rather than Document went with Sheets

copiedintogooglesheets-2017012-1039am

 

Explanation

  1. Making progress
    • Kept the grid or columns paradigm
    • That is things are not jumbled well, with text intertwined together

 

Google Drive – Copy From Google Sheets Into Google Docs

Here we copied the cells from Google Sheets Into our original Google Docs

copiedfromgooglesheetintodocs-20170120-1044am

 

Explanation

  1. Thankfully things are kept neatly arranged in a Columns
  2. Need to get rid of some extra columns and that is doable

 

Google Drive – Google Docs – Table – Delete Extra Columns

Got rid of the extra columns using the menu item Table / Delete Columns.

Steps

  1. Inside the Google Doc
  2. Select the extra columns
  3. And, use menu item Table / Delete Columns

 

googledocs-columnsdeleted-20170120-1053am

Format the Table

One of the great things about these Google Products such as Chrome and Google Drive is that they are extensible and have such a nice and rich 3rd party ecosystem.

 

Adds On

Table Formatter

I already have Table Formatted installed and so let us initiate it by accessing Google Docs menu items “Add-ons” \ “Table Formatter”.

 

Google Docs – Menu – Add-Ons

addson

 

Add-On – Table Formatter – Default Templates

Here are some of the Default Templates available

tableformatter-20170120-1057am

Customize Table with Add-On – Table Formatter

Select the Google Docs’s tale and choose the one of the Formatting Choices.

Here is our colored layout.

googledocs-tableformatted-20170120-1103am

 

Summary

  1. Copy SSMS Grid Data into Clipboard
  2. Create a new Google Sheet ou use existing one
    • Paste copied into Sheet
  3. Create a new Google Doc
    • Select data from Google Sheet
    • Copy into Clipboard
    • And, paste into Google Doc
  4. In Google Docs
    • Using 3rd Party Add Ons such as Table Formatter format Table

Solution – 02

Outline

  1. Copy SSMS Grid output into Clipboard
  2. Use Microsoft Excel
    • Launch Microsoft Excel
    • Copy Grid’s data into Excel
    • If you like the way Excel Formats Table, use Excel’s Table Formatting functionality
      • Using F8, make Sheet’s column into actual table
        • Be sure you have Column Headers and all
  3. Create or use New Google Docs
    • Copy Table’s content from MS Excel
    • Paste into Google Doc

 

In MS SSMS, Copying with Headers

ssms-copywithheaders-20170120-1126am

Explanation

 

In MS Excel, Pasted SSMS Grid

excel-pastedgrid-20170120-115am

 

In MS Excel, Create Table

Here is the panel displayed upon clicking on F8 and thus initiating the “Create Table” options

createtable-20170120-1119am

Explanation

  1. Please pay attention to the “My table has headers” option

 

In MS Excel, Formatted Table

excel-createtabled-20170120-1120am

Chrome on Older OSes ( MS Windows 2003 )

Background

One of the side-effects of auto-updated software such as Google’s Chrome is one no longer has access to the Install Binaries.

If you find yourself needing to download and install Google Chrome on an out of service OS, please take to the Internet and search out an offline installer.

Here are ones I have found for the last available version of Chrome for MS Windows 2003.

BTW, the version of MS Windows 2003 is 49.0.2623.112.

 

Download Links

Version = 49.0.2623.112

Installers

Web Site Write Up Targeted OS Media
offlineinstallerfilehippo.com Link
 x32 Link
 x64
Link
Software Mirrors Link Link

 

 

 

Application Files

The media listed here are not the actual installers, but the application files themselves.

 

The app files are bundled into a self ex-tractable exe.

Web Site Write Up
SlimJet  Link

 

 

SlimJet

Here is how SlimJet describes its delivery mechanism:

Link
The old versions of Chrome are packed as 7zip self-extracting executable. Just run the executable and extract the files under any folder on your hard drive. Then launch Google chrome with chrome.exe under the extraction folder.

SlimJet has files for the following OSes:

  • Microsoft ( 32 bit and 64 bit)
  • Linux ( Ubuntu & Debian )
  • Mac OS

Older Versions

Web Site Write Up Versions Available
Old Versions Link Google Chrome 0.2.149.27 Beta – 46.0.2490.80

 

 

 

YouTube – Upload – “Stuck at Processing 95%”

Prelude

Trying to upload a video segment to YouTube, but the upload is stuck at 95%.

 

Error Message

Image

Processing95Percent

Textual

Processing 95%

 

Download Video Segment

Using ClipConverter.cc

Went to http://www.clipconverter.cc/ and entered the YouTube’s video URL, entered the begin and end time.

Here is the screen progress

Enter Video Segment

DownloadYouTubeVideoSegment

 

Confirm Video Segment

DownloadSegment

 

Conversion Progress

ConversionProgress

 

Conversion Successful

ConversionSuccessful-AVI

Save As

SaveAs

 

Upload Video Segment

Use YouTube

Nothing fanciful here, just using YouTube’s own Video Upload Utility  to upload the download AVI file.

No Error Message…Yet stuck at 95%

StuckAt95Percent

Btw, the URL for Youtube’s Upload is https://www.youtube.com/upload.

 

Workaround

A good workaround is to return back to http://www.clipconverter.cc/, enter the URL and Video’s start and end time.

But, use a different video download format.  In our case, we choose MP4 as Conversion Format.

Using ClipConverter.cc

Enter Video Specification

EnterVideoURL

 

Confirm Specification

ConfirmSpecification

 

Processing

Upload-Processing

Complete

UploadComplete

Summary

So http://www.clipconverter.cc/ works well to capture youtube videos.  But, one might have to try a different format.
We were trying AVI, but we needed to use MP4.

Google – Chrome – Left over installation files

Background

Ever so often Google’s Chrome install fails and leaves behind huge install files.

Let us see how to identify and remove some of those files.

 

Folder

Depending on the bitness, 32 or 64 bit, the location we will be dealing with will vary.

  1. 32 bit
    • C:\Program Files\Google\Update\Install
  2. 64 bit
    • C:\Program Files (x86)\Google\Update\Install

Files

MS Windows

Using Window Search, here are the files we identified

NumerousInstallerFiles

 

Space Sniffer

GoogleInstallAndUpdateFiles

 

Files Details

Installer

GoogleInstallFileNarrow

Update

GoogleUpdateFileNarrow

 

Accumulated File Size

PowerShell



Function sizeFolder($path) # Return the size in MB.
{
    $objFSO = New-Object -com  Scripting.FileSystemObject
    ("{0:N2} MB" -f (($objFSO.GetFolder($path).Size) / 1MB))
}

$path = "C:\Program Files\Google\Update\Install"

sizeFolder $path


Output:

PowerShellFolderSize

Remove Files

Dos Batch:


@Rem Remove Installer Files
dir "C:\Program Files\Google\Update\Install\*_Chrome_Installer.exe" /s
del "C:\Program Files\Google\Update\Install\*_Chrome_Installer.exe" /s

@Rem Remove Updater Files
dir "C:\Program Files\Google\Update\Install\*_Chrome_Updater.exe" /s
del "C:\Program Files\Google\Update\Install\*_Chrome_Updater.exe" /s

Revisit Folder Size

Output:

PowerShellFolderSizeAfter

 

Special Mention

Though, the point is clearly missed here, but I really do like the SpaceSniffer software; as it is very good at locating storage hoggers when they are hidden in nested locations or just spread across various relatively smaller files.

The interface is nice and it really should not be freeware, but for the heart of Uderzo Umberto.

Maintaining Windows Installer SecureRepairWhitelist through Powershell

Background

Here is a quick follow-up to a recent post, where we discussed options for getting rid of a pesky MS Windows Installer error “Product: Google Update Helper — Error 1260. Windows cannot open this program because it has been prevented by a
software restriction policy“.

Original Remediation

The redemptive process involved setting RemappedElevatedProxiesPolicy to 1.

 

Re-Install/Install Microsoft Hotfixes

Let us go ahead and install the “problematic” Microsoft hot-fixes that we studiously avoided last time.

  1. Security Update for Windows Server 2003 ( KB3072630 ) [ released on 2015-July -15 ]
    https://www.microsoft.com/en-us/download/details.aspx?id=47959

 

Opt-Out Affected Programs

Forward

Another option is to opt-out selected applications.

 

Code Analysis

  1. Launch Registry
  2. Transverse to
    HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer
  3. Add / Update new key named SecureRepairPolicy to 2
  4. Add the MSI’s product code for each application that you will like skip

 

Configuration File and Code

Configuration File


<?xml version="1.0"?>
<?xml-stylesheet type='text/xsl' href='style.xsl'?>
<!--Product Key List-->
<ProductKeys>
 <!--Google Update Helper 1.3.26.9-->
 <Product GUID="Google Update Helper 1.3.26.9">
  <Vendor>Google Inc.</Vendor> 
  <ProductName>Google Update Helper 1.3.26.9</ProductName>
  <ProductGUID>{60EC980A-BDA2-4CB6-A427-B07A5498B4CA}</ProductGUID>
  <CodeSegment info3="another attribute">
	<![CDATA[this is untouched code and can contain special characters /\@<>]]>
  </CodeSegment>
 </Product>
</ProductKeys>

Powershell Script

The Powershell script has been been uploaded to https://github.com/DanielAdeniji/SecureRepairWhitelist.

Summary

I have yet to sufficiently test out this code.

In fact, it has been only been minimally tested on two machines running MS Windows 2003.

We fixed our problem using the option described earlier.

In retrospect, the approach Microsoft offered as a workaround is likely a better option as it balances MSFT offering of a stronger system with the needs of individual Vendors and Applications.

 

Addendum

2015-Sept-26

  1. Added some bug fixes
  2. Last Google Chrome update gave us an actual opportunity to see bug recurrence and thus actually test code
  3. Removed code from posting and posted to GitHub

Google Update Helper – Error 1260 – Windows cannot open this program because it has been prevented by a software restriction policy

Background

While chasing down another bug returned back to my Event Viewer and noticed many entries bearing failed “Google Updates“.

Error Message

Listing:

EventViewer-Errors

 

Explanation:

  1. So basically every hour, specifically at the 55th minute, we are registering an error.

Textual:


The description for Event ID ( 11260 ) in Source 
( MsiInstaller ) cannot be found. 

Product: Google Update Helper -- Error 1260. Windows cannot open this program because it has been prevented by a 
software restriction policy.

 

Visual:

EventViewer-Error-EventID-11260

 

Google Search

Google Matches

Performed the per-functional Google Search, and here is what keep came up:

  1. “Windows cannot open this program because it has been prevented by a software restriction policy” error message when a user tries to open a file in Windows Server 2003
    https://support.microsoft.com/en-us/kb/873419

    • Advapi32.dll
      • 5.2.3790.199
      • File Date :- 17-Aug-2004

 

Download & Install

Downloaded and attempted install of the KB 873419.

Receive the message pasted below.

Textual:

Setup has detected that the Service Pack version of this system is newer than the update you are applying.

There is no need to install this update.

 

Image:

KB873419Cropped

 

Google Some More

After a while googled some more.  And, found more promising leads:

  1. ECI DDMS – Removing Windows Security Update KB2918614 & KB3072630
    http://support.ecisolutions.com/doc-ddms/keyop/setup/RemovingWinSecurityUpdateWinServer2003.pdf
  2. IBM – Error 1260. Windows cannot open this program because it has been prevented by a software restriction policy.
    http://www-01.ibm.com/support/docview.wss?uid=swg21690353
  3. SolidWorks

 

Steps

Overview

So following the instructions carefully detailed in the posting by ECI DDMS, here is what we did:

  1. Accessed Windows Registry and enable RemappedElevatedProxiesPolicy
  2. Ensure that hotfix KB3072630 and corresponding hotfixes are no longer offered

 

Windows Registry Change

Accessed registry branch “HKLM\SOFTWARE\Policies\Microsoft\Windows\Installer” and added/set registry entry for RemappedElevatedProxiesPolicy to 1

Script

Read Value


@REM Reg query
@REM https://technet.microsoft.com/en-us/library/Cc742028.aspx
@REM HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer RemappedElevatedProxiesPolicy
set "keyName=HKLM\SOFTWARE\Policies\Microsoft\Windows\Installer"
set "valueName=RemappedElevatedProxiesPolicy"
reg query %keyName% /v %valueName%


Output:

readRegistryOriginal

Effect Change


@REM Reg add
@REM https://technet.microsoft.com/en-us/library/Cc742162.aspx
@REM KeyName = HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer 
@REM Item = RemappedElevatedProxiesPolicy
set "keyName=HKLM\SOFTWARE\Policies\Microsoft\Windows\Installer"
set "valueName=RemappedElevatedProxiesPolicy"
set "valueType=REG_DWORD"
set "value=1"
reg add %keyName% /v %valueName% /t %valueType% /d %value%

 

Output:

RegistryOriginalWrite

 

GUI

GUI Original

GUIOriginal

 

GUI Revised

GUIRevised

 

Say No to KB2918614

There are a couple of avenues that are available for availing KB2918614.  Inclusive are:

  1. Desktop Automatic Updates
  2. Microsoft Update Web Site
  3. Corporate

KB Hotfixes

There are corresponding updates that we need to say No to, as well.  Here is the current list:

KB Title Date
KB3072630 MS15-074: Vulnerability in Windows Installer service could allow elevation of privilege: July 14, 2015 2015-July-14
KB2918614 MS14-049: Description of the security update for Windows Installer Service: August 12, 2014 014-August-12

 

 

Desktop Automatic Updates

Access “Automatic Updates” via your Desktop status panel.

StatusPanel

Automatic Updates

Choose updates to install

Here is the “Choose updates to install” window once we unchecked “Updates for Windows Server 2003 (KB2661254)”.

HideUpdates

Hide Updates

Please check “Don’t notify me about these updates again”.

HideUpdatesAfter

 

Repeat

Please repeat same for hot-fixes listed in this post.

 

Issues

Microsoft’s acknowledges there are issues with the KB hotfix.

  1. After you install this security update and try to install any MSI package that uses a mandatory or temporary user profile, the MSI package installation fails, and you receive an error message that resembles the following:
    • The profile for the user is a temporary profile
    • MSI Log :- SECREPAIR: A general error running CryptAcquireContext / Crypt Provider not initialized. Error:-2146893813
  2. After you install this security update, you may receive a User Account Control (UAC) prompt when you try to use remote deployments, centralized deployments, or other local methods to reinstall a program that was already installed before the security update was installed.

 

Workaround

Microsoft’s workaround includes using a tool such as ORCA to get the application’s product code.

Once the code is known one can register that product and others under the SecureRepairWhitelist key.

The operability of this approach is a bit reliant on vendors ensuring that their Application’s product code stays same through maintenance and patches.

 

Summary

MSFT continues to be under intense pressure to protect its surface area. Unfortunately, sometimes that will involve breaking working approaches and applications.

And, force vendors to return to Redmond and work towards new working API and understanding.

YouTube – Upload Audio Files – Using Microsoft Movie Maker (v2012)

Background

It seems easy enough.  There are some audio files that I will like to upload to YouTube.

But, Youtube is kicking back that it does not accept Audio Files.

 

Error Message

Image

TheFileYouUploadedContainsOnlyAudioAndNoVideo

 

Textual

The file you uploaded contains only audio and no video. Learn how to easily convert your audio track to a video file type.

The hyperlink directed us to:

Convert audio and image files into a format that will work on YouTube

Microsoft Movie Maker – v2012

Movie Maker is bundled as part of Microsoft Live Essential.

Depending on my OS, I will need a different version of Live Essential.

OS Matrix and Software Version

http://windows.microsoft.com/en-us/windows-live/essentials

OS  Product Version Availability
 Windows 8.1, Windows 8, and Windows 7 Windows Movie Maker 2012 ( Windows Essential 2012 ) Available
 Windows Vista Windows Movie Maker 6.0 for Windows Vista (  Windows Essential 2011 ) Bundled in Vista
  Windows Vista  Windows Movie Maker 2.6 for Windows Vista Available
 Windows XP  Windows Movie Maker 2.1 Bundled as part of MS Windows XP SP2 and SP3

 

 

Download Location

Thankfully, On a blog post, Microsoft’s Aviraj Ajgekar provided a link for Windows Essential 2012.  The link is http://g.live.com/1rewlive5-all/en/wlsetup-all.exe

 

Installed Application

Downloaded and installed Application.

 

Usage

Here are quick steps on how to create a video file out of an audio file.

  1. Avail Audio File
    • For us, we downloaded Ray Stedman’s Audio file on Prayer
  2. Select a background image
    • Choose Ray’s picture from Googling his name
  3. Launch Windows Movie Maker v2012
    • Choose to create a new project ( File / New Project )
    • From the menu access the “Add videos and photos” icon ( AddVidoesAndPhotos )
      • From the File menu, navigate to the folder where our photos were placed
    • From the menu access the “Add Music” icon ( AddMusic )
      • From the File menu, navigate to the Folder where our audio ( mp3 ) files were placed
    • Get duration of the Audio
      • Double click on the Audio
      • Context sensitive information on the selected media is shown at the top of the Application
      • Here is what ours look like ( when we selected the green audio strip )
        GetDurationOfAudio
      • Note the Start and End Point; in our case 0s and 1776 s
    • Set the duration of the Picture element to be same as the Audio
      • Double-click on the Picture Element
      • Again, the top panel reflects specificalities of the chosen element
        pictureDurationInitial
      • Match the duration
      • Here is what our screen looks like, post matchpictureDurationSet
  4. The window changes to reflect the fact that we have extended the duration of the pictures
    PostPictureSizeChange
  5. Save the movie via the “File” \ “Save Movie” menu option
    SaveMovie_v2
    Of course, we chose “YouTube”

Images

A little out of place, but here are the pictures we took.

Picture Added

AddedPicture

Audio  Added

AddedPictureAndLaterAudio

The difference between this image and the one preceding it is the AudioAdded

 

Upload

We now have a good, well package mp4 file that YouTube will allow us to upload as a movie.

Result

Here are Ray Stedman’s Audio artifacts that we are able to package as video (mp4) files.

Media Audio Video
Ray C. Stedman – The Cirmcumcised Life Audio Video
Ray C. Stedman  – How Prayer Works Audio Video
Ray C. Stedman –  The Furnace and the Lamp Audio Video