<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Ian's Blog</title>
	<link>http://blog.ianchivers.com/wordpress</link>
	<description></description>
	<lastBuildDate>Sun, 04 Jul 2010 09:38:49 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0" -->

	<item>
		<title>Working with Excel Spreadsheets</title>
		<description><![CDATA[Everytime I see some code that has to work with data in Excel files it always uses OLE automation. The worst case of this is on servers to process uploaded files, Microsoft doesn&#8217;t support Office on backend servers. I think a much better method is to use the OLEDB JET database providers, whether it&#8217;s for [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=55</link>
			</item>
	<item>
		<title>Domino: Read a file attachment without detaching</title>
		<description><![CDATA[The function below shows how you can read a file attachment, in this case a text or csv file into a string without detaching it to disk. Function getAttachmentData Dim doc As NotesDocument Dim stream As NotesStream Dim export As NotesDXLExporter Dim mime As NotesMimeEntity Dim txt As String Dim Start As Double Dim Finish [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=47</link>
			</item>
	<item>
		<title>Send a Calendar Invitation from c# using vCalendar</title>
		<description><![CDATA[using System; using System.Collections.Generic; using System.Text; using System.Net.Mail; using System.IO; namespace CalendaringScheduling { class Program { static void Main(string[] args) { StringBuilder sbCalendar = new StringBuilder(); DateTime dtStart = DateTime.Now; DateTime dtEnd = DateTime.Now.AddHours(2); sbCalendar.AppendLine(&#34;METHOD: REQUEST&#34;); sbCalendar.AppendLine(&#34;BEGIN:VCALENDAR&#34;); sbCalendar.AppendLine(&#34;PRODID:-//Ian Chivers//NET&#34;); sbCalendar.AppendLine(&#34;MIMEDIR//ENVERSION:1.0&#34;); sbCalendar.AppendLine(&#34;METHOD:REQUEST&#34;); sbCalendar.AppendLine(&#34;BEGIN:VEVENT&#34;); sbCalendar.AppendLine(&#34;DTSTAMP:&#34; + dtStart.ToUniversalTime().ToString(&#34;yyyyMMdd\\THHmmss\\Z&#34;)); sbCalendar.AppendLine(&#34;DTSTART:&#34; + dtStart.ToUniversalTime().ToString(&#34;yyyyMMdd\\THHmmss\\Z&#34;)); sbCalendar.AppendLine(&#34;DTEND:&#34; + dtEnd.ToUniversalTime().ToString(&#34;yyyyMMdd\\THHmmss\\Z&#34;)); sbCalendar.AppendLine(&#34;LOCATION:Minstead&#34;); sbCalendar.AppendLine(&#34;DESCRIPTION;ENCODING=QUOTED-PRINTABLE:My first meeting&#34;); [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=43</link>
			</item>
	<item>
		<title>Domino Keyword Lookups, jQuery &amp; JSON</title>
		<description><![CDATA[In Domino 8 it became possible to return a view in JSON format using &#38;outputformat=JSON querystring parameter. Here&#8217;s a simple view in Notes: Here is what the JSON looks like: {   &#8220;@timestamp&#8221;: &#8220;20090303T123231,91Z&#8221;,   &#8220;@toplevelentries&#8221;: &#8220;3&#8243;,   &#8220;viewentry&#8221;: [     {       "@position": "1",       "@noteid": "8000000C",     [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=41</link>
			</item>
	<item>
		<title>Run a SQL Server Agent Job from a Windows Powershell script</title>
		<description><![CDATA[## ================================================================== ## Title            : runSQLServerAgentJob ## Description  : Start a SQL Server Agent Job ## Author         : Ian Chivers ## Date            : 8/12/2008 ## Input           : -serverInstance &#60;server\instance&#62; -jobName &#60;jobName&#62; ## Usage          : PS&#62; .\runSQLServerAgentJob -serverInstance MyServer -jobName MyJob ## Tag             : SQL Server, SMO, SQL Agent Jobs ## Change log  : ## [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=38</link>
			</item>
	<item>
		<title>Using Sharepoint UserGroup Web Service with InfoPath Forms Service</title>
		<description><![CDATA[When you create a data connection to the UserGroup Sharepoint Web Service and select the GetUserCollectionFromGroup method, Infopath doesn&#8217;t interpret the results correctly and you can&#8217;t use the data connection in a Drop Down List control. I&#8217;ve seen examples which use code to get around this problem, but I&#8217;m using the Forms Service so code [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=37</link>
			</item>
	<item>
		<title>Sharepoint Drop Down Context Menu Workflow Shortcut</title>
		<description><![CDATA[It&#8217;s fairly simple to add custom menu options to the drop down context menu in sharepoint library/list views.  One useful example maybe to provide a shortcut to start workflows, instead of opening the workflow page; selecting the desired workflow and clicking the Start button. To do this we need to add some Javascript to the page.  [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=30</link>
			</item>
	<item>
		<title>Microsoft SQL Server Data Services</title>
		<description><![CDATA[Microsoft‟s Data Platform vision meets the needs of the evolving data explosion and the next generation of data-driven web applications with its new services offering in the cloud called Microsoft® SQL Server™ Data Services (SSDS). SQL Server Data Services (SSDS) is a highly scalable web facing data storage and query processing utility. Built on robust [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=29</link>
			</item>
	<item>
		<title>VBScript Active Directory LDAP ANR Query</title>
		<description><![CDATA[Here&#8217;s a really simple Active Directory ANR (Ambiguous Name Resolution) query that uses VBScript and ADO.  name = &#34;ian&#34; Set objDomain = GetObject (&#34;LDAP://rootDSE&#34;) Set conn = CreateObject(&#34;ADODB.Connection&#34;) conn.provider =&#34;ADsDSOObject&#34; conn.open &#34;Active Directory Provider&#34; Set Comm = CreateObject(&#34;ADODB.Command&#34;) Set Comm.ActiveConnection = conn Comm.CommandText = &#34;&#60;LDAP://&#34; &#38; objDomain.get(&#34;defaultnamingcontext&#34;) &#38; &#34;&#62;;(&#38;(objectCategory=User)(anr=&#34; + name + &#34;));displayName,AdsPath;subtree&#34; Set rs [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=24</link>
			</item>
	<item>
		<title>Lotus Notes DXL to remove Design Element Inherit from the design template</title>
		<description><![CDATA[There is no easy way in Domino Designer Client to clear the &#8220;Inherit from the design template&#8221; design element property from all design elements.  The best you can do is to view all the forms, highlight those that show as inheriting from a design template as clear the property.  But you have repeat this for Forms, [...]]]></description>
		<link>http://blog.ianchivers.com/wordpress/?p=25</link>
			</item>
</channel>
</rss>
