That's because the download is an .sgb file and for .sgbs to show up you need to run in -dev mode and have them installed in the main CoH directory/ww2/data/scenarios/mp ... or whatever it was again

.
Either way, pm the creator and ask him to make an .sga.
Don't bother with the .sgb it's too much hassle.