Copying Syntax Highlighted Text From Notepad++

If you write SQL, you might often find that you want to copy some SQL from your SQL editor, e.g. TOAD or SQL Developer.

If you use TOAD, I think you can copy SQL from the editor window, and paste it into an email or a Word document, and the syntax highlight is preserved.

If you use SQL Developer, I haven’t found a way to do that – if you copy the SQL, and paste it into something else, you just get plain text.

I found you can do it using Notepad++, via an answer on Stackoverflow.

Instructions

Select the text, and go to Plugins > NppExport > Copy HTML to clipboard, though copying in RTF format also works just as well…

Here’s an example:

Starting with pretty SQL:

Select the text, and choose the relevant options in Notepad++:

Select and copy the SQL

Now paste into e.g MS Word:

Exported SQL preserving syntax highlighting

This works just as well for any other syntax highlighted text you might be writing in Notepad++.

Email search problem in Outlook 2016

I’ve been using Outlook 2016 for the past 11 months.

One thing that’s annoyed me about it is the fact that the search facility has not worked. I’d press CTRL + SHIFT + F to open the Advanced Find option.

Then run a search, making sure to click the Browse button, and select to include all sub folders.

Anyway, this is more for a note for myself.

I found a fix via this post on lookeen.com, which included a comment by Rachel Harrell-Harper which fixed the issue for me:

  1. Open Control Panel > Programs > Programs and Features
  2. Highlight your Office product
  3. Click change at top
  4. Click quick repair.

 

Unable to Sign in with Skype for Business: Certificate Error

Update 11th November 2017 – last week I also had to add live.com to the list of allowed sites on Open DNS, as our home Skype stopped working… I think I also added in skypeassets.com. Adding in these new ‘allowed’ sites fixed the Skype issue. Alternatively you could just disable the ‘Chat’ category in your Web Content Filtering section in Open DNS, but then that allows other sites in.

This week I have been working from home. When I connected my laptop to wifi, and tried to sign into Skype for Business, I received an error message:

Can't sign in to Skype for Business - there was a problem verifying the certificate from the server

Skype for Business Certificate Error

In the end, I remembered that we use Open DNS at home to add in some basic content filtering so that our kids can’t access unsuitable content when using Wifi (now they’re all old enough to have mobiles with 3 or 4G then maybe Open DNS is failrly pointless).

I found a query on the Office 365 URLs and IP address ranges about a similar issue. That pointed me to a page on the Office 365 website about Office 365 URLs and IP address ranges.

I already had these 2 domains whitelisted in my OpenDNS settings:

  • skype.com
  • skype.net

Once I added these in, the problem was solved:

  • cloudappsecurity.com
  • live.com
  • lync.com
  • microsoftonline.com
  • office365.com
  • onmicrosoft.com
  • skypeassets.com
  • skypeforbusiness.com

It might be that was overkill and that I didn’t need to whitelist all of them, but one or more of them being whitelisted fixed the issue.

BI Publisher menu.2007 Problem

Update, 17th October 2017 – I’ve since realised, after posting this, that the version (32 or 64 bit) of BI Publisher you download has to correspond to your version of Office, not Windows. As it clearly says on the BI Publisher Download page, e.g. “Oracle BI Publisher Desktop xxx for 32 bit Office on Windows“. A classic case of not reading the information on the page properly, and wasting hours in the process.

At work we’re using Word 2016. I wanted to install BI Publisher Desktop for a change request I was working on a Developer with.

I use a laptop running Windows 8.1. I wanted to check if it was running a 32 or 64 bit version of Windows so press Windows key + Pause Break (more shortcuts) to open the System dialog. That confirmed 64-bit.

Therefore I downloaded and installed the 64-bit BI Publisher, version 12.2.1.3.0.

Once installed I followed the advice from a post on Oracle Support which confirmed I needed to install the relevant MSI from C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\DotNetInstallFiles to make the “BI Publisher” tab appear in Word:

MSI Advice

I did that – installed TBAddInSetup64.msi and then when I looked in Word, I saw this on the BI Publisher tab:

Looks Wrong

The problem here is that instead of “Log On” on the far left, it said “menu2007.logon” and instead of “Sample XML” it said “menu2007.load_xml_data” and so on. If I tried to load XML data I got an error (I can’t remember which now).

I then tried all sorts, such as uninstalling the latest version of BI Publisher, trying older versions, mucking about with MS Office on Virtual Machines and so on.

At some point, I chanced upon installing the 32-bit version of BI Publisher, and the associated TBAddInSetup.msi installer for the Add-In, and then the toolbar loaded correctly:

Look It Works!

I’m putting this here, in case it saves anyone else about 4 or 5 hours…