Prince: Buy Prince:
'via Blog this'
Tuesday, January 31, 2012
Monday, January 23, 2012
Problems enabling SSL on AD - Active Directory
Problems enabling SSL on AD - Active Directory: "I've found that if I clean out the Local Computer\Personal store and the
Local Computer\Certificate Enrollment Requests store, and then REBOOT
THE AD machine, and then go through the procedure in the MS KB article,
that works successfully.
From what I can tell, after you remove the server cert, you HAVE TO
bounce the AD machine, otherwise, AD seems to still think it has the
server cert.
"
'via Blog this'
Local Computer\Certificate Enrollment Requests store, and then REBOOT
THE AD machine, and then go through the procedure in the MS KB article,
that works successfully.
From what I can tell, after you remove the server cert, you HAVE TO
bounce the AD machine, otherwise, AD seems to still think it has the
server cert.
"
'via Blog this'
Thursday, January 19, 2012
Saturday, January 14, 2012
Friday, January 13, 2012
Computer History Timeline
Computer History Timeline: "This History Timeline has been developed to provide a 'snapshot' of the famous people and
events during this historical time period. Important dates in a fast, comprehensive,
chronological, or date order providing an actual sequence of important
past events which were of considerable significance to the
famous people involved in this time period.
A full History Timeline...
Read on!"
'via Blog this'
events during this historical time period. Important dates in a fast, comprehensive,
chronological, or date order providing an actual sequence of important
past events which were of considerable significance to the
famous people involved in this time period.
A full History Timeline...
Read on!"
'via Blog this'
Monday, January 9, 2012
Delete duplicates in form responses - Google Groups
Delete duplicates in form responses - Google Groups:
function deleteDuplicates() {
// SET UP - Indicate sheet name & columns to look at
// eg. for each row, look at data in columns emailAddress & event to find duplicates
var DATA_SHEET = SpreadsheetApp .getActiveSpreadsheet().getSheetByName ("Sheet1");
var FIRST_COLUMN = 3;
var SECOND_COLUMN = 6;
///////////////////////////////////////////////////////////
//This script deletes duplicates in form responses
//By default, it keeps the last response submitted
///////////////////////////////////////////////////////////
var data = DATA_SHEET.getDataRange ().getValues();
var cleanupData = new Array() ;
var lastColumn = DATA_SHEET.getLastColumn ();
for (var i = data.length - 1; i > -1; --i) {
if (data[i][FIRST_COLUMN - 1] != "DO NOT COPY"){
for (var j = 0; j < i; ++j){
] == data[i][FIRST_COLUMN - 1] && data[j][SECOND_COLUMN - 1] == data[i][SECOND_COLUMN - 1] && j!=i) {
data[j][FIRST_COLUMN - 1] ="DO NOT COPY" ;
}
}
}
if (data[i][FIRST_COLUMN - 1] != "DO NOT COPY"){
cleanupData.unshift(data[i]);
}
}
DATA_SHEET.clearContents();
DATA_SHEET.getRange(1,1,cleanupData .length,lastColumn).setValues (cleanupData);
SpreadsheetApp.flush();
}
'via Blog this'
function deleteDuplicates() {
// SET UP - Indicate sheet name & columns to look at
// eg. for each row, look at data in columns emailAddress & event to find duplicates
var DATA_SHEET = Spreadsheet
var FIRST_COLUMN = 3;
var SECOND_COLUMN = 6;
////////////////////////////
//This script deletes duplicates in form responses
//By default, it keeps the last response submitted
////////////////////////////
var data = DATA_SHEET.getDat
var cleanupData = new Array(
var lastColumn = DATA_SHEET.
for (var i = data.length - 1
if (data[i][FIRST_COLUMN - 1
for (var j = 0; j < i; ++j)
//IF duplicates, mark those duplicates as empty
if (data[j][FIRST_COLUMN - 1data[j][FIRST_COLUMN - 1] =
}
}
}
if (data[i][FIRST_COLUMN - 1
cleanupData.unshift(data[i])
}
}
DATA_SHEET.clearContents();
DATA_SHEET.getRange(1,1,clea
SpreadsheetApp.flush();
}
'via Blog this'
Subscribe to:
Posts (Atom)