Writing Archive

“NOT” – Yaduk’s Music Profile – Users at Last.fm

How bizarre! From link searching I came across a profile on Last.fm with ‘Yaduk’ rather as titled yadUK. Some damn good google lurve on the seach term yaduk as one might expect!?

A quick wiggle of the ‘ol mouse finger and I’m in a strange parallel universe with a twist and …

Read more...

Exporting SharePoint People & Groups

You can export the “People & Groups” section to an XL spreadsheet by hinging through the owssvr DLL. However, you’re going to need the SSID for both your ‘List’ and whichever ‘View’ also to get it to work.

To obtain both of these:

List SSID – Goto the “People & …

Read more...

BCS – Social Networking Article

Fantastic article in the latest ITNow magazine in regards to Social Networking ‘in the business’. Simon Morris of Pentura lays down some great pointers on how best to manage and secure such systems against their use in collaborative and strangely ‘Social Networking’ activities.

Do look back to a post here: …

Read more...

Restart haldaemon and dbus Commands for CentOS 5.2

/etc/init.d/messagebus restart
/etc/init.d/haldaemon restart…

Read more...

Javascript English Stoplists / Stopwords

Not listed verbs, adjectives nor articles but the below arrays are very handy should one be running language based queries over rendered pages.

Why? I dunno … say you’re trying to make a tag cloud or something but it’s full of filler words!

Articles are “a”, “an” and “the” only …

Read more...

Javascript Export HTML table to MS Excel (JScript)

Here’s a little code snippet to export an HTML table to MS Excel through utilising ActiveXObject(“Excel.Application”) from Internet Explorer.

The JavaScript (in this case utilising Microsoft’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 …

Read more...

Export Access to Excel with Custom Headers

Have you noticed how the “out the box” solution to export your dataset from MS Access to MS Excel doesn’t give much room to give custom headers to your worksheet?

Through utlising ActiveX you can instantiate a copy of MS Excel in memory to add in your own custom headers …

Read more...

Script to set IE – Internet Explorer homepage

Stuck in a restrictive environment where you can’t alter your homepage settings? Check out the below WSH shell script to alter your homepage in Internet Explorer via the registry:

Set WSHShell = WScript.CreateObject(“WScript.Shell”)
‘ home page URL
StartPage = “http://www.yaduk.co.uk”
WSHShell.RegWrite “HKLM\Software\Microsoft\Internet Explorer\Main\Start Page”, StartPage
WSHShell.RegWrite “HKCU\Software\Microsoft\Internet Explorer\Main\Start Page”, StartPage…

Read more...

XHR Connector for Internet Explorer

Below is a great code snippet to process XML dynamically through an XMLHttpRequest (XHR) request. From this further XSLT processing can be applied dynamically utilising Internet Explorers “fragment” transformations.…

Read more...

Excel Split Firstname Lastname 2 Columns

Excellent post in the MSDN microsoft.public.excel.programming community regarding the splitting of a firstname and lastname into two seperate columns.  The honours go to someone called “Bam”.

Last Name
=IF(ISERROR(LEFT(B2,FIND(“,”,B2,1)-1)),RIGHT(B2,LEN(B2)-(FIND(” “,B2,1))),LEFT(B2,FIND(“,”,B2,1)-1))

First Name
=IF(ISERROR(RIGHT(B1,LEN(B1)-(FIND(“,”,B1,1)+1))),LEFT(B1,FIND(” “,B1,1)+1-1),RIGHT(B1,LEN(B1)-(FIND(“,”,B1,1)+1)))…

Read more...