Tuesday, 8 July 2014

Using Mozilla Webmaker to create a map of all Gurdwaras (Sikh Temples) in Bradford, UK

No comments:
I have created a map of all the Gurdwara Sahibs in Bradford. It uses leaflet.js and openstreetmap for the mapping. It was all created in Mozilla Thimble which allows for easier javascript and html editing through an online editor.

Monday, 7 July 2014

Geocoding address data in Excel using google Geocoding API

I had a long list of addresses that I needed to show on a map. I found a great article that showed exactly how to call googles geocoding mapping from Excel.

The only issue I had was that Googles API doesn't like it if too many requests are made too quickly so I created a function to add the geocoding calculation into a column one cell at a time and waiting one second between calls.

Below is the function

Sub Geocoding100()
    Dim I
    For I = 1 To 100
        ActiveCell.FormulaR1C1 = "=GoogleGeocode(RC[-1])"
        ActiveCell.Offset(1, 0).Select
        Application.Wait (Now + TimeValue("00:00:01"))
        Next I
End Sub
I can leave this function running in the background to geocode a list of addresses in excel and I am not hammering Google Geocoding API.

Its a win win situation!

Tuesday, 3 December 2013

Hyper-V 2012 R2 Export / Backup Script

No comments:
Our backup tool of choice for our virtual infrastructure is Acronis Backup and Recovery Virtual Edition 11.5. However recently we had issues with it on our new Hyper-V 2012 R2 Servers.

We needed some backups while we fixed the issues with Acronis so I created this powershell script to export all the vms on each of our Hyper-V servers.

The script loops through all virtual machines on the local Hyper-V server and exports the virtual machine to the backup location specified in $path. The exported files are stored in a folder named with todays date inside a folder with the name of the virtual machine.

Example \\[path backup location]\testVM\2013-12-03\

--Start of script--

$path = ""
$vms = Get-VM
foreach ($vm in $vms) {
    $date = Get-Date -format “yyyy-MM-dd”
    $vmname = $vm.Name
    New-Item -ItemType Directory -Path $path\$vmname\$date -Force
    Export-VM -Name $vmname -Path $path\$vmname\$date\

--End of script--


This script has only been used on Hyper-V 2012 R2 servers as this version allows virtual machines to be exported while the virtual machine is running.

I have had to run the script on the local Hyper-V server. It doesn't work when ran from a remote console.

As with any script please test it before using in production as there is no warranty with this script.

Hope it helps some one.

Tuesday, 3 July 2012

Access 2000 web page showing HTTP 500 internal server error

No comments:
We had to move our web server to a new Windows 2008 R2 server.

Everything copied over ok using Web Deploy to copy over IIS settings.

We had a problem with a website that had an Access 2000 backend database.

  • Connection issues
  • HTTP 500 internal server errror


Connection issues

Firstly it wouldn't connect at all. We found that this was due to the Win 2008 not having the correct Jet drivers. (It has changed to ACE).

HTTP 500 internal server errror

The next issue was that some pages were showing Server 500 errors when users clicked on them. It looked to be when users were trying to modify the database. In one case the issue was due to the database file becoming read only when it was moved to the new server. and in the other case it was because the lock file (.ldb) file had been copied over with the main database file. Once the lock file was deleted it all started to work as it should.

Hope this saves people some time

Sunday, 3 June 2012

Plain text email not wrapping correctly

No comments:
It has been a while!

Now that summer have finally arrived in the UK I thought I should come out of my blogging hibernation.

Here is an interesting one to start with.

At work i have been developing a system that requires a log to be emailed to users. For this particular application I was developing in Delphi but the same problem seems to occur with many other languages.

The problem was that any emails that were sent from my system were stripped of there line breaks. At first I thought that the issue was in Delphi. After a bit of debugging I found that delphi was send the information correctly as separate lines. Even the outlook notification was displaying the line breaks correctly. However when the full email was opened all text appeared on one continious line.

After a frustrating few hours I found a stackoverflow post.

Some of the solutions suggested were:
  • Convert the email to HTML format so that '
    ' breaks can be inserted when required.
  • Add extra \r\n at the end of each line
  • Add %0D%0A at the end of each line
  • Add a (.) dot at the end of each line.
  • Re instated line breaks in Outlook by going into Format -> Unwrap text when viewing the email.
I decieded to go for the dot solution and it worked fine.

Hope this helps someone.