Restart Jenkins from Web Interface

Navigate to:

  • [jenkins_url]/safeRestart.   – This will restart Jenkins after the current builds have completed.
  • [jenkins_url]/restart  - This will force a restart. Builds will not wait to complete.
0

Microsoft Office installs” when opening a file

Does Office appear to install every time you try to open a document or you see a configuration dialog.

Open run (Press Windows Key + R) and paste in the correct line for your version of Office and the troublesome application.

For Office 2010

Run the command for the application giving you trouble

  • reg add HKCU\Software\Microsoft\Office\14.0\Word\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\14.0\Excel\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\14.0\Access\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\14.0\Powerpoint\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\14.0\Outlook\Options /v NoReReg /t REG_DWORD /d 1

For Office 2007

Run the command for the application giving you trouble

  • reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\12.0\Excel\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\12.0\Access\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\12.0\Powerpoint\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\12.0\Outlook\Options /v NoReReg /t REG_DWORD /d 1

For Office 2003

  • reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\11.0\Excel\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\11.0\Access\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\11.0\Powerpoint\Options /v NoReReg /t REG_DWORD /d 1
  • reg add HKCU\Software\Microsoft\Office\11.0\Outlook\Options /v NoReReg /t REG_DWORD /d 1
0
Always open IE 10 in Desktop Mode

Always open IE 10 in Desktop Mode

While I do use Windows 8 I find that I often work in Desktop Mode. One thing I found is that I always want Internet Explorer to open in desktop mode. If you are like me. Here is how

  • While at the Windows 8 Start menu Search for Internet Options
  • Select Settings on the right hand side

Windows 8 Internet Options

  • When the internet option window appears
  • Navigate to the program tab

Internet Explorer 10 Internet Settings

  • Change the Choose how to open links settings. I set mine to always open on the desktop.
0

.NET Multiple Line Regex

Recently I was trying to use a Regular Expression in .NET. I was working with small blobs of text. I was trying to extract some code snippets out of some wiki markup.

The code snippets looked like:

{code:csharp|title=C#}
//C# Code
{code}
{code:vbnet|title=vb.net}
//VB.NET Code
{code}

For testing purposes I was using the simplest Regex I could think of {code:(.+?){code}. After playing around it became obvious that it was not matching over multiple lines. This makes sense because the ‘ .’ character  matches every character except /n/r

Well it turns out you want to enable SingleLineMode not MultiMode.  I know I know makes a ton of sense.

Lesson learned. Read the documentation.

Extra Bonus: If you want to quickly test .NET regular expressions with all these options. I found I like http://derekslager.com/blog/posts/2007/09/a-better-dotnet-regular-expression-tester.ashx

0

MYSQL cross table update

So today update data cross table in a MYSQL database. It took me way longer than it should have.  I spent way too much time trying to get my join to work only to continue getting syntax errors.  So long story short. If you are doing a cross table update in MYSQL you cannot use a join. Rather you must use WHERE a simple example looks like:

UPDATE TableToUpdate, TableToPullInfoFrom
SET
TableToUpdate.col1 = TableToPullInfoFrom.col1,
TableToUpdate.col2 = TableToPullInfoFrom.col2,
TableToUpdate.col3 = TableToPullInfoFrom.col3,
TableToUpdate.col4 = TableToPullInfoFrom.col4
WHERE TableToPullInfoFrom.id = TableToPullInfoFrom.id

And I will just leave this here so I don’t make that mistake again.

0