<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>yadUK - Effective Information System Solutions</title>
	
	<link>http://www.yaduk.co.uk</link>
	<description>Effective Information System Solutions</description>
	<lastBuildDate>Mon, 07 Sep 2009 08:11:27 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.8.5</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/yaduk" type="application/rss+xml" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><item>
		<title>Ownership of Intranets? Information Architecture.</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/-AMAZV5Gxkk/</link>
		<comments>http://www.yaduk.co.uk/2009/08/22/ownership-of-intranets-information-architecture/#comments</comments>
		<pubDate>Sat, 22 Aug 2009 19:26:22 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Arbitrary 'Stuff']]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=375</guid>
		<description><![CDATA[<p>I was passed a fantastic link to Joel Olesons&#8217;s blog post on the Microsoft Developer Network at:</p>
<p><a href="http://blogs.msdn.com/joelo/archive/2007/03/16/information-architecture-and-the-information-architect.aspx">http://blogs.msdn.com/joelo/archive/2007/03/16/information-architecture-and-the-information-architect.aspx</a></p>
<p>Though Joel&#8217;s post is essentially discussing the deployment of Microsoft Sharepoint in an Enterprise environment its essentially questioning the very core of what is an Intranet environment for <em>any</em> content management! Not only deloying technology but&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>I was passed a fantastic link to Joel Olesons&#8217;s blog post on the Microsoft Developer Network at:</p>
<p><a href="http://blogs.msdn.com/joelo/archive/2007/03/16/information-architecture-and-the-information-architect.aspx">http://blogs.msdn.com/joelo/archive/2007/03/16/information-architecture-and-the-information-architect.aspx</a></p>
<p>Though Joel&#8217;s post is essentially discussing the deployment of Microsoft Sharepoint in an Enterprise environment its essentially questioning the very core of what is an Intranet environment for <em>any</em> content management! Not only deloying technology but past/current Intranet structures too on whatever CMS!</p>
<p>Noted painfully is the central question missed time and time again of  &#8220;Who actually owns an Intranet?&#8221;. Large organisations inherently contain internal power struggles between various departments as a matter of course, but to miss the potential glue between these with a misconfigured and misunderstood &#8220;Intranet&#8221; is not only costly in technology itself, but also collaborative and  potential productivity that can be gained from having one in the first place. Siloed information architecture and strategy <em>is</em> the exact opposite of these key tenants.</p>
<p>Why do companies have an Intranet? Mostly because someone somewhere managed to convince those with the purse strings that it would increase these key tenants of collaboration and productivity or simply just in having a centralised communicative point. &#8220;Rhetorically&#8221; &#8230; why then are these points in their entirety lost and never fulfilled?</p>
<!-- AdSense Now! V1.59 -->
<!-- Post[count: 2] -->
<div class="adsense adsense-leadout" style="text-align:center;margin: 12px;"><script type="text/javascript"><!--
google_ad_client = "pub-6844882450581533";
/* 234x60, created 06/07/09 */
google_ad_slot = "5017993839";
google_ad_width = 234;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></div><a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F08%2F22%2Fownership-of-intranets-information-architecture%2F&amp;linkname=Ownership%20of%20Intranets%3F%20Information%20Architecture."><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/-AMAZV5Gxkk" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/08/22/ownership-of-intranets-information-architecture/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/08/22/ownership-of-intranets-information-architecture/</feedburner:origLink></item>
		<item>
		<title>Restart haldaemon and dbus Commands for CentOS 5.2</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/dtKMwhUtxF8/</link>
		<comments>http://www.yaduk.co.uk/2009/08/18/restart-haldaemon-and-dbus-commands-for-centos-5-2/#comments</comments>
		<pubDate>Tue, 18 Aug 2009 17:42:50 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Reference]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=374</guid>
		<description><![CDATA[<p>/etc/init.d/messagebus restart<br />
/etc/init.d/haldaemon restart</p>


<div class="adsense adsense-leadout" style="text-align:center;margin: 12px;">


</div><a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F08%2F18%2Frestart-haldaemon-and-dbus-commands-for-centos-5-2%2F&#38;linkname=Restart%20haldaemon%20and%20dbus%20Commands%20for%20CentOS%205.2"></a>]]></description>
			<content:encoded><![CDATA[<p>/etc/init.d/messagebus restart<br />
/etc/init.d/haldaemon restart</p>
<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F08%2F18%2Frestart-haldaemon-and-dbus-commands-for-centos-5-2%2F&amp;linkname=Restart%20haldaemon%20and%20dbus%20Commands%20for%20CentOS%205.2"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/dtKMwhUtxF8" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/08/18/restart-haldaemon-and-dbus-commands-for-centos-5-2/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/08/18/restart-haldaemon-and-dbus-commands-for-centos-5-2/</feedburner:origLink></item>
		<item>
		<title>Javascript English Stoplists / Stopwords</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/-vmnwgSVcnA/</link>
		<comments>http://www.yaduk.co.uk/2009/08/03/javascript-english-stoplists-stopword/#comments</comments>
		<pubDate>Mon, 03 Aug 2009 12:18:44 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Reference]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=373</guid>
		<description><![CDATA[<p>Not listed verbs, adjectives nor articles but the below arrays are very handy should one be running language based queries over rendered pages.</p>
<p>Why? I dunno &#8230; say you&#8217;re trying to make a tag cloud or something but it&#8217;s full of filler words!</p>
<p>Articles are &#8220;a&#8221;, &#8220;an&#8221; and &#8220;the&#8221; only for English.&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Not listed verbs, adjectives nor articles but the below arrays are very handy should one be running language based queries over rendered pages.</p>
<p>Why? I dunno &#8230; say you&#8217;re trying to make a tag cloud or something but it&#8217;s full of filler words!</p>
<p>Articles are &#8220;a&#8221;, &#8220;an&#8221; and &#8220;the&#8221; only for English. Verbs and adjectives, well that&#8217;ll be down to what you&#8217;re up to I guess?!</p>
<textarea cols="40" rows="10" name="code" class="JScript">var prepositions = ["aboard","about","above","across","after","against","along","amid","among","anti","around","as","at","before","behind","below","beneath","beside","besides","between","beyond","but","by","concerning","considering","despite","down","during","except","excepting","excluding","following","for","from","in","inside","into","like","minus","near","of","off","on","onto","opposite","outside","over","past","per","plus","regarding","round","save","since","than","through","to","toward","towards","under","underneath","unlike","until","up","upon","versus","via","with","within","without"]

var conjunctions = ["after","although","and","as","as far as","as how","as if","as long as","as soon as","as though","as well as","because","before","both","but","either","even if","even though","for","how","however","if","if only","in case","in order that","neither","nor","now","once","only","or","provided","rather than","since","so","so that","than","that","though","till","unless","until","when","whenever","where","whereas","wherever","whether","while","yet"]

var pronouns = ["all","another","any","anybody","anyone","anything","both","each","each other","either","everybody","everyone","everything","few","he","her","hers","herself","him","himself","his","I","it","its","itself","little","many","me","mine","more","most","much","myself","neither","no one","nobody","none","nothing","one","one another","other","others","ours","ourselves", "several","she","some","somebody","someone","something","that","theirs","them","themselves","these","they","this","those","us","we","what","whatever","which","whichever","who","whoever","whom","whomever","whose","you","yours","yourself","yourselves"]</textarea>
	<!-- Wordpress Code Snippet -->
	<script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shCore.js"></script><script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shBrushJScript.js"></script>
	<link type="text/css" rel="stylesheet" href="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/css/SyntaxHighlighter.css"/>
	
	<script language="javascript">
	dp.SyntaxHighlighter.ClipboardSwf = 'http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/clipboard.swf';
	dp.SyntaxHighlighter.HighlightAll('code');
	</script>
	<!-- End Wordpress Code Snippet -->
	<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F08%2F03%2Fjavascript-english-stoplists-stopword%2F&amp;linkname=Javascript%20English%20Stoplists%20%2F%20Stopwords"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/-vmnwgSVcnA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/08/03/javascript-english-stoplists-stopword/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/08/03/javascript-english-stoplists-stopword/</feedburner:origLink></item>
		<item>
		<title>Javascript Export HTML table to MS Excel (JScript)</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/D-i5v0BwCxo/</link>
		<comments>http://www.yaduk.co.uk/2009/07/22/javascript-export-html-table-excel-jscript/#comments</comments>
		<pubDate>Wed, 22 Jul 2009 11:19:31 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Reference]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=371</guid>
		<description><![CDATA[<p>Here&#8217;s a little code snippet to export an HTML table to MS Excel through utilising ActiveXObject(&#8221;Excel.Application&#8221;) from Internet Explorer.</p>
<p>The JavaScript (in this case utilising Microsoft&#8217;s JScript) runs over the table displayed pulling out the relevant data and exporting into the instantiated copy of Excel. This is a working example based&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Here&#8217;s a little code snippet to export an HTML table to MS Excel through utilising ActiveXObject(&#8221;Excel.Application&#8221;) from Internet Explorer.</p>
<p>The JavaScript (in this case utilising Microsoft&#8217;s JScript) runs over the table displayed pulling out the relevant data and exporting into the instantiated copy of Excel. This is a working example based loosely on Microsoft&#8217;s <a href="http://support.microsoft.com/kb/234774">http://support.microsoft.com/kb/234774</a> Knowledgebase Article &#8220;How to automate Excel from an HTML Web page by using JScript&#8221;.</p>
<p>Worth noting is that the garbage collection between the JScript and MS Excel doesn&#8217;t work too well and more often than not one can be left with the instantiated copy of MS Excel still in memory (see it in the Task Manager). One must manually remove these instances.</p>
<p>Perhaps dynamically inputting a module to clean up from within MS Excel on the workbook deactivating might clear this up &#8211; not tried this though!?</p>
<textarea cols="40" rows="10" name="code" class="Xml"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Export to Excel Example</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="charset" content="iso-8859-1" />
<meta http-equiv="content-language" content="english" />
<meta http-equiv="expires" content="-1" />
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="imagetoolbar" content="false" />
<style>
body {
   margin: 0;
   font-family: verdana,arial,helvetica,sans-serif;
   font-size: .85em;
   padding: 3px;
}
th {background-color:#ccd;}
.odd{background-color:#DDDBDB;}
.even{background-color:#CECCCC;}

</style>
<script language="javascript" type="text/javascript">  
function ExportToExcel() {
	input_box=confirm("Export rows of table data to MS Excel?");
		if (input_box==true) {
			
			var xlApp = new ActiveXObject("Excel.Application");
			// Silent-mode:
			xlApp.Visible = true;
			xlApp.DisplayAlerts = false;
			var xlBook = xlApp.Workbooks.Add();
			xlBook.worksheets("Sheet1").activate;
			var XlSheet = xlBook.activeSheet;
			XlSheet.Name="JavaScript Export to Excel";
			
			// Store the sheet header names in an array
			var rows = tabletoexport.getElementsByTagName("tr");
			var columns = tabletoexport.getElementsByTagName("th");
			var data = tabletoexport.getElementsByTagName("td");
			
  			// Set Excel Column Headers and formatting from array
			for(i=0;i<columns.length;i++){
	   			XlSheet.cells(1,i+1).value= columns[i].innerText; //XlSheetHeader[i];
	   			XlSheet.cells(1,i+1).font.color="6";
	   			XlSheet.cells(1,i+1).font.bold="true";
	   			XlSheet.cells(1,i+1).interior.colorindex="45";
			}
			
			//run over the dynamic result table and pull out the values and insert into corresponding Excel cells
			var d = 0;
			for (r=2;r<rows.length+1;r++) { // start at row 2 as we've added in headers - so also add in another row!
				for (c=1;c<columns.length+1;c++) {
					XlSheet.cells(r,c).value = data[d].innerText;
					d = d + 1;
				}
			}
			
			//autofit the columns
			XlSheet.columns.autofit;
			
			// Make visible:
			xlApp.visible = true;
			xlApp.DisplayAlerts = true;
			CollectGarbage();
			//xlApp.Quit();
		}
}
</script>
</head>
<body>
	<input type="button" value="Export To Excel" onClick="ExportToExcel()">
	<table border="1" width="100%" id="tabletoexport">
		<tr>
			<th>Month</th>
			<th>Column 1</th>
			<th>Column 2</th>
			<th>Column 3</th>
			<th>Column 4</th>
		</tr>
		<tr class="even">
			<td>January</td>
			<td>123</td>
			<td>456</td>
			<td>798</td>
			<td>123</td>
		</tr>
		<tr class="odd">
			<td>February</td>
			<td>456</td>
			<td>798</td>
			<td>123</td>
			<td>456</td>
		</tr>
		<tr  class="even">
			<td>March</td>
			<td>798</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
		</tr>
		<tr class="odd">
			<td>April</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
			<td>123</td>
		</tr>
		<tr  class="even">
			<td>May</td>
			<td>456</td>
			<td>789</td>
			<td>123</td>
			<td>456</td>
		</tr>
		<tr class="odd">
			<td>June</td>
			<td>789</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
		</tr>
		<tr class="even">
			<td>July</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
			<td>123</td>
		</tr>
		<tr class="odd">
			<td>August</td>
			<td>456</td>
			<td>789</td>
			<td>123</td>
			<td>456</td>
		</tr>
		<tr  class="even">
			<td>September</td>
			<td>789</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
		</tr>
		<tr class="odd">
			<td>October</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
			<td>123</td>
		</tr>
		<tr class="even">
			<td>November</td>
			<td>456</td>
			<td>789</td>
			<td>123</td>
			<td>456</td>
		</tr>
		<tr class="odd">
			<td>December</td>
			<td>789</td>
			<td>123</td>
			<td>456</td>
			<td>789</td>
		</tr>
	</table>
</body>
</html></textarea>
	<!-- Wordpress Code Snippet -->
	<script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shCore.js"></script><script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shBrushXml.js"></script>
	<link type="text/css" rel="stylesheet" href="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/css/SyntaxHighlighter.css"/>
	
	<script language="javascript">
	dp.SyntaxHighlighter.ClipboardSwf = 'http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/clipboard.swf';
	dp.SyntaxHighlighter.HighlightAll('code');
	</script>
	<!-- End Wordpress Code Snippet -->
	<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F07%2F22%2Fjavascript-export-html-table-excel-jscript%2F&amp;linkname=Javascript%20Export%20HTML%20table%20to%20MS%20Excel%20%28JScript%29"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/D-i5v0BwCxo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/07/22/javascript-export-html-table-excel-jscript/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/07/22/javascript-export-html-table-excel-jscript/</feedburner:origLink></item>
		<item>
		<title>Organisational Expectations of an Intranet</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/xQ6dXVvOsSs/</link>
		<comments>http://www.yaduk.co.uk/2009/07/21/organisational-expectations-of-an-intranet/#comments</comments>
		<pubDate>Tue, 21 Jul 2009 08:15:55 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Arbitrary 'Stuff']]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=362</guid>
		<description><![CDATA[<p>Organisations anticipate a return on the investment involved in implementing Intranets expressed in financial terms or intangible benefits; an expectation their Intranet will either save money, enhance efficiency or both.</p>
<p>Organisations however, are not cohesive bodies with unified needs or interests; instead they are formed by individuals, each with their own intrinsic&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Organisations anticipate a return on the investment involved in implementing Intranets expressed in financial terms or intangible benefits; an expectation their Intranet will either save money, enhance efficiency or both.</p>
<p>Organisations however, are not cohesive bodies with unified needs or interests; instead they are formed by individuals, each with their own intrinsic self-interest and motivations for working within the framework of an organisation. Organisational expectations when broadly defined conflict with the behaviour of users. Users&#8217; expectations are practical, organisations expectations strategic ultimately providing an inherent tension between these different formulations of expectation.</p>
<p>The expectations then that organisations have of Intranets introduce inherent conflicts in their function. Intranets are expected to do several things simultaneously under the umbrella of a single resource: to merge the communicative function and the informative function; to do things cheaper and do things better; to disseminate new information and store old information.</p>
<p>Organisations often expect Intranets to take over existing functions, such as the dissemination of information without affecting the nature of those functions. For example, paper resources migrated to Intranets with little or no modification.</p>
<h2>Ensuing Information Wasteland</h2>
<p>Strategic expectations of organisations then create conflict in the implementation of Intranets from the tension between the qualities of information; a confusion between the communicative function and an informative function.</p>
<p>This single platform for all information needs becomes a confusing aggregate of differing types of information with different functions and different characteristics, all presented to the user as if they are of the same value &#8211; confusing end user expectations of information retrieval and in turn deflating the original assumption that an Intranet will &#8220;either save money, enhance efficiency or both&#8221;!</p>
<p>An examination of these &#8220;end-user&#8221; expectations <em>are</em> required to enable alignment with organisational expectations.</p>
<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F07%2F21%2Forganisational-expectations-of-an-intranet%2F&amp;linkname=Organisational%20Expectations%20of%20an%20Intranet"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/xQ6dXVvOsSs" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/07/21/organisational-expectations-of-an-intranet/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/07/21/organisational-expectations-of-an-intranet/</feedburner:origLink></item>
		<item>
		<title>Export Access to Excel with Custom Headers</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/RV8c1iZMfy8/</link>
		<comments>http://www.yaduk.co.uk/2009/07/20/export-access-to-excel-with-custom-headers/#comments</comments>
		<pubDate>Mon, 20 Jul 2009 11:26:46 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Reference]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=359</guid>
		<description><![CDATA[<p>Have you noticed how the &#8220;out the box&#8221; solution to export your dataset from MS Access to MS Excel doesn&#8217;t give much room to give custom headers to your worksheet?</p>
<p>Through utlising ActiveX you can instantiate a copy of MS Excel in memory to add in your own custom headers etc.&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Have you noticed how the &#8220;out the box&#8221; solution to export your dataset from MS Access to MS Excel doesn&#8217;t give much room to give custom headers to your worksheet?</p>
<p>Through utlising ActiveX you can instantiate a copy of MS Excel in memory to add in your own custom headers etc. prior to exporting your MS Access dataset into the worksheet.</p>
<p>The below code example shows you how to add 5 custom headers to your sheet. Just add in your own SQL query where it is indicated.</p>
<textarea cols="40" rows="10" name="code" class="Vb">Private Sub btn_export_excel_Click()
   
    Dim mySQL, thepos, theleft, theright, test As String
    Dim i, iNumCols  As Integer
    Dim DB As DAO.Database
    Dim rs As DAO.Recordset
    
    Set DB = CurrentDb
    
    With Me.yourformname.Form.RecordsetClone
        If .RecordCount > 0 Then .MoveLast
        test = .RecordCount
    End With
    
    If test < 65535 Then
        'create output table and output
        If MsgBox("Export selected data?", vbOKCancel, "Export . . ?") = vbOK Then
            
            Dim oApp As New Excel.Application
            Dim oBook As Excel.Workbook
            Dim oSheet As Excel.Worksheet
            Dim oRange As Excel.Range
			
			mySQL = "enter in whatever youSQL query is here"
                  
            Set rs = DB.OpenRecordset(mySQL, dbOpenSnapshot)
            Set oBook = oApp.Workbooks.Add
            Set oSheet = oBook.Worksheets(1)
            
            oSheet.Cells(1, 1).Value = "HEADER 1"
            oSheet.Cells(2, 1).Value = "HEADER 2"
            oSheet.Cells(3, 1).Value = "HEADER 3"
            oSheet.Cells(4, 1).Value = "HEADER 4"
            oSheet.Cells(5, 1).Value = "HEADER 5"
            
            'Format the header
            oSheet.Cells(1, 1).Font.Bold = True
            
            With oSheet
                Set oRange = .Range("A5:AL5")
            End With
            
            With oRange
                .MergeCells = True
            End With
           
            'Add the field names in row 7
            iNumCols = rs.Fields.count
            For i = 1 To iNumCols
                oSheet.Cells(7, i).Value = rs.Fields(i - 1).Name
            Next
            
            'Add the data starting at cell A8
            oSheet.Range("A8").CopyFromRecordset rs
            
            'Format the header row as bold and autofit the columns
            With oSheet.Range("a7").Resize(1, iNumCols)
                .Font.Bold = True
                .EntireColumn.AutoFit
            End With
            oSheet.Columns("A:A").ColumnWidth = 10.14
            
            oApp.Visible = True
            oApp.UserControl = True
            
            'make sure we clean up the instantiated Excel app!!
            'oApp.Quit
            Set oApp = Nothing
            Set oBook = Nothing
            Set oSheet = Nothing
            rs.Close
            DB.Close
            
        End If
    Else
        MsgBox "Sorry - your export is larger than what can be held within Excel!" & vbCrLf & vbCrLf & " Please consider revising your dataset.", vbCritical, "Export Error"
    End If
    
End Sub</textarea>
	<!-- Wordpress Code Snippet -->
	<script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shCore.js"></script><script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shBrushVb.js"></script>
	<link type="text/css" rel="stylesheet" href="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/css/SyntaxHighlighter.css"/>
	
	<script language="javascript">
	dp.SyntaxHighlighter.ClipboardSwf = 'http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/clipboard.swf';
	dp.SyntaxHighlighter.HighlightAll('code');
	</script>
	<!-- End Wordpress Code Snippet -->
	<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F07%2F20%2Fexport-access-to-excel-with-custom-headers%2F&amp;linkname=Export%20Access%20to%20Excel%20with%20Custom%20Headers"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/RV8c1iZMfy8" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/07/20/export-access-to-excel-with-custom-headers/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/07/20/export-access-to-excel-with-custom-headers/</feedburner:origLink></item>
		<item>
		<title>Google margin</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/K42S5ZXOMwE/</link>
		<comments>http://www.yaduk.co.uk/2009/07/02/google-margin/#comments</comments>
		<pubDate>Thu, 02 Jul 2009 21:03:09 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Arbitrary 'Stuff']]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=346</guid>
		<description><![CDATA[<p>Is it just me or has google added a margin around their search results? An ID of &#8216;gsr&#8217; on the body tag appears to apply &#8216;margin: 3px 8px;&#8217; bumping the results in at each side!</p>
<p>Clocked this on Tuesday night and thought it was a mistake with my setup or someone&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Is it just me or has google added a margin around their search results? An ID of &#8216;gsr&#8217; on the body tag appears to apply &#8216;margin: 3px 8px;&#8217; bumping the results in at each side!</p>
<p>Clocked this on Tuesday night and thought it was a mistake with my setup or someone at google had screwed something up and it&#8217;d flip back &#8211; but no! Here we are and I&#8217;ve either gone mad or the margin is here to stay! I find it quite disconcerting to behonest.</p>
<p>Nah! Here&#8217;s to progressive development. Change is a good thing. . .  even if it&#8217;s some whitespace!</p>
<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F07%2F02%2Fgoogle-margin%2F&amp;linkname=Google%20margin"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/K42S5ZXOMwE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/07/02/google-margin/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/07/02/google-margin/</feedburner:origLink></item>
		<item>
		<title>Script to set IE – Internet Explorer homepage</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/oTTlO3n0-60/</link>
		<comments>http://www.yaduk.co.uk/2009/06/30/script-to-set-ie-internet-explorer-homepage/#comments</comments>
		<pubDate>Tue, 30 Jun 2009 14:48:03 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Reference]]></category>
		<category><![CDATA[wscript]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=344</guid>
		<description><![CDATA[<p>Stuck in a restrictive environment where you can&#8217;t alter your homepage settings? Check out the below WSH shell script to alter your homepage in Internet Explorer via the registry:</p>
<p>Set WSHShell = WScript.CreateObject(&#8221;WScript.Shell&#8221;)<br />
&#8216; home page URL<br />
StartPage = &#8220;http://www.yaduk.co.uk&#8221;<br />
WSHShell.RegWrite &#8220;HKLM\Software\Microsoft\Internet Explorer\Main\Start Page&#8221;, StartPage<br />
WSHShell.RegWrite &#8220;HKCU\Software\Microsoft\Internet Explorer\Main\Start Page&#8221;, StartPage</p>
<p>Stick in a text file with&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Stuck in a restrictive environment where you can&#8217;t alter your homepage settings? Check out the below WSH shell script to alter your homepage in Internet Explorer via the registry:</p>
<p>Set WSHShell = WScript.CreateObject(&#8221;WScript.Shell&#8221;)<br />
&#8216; home page URL<br />
StartPage = &#8220;http://www.yaduk.co.uk&#8221;<br />
WSHShell.RegWrite &#8220;HKLM\Software\Microsoft\Internet Explorer\Main\Start Page&#8221;, StartPage<br />
WSHShell.RegWrite &#8220;HKCU\Software\Microsoft\Internet Explorer\Main\Start Page&#8221;, StartPage</p>
<p>Stick in a text file with the extension .vbs</p>
<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F06%2F30%2Fscript-to-set-ie-internet-explorer-homepage%2F&amp;linkname=Script%20to%20set%20IE%20%26%238211%3B%20Internet%20Explorer%20homepage"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/oTTlO3n0-60" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/06/30/script-to-set-ie-internet-explorer-homepage/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/06/30/script-to-set-ie-internet-explorer-homepage/</feedburner:origLink></item>
		<item>
		<title>XHR Connector for Internet Explorer</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/e5VVuY-T2v8/</link>
		<comments>http://www.yaduk.co.uk/2009/06/24/xhr-connector-for-internet-explorer/#comments</comments>
		<pubDate>Wed, 24 Jun 2009 17:38:05 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Reference]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=339</guid>
		<description><![CDATA[<p>Below is a great code snippet to process XML dynamically through an <em>XMLHttpRequest</em> (XHR) request. From this further XSLT processing can be applied dynamically utilising Internet Explorers &#8220;fragment&#8221; transformations.</p>
/* XHR Connector */
XMLReq = function() {
	this.adapter = false;
	/*@cc_on @*/
	/*@if (@_jscript_version >= 5)
		try {
			this.adapter = new ActiveXObject("Msxml2.XMLHTTP");&#8230;]]></description>
			<content:encoded><![CDATA[<p>Below is a great code snippet to process XML dynamically through an <em>XMLHttpRequest</em> (XHR) request. From this further XSLT processing can be applied dynamically utilising Internet Explorers &#8220;fragment&#8221; transformations.</p>
<textarea cols="40" rows="10" name="code" class="JScript">/* XHR Connector */
XMLReq = function() {
	this.adapter = false;
	/*@cc_on @*/
	/*@if (@_jscript_version >= 5)
		try {
			this.adapter = new ActiveXObject("Msxml2.XMLHTTP");
		} catch (e) {
			try {
				this.adapter = new ActiveXObject("Microsoft.XMLHTTP");
			} catch (E) {
				this.adapter = false;
			}
		}
	@end @*/
	if (!this.adapter && typeof(XMLHttpRequest) != 'undefined') {
		this.adapter = new XMLHttpRequest();
	}
};
XMLReq.prototype.adapter = null;
XMLReq.prototype.getDocument = function(sUrl) {
	this.adapter.open("GET", sUrl, false);
	this.adapter.send(null);
	//alert("Status = " + this.adapter.status + "n"+this.adapter.getAllResponseHeaders()+"nParse Error = " +this.adapter.responseXML.parseError.errorCode);
	// if XML sent as application/octet-stream!! you can't use responseXML in this instance instead must use responseBody
	return this.adapter.responseBody;
};

/*  The actual  */
var yourprocessorfunction = function() {};
var nameofcallvariable = new yourprocessorfunction();
yourprocessorfunction.prototype.data = null;
yourprocessorfunction.prototype.init = function() {
	// init vars
	this.data = this.XMLReq.getDocument("http://whereeveryourxmldocis");
};
/* Init */
function start() {
	nameofcallvariable.init();
}
window.onload = start;</textarea>
	<!-- Wordpress Code Snippet -->
	<script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shCore.js"></script><script type="text/javascript" src="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/shBrushJScript.js"></script>
	<link type="text/css" rel="stylesheet" href="http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/css/SyntaxHighlighter.css"/>
	
	<script language="javascript">
	dp.SyntaxHighlighter.ClipboardSwf = 'http://www.yaduk.co.uk/wp-content/plugins/wordpress-code-snippet/js/clipboard.swf';
	dp.SyntaxHighlighter.HighlightAll('code');
	</script>
	<!-- End Wordpress Code Snippet -->
	<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F06%2F24%2Fxhr-connector-for-internet-explorer%2F&amp;linkname=XHR%20Connector%20for%20Internet%20Explorer"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/e5VVuY-T2v8" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/06/24/xhr-connector-for-internet-explorer/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/06/24/xhr-connector-for-internet-explorer/</feedburner:origLink></item>
		<item>
		<title>Business Strategies, Information Systems and People: Holistic Approach</title>
		<link>http://feedproxy.google.com/~r/yaduk/~3/L2rfetZCkC4/</link>
		<comments>http://www.yaduk.co.uk/2009/05/31/business-strategies-information-systems-and-people-holistic-approach/#comments</comments>
		<pubDate>Sun, 31 May 2009 19:43:23 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Arbitrary 'Stuff']]></category>
		<category><![CDATA[intranet]]></category>

		<guid isPermaLink="false">http://www.yaduk.co.uk/?p=254</guid>
		<description><![CDATA[<h3>Information Architecture and Information Retrieval</h3>
<p>Intranet information retrieval requires more often than not implicit end-user understanding to the nature and location of information sought since architecturally information organically mirrors organisational layout rather than information &#8216;typing&#8217;. Semantic linkage and intelligible meta data unfortunately take a back seat. As a result it is commonplace&#8230;</p>]]></description>
			<content:encoded><![CDATA[<h3>Information Architecture and Information Retrieval</h3>
<p>Intranet information retrieval requires more often than not implicit end-user understanding to the nature and location of information sought since architecturally information organically mirrors organisational layout rather than information &#8216;typing&#8217;. Semantic linkage and intelligible meta data unfortunately take a back seat. As a result it is commonplace for &#8220;Intranet&#8221; users to consider Intranets an unresponsive technology in respect to finding and utilising information in their day to day jobs. One of the tenants to having an organisational Intranet in the first place!</p>
<p>For the majority, Intranet information retrieval issues are born from how individuals have learned &#8216;web technology interaction&#8217; from the Internet. Bringing learned behaviours with them, end-users directly influence the effectiveness of organisational Intranets. For developers, Intranets should then be considered essentially as &#8220;socio-technical&#8221; devices requiring understanding of end-user interaction in the dissemination and retrieval of information.</p>
<p>It must be said that Internet users have a humungous resource from which they can narrow down something of interest or a link to a site of value in their quest. Within an Intranet environment this same search strategy fails due to the need for a defined information nugget rather as a rough guestimate.</p>
<h3>Intranet Strategy &#8211; An holistic approach</h3>
<p>Varying academic studies detail the extent of which Intranet implementation and use within individual organisations has significant implications for organisational performance. A key component in that performance is &#8220;technology adoption in the workplace [and its acceptance being directly] influenced [...] individual differences, social influences, beliefs, attitudes, and situational influences.&#8221; (Lee, S., &amp; Kim, B.).</p>
<p>Evidence that organisations are &#8220;cultures, tribes, political battlegrounds, networks, [...]&#8221; (Checkland &amp; Scholes, 1990); non-deterministic open systems, directly refutes the traditional deterministic approach to information systems development.</p>
<p>Organisations generally are viewed as &#8220;unitary systems with coherent purposes and goals rather than collections of people with many (sometimes conflicting) concerns&#8221;, (Clarke &amp; Lehaney, 1997), in turn influencing the traditional approach that systems are – &#8220;autonomous purpose-directed systems […] with predetermined goals or sets of goals&#8221;, (Introna, 1996). These &#8220;hard systems&#8221; define objectives, modelled and measured against declared criteria, in an attempt to fulfil information needs and organisational goals.</p>
<p>&#8220;Soft systems&#8221; thinking, in comparison, gives credence to user perceptions and interaction, allowing us to understand underlying causal factors in Intranet complexity and their use. Examining and understanding these factors and their impact assists movement towards effective distribution and retrieval of information.</p>
<p>The intrinsic qualities of organisations generate a complex relationship between information creation, dissemination and use by end users &#8211; expectations of success of business strategies, information systems and people themselves disseminating and retrieving information impact on the implementation and use of an Intranet.</p>
<h3>Important Intranet Considerations</h3>
<p>Information systems <em>are</em> socio-technical systems requiring an understanding not only of technical/information infrastructure, but in the case of an Intranet, the end-user and how they inherently interact with the interface that is an Intranet.</p>
<p>Taking a view of &#8220;human computer interaction&#8221; in not only technology but also the overlying information, the process of Intranet information systems development and their inherent issues can much more readily be appreciated.</p>
<p>The predominant influence on Intranet use is learnt a priori from &#8220;outside-of-organisation&#8221; use of the Internet. When users come to Intranets, they do not usually experience the whole resource, but sub-sections of it, the parts they frequent regularly. It is therefore, imperitive that Intranets be designed with these factors in mind, limiting the scope of the resource as it is presented to each individual user, yet bringing those parts to the fore that are required habitually.</p>
<p>Significantly, a causal factor of Intranet failure is a distinct lack of process governance in content handling with the accuracy and relevance of information often going unchecked. Consequently content structuring ends up disparate across sub-sections leading to contrasting navigation systems independent from content types which in turn compounds retrieval issues.</p>
<p>The inability then to find information directly impacts &#8220;carrying out tasks and activities&#8221; and ultimately reduces productivity around the use of information disseminated through an Intranet. Addressing user expectations in their use of an organisational Intranet <em>will</em> aid in their alignment with any overall organisational strategy.</p>
<p>What are these? Well &#8230; email to find out! Taking stock of HCI: Human Computer Interaction against human interfaces is key to any &#8216;application&#8217;! &#8211; Hmm? What&#8217;s an Intranet or Internet interface? &#8230;&#8230; Hmm..!!?</p>
<p style="MARGIN-BOTTOM: 0cm" align="justify">Checkland, P. &amp; Scholes, J. (1990). &#8220;<em>Soft systems methodology in action</em>&#8220;. Chichester: John Wiley &amp; Sons.</p>
<p style="MARGIN-BOTTOM: 0cm" align="justify">Clarke, S. &amp; Lehaney, B. (1997). &#8220;<em>Critical approaches to information systems development: Some practical implications</em>&#8220;. In Stowell, F., Ison, R., Holloway, R., Jackson, S. &amp; McRobb, S., (Eds.), &#8220;<em>Systems for sustainability: People, organisations and environments</em>&#8220;, 333–337. New York: Plenum.</p>
<p style="MARGIN-BOTTOM: 0cm" align="justify">Introna, L. D. (1996). &#8220;<em>Notes on ateological information systems development</em>&#8220;. <em>Information Technology </em>&amp;<em> People</em>,<em> 9</em>, 20–39.</p>
<p style="MARGIN-BOTTOM: 0cm" align="justify">Lee, S., &amp; Kim, B. (2009, January). &#8220;<em>Factors affecting the usage of intranet: A confirmatory study. Computers in Human Behavior&#8221;</em>, <em>25</em>(1), 191-201. Retrieved January 13, 2009, doi:10.1016/j.chb.2008.08.007</p>
<a class="a2a_dd addtoany_share_save" href="http://www.addtoany.com/share_save?linkurl=http%3A%2F%2Fwww.yaduk.co.uk%2F2009%2F05%2F31%2Fbusiness-strategies-information-systems-and-people-holistic-approach%2F&amp;linkname=Business%20Strategies%2C%20Information%20Systems%20and%20People%3A%20Holistic%20Approach"><img src="http://www.yaduk.co.uk/wp-content/plugins/add-to-any/share_save_171_16.png" width="171" height="16" alt="Share/Bookmark"/></a><img src="http://feeds.feedburner.com/~r/yaduk/~4/L2rfetZCkC4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.yaduk.co.uk/2009/05/31/business-strategies-information-systems-and-people-holistic-approach/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.yaduk.co.uk/2009/05/31/business-strategies-information-systems-and-people-holistic-approach/</feedburner:origLink></item>
	</channel>
</rss>
