New option in revenue report: totals by type

We've added another option in the revenue report to let you show revenue by type (room, extras, or adjustments):

When you select to total by Type, you'll see one line in the table form "Rooms", then a line for each extra, and a line for adjustments.

This will make it much easier to track spending on different types of extras.

*****

Get your free one-month trial of KeepMeBooked here. Sign up in 60 seconds, no credit card needed.

New report: list of bookings by date, room, etc.

You'll find a new report called "Bookings" under the reports menu. This lets you show a list of bookings, filtered by various criteria:

 - Arrival date
 - Deparature date
 - Date the booking was created
 - Room
 - Status of booking (provisional, confirmed-but-not-paid-for, confirmed-and-paid-for, or cancelled)

This replaces the old Outstanding Balances report - you can still list bookings with balances outstanding by filtering for Confirmed (not fully paid), but the report now lets you list other types of bookings too.

(RESOLVED) Unexpected outage

Update at 1915: KeepMeBooked back up again at about 19:06 UK time, after down time of 1hr 40mins. That's the first time in two years we've had a full-on outage affecting all users. See final update below for detailed explanation of what happened

We are aware that KeepMeBooked is has been unreachable since about 1730 UK time (20mins ago). There is a problem at our host, BrightBox. They are aware and investigating.

Updates soon.

17:55: Update from BrightBox: It seems as if a switch stack has crashed – we’re getting it rebooted. ETA is currently 30mins. http://status.brightbox.co.uk/2011/10/internet-outage/

18:24 Still waiting for more info from datacentre

18:46 Update from our hosting partner, BrightBox: "We’ve ruled out the possibility of this being due to a DoS or a power failure. We’re still waiting on the switch stack reboot, which we now expect to be done within another 30 minutes (due to a communication failure regarding availability of the engineer – our apologies for the miscommunication)." http://status.brightbox.co.uk/2011/10/internet-outage/

19:07 Back up!

19:09 OK, connectivity has been restored. Two firewalls had crashed at the datacentre. More details to follow when we have them.

Update Monday 10th October:
Here's what happened, and why it took so long to resolve:

One firewall crashed. Ordinarily, that shouldn't be a big deal, because there is a secondary firewall in place to take over if the primary firewall fails.

But the secondary firewall crashed too.

Again, that shouldn't be a huge disaster, because BrightBox engineers should be able to access it remotely and restart it.

But BrightBox didn't have "out of band" access to the firewall. That is to say, their only way of remotely accessing the firewall to work on it was through the firewall. No firewall, no remote access.

(With other parts of our hosting system, BrightBox do have 'out of band' access, so even if the primary internet connection to the servers fails, they can still get in remotely through a backup connection. Not so with the firewalls.)

So BrightBox needed to rely on an on-site engineer in the datacentre to restart the firewall. That's what caused the delay - raising someone on-site to go and manually hit the restart button.

BrightBox will now put in place out-of-band access to the firewalls, so if both firewalls crash again, they will be able to remotely access the firewalls and fix them quickly, without needing to wait for someone physically at the datacentre to do that.

They have also updated some software on the firewalls, but are still investigating what caused them to crash in the first place.

(BrightBox's own explanation is here.)

Guest addresses now better organised

We've added some new fields for storing guest addresses. Before, you just had Address (for all of the address lines), Postcode / ZIP, and country.

You now have:

Address line 1
Address line 2
City / Town
State / Region
Postcode/ZIP
Country

These appear on the booking widget:

And on the booking details / guest details screen:

We've also done some clever jiggery-pokery to display local names for the City / State / ZIP fields depending on the country of the guest. So if your guest's address is in the USA, those three fields are labelled City, State, ZIP (as above). If they are in Canada, though, those fields are labelled City/Town, Province, Postal code:

And Town, County, Postcode for UK:

And City, State/Territory, Postcode for Australia:

Elsewhere, we use generic City/Town, State/Region, Postcode/ZIP:

(This doesn't work perfectly for all countries. Lots of European countries put the postal code before the town name for example, but it is a start. Hat-tip to Luke Wroblewski for those localisation tips)

You can also now set the guest's language from with the booking details screen (previously, you could only do that from the Guest screen).