If you have number of milliseconds since Unix epoch, for example 1724117711296, you can use the following Excel formula to convert it to date and time:
I created a fun little program a while ago. It updates my Outlook signature with the current temperature in Melbourne, Australia.
Here is C# source code:
The program fetches the temperature from Australia’s Bureau of Meteorology (BOM) website.
I created a Visual Basic Script to run so that I don’t see a black console window every time the programs gets executed:
Open Outlook options, switch to Mail tab and click ‘Signatures’ button:
Create a new signature and give it ‘Temperature’ name. Edit the Temperature.htm file in C:\Users\<your username>\AppData\Roaming\Microsoft\Signatures folder and make sure it has this line:
<p class=MsoAutoSig>Pavel<br></p>
Don’t forget to change Pavel to your name 🙂
Next, open Task Scheduler.
Create a new task
Define a schedule to run every hour from 7:11
Select .vbs file as ‘Program/script’
Now every time you create a new email or hit reply button you will see the temperature: — Pavel 15°
I use s3.exe command line utility to backup photos to Amazon Simple Storage (S3) and it works great.
I have lots of photos to backup: 900,000 files in 4,000 folders.
Obivously it is impractical to copy all files on every backup – it will take forever. s3.exe has exact feature that I need:
/sync is used with the put command and only uploads files that do not exist on S3 or have been modified since last being uploaded, based on the timestamp. It can be used alone or in conjunction with the /sub option for a fast incremental backup of a whole directory.
Here’s command line that I use for backups:
s3.exe put mybucket C:\photos\ /sub:withdelete /sync /acl:public-read /yes /nogui
Charges
When I started using S3 however I was surpised with the bill from Amazon.
Let’s open source code to see how backup is done. Here are relevant bits:
For each file s3.exe gets last modified date from the storage. If it is greater than last modified date of local file then no upload is performed.
Let’s do some calculations. To get last modified date s3.exe sends HEAD request. Amazon charges $0.01 per 10,000 HEAD requests. So I would end up paying $0.09 every time I perform backup. If I do it every day that’s $27 per month.
Let’s try to optimize it. How about this: for every local folder get the corresponding list of files in storage. Last modified date will be included in response. Now we’re going to issue about 4,000 LIST requests (1 for each folder). 1,000 LIST requests is $0.01 so that would be $0.04 in total. Or $1.20 per month – that’s saving of $25.80 – a big win 🙂
JavaScript Date constructor accepts number of milliseconds since Unix epoch (1 January 1970 00:00:00 UTC). Here’s C# extension method that converts .Net DateTime object to JavaScript date:
public static class DateTimeJavaScript
{
private static readonly long DatetimeMinTimeTicks =
(new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).Ticks;
public static long ToJavaScriptMilliseconds(this DateTime dt)
{
return (long)((dt.ToUniversalTime().Ticks - DatetimeMinTimeTicks) / 10000);
}
}
Usage:
var dt = new Date(<%= DateTime.Today.ToJavaScriptMilliseconds() %>);
alert(dt);
Aha! For IE7 you need to set title of the hidden iframe in addition to setting document title. So this is how you set page title:
document.title = "New title";
var iframe = $("iframe:hidden");
if (iframe.length > 0 && iframe[0].contentWindow && iframe[0].contentWindow.document)
iframe[0].contentWindow.document.title = "New title";
Updated demo should work correctly in Internet Explorer 7.
Let’s take previous demo and use jQuery BBQ plugin instead. Our goal is Ajax photo gallery that supports browser’s back button. We will display numbers instead of actual photos for now.
$(function ()
{
$(window).bind('hashchange', function(e) {
var i = parseInt(e.fragment, 10);
if (!isNaN(i))
switchTo(i);
});
$(window).trigger('hashchange');
});
function switchTo(i)
{
if ($("#number").text() == i)
return;
$("#number").text(i);
document.title = i;
if (i > 1)
$("#lnk_prev").attr("href", "#" + (i - 1)).removeClass("disabled");
else
$("#lnk_prev").removeAttr("href").addClass("disabled");
if (i < 20)
$("#lnk_next").attr("href", "#" + (i + 1)).removeClass("disabled");
else
$("#lnk_next").removeAttr("href").addClass("disabled");
}
Instead of handling click event we modify href attribute of the links. BBQ will fire hashchange event whenever we "navigate" to a new page. No need to prevent default processing – simple!
One gotcha to watch out for is changing page title. If you take naive approach and simply use document.title (like I did) to set page title you won't see your titles in the history menu in Internet Explorer 7:
Let’s say you want to build photo gallery. Something like this:
You want to open next and previous photos without page reload, using Ajax. One problem with this is that browser’s back button stops working. Fortunately, it’s easy to fix with jQuery Address plugin from Asual. I tried using this plugin and it worked very well. I’ve put together a simple demo.
For simplicity, let’s display just a number instead of actual photo:
Every time you click right arrow the number increases; left arrow decrements the number by one. Simple! Back and forward buttons should work. Also, it would be nice to have different titles in the history:
The code:
$(function ()
{
$.address.strict(false);
$.address.externalChange(function(e)
{
switchTo(e.value);
});
$("#lnk_prev").click(function(e)
{
e.preventDefault();
var i = $("#number").text() * 1 - 1;
switchTo(i);
$.address.value(i);
});
$("#lnk_next").click(function(e)
{
e.preventDefault();
var i = $("#number").text() * 1 + 1;
switchTo(i);
$.address.value(i);
});
});
function switchTo(i)
{
$("#number").text(i);
$.address.title(i);
}
The magic happens in click handler. $.address.value method changes page address and adds browser history point. You need to cancel navigation by calling e.preventDefault() — otherwise browser would follow the link and two history entries would get created.
Note that you need to disable plugin’s strict option, otherwise it would add slash symbol immediately after hash symbol, like this: #/11.
Invalid postback or callback argument.  Event validation is enabled using <pages enableEventValidation=”true”/> in configuration or <%@ Page EnableEventValidation=”true” %> in a page.  For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them.  If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.
That’s pretty long error message. I get this exception if I add items to drop-down control from JavaScript. The question is how to use ClientScriptManager.RegisterForEventValidation method?
First, let’s reproduce the problem. Create a new website and copy/paste this code:
If you select option “Three” sure enough, exception is thrown. To prevent it you need to supply all possible values for drop-down control:
protected override void Render(HtmlTextWriter writer)
{
Page.ClientScript.RegisterForEventValidation(dd.UniqueID, "3");
Page.ClientScript.RegisterForEventValidation(dd.UniqueID, "4");
Page.ClientScript.RegisterForEventValidation(dd.UniqueID, "11");
// and so on
base.Render(writer);
}
The exception is fixed but server variable for drop-down control is useless – it has no idea that you’ve added new item so dd.SelectedValue will give One, not 3. You need to read POST variable directly instead, like this:
