Dalle & DXter

PowerShell Twitter

By Fredrik Wall

I will start to twitter PowerShell stuff from a new twitter account today, @SteriaPosh. This will seperate my personal twitters from my Powershell Twitters.

Twitter Status klient för TechDays 2010 Örebro

By Fredrik Wall

#TechDaysSE Twitter Status

Mellan en massa jobbsaker och privata saker så har jag suttit och
knåpat på en liten enkel Twitter Status Klient för TechDays 2010 i Örebro.

Och lagom till kvällen innan starten av TechDays så är den klar.

Det är en enkel klient som på default tabben visar de 50 senaste
Twitter meddelandena om #TechDaysSE.

Och tabbenTop 50 Twitters about #TechDaysSE visar top 50 bland
de senaste 100 meddelandena om #TechDaysSE. Twitter verkar inte
gilla att ta fram fler än 100.

 

Skicka ett direct message på Twitter (@walle75) till mig om du är intresserad av
denna PowerShell applikation.

Och den kommer att finnas i montern för The Scandinavian PowerShell User Group.

PowerShell app to view #TechDaysSE tweets

By Fredrik Wall

I made this little PowerShell application to view
tweets about #TechDaysSE.

I will have It at TechDays in the Scandinavian PowerShell
User Group both.

I’m a pc geek with a iPhone

By Fredrik Wall

I did buy me an iPhone last week.
And now I have been using it a lot since I
got it.

Yes I’m a PC guy with a iPhone

The applications that I use most after the
the iPod application is Gowalla and Spotify.

My top 10 applications so far:

Gowalla
Spotify
iPod
Facebook
Res i STHLM
Mail
Twitterrific
Maps
Weather
Clock

 

Yesterday I made a Trip in Gowalla.
Stockholm Crazy Commuter Train –
Stockholm Märsta.

If you got Gowalla you can add me
if you like. http://gowalla.com/users/walle75

 

At work I just plug-in computer speakers into my
iPhone and use the Spotify application.

My favorite music at work to and with good
sound.

And I got my Twitter account in my iPhone too.

Is there a better Twitter client then the free version of Twitterrific?

Does anybody use a good messenger client in iPhone?

 

Bill Gates at Twitter

By Fredrik Wall

Bill Gates have signed up on Twitter.
And every geek and every IT person wants
to follow him.

5 Tweets and he’s got over 120 000 followers.

That’s pretty good!

 

Poll about Twitter

By Fredrik Wall

The IO Guy at Microsoft have posted
a poll about Twitter and customers.

Take the poll here.

I think this deserves that everybody that see
this take the poll. It’s an interesting question.

 

How to Backup Twitter Friends with PowerShell and Excel Automatically

By Fredrik Wall

This script is an updated version of the
How to Backup Twitter Friends with PowerShell and Excel
post earlier today. In this version I use the
out-Excel function by The Pathological Scripter.

[System.Reflection.Assembly]::LoadWithPartialName(”System.Web") | Out-Null 

$userName = "username"
$password = "password"

Function Get-TwitterFriends {
param ($username, $password, $ID)
if ($WebClient -eq $null) {$Global:WebClient=new-object System.Net.WebClient  }
$WebClient.Credentials = (New-Object System.Net.NetworkCredential -argumentList $username, $password)
$page = 1
$Friends = @()
if ($ID) {$URL="http://twitter.com/statuses/friends/$ID.xml?page="}
else     {$URL="http://twitter.com/statuses/friends.xml?page="}
do {  $Friends += (([xml]($WebClient.DownloadString($url+$Page))).users.user   )
        $Page ++
    } while ($Friends.count -eq 100)
$Friends
} 

function out-excel { 

param ([string[]]$property,[switch]$raw) 

begin {
  # start Excel and open a new workbook 
  $Excel = New-Object -Com Excel.Application
  $Excel.visible = $True
  $Excel = $Excel.Workbooks.Add()
  $Sheet = $Excel.Worksheets.Item(1)
  # initialize our row counter and create an empty hashtable 
  # which will hold our column headers 
  $Row = 1
  $HeaderHash = @{}
} 

process {
  if ($_ -eq $null) {return}
  if ($Row -eq 1) {
    # when we see the first object, we need to build our header table 
    if (-not $property) {
      # if we haven’t been provided a list of properties, 
      # we’ll build one from the object’s properties 
      $property=@()
      if ($raw) {
        $_.properties.PropertyNames | %{$property+=@($_)}
      } else {
        $_.PsObject.get_properties() | % {$property += @($_.Name.ToString())}
      }
    }
   $Column = 1
    foreach ($header in $property) {
      # iterate through the property list and load the headers into the first row 
      # also build a hash table so we can retrieve the correct column number 
      # when we process each object 
      $HeaderHash[$header] = $Column
      $Sheet.Cells.Item($Row,$Column) = $header.toupper()
      $Column ++
    }
    # set some formatting values for the first row 
    $WorkBook = $Sheet.UsedRange
    $WorkBook.Interior.ColorIndex = 19
    $WorkBook.Font.ColorIndex = 11
    $WorkBook.Font.Bold = $True
    $WorkBook.HorizontalAlignment = -4108
  }
  $Row ++
  foreach ($header in $property) {
    # now for each object we can just enumerate the headers, find the matching property 
    # and load the data into the correct cell in the current row. 
    # this way we don’t have to worry about missing properties 
    # or the “ordering” of the properties 
    if ($thisColumn = $HeaderHash[$header]) {
      if ($raw) {
        $Sheet.Cells.Item($Row,$thisColumn) = [string]$_.properties.$header
      } else {
        $Sheet.Cells.Item($Row,$thisColumn) = [string]$_.$header
      }
    }
  }
} 

end {
  # now just resize the columns and we’re finished 
  if ($Row -gt 1) { [void]$WorkBook.EntireColumn.AutoFit() }
}
} 

Get-TwitterFriends $userName $password | select name,screen_Name,url | out-excel

 

How to backup Twitter Friends using PowerShell and Excel

By Fredrik Wall

Twitter have been cleaning out spamers and some ordinary users got cleaned too.
It can be hard to know wish Twitter Friends you had yesterday and whish you got today.

From now on I will use a PowerShell script that I wrote today.

I did some changes to James O’Neils Twitter Function Get-TwitterFriend to
get It to work with more then 100 Friends.

And then Export it to a csv file and imported it in to Excel.

This can be handled with a export or import to Excel function.

[System.Reflection.Assembly]::LoadWithPartialName(”System.Web") | Out-Null

$userName = "username"
$password = "password"
$txtFile = "c:\textfile.txt"

Function Get-TwitterFriends {
param ($username, $password, $ID)
if ($WebClient -eq $null) {$Global:WebClient=new-object System.Net.WebClient  }
$WebClient.Credentials = (New-Object System.Net.NetworkCredential -argumentList $username, $password)
$page = 1
$Friends = @()
if ($ID) {$URL="http://twitter.com/statuses/friends/$ID.xml?page="}
else     {$URL="http://twitter.com/statuses/friends.xml?page="}
do {  $Friends += (([xml]($WebClient.DownloadString($url+$Page))).users.user   )
        $Page ++
    } while ($Friends.count -eq 100)
$Friends
}

Get-TwitterFriends $userName $password | select name,screen_Name,url | export-csv $txtfile

Then start Excel

and Open, file types .txt and chose your file.

In the text import Wizard step 1

Change Start import at row 1 to 2.

Then we do not get the row with PowerShell’s information.

In the text import Wizard step 2

Change Delimiters from Tab to Comma

When Excel opens you got all of your Friends in an excel document.

To view whole names in columns just push down right arrow over

the first row and to the left of the first column.

No you have the worksheet marked and then just double click on the

line between column A and B.

The first Friends on the list is the last Friends you have added to

Twitter.

I hope this will help you!

My next post will be a PowerShell and .net Windows Forms App

for this.

 

Visible Tweets

By Fredrik Wall

This was cool!

http://visibletweets.com/

 

Shows twitter feeds based on your choice.

 

And the animate it.

 

 

 

5 Spotify invites for my followers

By Fredrik Wall

I got 5 spotify invites to give away and I think you as
my follower, blog reader etc maybe want an account.

Leave a comment here with your mail address
or contact me at one of the following sites: